Advertisement
Guest User

Untitled

a guest
Jul 11th, 2014
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. form.php
  2. <?php
  3. $con=mysqli_connect("localhost","","","");
  4. mysql_select_db('', '$con');
  5.  
  6.  
  7. $users_on= $_POST ['users_on'];
  8. $comm_av = $_POST['comm_av'];
  9. $comm_store = $_POST['comm_store'];
  10. $cii_on = $_POST['cii_on'];
  11. $cii_off = $_POST['cii_off'];
  12. $cii_today = $_POST['cii_today'];
  13. $cii_store = $_POST['$cii_store'];
  14. $cii_confirm = $_POST['$cii_confirm'];
  15. $cii_fail = $_POST['cii_fail'];
  16. $reboot = $_POST['reboot']
  17. $reboot_fail = $_POST['reboot_fail'];
  18. $battery = $_POST['$battery'];
  19. $cii_history = $_POST['$cii_history'];
  20.  
  21.  
  22. $query="INSERT INTO summary_report (users_on, comm_av, comm_store, cii_on, cii_off,
  23. cii_today, cii_store, cii_confirm, cii_fail, reboot, reboot_fail, battery, cii_history)
  24. VALUES ('$users_on', '$comm_av', '$comm_store', '$cii_on', '$cii_off', '$cii_today',
  25. '$cii_store', '$cii_confirm', '$cii_fail', '$reboot', '$reboot_fail', '$battery', '$cii_history')";
  26.  
  27.  
  28. if (!mysqli_query($con,$query)) {
  29. die('Error: ' . mysqli_error($con));
  30. }
  31. echo "Records added";
  32.  
  33. mysqli_close($con);
  34. ?>
  35.  
  36. PHP on index.html to display form results.
  37.  
  38. <?php
  39.  
  40. $connection=mysqli_connect("localhost","", "");
  41. mysql_select_db('', '$connection');
  42.  
  43. $sql= "SELECT * FROM summary_report";
  44. $myData = mysql_query($sql, $connection);
  45.  
  46. while ($record=$mysql_fetch_array($myData)){
  47.  
  48. echo $record['users_on'];
  49. echo $record['comm_av'];
  50. echo $record['comm_store'];
  51. echo $record['cii_on'];
  52. echo $record['cii_off'];
  53. echo $record['cii_today'];
  54. echo $record['cii_store'];
  55. echo $record['cii_confirm'];
  56. echo $record['cii_fail'];
  57.  
  58.  
  59. }
  60. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement