topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-php-12-admin-update-user.php / php



  <?php
  session_start();
  include "auth_admin.inc.php";
  include "conn.inc.php";
  ?>
  <html>
  <head>
  <title>Beginning PHP5, Apache and MySQL</title>
  </head>
  <body>
  <h1>Update User Information</h1>
  <p>
  <?php
  if (isset(_POST['submit']) && _POST['submit'] == "Update") {
    query_update = "UPDATE user_info SET username = '" . 
                    _POST['username'] . "', password = (PASSWORD('" .
                    _POST['password'] . "')), first_name = '" . 
                    _POST['first_name'] . "', last_name = '" .
                    _POST['last_name'] . "', email = '" . 
                    _POST['email'] . "', city = '" . 
                    _POST['city'] . "', state = '" . 
                    _POST['state'] . "', hobbies = '" . 
                    implode(", ", _POST['hobbies']) . "' " .
                    "WHERE id = '" . _POST['id'] . "'";
    result_update = mysql_query(query_update) 
      or die(mysql_error());
  
    query = "SELECT * FROM user_info WHERE id = '" . _POST['id'] . "'";
    result = mysql_query(query) 
      or die(mysql_error());
  
    row = mysql_fetch_array(result);
    hobbies = explode(", ", row['hobbies'])
  ?>
    <b>User information has been updated.</b><br>
    <a href="admin_area.php">Click here</a> to return to the admin area.
    <form action="update_user.php" method="post">
      <input type="hidden" name="id" value="<?php echo _POST['id']; ?>">
      Username: <input type="text" name="username" 
                  value="<?php echo row['username']; ?>"><br>
      Password: <input type="password" name="password" 
                  value=""> Not displayed<br>
      First Name: <input type="text" name="first_name" 
                    value="<?php echo row['first_name']; ?>"><br>
      Last Name: <input type="text" name="last_name" 
                   value="<?php echo row['last_name']; ?>"><br>
      Email: <input type="text" name="email" 
               value="<?php echo row['email']; ?>"><br>
      City: <input type="text" name="city" 
              value="<?php echo row['city']; ?>"><br>
      State: <input type="text" name="state" 
               value="<?php echo row['state'];?>"><br>
      Hobbies/Interests: (choose at least one)<br>
      <select name="hobbies[]" size="10" multiple>
        <option value="Golfing"<?php 
          if (in_array("Golfing", hobbies)) {
            echo " selected"; 
          } ?>>Golfing</option>
        <option value="Hunting"<?php 
          if (in_array("Hunting", hobbies)) {
            echo " selected"; 
          } ?>>Hunting</option>
        <option value="Reading"<?php 
          if (in_array("Reading", hobbies)) {
            echo " selected"; 
          } ?>>Reading</option>
        <option value="Dancing"<?php 
          if (in_array("Dancing", hobbies)) {
            echo " selected"; 
          } ?>>Dancing</option>
        <option value="Internet"<?php 
          if (in_array("Internet", hobbies)) {
            echo " selected"; 
          } ?>>Internet</option>
        <option value="Flying"<?php 
          if (in_array("Flying", hobbies)) {
            echo " selected"; 
          } ?>>Flying</option>
        <option value="Traveling"<?php 
          if (in_array("Traveling", hobbies)) {
            echo " selected"; 
          } ?>>Traveling</option>
        <option value="Exercising"<?php 
          if (in_array("Exercising", hobbies)) {
            echo " selected"; 
          } ?>>Exercising</option>
        <option value="Computers"<?php 
          if (in_array("Computers", hobbies)) {
            echo " selected"; 
          } ?>>Computers</option>
        <option value="Other Than Listed"<?php 
          if (in_array("Other Than Listed", hobbies)) {
            echo " selected"; 
          } ?>>Other Than Listed</option>
      </select><br><br>
      <input type="submit" name="submit" value="Update">
    </form>
  <?php
  } else {
    query = "SELECT * FROM user_info WHERE id = '" . _GET['id'] . "'";
    result = mysql_query(query) 
      or die(mysql_error());
  
    row = mysql_fetch_array(result);
    hobbies = explode(", ", row['hobbies'])
  ?>
    <form action="update_user.php" method="post">
      <input type="hidden" name="id" value="<?php echo _GET['id']; ?>">
      Username: <input type="text" name="username" 
                  value="<?php echo row['username']; ?>"><br>
      Password: <input type="password" name="password" 
                  value=""> Not displayed<br>
      First Name: <input type="text" name="first_name" 
                    value="<?php echo row['first_name']; ?>"><br>
      Last Name: <input type="text" name="last_name" 
                   value="<?php echo row['last_name']; ?>"><br>
      Email: <input type="text" name="email" 
               value="<?php echo row['email']; ?>"><br>
      City: <input type="text" name="city" 
              value="<?php echo row['city']; ?>"><br>
      State: <input type="text" name="state" 
               value="<?php echo row['state']; ?>"><br>
      Hobbies/Interests: (choose at least one)<br>
      <select name="hobbies[]" size="10" multiple>
        <option value="Golfing"<?php 
          if (in_array("Golfing", hobbies)) {
            echo " selected"; 
          } ?>>Golfing</option>
        <option value="Hunting"<?php 
          if (in_array("Hunting", hobbies)) {
            echo " selected"; 
          } ?>>Hunting</option>
        <option value="Reading"<?php 
          if (in_array("Reading", hobbies)) {
            echo " selected"; 
          } ?>>Reading</option>
        <option value="Dancing"<?php 
          if (in_array("Dancing", hobbies)) {
            echo " selected"; 
          } ?>>Dancing</option>
        <option value="Internet"<?php 
          if (in_array("Internet", hobbies)) {
            echo " selected"; 
          } ?>>Internet</option>
        <option value="Flying"<?php 
          if (in_array("Flying", hobbies)) {
            echo " selected"; 
          } ?>>Flying</option>
        <option value="Traveling"<?php 
          if (in_array("Traveling", hobbies)) {
            echo " selected"; 
          } ?>>Traveling</option>
        <option value="Exercising"<?php 
          if (in_array("Exercising", hobbies)) {
            echo " selected"; 
          } ?>>Exercising</option>
        <option value="Computers"<?php 
          if (in_array("Computers", hobbies)) {
            echo " selected"; 
          } ?>>Computers</option>
        <option value="Other Than Listed"<?php 
          if (in_array("Other Than Listed", hobbies)) {
            echo " selected"; 
          } ?>>Other Than Listed</option>
      </select><br><br>
      <input type="submit" name="submit" value="Update"> &nbsp; 
      <input type="button" value="Cancel" onclick="history.go(-1);">
    </form>
  <?php
  }
  ?>
  </p>
  </body>
  </html>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.