getMessage();
$message .= 'For the followings reason' . $message . '$my_guitar_shop2
database couldnt be opened, thanks!';
echo $message;
exit();
}
$query = "SELECT * FROM PRODUCTS
ORDER BY productID";
$products = $db->query($query);
$list_tasks = array('task1', 'task2', 'task3', 'task4', 'task5', 'task6',
'task7', 'task8', 'task9', 'task10', 'task11', 'task12', 'task13', 'task14');
$date = new DateTime('06/05/2015 12:00');
$date_product = $date ->format('M. j, Y');
//Insert product
function add_product($category_id, $code, $name, $price){
global $db;
if(empty($code)||empty($name)||empty($price)){
$message = 'Invalid Data';
} else {
$query ="INSERT INTO products
(categoryID, productCode, productName, listPrice)
VALUES
('$category_id', '$code', '$name', '$price')";
$insert_count = $db->exec($query);
$message = '' . 'Insert count: ' . $insert_count . '
';
}
return $message;
}
function delete_product($product_id){
global $db;
$query = "DELETE FROM products
WHERE productID ='$product_id'";
$delete_count = $db->exec($query);
$message = '' . 'Delete count: ' . $delete_count . '
';
return $message;
}
//Get all product
if(isset($_GET['action'])){
$action =$_GET['action'];
}elseif(isset($_POST['action'])){
$product_Id = $_POST['product_id'];
$action =$_POST['action'];
}else{
$action = '';
}
switch ($action){
case 'add_product':
$category_id = $_GET['categoryId'];
$code =$_GET['code'];
$name = $_GET['name'];
$price = $_GET['price'];
$message = add_product($category_id, $code, $name, $price);
break;
case 'delete_product':
$product_id = $_GET['product_id'];
$message = delete_product($product_id);
$category_id = '';
$code = '';
$name = '';
$price = '';
break;
default:
$category_id = '';
$code = '';
$name = '';
$price = '';
$product_id = '';
break;
}
?>
Task6
FeedBack of Action: ' . $message;
}
?>
List of Products
| Product Name |
Listed Price |
Remove Product |
|
|
Delete |
ADDING PRODUCT TO DATABASE