/** * Create/update a product record in the database */ public function saveAction() { $productsTable = new Products(); $form = $this->getForm(); if ($form->isValid($_POST)) { $values = $form->getValues(); $id = $this->_hasParam('id') ? $this->_getParam('id') : null; unset($values['product_id'], $values['submit']); if (isset($id) && $id != null) { $productsTable->update($values, array('product_id = ?' => $id)); } else { $id = $productsTable->insert($values); } $this->_redirect('/products/view/id/' . $id); } else { echo $form; } }
/** * 更新国家信息 * @access public */ function update_save() { $id = get_post_value('product_id'); $product_url = get_post_value('product_url'); $title_cn = get_post_value('title_cn'); $title_th = get_post_value('title_th'); $category_1 = get_post_value('category_1'); $category_2 = get_post_value('category_2'); $category_3 = get_post_value('category_3'); $floor_1 = get_post_value('floor_1'); $floor_2 = get_post_value('floor_2'); $floor_3 = get_post_value('floor_3'); $purchase_price = trim(get_post_value('purchase_price')); $sales_price = trim(get_post_value('sales_price')); $start_time = get_post_value('start_time'); $end_time = get_post_value('end_time'); $image_url = trim(get_post_value('image_url')) == '' ? get_post_value('image_url_old') : get_post_value('image_url'); $product_url = get_post_value('product_url'); $shop_id = get_post_value('shop_id'); $shop = get_post_value('shop'); $shop_url = get_post_value('shop_url'); $preferential_price = get_post_value('preferential_price'); $field = array('title_cn' => trim($title_cn), 'title_th' => trim($title_th), 'category_3_id' => trim($category_3), 'floor_3_id' => trim($floor_3), 'purchase_price' => intval($purchase_price), 'sales_price' => intval($sales_price), 'preferential_price' => intval($preferential_price), 'image_url' => trim($image_url), 'product_url' => trim($product_url), 'shop' => trim($shop), 'start_time' => $start_time, 'end_time' => $end_time, 'hits' => '0', 'buys' => '0', 'favorites' => '0', 'created' => time(), 'created_name' => '', 'upload_name' => '', 'status' => '10000', 'category_1_id' => $category_1); $m = new Products(); $m->clear(); $m->setTable('vcb_product'); //设置表名 $m->setField($field); ///设置更新字段及值,(键值数组) $m->setWhere('product_id', '=', $id); //设置Where条件 $m->update(); //返回 echo '<br>操作成功,<a href="index" >返回</a><br>'; }
function update_sizesave() { $size = trim(get_post_value('u_size')); $id = get_post_value('id'); //echo $pro_k_id; $ve = $this->verify_kind($id); // var_dump($ve); if (empty($ve)) { header('Location:error.php'); } $m = new Products(); $field = array('size' => $size); $m->clear(); $m->setField($field); $m->setTable(' vcb_product_ksize '); $m->setWhere('id', '=', $id); $data = $m->update(); if (!empty($data)) { header('Location:add_size?id=' . $id); } }
<input type="submit" value="Save" style="width:100%;height:100%;"></button> </td> </form> <?php echo "</tr>"; } echo " </tbody></table></div></div>"; } elseif ($_GET['y'] == 3) { $array = $product->delete($_GET['z']); } elseif ($_GET['y'] == 2) { $prod = new Products(); $prod->name = $_POST['name']; $prod->price = $_POST['price']; $prod->qty = $_POST['qty']; $prod->sale = $_POST['sale']; $prods = $prod->update($_POST['id']); } } ?> </div> <!-- /. ROW --> </div> <!-- /. PAGE INNER --> </div> <!-- /. PAGE WRAPPER --> </div> <!-- /. WRAPPER --> <!-- JS Scripts--> <!-- jQuery Js -->
} class Users extends Table { // 针对于Users表的操作 function getById() { $sql = '.....'; } } class Products extends Table { // 针对Products表的操作 function showoff() { $sql = 'XXXX products'; } } class Admins extends Table { function changePermissions() { $sql = '....'; } } $users = new Users(); $users->delete(); echo '这张表叫', $users->getTableName(), '<br/><br/>'; $p = new Products(); $p->update(); $a = new Admins(); $a->insert();
$collection_name = $settings['collection']['name']; if (isset($_POST['submit'])) { if (isset($_GET['move'])) { $db->update("products", "collection_id", $_POST['collection_id'], $_GET['move']); $html->redirection("products.php?c=" . $_POST['collection_id'] . "&p=" . $_GET['move']); } else { $products->set_data(); $error = $products->check_data(); if (!$error) { switch ($_GET['p']) { case 'add': $products->create(); $html->redirection("products.php?c=" . $_GET['c'] . "&p=add"); break; default: $products->update(); $html->redirection("products.php?c=" . $_GET['c'] . (isset($_GET['f']) ? "&f=" . $_GET['f'] : '')); break; } } } } if (isset($_GET['p'])) { $products->get_data(); echo "<div id='page-title' class='row'>"; echo "<div class='col-xs-12 col-sm-6'>"; $html->title($_GET['p'] == "add" ? "Add Product" : "{$products->name}", "Collection: {$collection_name}", "left"); echo "</div>"; $products->form(); } else { if (isset($_GET['d'])) {
/** * 删除国家 * @access public */ function delete() { $id = get_post_value('id'); $field = array('status' => '50000'); $m = new Products(); $m->clear(); $m->setField($field); ///设置更新字段及值,(键值数组) $m->setTable('vcb_product'); //设置表名 $m->setWhere('product_id', '=', $id); //设置Where条件 $m->update(); //返回 echo '<br>操作成功,<a href="index" >返回</a><br>'; }