$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');
}
