php inset into db code example
Example: php insert and display data
<?php
include("config.php");
if(isset($_POST['Submit'])) {
$pname = $_POST['pname'];
$pcode = $_POST['pcode'];
$pprice = $_POST['pprice'];
if(empty($pname) || empty($pcode) || empty($pprice)) {
if(empty($pname)) {
echo "<font color="red">Product Name field is empty.</font><br>";
}
if(empty($pcode)) {
echo "<font color="red">Product Code field is empty.</font><br>";
}
if(empty($pprice)) {
echo "<font color="red">Product Price field is empty.</font><br>";
}
echo "<br><a href="javascript:self.history.back();">Go Back</a>";
} else {
$result = mysqli_query($cser, "INSERT INTO crud2(pname,pcode,pprice) VALUES('$pname','$pcode','$pprice')");
echo "<font color="green">Data added successfully.</font>";
}
}
?>