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 -
   31   32   33   34   35   36   37   38   39   40   41