/** * Delete record * @param int|string $id * @return bool True in case of success * @throws \Exception */ public function delete($id, $extCall = false) { $this->gp->checkAccess(__FUNCTION__, $extCall); $parsed_arg = $this->checkArguments($id); if (is_numeric($parsed_arg) !== true) { throw new \Exception("Argumunt is not a string", 6024); } if ($this->isImplement("FileManage")) { $this->deleteFile($parsed_arg); } if (EMA_DEBUG && EMA_LOG_SQL_QUERIES) { $this->logDeleteQuery($this->dbTable, array("id" => $parsed_arg)); } $dbData = $this->dbConnection->delete($this->dbTable, array("id" => $parsed_arg)); if (is_numeric($dbData) === false || $dbData < 1) { $this->throwMysqlError(); } if ($this->isImplement("Sitemap")) { $this->generateSitemap(); } if ($this->isImplement("RssFeed")) { $this->rssFeedUpdate(); } return true; }
<?php error_reporting(E_ALL); ini_set("display_errors", 1); require_once 'meedoo.php'; require_once 'config.php'; $database = new medoo(); // echo 'Request: ' . $_SERVER['REQUEST_METHOD'].'. '; $mealID = $_GET['mealID']; $del = $database->delete("meals", ["AND" => ["mealID" => $mealID]]); if ($del) { echo 'good'; } else { echo 'bad'; }
$p = 1; while ($k < $t) { $result = mysql_query("SELECT * FROM feedback WHERE question_id='{$q_id[$k]}'") or die(mysql_error()); $resp = array("question" => $question[$k], "one" => "0", "two" => "0", "three" => "0", "four" => "0", "five" => "0", "six" => "0"); if ($type[$k] == "radio") { while ($row = mysql_fetch_array($result)) { $resp[$row['answer']]++; } $p++; fputcsv($output, $resp); } $k++; } //reset feedback data $db = new medoo($config['db']); $db->delete('feedback', ['courseid' => $_GET['courseid']]); $db->update('student_course', ['done' => 0], ['course' => $_GET['courseid']]); } else { ?> <!doctype html> <html> <head> <title>Feedback Statistics</title> <script src="<?php echo $config['url']['base_url'] . $config['js_includes']['jquery']; ?> "></script> <script src="Chart.js"></script> <link rel="stylesheet" href="accr.css" />
<?php /** * Created by PhpStorm. * User: KeenSting * Date: 2015/7/7 * Time: 13:09 */ session_start(); $did = $_SESSION['did']; $id = $_POST['depart']; include './parameter/Medoo/Resource/medoo.php'; $mydb = new medoo('meetingmanage'); //换部门 $mydb->update('user', array('DEPART_ID' => $id), array('DEPART_ID' => $did)); //删除部门 $mydb->delete('departs', array('DEPART_ID' => $did)); ?> <html> <head> </head> <body> <script> alert("部门人员已经转移,部门已从列表中删除!"); </script> <meta http-equiv="refresh" content="1;href='./delDepart.php'"; </body> </html>
/** * @param $table * @param $where * @return bool|int */ public function delete($table, $where) { return parent::delete($this->prefix . $table, $where); }
session_start(); header("Content-type:text/html; charset=utf8"); include 'medoo/medoo.php'; $database = new medoo(); if (@$_POST['depart']) { $depart = $_POST['depart']; if ($depart != "日新网") { $manager = $database->select("user", array("id", "name", "sex", "college", "depart", "center"), array("depart" => $depart)); } else { $manager = $database->select("user", array("id", "name", "sex", "college", "depart", "center")); } } else { $manager = $database->select("user", array("id", "name", "sex", "college", "depart", "center")); } $result = array(); if ($manager) { $result["state"] = "success"; $result["message"] = "all done"; $result["info"] = $manager; $json_result = json_encode($result); echo $json_result; } else { $result["state"] = "error"; $result["message"] = "ERROR:Sql flase"; $json_result = json_encode($result); echo $json_result; } if (@$_POST['id']) { $id = $_POST['id']; $database->delete("user", array("id" => $id)); }
/** * @param string $table * @param array $where * @return bool|int */ public function delete($table, $where) { $re = parent::delete($table, $where); $this->lastSql = $this->last_query(); $this->lastError = $this->error(); return $re; }
$_SESSION["allOP"] = $allOP; } if ("addOP" === $action) { $opid = htmlspecialchars($_GET["opid"]); $opname = htmlspecialchars($_GET["opname"]); $limit = htmlspecialchars($_GET["limit"]); $database->insert("gr_op", ["opid" => $opid, "opname" => $opname, "pw" => "123", "privilege" => $limit]); listOP(); header("location: ../../op.php"); } if ("delOP" === $action) { $opid = htmlspecialchars($_GET["id"]); $opname = $database->select("gr_op", "opname", ["opid" => $opid]); $op = $database->select("gr_charge", "opname", ["opname" => $opname, "LIMIT" => 1]); if (count($op) == 0) { $database->delete("gr_op", ["opid" => $opid]); listOP(); header("location: ../../op.php"); } else { header("location: ../../op.php?error=true"); } } if ("modifyOP" === $action) { $opname = htmlspecialchars($_GET["opname"]); $privilege = htmlspecialchars($_GET["limit"]); $opid = htmlspecialchars($_GET["opid"]); $database->update("gr_op", ["opname" => $opname, "privilege" => $privilege], ["opid" => $opid]); listOP(); header("location: ../../op.php"); } if ("listAllStyle" === $action) {
/** * 针对MYSQL级联操作无法触发级联操作的BUG * @param int $comment_id 评论ID * @param string $table 对应的数据表 * @param \medoo $db_writer 数据库操作的引用 */ private function deleteRelationTable($comment_id, $table, &$db_writer) { if ($db_writer->delete($table, ['comments_id' => $comment_id]) === false) { $db_writer->pdo->rollBack(); $this->throwMsg(-1); } }
<?php /** * Created by PhpStorm. * User: KeenSting * Date: 2015/10/14 * Time: 14:20 */ require_once '../../../medoo/medoo.php'; session_start(); $key = $_POST['key']; $db = new medoo(); $item = $db->select('ambassador', '*', array('ekey' => $key)); $item[0]['operator'] = $_SESSION['userinfo']['ekey']; //记录操作者的邀请码 $db->insert('d_user', $item[0]); $re = $db->delete('ambassador', array('ekey' => $key)); unset($db); if ($re == 1) { echo 'ok'; } else { echo 'error'; }
// Match confirmation against a user's email. $confirmation = isset($_GET['code']) ? $_GET['code'] : ''; $datas = $database->select("users_pw_reset", "*", ["code" => $confirmation]); foreach ($datas as $data) { $code = $data["email"]; } if (isset($code)) { // Display a password reset form here. echo 'Reset your password <hr/>' . $code; if (isset($_POST['password'])) { // Update the user's account to the new password. $new_password = password_hash($_POST['password'], PASSWORD_DEFAULT) . ""; $database->update("users2", ["password" => $new_password], ["email" => $code]); // update($table, $data, $where) // Remove the confirmation code. $database->delete("users_pw_reset", ["AND" => ["code" => $confirmation]]); echo '<br> Your new password is set!'; userLogin($code); } else { echo ' <form method="POST" action=""> <input type="password" name="password" placeholder="Password" /> <br> <button type="submit">Reset »</button> </form> '; } } else { echo 'Sorry, this reset link is no longer valid. <a href="?a=forgotten">Request another.</a>'; } break; // NEW USER REGISTRATION
/** * @param $table * @param $where * @return int */ public function delete($table, $where) { return $this->_writer->delete($table, $where); }
$datas = $database->update("AdressBook", ["username" => $data['username'], "password" => $data['password']], ["AND" => ["id[=]" => $addressbookid, "candidate[=]" => $candidate]]); if ($datas) { //echo $database->last_query(); //header("Content-Type: application/json"); //echo json_encode($datas, JSON_PRETTY_PRINT); //echo json_encode($datas); $app->response->headers->set('Content-Type', 'application/json'); $app->response->setBody(json_encode($datas)); } else { $app->response->headers->set('HTTP/1.1', '404'); } }); $app->delete('/:candidate/:addressbookid/', function ($candidate, $addressbookid) use($app, &$database) { $body = $app->request()->getBody(); $data = json_decode($body, true); $datas = $database->delete("AdressBook", ["AND" => ["id[=]" => $addressbookid, "candidate[=]" => $candidate]]); if ($datas) { //echo $database->last_query(); //header("Content-Type: application/json"); //echo json_encode($datas, JSON_PRETTY_PRINT); //echo json_encode($datas); $app->response->headers->set('Content-Type', 'application/json'); $app->response->setBody(json_encode($datas)); } else { $app->response->headers->set('HTTP/1.1', '404'); } }); $app->get('/:candidate/:addressbookid/groups/:contactgroupid/', function ($candidate, $addressbookid, $contactgroupid) use($app, &$database) { //echo "GET {$candidate}/{$addressbookid}/groups/{$contactgroupid}\n"; $datas = $database->select("ContactGroup", ["name", "description", "pictureURL"], ["AND" => ["id_adressbook[=]" => $addressbookid, "id_group[=]" => $contactgroupid]]); if ($datas) {
$database = new medoo(['database_type' => 'mysql', 'database_name' => 'r8db', 'server' => '172.16.2.109', 'username' => 'admin', 'password' => 'admin', 'charset' => 'utf8']); $user_id = $database->select("user", ["[>]entry" => "user_id"], ["entry.entry_id"], ["entry_id" => 10]); $user = $database->get('user', ['[>]entry' => "user_id"], ['user_id', 'email', 'username', 'admin', 'nsfw'], ['entry_id' => 10]); $html = '<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"><div class="container"><div class="row">'; $html .= '<form class="clearfix" method="get"> <div class="form-group col-sm-4"><label for="action">Action</label><select class="form-control" name="action" id="action"><option value="show">show</option><option value="delete">delete</option><option value="add">add</option><option value="set">set</option></select></div> <div class="form-group col-sm-4"><label for="amount">Amount</label><input class="form-control" type="number" name="amount" id="amount" value=""></div> <div class="form-group col-sm-4"><label>Functions</label><div><button type="submit" class="btn btn-primary">Submit</button> <button type="reset" class="btn btn-warning">Reset</button></div></div> </form>'; $html .= '</div><div class="row"><div class="col-sm-12">'; $count = $database->count('entry'); $database->query('ALTER TABLE "entry" AUTO_INCREMENT = ' . ($count + 1)); if (isset($_GET['action'])) { $amount = isset($_GET['amount']) && is_numeric($_GET['amount']) ? intval($_GET['amount']) : 100; if ($_GET['action'] == 'delete' && $count != 0) { $database->delete('entry', ['ORDER' => 'entry_id DESC', 'LIMIT' => $amount]); } elseif ($_GET['action'] == 'delete') { $html .= 'Where nothing is, nothing can be removed.'; } elseif ($_GET['action'] == 'add') { for ($i = $count + 1; $i < $count + $amount + 1; ++$i) { $data = ['user_id' => 1, 'category_id' => 1, 'title' => 'Dummy #' . $i, 'desc' => 'Lorem Ipsum', 'image' => 'https://placehold.it/400x400']; $database->insert('entry', $data); } } elseif ($_GET['action'] == 'set') { $database->delete('entry', ['LIMIT' => 99999999999999]); $count = $database->count('entry'); $database->query('ALTER TABLE "entry" AUTO_INCREMENT = 1'); for ($i = $count + 1; $i < $count + $amount + 1; ++$i) { $data = ['user_id' => 1, 'category_id' => 1, 'title' => 'Dummy #' . $i, 'desc' => 'Lorem Ipsum', 'image' => 'https://placehold.it/700x350']; $database->insert('entry', $data); }
<?php require_once '../config.php'; require_once BASE_PATH . '/medoo.min.php'; require_once BASE_PATH . '/login_handler.php'; /* Login handling and permission check */ $login = new loginHandler($config); if (!$login->is_logged_in()) { $login->redirect_login('Please login'); } if ($login->get_user_type() != 'admin') { $login->not_authorized_error(); } if (isset($_GET['courseid'])) { $courseid = $_GET['courseid']; //delete from courses $db = new medoo($config['db']); $db->delete('courses', ['courseid' => $courseid]); //delete from student course linkage $db->delete('student_course', ['course' => $courseid]); //delete question $db->delete('questions', ['courseid' => $courseid]); //delete feedback $db->delete('feedback', ['courseid' => $courseid]); } //redirect to course list header('Location: ' . $config['url']['base_url'] . $config['url']['admin_course_list']);
<?php /** * Created by PhpStorm. * User: KeenSting * Date: 2015/7/8 * Time: 13:11 */ include '../../parameter/Medoo/Resource/medoo.php'; $id = $_POST['id']; $mydb = new medoo('meetingmanage'); $mydb->delete('rooms', array('ROOM_ID' => $id));
$app->render(200, ['line' => $line]); } }); // Delete Invoice $app->delete('/api/invoices/:id', 'APIrequest', function ($id) use($app) { // Connect global $dbCredentials; $database = new medoo($dbCredentials); // Insert $database->delete('invoice', ['id' => $id]); $error = $database->error(); if ($error[1]) { $app->render(500, ['error' => true, 'message' => $error[2], 'query' => $database->last_query()]); } else { $app->render(200, ['message' => 'deleted']); } }); // Delete Invoice Line $app->delete('/api/invoices/:invoice_id/lines/:line_id', 'APIrequest', function ($invoice_id, $line_id) use($app) { // Connect global $dbCredentials; $database = new medoo($dbCredentials); // Insert $database->delete('line', ['AND' => ['id' => $line_id, 'invoice_id' => $invoice_id]]); $error = $database->error(); if ($error[1]) { $app->render(500, ['error' => true, 'message' => $error[2], 'query' => $database->last_query()]); } else { $app->render(200, ['message' => 'deleted']); } });
/** * 删除图片 * @param bool $rt * @param int $id * @param int $uid * @param \medoo $write_db * @return bool */ public function deletePictureFeed($rt, $id, $uid, \medoo $write_db) { if ($rt !== true || $id < 1 || $uid < 1) { return $rt; } $write_db->delete("feed", ['sid' => "SharePicture_" . $id]); if ($write_db === false) { Log::write("deletePictureFeed Error", Log::SQL); return false; } return true; }
if (!empty($metas['0']["meta_value"])) { // Select from old table all Featured Images information $images = $database->select("xp_posts", ["id", "post_title", "post_name", "post_mime_type", "guid"], ["AND" => ["post_status" => 'inherit', "post_parent" => $data["id"], "post_type" => 'attachment', "id" => $metas['0']['meta_value']]], ["ORDER" => "xp_posts.id DESC", "LIMIT" => 1]); foreach ($images as $img) { //echo "ID:" . $img["id"] . "IDnew:".$img["guid"]." - <br/>"; // Insert record with Images information to wp_post $last_user_id = $database->insert("wp_posts", ["post_author" => "1", "post_date" => "2015-12-15 11:13:52", "post_date_gmt" => "2015-12-15 08:13:52", "post_title" => $img["post_title"], "post_status" => "inherit", "comment_status" => "open", "ping_status" => "open", "post_name" => $img["post_name"], "post_modified" => "2016-01-25 01:03:55", "post_modified_gmt" => "2016-01-25 01:03:55", "post_parent" => $data["idn"], "guid" => $img["guid"], "menu_order" => "0", "post_type" => "attachment", "post_mime_type" => $img["post_mime_type"], "comment_count" => "0"]); ////// select meta information from xp_postmeta $meta_all = $database->select("xp_postmeta", ["post_id", "meta_key", "meta_value"], ["post_id" => $metas['0']['meta_value']]); ////// ###select from wp_postmeta ///// foreach ($meta_all as $meta) { //echo "ID:" . $meta["post_id"] . "IDnew:".$meta["meta_value"]." - <br/>"; // Insert meta information to wp_postmeta $last_id = $database->insert("wp_postmeta", ["post_id" => $last_user_id, "meta_key" => $meta["meta_key"], "meta_value" => $meta["meta_value"]]); } // Insert meta information to wp_postmeta $last_id = $database->insert("wp_postmeta", ["post_id" => $data["idn"], "meta_key" => "_thumbnail_id", "meta_value" => $last_user_id]); } // Delete incorect records from wp_postmeta $meta_del = $database->select("wp_postmeta", ["meta_id"], ["AND" => ["post_id" => $data["idn"], "meta_key" => "_thumbnail_id", "meta_value" => $metas['0']['meta_value']]]); if (!empty($meta_del['0']['meta_id'])) { $database->delete("wp_postmeta", ["meta_id" => $meta_del['0']['meta_id']]); } } } } echo "<br><h1>All records - " . $i . "</h1>"; ?> </body> </html>