Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. <?php
  2.  
  3. $username="XXXX";
  4. $password="XXXXXX";
  5. $database="XXXXX";
  6.  
  7. mysqli_connect('XXXX',$username,$password);
  8. mysqli_select_db($database) or die( "Unable to select database");
  9. $query = "SELECT * FROM Request";
  10. $query2="UPDATE Request (Reg_F_Name,Reg_L_Name,Reg_Request)";
  11. VALUES ("$row[Reg_F_Name]","$row[Reg_L_Name]","$row[Reg_Request]")
  12. $result = mysqli_query($query);
  13. $row = mysqli_fetch_array($result);
  14. ?>
  15.  
  16. <form method="post" action="ApproveDenyPrayerRequest.php" />
  17.  
  18. <table>
  19.  
  20. <tr>
  21. <td>First Name:</td>
  22. <td><input type="text" name="first" value="<? echo "$row[Reg_F_Name]" ?>"></td>
  23. </tr>
  24.  
  25. <tr>
  26. <td>Last Name:</td>
  27. <td><input type="text" name="last" value="<? echo "$row[Reg_L_Name]" ?>"></td>
  28. </tr>
  29.  
  30. <tr>
  31. <td>Prayer Request</td>
  32. <td><input type="text" name="phone" value="<? echo "$row[Reg_Request]" ?>"></td>
  33. </tr>
  34.  
  35. </table>
  36.  
  37. </form>
  38.  
  39. $query2="UPDATE Request (Reg_F_Name,Reg_L_Name,Reg_Request)";
  40. VALUES ("$row[Reg_F_Name]","$row[Reg_L_Name]","$row[Reg_Request]")
  41.  
  42. $query2="INSERT INTO Request (Reg_F_Name,Reg_L_Name,Reg_Request)
  43. VALUES ( '$row[Reg_F_Name]', '$row[Reg_L_Name]', '$row[Reg_Request]' )";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement