PHP Model::executeQuery_Row Examples

Example #1

File: controller_content.php Project: Falscroom/myFirstSite

 function action_add($routes)
 {
     $model = new Model();
     $user_id = $_COOKIE['user_id'];
     $model->prepareQuery("SELECT COUNT(id) FROM `order` WHERE user_id=" . $user_id . "");
     $res = $model->executeQuery_Row();
     if ($res[0] > 0) {
         $model->prepareQuery("SELECT id FROM `order` WHERE user_id=" . $user_id . " LIMIT 1");
         $res = $model->executeQuery_Row();
         $model->prepareQuery("INSERT INTO `order_item` (order_id,item_id) VALUES ('.{$res['0']}.','.{$routes['0']}.')");
         $model->executeQuery_Simple();
     } else {
         $model->prepareQuery("INSERT INTO `order`(`user_id`) VALUES ('.{$user_id}.')");
         $model->executeQuery_Simple();
         $model->prepareQuery("SELECT id FROM `order` WHERE user_id=" . $user_id . " LIMIT 1");
         $res = $model->executeQuery_Row();
         $model->prepareQuery("INSERT INTO `order_item` (order_id,item_id) VALUES ('.{$res['0']}.','.{$routes['0']}.')");
         $model->executeQuery_Simple();
     }
 }