Advertisement
Guest User

Untitled

a guest
Mar 15th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.13 KB | None | 0 0
  1. //form.html
  2.  
  3. <form name="account" action="test.php" method="post">
  4. <td align="left" valign="top" class="labelstyle" width="25%">First Name</td>
  5. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="fname" value="" /></td>
  6. <td align="left" valign="top" class="labelstyle" width="25%">Last Name</td>
  7. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="lname" value="" /></td>
  8. <td align="left" valign="top" class="labelstyle" width="25%">Email</td>
  9. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="email" value="" /></td>
  10.  
  11.  
  12. <td align="left" valign="top" class="labeltextstyle"><input type="submit" name="submit" value="Save" /></td>
  13.  
  14. </form>
  15.  
  16. // test.php
  17. <?php
  18.  
  19. $dbhost = "localhost";
  20. $dbname = "test";
  21. $dbuser = "";
  22. $dbpass = "";
  23.  
  24. mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
  25. mysql_select_db($dbname) or die(mysql_error());
  26.  
  27. session_start();
  28. if(isset($_REQUEST['submit'])){
  29.  
  30. // $query = "select * from form";
  31. // $result = mysql_query($query);
  32. // $numcolumn = mysql_num_fields($result);
  33. // for ( $i = 0; $i < $numcolumn; $i++ ) {
  34. // $columnnames = mysql_field_name($result, $i);
  35. // echo $columnnames;
  36. // }
  37.  
  38.  
  39. $fname = $_POST['fname'];
  40. $lname = $_POST['lname'];
  41. $email = $_POST['email'];
  42.  
  43. echo $fname ;
  44. echo $lname ;
  45. echo $email ;
  46.  
  47. $query = "update test set
  48. fname = $fname,
  49. lname = $lname,
  50. email = $email
  51. where 1 ";
  52.  
  53. $result = mysql_query($query);
  54.  
  55. if ($query = 1) {
  56.  
  57. echo "IT WORKED";
  58.  
  59. } else {
  60. echo "DIDNT WORK";
  61. }
  62. }else{
  63. echo "NOT SUBMITTED";
  64. }
  65.  
  66. ?>
  67.  
  68. //form.html
  69.  
  70. <form name="account" action="test.php" method="post">
  71. <td align="left" valign="top" class="labelstyle" width="25%">First Name</td>
  72. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="fname" value="" /></td>
  73. <td align="left" valign="top" class="labelstyle" width="25%">Last Name</td>
  74. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="lname" value="" /></td>
  75. <td align="left" valign="top" class="labelstyle" width="25%">Email</td>
  76. <td align="left" valign="top" class="labeltextstyle" width="75%"><input type="text" name="email" value="" /></td>
  77.  
  78.  
  79. <td align="left" valign="top" class="labeltextstyle"><input type="submit" name="submit" value="Save" /></td>
  80.  
  81. </form>
  82.  
  83. $query = "update test set
  84. fname = $fname,
  85. lname = $lname,
  86. email = $email
  87. where id = 1";
  88.  
  89. $query = "insert into test (fname,lname,email) VALUES ($fname,$lname,$email);
  90.  
  91. $query = "update test set
  92. fname = '$fname',
  93. lname = '$lname',
  94. email = '$email'
  95. where 1";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement