Create Read Update Delete in PHP with Source Code

BySlide Scope

Create Read Update Delete in PHP with Source Code

Source Code of Create, Read, Update and Delete in Php.

Source code of config.php

<?php
$conn = mysqli_connect(“localhost”, “root”, “”, “northwind”) OR die(“CNC”);
?>

Showcustomers.php

<?php
include ‘config.php’;
$sqlshow = “SELECT `CustomerID`, `CompanyName`, `ContactName`, `ContactTitle` FROM `customers` “;
$results = mysqli_query($conn, $sqlshow);
echo “<table border=’1′ width=’100%’><tr><th>ID</th> <th>CompanyName</th> <th>ContactName</th> <th>ContactTitle</th></tr>”;
foreach($results as $result){
?>
<tr>
<td><?php echo $result[‘CustomerID’];?></td>
<td><?php echo $result[‘CompanyName’];?></td>
<td><?php echo $result[‘ContactName’];?></td>
<td><?php echo $result[‘ContactTitle’];?></td>
<td>
<a href=”editcustomers.php?cust_id=<?php echo $result[‘CustomerID’];?>”>Edit</a>
</td>
</tr>
<?php
}
echo “</table>”;
?>

Editcustomers.php

<?php
include ‘config.php’;
$custid = $_GET[‘cust_id’];
$sqlshow = “SELECT `CustomerID`, `CompanyName`, `ContactName`, `ContactTitle`
FROM `customers`
WHERE CustomerID = ‘$custid’;
“;
$results = mysqli_query($conn, $sqlshow);
foreach($results as $result){
?>

<form>
<input type=”hidden” name=”contid” value=”<?php echo $_GET[‘cust_id’];?>”><br/>
<input type=”text” name=”cmpname” value=”<?php echo $result[‘CompanyName’];?>”><br/>
<input type=”text” name=”contname” value=”<?php echo $result[‘ContactName’];?>”><br/>
<input type=”text” name=”contitle” value=”<?php echo $result[‘ContactTitle’];?>”><br/>
<input type=”submit” name=”update” value=”Update”>
</form>
<?php
}
echo $_GET[‘cust_id’];
?>

Download Sql from here

 

https://www.aspsnippets.com/Articles/Download-and-Install-Microsoft-Northwind-Sample-database-in-MySql.aspx

About the author

Slide Scope administrator

Slide Scope Posts are written by experts from Core Information Technology and Digital Marketing Industry. We have assistants from Management Science as well.

Leave a Reply