} // preg product's cover preg_match('/data\\:image\\/jpeg;base64,(.+)/i', $html, $cover); if (!empty($cover[0])) { $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.'); }