Project | BBG -> PHP(2)

1. Create Table
2. Create Connection
3. Insert Data by Form
4. Display Data
5. Update Record by Form:

there are two file to link
// modify.php & update.php

1. this is a file PHP (update.php)
   

<?php
require("connect_db.inc");
$rs=mysql_query("UPDATE tblproducts
SET productid='$proid', productname
='$proname',price='$price' ,qty='$qty'
WHERE productid='$proid'");
?>
<SCRIPT>
alert("One record modified");
window.location="view_pro_update.php";
</SCRIPT>

Download here
//modify.php

1. Modify Product by Form

6. Delete Record
//delete.php

  <?php
require("connect_db.inc");
mysql_query("delete from tblproducts
where productid='$productid'");
?>
<SCRIPT>
alert("Delecte one Record Successful!");
window.location="view_pro_update.php";
</SCRIPT>

Download here
//view_pro_update.php & Searching Product with Database

1. Display Data Product (new update)
2. Database MySql (*.sql) (tblproducts.sql)

Done...!!!