Created
December 10, 2021 14:45
-
-
Save SudiDav/c4eb4a857f3682ca61590b0f666f6a34 to your computer and use it in GitHub Desktop.
CRUD in PHP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include'dbconnect.php'; | |
//Save to db | |
if (isset($_POST['btnsave'])) { | |
$productname = $_POST['txtname']; | |
$productprice = $_POST['txtprice']; | |
if (!empty($productname && $productprice)) { | |
$insert = $pdo -> prepare("insert into tbl_product(productname,productprice) values(:name,:price)"); | |
$insert -> bindParam(':name',$productname); | |
$insert -> bindParam(':price',$productprice); | |
$insert -> execute(); | |
if ($insert -> rowCount()) { | |
echo 'Inserted Successfully!'; | |
} else { | |
# code... | |
echo 'Insertion Failed!'; | |
} | |
} else { | |
# code... | |
echo 'Fields are empty!'; | |
} | |
} | |
//Update data from db | |
if (isset($_POST['btnUpdate'])) { | |
# code... | |
$productname = $_POST['txtname']; | |
$productprice = $_POST['txtprice']; | |
$prodId = $_POST['txtprodId']; | |
if (!empty($productname && $productprice)) { | |
# code... | |
$update = $pdo -> prepare('update tbl_product set | |
productname=:pname,productprice=:pprice where prodId='.$prodId); | |
$update -> bindParam(':pname',$productname); | |
$update -> bindParam(':pprice',$productprice); | |
$update -> execute(); | |
if ($update -> rowCount()) { | |
echo 'Updated Successfully!'; | |
} else { | |
# code... | |
echo 'Update Failed!'; | |
} | |
} else { | |
# code... | |
echo 'Please give me valid values!'; | |
} | |
} | |
//Delete data from the db | |
if (isset($_POST['btnDelete'])) { | |
# code... | |
$delete = $pdo -> prepare("delete from tbl_product where prodId=".$_POST['btnDelete']); | |
$delete -> execute(); | |
if ($delete -> rowCount()) { | |
echo 'Delete Successfully!'; | |
} else { | |
# code... | |
echo 'Delete Failed!'; | |
} | |
} | |
?> | |
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<title>CRUD | PHP</title> | |
<link rel="stylesheet" href="style.css"> | |
</head> | |
<body> | |
<h2>PHP PDO CRUD OPERATIONS</h2> | |
<form class="main" action="" method="post"> | |
<?php | |
# Edit | |
if (isset($_POST['btnEdit'])) | |
{ | |
$select = $pdo->prepare("select * from tbl_product where prodId=".$_POST['btnEdit']); | |
$select->execute(); | |
if ($select) { | |
# code... | |
$row = $select->fetch(PDO::FETCH_OBJ); | |
//print_r($row); | |
//Update text filed below | |
echo ' | |
<p><input type="text" name="txtname" value="'.$row->productname.'" class="field"></p> | |
<p><input type="text" name="txtprice" value="'.$row->productprice.'" class="field"></p> | |
<p><input type="hidden" name="txtprodId" value="'.$row->prodId.'"></p> | |
<button type="submit" name="btnUpdate" class="btnUpdate">Update</button> | |
<button type="submit" name="btnCancel" class="btnCancel">Cancel</button> | |
'; | |
} | |
//get all the records from the db | |
} | |
else { | |
# code... | |
echo ' | |
<p><input type="text" name="txtname" | |
placeholder="Product Name" | |
class="field"></p> | |
<p><input type="text" name="txtprice" | |
placeholder="Product Price" | |
class="field"></p> | |
<input type="submit" name="btnsave" value="Save" class="btn"> | |
'; | |
} | |
?> | |
<br> | |
<br> | |
<table id="producttable" border="1"> | |
<thead> | |
<th>ID </th> | |
<th>Product Name </th> | |
<th>Product Price </th> | |
<th>Edit </th> | |
<th>Delete</th> | |
</thead> | |
<tbody> | |
<?php | |
$select = $pdo->prepare("select * from tbl_product"); | |
$select->execute(); | |
//get all the records from the db | |
while ($row = $select->fetch(PDO::FETCH_OBJ)) { | |
echo' | |
<tr> | |
<td>'.$row->prodId.'</td> | |
<td>'.$row->productname.'</td> | |
<td>$'.$row->productprice.'</td> | |
<td><button type="submit" value="'.$row->prodId.'" | |
name="btnEdit">EDIT</button></td> | |
<td><button type="submit" value="'.$row->prodId.'" | |
name="btnDelete">DELETE</button></td> | |
</tr> | |
'; | |
} | |
?> | |
</tbody> | |
</table> | |
</form> | |
</body> | |
</html> | |
<hr> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment