public function savePost() { foreach ($_POST as $key => $val) { if ($key != "id") { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } } if (!$_POST["id"]) { $sql = "INSERT INTO " . get_table("brands") . " SET " . implode(",", $sqlv); } else { $sql = "UPDATE " . get_table("brands") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"]; } $rs = $this->mDb->execute($sql); return $rs; }
public function savePost() { foreach ($_POST as $key => $val) { if (!in_array($key, array("id", "aid"))) { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } } if (!$_POST["id"]) { $sql = "INSERT INTO " . get_table("asks") . " SET " . implode(",", $sqlv) . ",addtime='" . time() . "'"; } else { $sql = "UPDATE " . get_table("asks") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"]; } $rs = $this->mDb->execute($sql); return $rs; }
public function savePost() { if ($_POST["status"] == "1") { } $aid = $_POST["aid"]; unset($_POST["aid"]); foreach ($_POST as $key => $val) { if (!in_array($key, array("id", "place_traffic"))) { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } } if (!$_POST["id"]) { //$sqlv[] = " createtime = '".time()."'"; $sql = "INSERT INTO " . get_table("events") . " SET " . implode(",", $sqlv); } else { $sql = "UPDATE " . get_table("events") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"]; } $rs = $this->mDb->execute($sql); if (!$_POST["id"]) { $pid = $this->mDb->Insert_ID(); } else { $pid = $_POST["id"]; } if ($rs) { $rs = $pid; } $this->updateAttachments($aid, $pid, "events"); return $rs; }
private function createExpand($expand, $pid, $type) { $this->mDb->execute("DELETE FROM " . get_table("expands") . " WHERE pid={$pid} AND type='{$type}'"); if ($expand) { foreach ($expand as $data) { $sqlv = ""; $sqlv[] = " type = '{$type}'"; $sqlv[] = " pid = '{$pid}'"; foreach ($data as $key => $val) { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } $sql = "INSERT INTO " . get_table("expands") . " SET " . implode(",", $sqlv); $this->mDb->execute($sql); } } }
public function savePost() { foreach ($_POST as $key => $val) { if (!in_array($key, array("id", "aid"))) { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } } if (!$_POST["id"]) { $sql = "INSERT INTO " . get_table("articles") . " SET " . implode(",", $sqlv) . ",addtime='" . time() . "'"; } else { $sql = "UPDATE " . get_table("articles") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"]; } $rs = $this->mDb->execute($sql); if (!$_POST["id"] and $_POST["email"] != "888") { if ($_POST["email"] == "999") { $send = $this->Send_mail(999); //发送全部 } else { $send = $this->Send_mail($_POST["email"]); //按班级发送 } } return $rs; }
public function savePackagesSales() { foreach ($_POST as $key => $val) { if (!in_array($key, array("id", "product_package"))) { $sqlv[] = " {$key} = '" . sb_addslashes($val) . "'"; } } if (!$_POST["id"]) { $sql = "INSERT INTO " . get_table("product_packages") . " SET " . implode(",", $sqlv); } else { $sql = "UPDATE " . get_table("product_packages") . " SET " . implode(",", $sqlv) . " WHERE id=" . $_POST["id"]; } $rs = $this->mDb->execute($sql); if (!$_POST["id"]) { $ppid = $this->mDb->Insert_ID(); } else { $ppid = $_POST["id"]; } $sql = "DELETE FROM " . get_table("product_to_packages") . " WHERE ppid=" . $ppid; $this->mDb->execute($sql); foreach ($_POST["product_package"] as $val) { $sql = "INSERT INTO " . get_table("product_to_packages") . " SET ppid='{$ppid}',pid='" . $val["pid"] . "',quantity='" . $val["quantity"] . "'"; $this->mDb->execute($sql); } return $rs; }