Page 36 - 3-2
P. 36
----------------*purcharse.php*-------------
<?php
require_once __DIR__ . '/db_connect.php';
$sql = "INSERT INTO mdp_table2 SELECT * FROM mdp_table1";
//Executing query to database
if(mysqli_query($con,$sql)){
echo 'mdp_table2 Added Successfully';
}else{
echo 'Could Not Add mdp_table2';
}
$sql2 = "DELETE FROM mdp_table1";
//Executing query to database
if(mysqli_query($con,$sql2)){
echo 'Deleted Successfully';
}else{
echo 'Could Not Delete Try Again';
}
mysqli_close($con);
?>
<html>
<title>TEST 1</title>
</html>
----------------*owner_all_product_table2.php*-------------
<?php
/*
* Following code will list all the products
*/
// array for JSON response
$response = array();
// include db connect class
require_once __DIR__ . '/db_connect.php';
// connecting to db
//$db = new DB_CONNECT();
- 36 -