Code:
<?php
//PHP insert new Record
if(isset($_POST['add'])){
try{
$PDOConnect = new PDO("mysql:host=localhost;dbname=pich","root","");
} catch (PDOException $exc){
echo $exc->getMessage();
exit();
}
$make = $_POST['make'];
$model = $_POST['model'];
$price = $_POST['price'];
$quantity = $_POST['quantity'];
$PDOQuery = "INSERT INTO `inventory`(`make`, `model`, `price`, `quantity`) VALUES (:make,:model,:price,:quantity)";
$PDOResult = $PDOConnect->prepare($PDOQuery);
$PDOExecute = $PDOResult->execute(array(":make"=>$make,":model"=>$model,":price"=>$price,"quantity"=>$quantity));
if($PDOExecute){
echo 'Successfully inserted data into invetory table';
}else{
echo 'data Not Inserted';
}
}
//end insert
//Display Table information
if(isset($_POST['add']))
{
$query = "SELECT * FROM `inventory` WHERE CONCAT(`item_number`, `make`, `model`, `price`, `quantity`)";
$SearchResult = filterTable($query);
}
else{
$query = "SELECT * FROM `inventory`";
$SearchResult = filterTable($query);
}
function filterTable($query){
$username="root";
$password=null;
$database="pich";
$connect = mysqli_connect("localhost",$username,$password,$database);
$FilterResult = mysqli_query($connect, $query);
return $FilterResult;
}
//end Table Display
?>
<!doctype html>
<html>
<head>
<title>Insert Record Using PHP Code</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<style>
table,tr,th,td
{
border: 1px solid black ;
}
</style>
</head>
<body>
<form action="Exercise_Pph_D.php" method="post">
<h1>Insert a new row: </h1>
Make <input type="text" name="make" required placeholder="Make" ><br><br>
Model <input type="text" name="model" required placeholder="Model" ><br><br>
Price <input type="number" name="price" required placeholder="Price"> <br><br>
Quantity<input type="number" name="quantity" required placeholder="Quantity"> <br><br>
<input type="submit" name="add" value="Add">
<hr>
<table>
<h1>content of inventory table</h1>
<tr>
<th>Item Number</th>
<th>Make</th>
<th>Model</th>
<th>Price</th>
<th>Quantity</th>
</tr><br><br>
<?php while ($row = mysqli_fetch_array($SearchResult)):?>
<tr>
<td><?php echo $row['item_number'];?></td>
<td><?php echo $row['make'];?></td>
<td><?php echo $row['model'];?></td>
<td><?php echo $row['price'];?></td>
<td><?php echo $row['quantity'];?></td>
</tr>
<?php endwhile; ?>
</table>
</form>
</body>
</html>
You can go to get more education of above this code by click on here: https://youtu.be/uMxaAdP3LrM
SHARE THIS
0 comments :