Page 28 - 3-2

9. 소프트웨어 작성하기
가. PHP 관련 소스

----------------*code_get.php*-------------
<?php
$code = $_GET['code'];
echo $code;
echo ' 코드';
require_once __DIR__ . '/db_connect.php';
$sql = "SELECT * FROM mdp_menu WHERE code=$code";
$r = mysqli_query($con,$sql);
$result = array();
$row = mysqli_fetch_array($r);
array_push($result,array(
"code"=>$row['code'],
$code=$row['code'],
"name"=>$row['name'],
$name=$row['name'],
"price"=>$row['price'],
$price=$row['price'],
));

$sql2 = "INSERT INTO mdp_table1 (code,name,num,price) VALUES
('$code','$name','1','$price')";
//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;
mysqli_close($con);
?>
----------------*db_connect.php*-------------
<?php
$con = mysqli_connect("localhost","root","raspberry","mdp");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>

- 28 -