$product['cover'] = 1; //trim($cover[0]); // save picture @file_put_contents(PT_PATH . 'picture/' . $product['id'] . '.jpg', base64_decode($cover[1])); } } // preg product's star if (preg_match('/5つ星のうち ([0-9.]+)/i', $html, $star)) { $product['star'] = $star[1]; } $db->beginTrans(); $product = filter::apply('refresh', $product, $html); // Save $id = $product['id']; unset($product['id']); list($sql, $value) = array_values(update_array($product)); $value[':id'] = $id; $rs = $db->prepare("UPDATE `a_good` SET {$sql} WHERE `id`=:id")->execute($value); if ($rs === false) { $db->rollback(); json_return(null, 1, 'Load page\'s data fail, please retry.'); } // Commit if (!$db->commit()) { $db->rollback(); json_return(null, 9, 'Load page\'s data fail, please retry.'); } $product['id'] = $id; template::assign('v', $product); $html = template::fetch('_tr'); json_return($html);
// Delete // Delete case 'delete': if ($_POST) { $id = (int) $_POST['id']; $db = db::init(); $db->beginTrans(); $rs = $db->prepare("DELETE FROM `a_good` WHERE `id`=:id")->execute(array(':id' => $id)); if (false === $rs) { $db->rollback(); json_return(null, 1, 'Operation failed.'); } action::exec('delete', $id); if ($db->commit()) { json_return(1); } json_return(null, 9, 'Operation failed.'); } break; // List page // List page case 'default': default: $keyword = ''; template::assign('keyword', $keyword); $db = db::init(); $sql = "SELECT * FROM `a_good` WHERE `user`=:uid ORDER BY `id` DESC"; $list = $db->prepare($sql)->execute(array(':uid' => $uid)); template::assign('list', $list); template::display('index'); }