List:General Discussion« Previous MessageNext Message »
From:Brian E Boothe Date:April 21 2006 6:53am
Subject:Form value editing
View as plain text  
can someone please just send me or post a example of editing feilds of a 
mysql database within an html form and then updating the values thanks alot
   here is a small database u can use i can expand on your example as needed
 /*************************************************************************         

CREATE TABLE `kids` (
  `id` int(10) NOT NULL auto_increment,
  `first_name` varchar(30) NOT NULL default '',
  `last_name` varchar(50) NOT NULL default '',
  `email` varchar(75) default NULL,
  `contact_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  ;

    add form i have working and SQL stuff i have its just bringing up a 
form from a list and editing values in the form i need help with ,, thanks
here is a form i have thats about all i have

      <table width="400" align="center" border="0" cellspacing="0" 
cellpadding="0">
     <tr>
         <td colspan="2" align="center" style="font-size:18px; 
font-weight:bold;">Manage Contact's Data Form</td>
         <input type="hidden" value="<?php echo $id?>" name="id">
     </tr>
     <tr>
       <td> </td>
       <td> </td>
     </tr>
     <tr>
       <td align="right">First Name: </td>
       <td><input name="first_name" type="text" value="<?php echo 
$first_name?>"> </td>
     </tr>
     <tr>
      <td align="right">Last Name: </td>
      <td><input name="last_name" type="text" value="<?php echo 
$last_name?>"> </td>
     </tr>
     <tr>
       <td align="right">Email Address: </td>
       <td><input name="email" type="text" value="<?php echo $email?>"> 
</td>
     </tr>
     <tr>
       <td align="right">Stop Contact? </td>
       <td><input name="status" type="checkbox" value="1" <?php if 
($status==1){ echo " checked=CHECKED "; } ?>> </td>
     </tr>
     <tr>
       <td> </td>
       <td> </td>
     </tr>
     <tr>
       <td colspan="2" align="center"><input name="submit" type="submit" 
value="<?php echo $value?>"> <input name="reset" type="reset" 
value="Clear Form"></td>
     </tr>
   </table>
Thread
Form value editingBrian E Boothe20 Apr
  • Re: Form value editingPeter Brawley20 Apr
  • RE: Form value editingfbsd21 Apr
    • RE: Form value editingPat Adams21 Apr
  • RE: Form value editingNicolas Verhaeghe21 Apr
RE: Form value editingJay Blanchard20 Apr