Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 5.51 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. PHP Save Record Error Message
  2. <?php
  3. mysql_connect ("host","user","password") or die (mysql_error());
  4. mysql_select_db ("database");
  5.  
  6. if ($_SERVER['REQUEST_METHOD'] == 'POST') {  
  7.    if (isset($_POST['search'])) {
  8.       $searchemailaddress = $_POST['searchemailaddress'];
  9.       $sql = mysql_query("select * from userdetails where emailaddress like '$searchemailaddress'");
  10.      if (mysql_num_rows($sql) == 0)
  11.         $msg = 'There are no member records set up with this email address, please try again!';
  12.      }
  13.      while ($row = mysql_fetch_array($sql)){
  14.         $emailaddress = $row['emailaddress'];
  15.         $forename = $row['forename'];
  16.         $surname = $row['surname'];
  17.         $subscriptionexpiration = $row['subscriptionexpiration'];
  18.      }
  19.    }
  20.    if (isset($_POST['update'])) {
  21.       $emailaddress = $_POST['emailaddress'];
  22.       $forename = $_POST['forename'];
  23.       $surname = $_POST['surname'];
  24.       $subscriptionexpiration = $_POST['subscriptionexpiration'];
  25.       $sql = mysql_query("UPDATE `userdetails` SET `emailaddress` = '$emailaddress', `forename` = '$forename',`surname` = '$surname',`subscriptionexpiration` = '$subscriptionexpiration' LIMIT 1");
  26.       $msg = 'This members records have been successfully updated!';
  27.   }
  28. ?>
  29. <html>
  30. <head>
  31. <title>Search the Database</title>
  32. <style type="text/css">
  33. <!--
  34. .style1 {font-family: Calibri
  35. }
  36. .style9 {   font-family: Calibri;
  37.     font-size: 24px;
  38.     background-color: #78AFC5;
  39. }
  40. .style7 {
  41.     font-family: Calibri;
  42.     font-size: 16px;
  43.     background-color: #FFFFFF;
  44. }  
  45. -->
  46. </style>
  47. </head>
  48. <body>
  49.  
  50.   </p>
  51.   <p class="style1">&nbsp;</p>
  52. <div align="center"><span class="style9">Search & Amend User Records </span></div>
  53. <p class="style7"><span class="style10">
  54.   <?php
  55. if (isset($msg)) // this is special section for
  56. // outputing message
  57. {
  58. ?>
  59. </span>
  60. <p class="style7">
  61.   <?=$msg?>
  62.   <p class="style7"><span class="style10">
  63.   <?php
  64. }
  65. ?>
  66.   </span>
  67.   <form action="searchandamend.php" method="post">
  68.   <table width="393" border="1">
  69.     <tr>
  70.       <td width="161"><span class="style1">Search:</span></td>
  71.       <td width="207"><span class="style1">
  72.         <input name="searchemailaddress" type="text" id="searchemailaddress" size="25"/>
  73.       </span></td>
  74.     </tr>
  75.     <tr>
  76.       <td><span class="style1">Email Address:</span></td>
  77.       <td><span class="style1">
  78.         <input name="emailaddress" type="text"value="<?php echo $emailaddress;?>" size="25"/>
  79.       </span></td>
  80.     </tr>
  81.     <tr>
  82.       <td><span class="style1">First Name:</span></td>
  83.       <td><span class="style1">
  84.         <input name="forename" type="text" value="<?php echo $forename;?>" size="20"/>
  85.       </span></td>
  86.     </tr>
  87.     <tr>
  88.       <td><span class="style1">Surname:</span></td>
  89.       <td><input name="surname" type="text" value="<?php echo $surname;?>" size="20"/></td>
  90.     </tr>
  91.     <tr>
  92.       <td><span class="style1">Subscription Expiry Date:</span> </td>
  93.       <td><input name="subscriptionexpiration" type="text" id="subscriptionexpiration" value="<?php echo $subscriptionexpiration;?>" size="10"/></td>
  94.     </tr>
  95.   </table>
  96.   <p><br/>
  97.   <input type="submit" name="search" value="Search Records">
  98.   <input name="update" type="submit" value="Update Record">
  99. </p>
  100. </form>
  101. </body>
  102. </html>
  103.        
  104. if (mysql_num_rows($sql) == 0)
  105.        
  106. if ($_SERVER['REQUEST_METHOD'] == 'POST') {  
  107.    if (isset($_POST['search'])) {
  108.       $searchemailaddress = $_POST['searchemailaddress'];
  109.       $sql = mysql_query("select * from userdetails where emailaddress like '$searchemailaddress'");
  110.       if (mysql_num_rows($sql) == 0)
  111.           $msg = 'There are no member records set up with this email address, please try     again!';
  112.       }
  113.     while ($row = mysql_fetch_array($sql)){
  114.        $emailaddress = $row['emailaddress'];
  115.        $forename = $row['forename'];
  116.        $surname = $row['surname'];
  117.        $subscriptionexpiration = $row['subscriptionexpiration'];
  118.     }
  119. }
  120.        
  121. if ($_SERVER['REQUEST_METHOD'] == 'POST') {  
  122.     if (isset($_POST['search'])) {
  123.         $searchemailaddress = $_POST['searchemailaddress'];
  124.         $sql = mysql_query("select * from userdetails where emailaddress like '$searchemailaddress'");
  125.         if (mysql_num_rows($sql) == 0) {
  126.             $msg = 'There are no member records set up with this email address, please try     again!';
  127.         }
  128.         while ($row = mysql_fetch_array($sql)) {
  129.             $emailaddress = $row['emailaddress'];
  130.             $forename = $row['forename'];
  131.             $surname = $row['surname'];
  132.             $subscriptionexpiration = $row['subscriptionexpiration'];
  133.         }
  134.     }
  135. }
  136.        
  137. if ($_SERVER['REQUEST_METHOD'] == 'POST')  
  138. {  
  139.     if (isset($_POST["search"]))  
  140.     {  
  141. $searchemailaddress = $_POST['searchemailaddress'];
  142. $result = mysql_query("select * from userdetails where emailaddress like '$searchemailaddress'");
  143. if (mysql_num_rows($result) == 0)
  144. $msg = 'There are no member records with the email address you have provided, please try again!';
  145. else
  146. while ($row = mysql_fetch_array($result)){
  147. $emailaddress = $row['emailaddress'];
  148. $forename = $row['forename'];
  149. $surname = $row['surname'];
  150. $subscriptionexpiration = $row['subscriptionexpiration'];
  151. $msg = 'Record retrieved!';
  152. }
  153. }
  154.  
  155. if (isset($_POST["update"]))  
  156.     {  
  157. $emailaddress = $_POST['emailaddress'];
  158. $forename = $_POST['forename'];
  159. $surname = $_POST['surname'];
  160. $result = mysql_query("UPDATE `userdetails` SET `emailaddress` = '$emailaddress', `forename` = '$forename',`surname` = '$surname', `subscriptionexpiration` = '$subscriptionexpiration' LIMIT 1");
  161. $msg = 'This members record has been successfully updated!';
  162. }
  163. }
create a new version of this paste RAW Paste Data