Page 35 - 3-2
P. 35

//Executing query to database
                            if(mysqli_query($con,$sql2)){
                                    echo 'mdp_table1 Added Successfully';
                            }else{
                                    echo 'Could Not Add mdp_table1';
                            }


                echo $name;
                echo $price;
                //require_once('layout_add.php');


                    mysqli_close($con);
            ?>




            <html>
            <title>TEST 1</title>
            </html>


            ----------------*owner_table3_create.php*------------
            <?php


            require_once __DIR__ . '/db_connect.php';
            $sql = "INSERT INTO mdp_table3(code, name, num,price)
                SELECT code, name,'1', price


                 FROM mdp_menu";
                            //Executing query to database
                            if(mysqli_query($con,$sql)){
                                    echo 'mdp_table3 Added Successfully';
                            }else{
                                    echo 'Could Not Add mdp_table3';
                            }


            mysqli_close($con);
            ?>


            <html>
            <title>TEST 1</title>
            </html>












                                                         - 35 -
   30   31   32   33   34   35   36   37   38   39   40