Re: [PHP] PHP webpage like MySQL, PART 2

Fri, 25 Jul 2003 02:07:17 -0700



Matt Hedges wrote:

<html>
<head><title>Update Sister Info.</title></head>
<body>
<?php
  $host="host";
  $user="user";
  $password="pw";
  $database="db";
  $id=1;
Why $id=1, you want to edit any sister info 
  $connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
  $db = mysql_select_db($database,$connection)
       or die ("Couldn't select database");

  if (@$first == "no")
  {

        $query = "UPDATE table SET
FirstName='$FirstName',MiddleName='$MiddleName',LastName='$LastName',GradYea
r='$GradYear',Email='$Email',MarriedName='$MarriedName' WHERE id='$id'";
        $result = mysql_query($query)
             or die ("Couldn't execute query.");
        echo "Thank you! Information entered. <a href=actives.php>View
Actives</a><br>";
        exit();

  }
  else
  {
    $query = "SELECT * FROM table WHERE id='$id'";
    $result = mysql_query($query)
         or die ("Couldn't execute query.");
    $row = mysql_fetch_array($result);
    extract($row);
  }

  /* Display user phone in a form */
  echo "<br><p align='center'>
       <font size='+1'><b>Please check the sister below and correct if
necessary.</b></font>
       <hr>
       <form action='updatesister.php?first=no' method='post'>
should be <form action='updatesister.php?first=no&id=$id' method='post'> 
        <div align='center'>
        <table width='50%' border='0' cellspacing='0' cellpadding='2'>
        <tr><td align='right'><B>$id</br></td>
           <td align='center'><input type='text' name='FirstName' size='20'
maxlength='20' value='$FirstName' > </td>
           <td align='center'><input type='text' name='MiddleName' size='20'
maxlength='20' value='$MiddleName' > </td>
           <td align='center'><input type='text' name='LastName' size='20'
maxlength='20' value='$LastName' > </td>
           <td align='center'><input type='text' name='GradYear' size='20'
maxlength='20' value='$GradYear' > </td>
           <td align='center'><input type='text' name='Email' size='20'
maxlength='20' value='$Email' > </td>
           <td align='center'><input type='text' name='MarriedName'
size='20' maxlength='20' value='$MarriedName' > </td>

        </tr>
        <tr><td></td><td align='center'>
           <br><input type='submit' value='Update Sister'></td>
        </tr>
        </table>
       </form>";
?>
</body>
</html>

Visit this page as updatesister.php?id=#id#


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to