Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- form.php
- <?php
- $con=mysqli_connect("localhost","","","");
- mysql_select_db('', '$con');
- $users_on= $_POST ['users_on'];
- $comm_av = $_POST['comm_av'];
- $comm_store = $_POST['comm_store'];
- $cii_on = $_POST['cii_on'];
- $cii_off = $_POST['cii_off'];
- $cii_today = $_POST['cii_today'];
- $cii_store = $_POST['$cii_store'];
- $cii_confirm = $_POST['$cii_confirm'];
- $cii_fail = $_POST['cii_fail'];
- $reboot = $_POST['reboot']
- $reboot_fail = $_POST['reboot_fail'];
- $battery = $_POST['$battery'];
- $cii_history = $_POST['$cii_history'];
- $query="INSERT INTO summary_report (users_on, comm_av, comm_store, cii_on, cii_off,
- cii_today, cii_store, cii_confirm, cii_fail, reboot, reboot_fail, battery, cii_history)
- VALUES ('$users_on', '$comm_av', '$comm_store', '$cii_on', '$cii_off', '$cii_today',
- '$cii_store', '$cii_confirm', '$cii_fail', '$reboot', '$reboot_fail', '$battery', '$cii_history')";
- if (!mysqli_query($con,$query)) {
- die('Error: ' . mysqli_error($con));
- }
- echo "Records added";
- mysqli_close($con);
- ?>
- PHP on index.html to display form results.
- <?php
- $connection=mysqli_connect("localhost","", "");
- mysql_select_db('', '$connection');
- $sql= "SELECT * FROM summary_report";
- $myData = mysql_query($sql, $connection);
- while ($record=$mysql_fetch_array($myData)){
- echo $record['users_on'];
- echo $record['comm_av'];
- echo $record['comm_store'];
- echo $record['cii_on'];
- echo $record['cii_off'];
- echo $record['cii_today'];
- echo $record['cii_store'];
- echo $record['cii_confirm'];
- echo $record['cii_fail'];
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement