/**
* 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>
