problem in extracting data from the mysql using php
Posted: Fri Jun 24, 2005 3:15 am
I'm a beginner in php/mysql .
i did a basic extracting of data from the mysql structurally almost identical to add.php function with the difference that it pre-fills the form with the data that is already in the database; the record number is indicated by the variable $id which is passed to it by the edit link in listcontacts.php); otherwise does the same job as add.php but updates the data instead of inserting it. I have two tables: user and branches table. The one i extracted data is the user table but i have difficulty in creating a query that will select branches in the branch table if the user will edit the branch field and will save it in the user table.below is my initial code.
i did a basic extracting of data from the mysql structurally almost identical to add.php function with the difference that it pre-fills the form with the data that is already in the database; the record number is indicated by the variable $id which is passed to it by the edit link in listcontacts.php); otherwise does the same job as add.php but updates the data instead of inserting it. I have two tables: user and branches table. The one i extracted data is the user table but i have difficulty in creating a query that will select branches in the branch table if the user will edit the branch field and will save it in the user table.below is my initial code.
Code: Select all
<?php
session_start();
echo "<script>alert('$_GET[id]')</script>";
// get agent id
$id = $_GET['id'];
if (!empty($id))
{
$_SESSION['recordId']=$id;
} else
{
$id = $_SESSION['recordId'];
}
// if the script has been called without ID or the user hit "Cancel" just return to listing
if (empty($id) || isset($_POST['cancel'])) {
Header("Location: listagents.php");
exit;
}
include('dbconnect.php');
// run this only, once the user has hit the "OK" button
if (isset($_POST['ok'])) {
// assign form inputs
$id = $_POST['id'];
$password = $_POST['password'];
$branch_location = $_POST['branch_location'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$reg = $_POST['reg'];
$stat = $_POST['stat'];
// validate inputs
if ( !empty($password) && !empty($branch_location) ) {
// add member to database
$query = "UPDATE user SET _password='".$password."', branch_location='".$branch_location."',_fname='".$firstname."',_lname='".$lastname."',_emailadd='".$email."',_logtime='".$reg."' WHERE _id='$id' AND _status='1'";
// $result = $database->query($query);
$result = mysql_query($query, $connection);
// $database->disconnect();
mysql_close();
Header("Location: listagents.php");
exit;
}
else {
$error = true; // input validation failed
$err=mysql_error();
print $err;
exit();
}
}
else { // read member data from database
$query = "SELECT * FROM user WHERE _id='".$id."'";
// $result = $database->query($query);
$result = mysql_query($query, $connection);
// $contact = $result->fetchRow(DB_FETCHMODE_ASSOC,0);
//$agents=mysql_num_rows($result);
while ($agents = mysql_fetch_array($result)) {
// echo "<p>",$row['id'],": ",$row['manufacturer'];
// $database->disconnect();
mysql_close();
$id = $agents['_id'];
$password = $agents['_password'];
$branch_location= $agents['branch_location'];
$firstname = $agents['_fname'];
$lastname = $agents['_lastname'];
$email = $agents['_emailadd'];
$reg=$agents['_logtime'];
$status=$agents['_status'];
}
}
?>
<html>
<head>
<title>Edit Contact</title>
</head>
<body>
<a href="addagents.php">Add a Contact</a> | <a href="listagents.php">My Contacts</a>
<h1>Edit Contact</h1>
<form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<?php
if ( $error && empty($id) ) {
echo '<span style="color:red">Error! Please enter a user id.</span><br>',"\n";
}
?>
USER ID:
<input name="id" type="text" value="<?php echo $id; ?>">
<br>
<?php
if ( $error && empty($password) ) {
echo '<span style="color:red">Error! Please enter a password.</span><br>',"\n";
}
?>
Password:
<input name="password" type="text" value="<?php echo $password; ?>">
<br>
<?php
if ( $error && empty($branch) ) {
echo '<span style="color:red">Error! Please enter a branch.</span><br>',"\n";
}
?>
Branch:
<input name="password" type="text" value="<?php echo $branch; ?>">
<br>
<?php
if ( $error && empty($firstname) ) {
echo '<span style="color:red">Error! Please enter a firstname.</span><br>',"\n";
}
?>
First Name:
<input name="firstname" type="text" value="<?php echo $firstname; ?>">
<br>
<?php
if ( $error && empty($lastname) ) {
echo '<span style="color:red">Error! Please enter a lastname.</span><br>',"\n";
}
?>
Last Name:
<input name="lastname" type="text" value="<?php echo $lastname; ?>">
<br>
<?php
if ( $error && empty($email) ) {
echo '<span style="color:red">Error! Please enter a email.</span><br>',"\n";
}
?>
E-mail:
<input name="email" type="text" value="<?php echo $email; ?>">
<br>
<input type="hidden" name="reg" value="<?php echo $reg; ?>">
<input type="hidden" name="stat" value="<?php echo $status; ?>">
<input type="submit" name="ok" value=" OK ">
<input type="submit" name="cancel" value="Cancel">
</form>
</body>
</html>