Page 1 of 1

problem in extracting data from the mysql using php

Posted: Fri Jun 24, 2005 3:15 am
by ~ladydune~
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.

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>