public function saveedit() { //保存产品 $id = getgpc("id"); if ($id) { $res = fetch_one_array("select * from " . dbtable("englandstyle") . " where id ='" . $id . "' "); if (!$res) { alert("错误,没有找到该数据", ""); } } $title = getgpc("title"); $showtime = getgpc("showtime"); $intr = getgpc("intr"); $content = getgpc("content"); $simgurl = getgpc("simgurl"); $imgurl = getgpc("imgurl"); $lovenum = getgpc("lovenum"); $displayorder = intval(getgpc("displayorder")); $status = intval(getgpc("status")); $indata = array("title" => $title, "showtime" => $showtime, "intr" => $intr, "content" => $content, "simgurl" => $simgurl, "imgurl" => $imgurl, "lovenum" => $lovenum, "displayorder" => $displayorder, "status" => $status); if (!$id) { // $indata["gtime"] = date("Y-m-d H:i:s"); dbinsert("englandstyle", $indata); } else { $indata["uptime"] = date("Y-m-d H:i:s"); dbupdate("englandstyle", $indata, array('id' => $id)); } js_alert("保存成功", "top.location.href='?mod=englandstyle&act=index'"); }
function entry_onsubmit($param, $post) { $data = ["msglist" => gettable("select * from site_guestbook")]; $scr = new Scriptor("site_guestbook/guestbook.html", $data); if (($post = $scr->validate("entry", $post)) === false) { return $scr->result(); } dbinsert("site_guestbook", ["name" => $post["name"], "content" => $post["content"]]); return child_render($param); }
function subscribe_onsubmit($param, $post) { global $_SERVER; $scr = new Scriptor("site_guestbook/purchase.html"); if (($post = $scr->validate("emailsubscribe", $post)) === false) { return $scr->result(); } dbinsert("beta_emails", ["email" => $post["email"], "landing" => $_SERVER["SERVER_NAME"]]); return redirect("/thanks"); }
/** * Called when migrating up */ public function up() { //fetch duplicate rows $duplicate_rows = dbfetch("SELECT *, COUNT(*) AS count FROM `#__edges` GROUP BY `type`, `node_a_id`, `node_a_type`, `node_b_id`, `node_b_type` HAVING count > 1"); //delete duplicate rows foreach ($duplicate_rows as $row) { dbexec('DELETE FROM `#__edges` WHERE `type`=\'' . $row['type'] . '\' AND `node_a_id`=\'' . $row['node_a_id'] . '\' AND `node_a_type`=\'' . $row['node_a_type'] . '\' AND `node_b_id`=\'' . $row['node_b_id'] . '\' AND `node_b_type`=\'' . $row['node_b_type'] . '\' '); } //add unique constraint to columns dbexec('ALTER TABLE `#__edges` ADD CONSTRAINT `uc_edge` UNIQUE(`type`, `node_a_id`, `node_a_type`, `node_b_id`, `node_b_type`)'); //insert previously duplicate rows once each foreach ($duplicate_rows as $row) { unset($row['id']); unset($row['count']); dbinsert('edges', $row); } }
if (isset($_SERVER["argv"]) && isset($_SERVER["SCRIPT_FILENAME"]) && basename($_SERVER["SCRIPT_FILENAME"]) == basename(__FILE__)) { echo "cog_database: Running self-tests...\n"; // set up asserts assert_options(ASSERT_ACTIVE, 1); assert_options(ASSERT_WARNING, 0); assert_options(ASSERT_QUIET_EVAL, 0); // Set up the callback assert_options(ASSERT_CALLBACK, function ($file, $line, $code) { echo "Assertion Failed:\n File '{$file}' \n Line '{$line}' Code '{$code}'\n\n"; }); assert(initsql()); assert(resolvequery("VALUES (@email, @example)", array("email" => "*****@*****.**", "example" => 123)) == 'VALUES ("*****@*****.**", "123")'); // table-based testing dbcommit("drop table if exists cog_testing"); dbcommit("create table if not exists cog_testing (id int primary key auto_increment, username varchar(64), status enum('live', 'deleted') default 'live', created datetime )"); dbinsert("cog_testing", ["username" => random_string(16)], ["created" => "now()"]); $q = gettable("select * from cog_testing where status = 'live' "); assert(count($q) == 1); // unique insert testing $res = dbuniqueinsert("cog_testing", ["username" => "unique"], ["username" => "unique", "status" => "live"], ["created" => "now()"]); assert($res !== false); // this should return with new ID $q = gettable("select * from cog_testing where status = 'live' "); assert(count($q) == 2); $res = dbuniqueinsert("cog_testing", ["username" => "unique"], ["username" => "unique", "status" => "live"], ["created" => "now()"]); assert($res == 0); // this should return 0 dbcommit("drop table if exists cog_testing"); // clean up echo "Self-tests finished\n"; }
<div style="clear: both;"></div> <div class="container"> <?php require 'functions.php'; if (isset($_POST['import'])) { $import = $_POST['import']; $arr = explode(',', $import); $run = srvimport($arr['0'], $arr['1'], $arr['2'], $arr['3'], $arr['4'], $arr['5'], $arr['6'], $arr['7'], $arr['8'], $arr['9'], $arr['10'], $arr['11'], $arr['12'], $arr['13']); if ($run == true) { echo "<div class=\"view-messages\">Import Successful!</div>"; } else { echo "<div class=\"view-messages\">Import Failed.</div>"; } } if (isset($_POST['name'])) { $run = dbinsert($_POST['name'], $_POST['provider'], $_POST['city'], $_POST['state'], $_POST['country'], $_POST['datacenter'], $_POST['cost'], $_POST['cycle'], $_POST['start'], $_POST['due'], $_POST['ram'], $_POST['swap'], $_POST['cpu'], $_POST['cpunum'], $_POST['cpuclock'], $_POST['bw'], $_POST['port'], $_POST['disk'], $_POST['disktype'], $_POST['ipv4'], $_POST['ipv6'], $_POST['notes'], $_POST['services']); if ($run == true) { echo "<div class=\"view-messages\">Creation Successful!</div>"; } else { echo "<div class=\"view-messages\">Creation Failed. Please make sure all fields are filled out.</div>"; } } if (isset($_POST['delsid']) and is_numeric($_POST['delsid'])) { $delete = dbdel($_POST['delsid']); if ($delete == true) { echo "<div class=\"view-messages\">Success!</div>"; } else { echo "<div class=\"view-messages\">Failed.</div>"; } } ?>
function set_product($upc, $sid, $description, $brand, $upc, $sku, $wholesale_price, $retail_price) { global $link; $pid = get_product_id($upc, $sid); if (empty($pid)) { $data = array('created_at' => '2014-11-11 11:11:11', 'is_archived' => 0, 'is_processed' => 0, 'is_tracked' => 1, 'is_violated' => 0, 'price_floor' => 0, 'retail_price' => $retail_price, 'sku' => $sku, 'status' => 1, 'store_id' => $sid, 'title' => $description, 'upc_code' => $upc, 'wholesale_price' => $wholesale_price); $pid = dbinsert($link, 'products', $data); if (!$pid) { var_dump($pid); exit; } } return $pid; }
function log_start() { global $g_log_id; $g_log_id = dbinsert("sys_logs", ["ip" => $_SERVER["REMOTE_ADDR"], "agent" => isset($_SERVER["HTTP_USER_AGENT"]) ? $_SERVER["HTTP_USER_AGENT"] : "", "referer" => isset($_SERVER["HTTP_REFERER"]) ? $_SERVER["HTTP_REFERER"] : "", "url" => $_SERVER["SERVER_NAME"] . $_SERVER["REQUEST_URI"], "permsid" => session_id()]); return true; }
public function saveedit_area() { //保存产品 $id = getgpc("id"); if ($id) { $res = fetch_one_array("select * from " . dbtable("joininfo_area") . " where id ='" . $id . "' "); if (!$res) { alert("错误,没有找到该数据", ""); } } $name = getgpc("name"); $tel = getgpc("tel"); $email = getgpc("email"); $join_name = getgpc("join_name"); $area = getgpc("area"); $displayorder = intval(getgpc("displayorder")); $status = intval(getgpc("status")); $indata = array("name" => $name, "join_name" => $join_name, "tel" => $tel, "area" => $area, "email" => $email, "displayorder" => $displayorder, "status" => $status); if (!$id) { $indata["gtime"] = date("Y-m-d H:i:s"); dbinsert("joininfo_area", $indata); } else { $indata["uptime"] = date("Y-m-d H:i:s"); dbupdate("joininfo_area", $indata, array('id' => $id)); } js_alert("保存成功", "top.location.href='?mod=joininfo&act=area'"); }
function savelink() { //新建 $lid = intval(getgpc("id")); $link_value = getgpc("link_value"); if ($link_value == 1) { $insdata = array("lid" => $lid, "gtime" => date("Y-m-d H:i:s")); dbinsert('newslink', $insdata); alert("推荐新闻成功", ""); } else { $ch = $this->db->query("delete from " . dbtable("newslink") . " where lid='" . $lid . "'"); if ($ch) { alert("取消推荐成功", ""); } else { alert("取消推荐失败", ""); } } //面包屑导航 }
public function saveedit() { //保存产品 $id = getgpc("id"); if ($id) { $res = fetch_one_array("select * from " . dbtable("faq") . " where id ='" . $id . "' "); if (!$res) { alert("错误,没有找到该数据", ""); } } $name = getgpc("name"); $tel = getgpc("tel"); $email = getgpc("email"); $question = getgpc("question"); $displayorder = intval(getgpc("displayorder")); $status = intval(getgpc("status")); $indata = array("name" => $name, "tel" => $tel, "email" => $email, "question" => $question, "reply_sign" => 1, "displayorder" => $displayorder, "status" => $status); if (!$id) { $indata["gtime"] = date("Y-m-d H:i:s"); dbinsert("faq", $indata); } else { $indata["reply"] = getgpc("reply"); $indata["reply_sign"] = 2; $indata["uptime"] = date("Y-m-d H:i:s"); dbupdate("faq", $indata, array('id' => $id)); } js_alert("保存成功", "top.location.href='?mod=faq&act=index'"); }
function faq_save() { $name = getgpc("name"); $tel = getgpc("tel"); $email = getgpc("email"); $question = getgpc("question"); if (empty($name)) { js_alert("请输入姓名"); } if (empty($tel)) { js_alert("请输入联系电话"); } if (empty($email)) { js_alert("请输入Email"); } if (empty($question)) { js_alert("请输入问题描述"); } $indata = array("name" => $name, "tel" => $tel, "email" => $email, "question" => $question, "reply_sign" => 1, "displayorder" => 0, "status" => 1); $indata["gtime"] = date("Y-m-d H:i:s"); dbinsert("faq", $indata); js_alert("提交成功", "top.location.href='?c=home&m=faq'"); }
public function save_employment_content() { //保存产品 $id = getgpc("id"); $pid = getgpc("pid"); if ($id) { $res = fetch_one_array("select * from " . dbtable("employment_content") . " where id ='" . $id . "' "); if (!$res) { alert("错误,没有找到该数据", ""); } } $content = getgpc("content"); $istop = intval(getgpc("istop")); $displayorder = intval(getgpc("displayorder")); $status = intval(getgpc("status")); $indata = array('pid' => $pid, "content" => $content, "istop" => $istop, "displayorder" => $displayorder, "status" => $status); if (!$id) { // $indata["gtime"] = date("Y-m-d H:i:s"); dbinsert("employment_content", $indata); } else { dbupdate("employment_content", $indata, array('id' => $id)); } js_alert("保存成功", "top.location.href='?mod=employment&act=content&pid=" . $pid . "'"); }
public function savecompare() { //保存门店 $id = getgpc("id"); if ($id) { $res = fetch_one_array("select * from " . dbtable("product_compare") . " where id ='" . $id . "' "); if (!$res) { alert("错误,没有找到该数据", ""); } } $title = getgpc("title"); $displayorder = intval(getgpc("displayorder")); $status = intval(getgpc("status")); $indata = array("title" => $title, "displayorder" => $displayorder, "status" => $status); if (!$id) { dbinsert("product_compare", $indata); } else { dbupdate("product_compare", $indata, array('id' => $id)); } alert("保存成功", "admin.php?mod=product&act=compareindex"); }
public function saveedit() { $id = intval(getgpc("id")); $tid = intval(getgpc("tid")); $title = getgpc("title"); $stitle = getgpc("stitle"); $imgurl = getgpc("imgurl"); $intr = getgpc("intr"); $type = getgpc("type"); $url = getgpc("url"); // if(!empty($url)) // { // if(!strstr($url,"http://") and !strstr($url,"www") and !strstr($url,"index.php")) // { // $url="index.php".$url; // } // } // if(!is_numeric(substr($url, -1)) and $tid=='1') // { // js_alert("请输入相对应产品的ID号"); // } if (empty($imgurl) and $tid != '11' and $tid != 9) { js_alert("上传相应的图片"); } $con = getgpc("con"); $istop = getgpc("istop"); $displayorder = getgpc("displayorder"); $status = getgpc("status"); $indata = array('tid' => $tid, 'type' => $type, 'title' => $title, 'stitle' => $stitle, 'imgurl' => $imgurl, 'intr' => $intr, 'url' => $url, 'con' => $con, 'gtime' => date("Y-m-d H:i:s"), 'postip' => json_encode(convertip()), "istop" => $istop, "displayorder" => $displayorder, "status" => $status); if (!$id) { //更新 dbinsert("indexpush", $indata); } else { //dbupdate("indexpush",$indata,"id='".$id."'"); dbupdate("indexpush", $indata, array('id' => $id)); } js_alert("保存成功", "top.location.href='?mod=indexpush&tid=" . $tid . "'"); }