protected function throwMysqlError()
{
$errorMsg = "MySQL error occurred. ";
if (EMA_DEBUG === true) {
$errorArray = $this->dbConnection->error();
$errorMsg .= " Debug Data: " . $errorArray[2];
}
throw new \Exception($errorMsg, 6022);
}
/**
* @return array
*/
public function error()
{
$rt = array('write' => $this->_writer->error(), 'read' => NULL);
if (empty($this->_reader)) {
$rt['read'] = $rt['write'];
} else {
$rt['read'] = $this->_reader->error();
}
return $rt;
}
public function getAjaxMethods()
{
$whereClause = $this->getRPCWhere($this->currentClass);
$dbData = $this->dbQuery(array('AND' => $whereClause));
if (is_array($dbData) === false) {
$errorMsg = "Cannot get data from db.";
if (EMA_DEBUG === true) {
$errorArray = $this->dbConnection->error();
$errorMsg .= " Debug Data: " . $errorArray[2];
}
throw new FatalError($errorMsg, 6022);
}
if (count($dbData) === 0) {
return false;
}
$methodsArray = array();
foreach ($dbData as $method) {
$methodsArray[] = $method['methodName'];
}
return $methodsArray;
}
ini_set('display_errors', 'ON');
error_reporting(E_ALL);
header("Content-type:text/html;charset=utf-8");
defined('ROOT_PATH') or define('ROOT_PATH', dirname(__FILE__));
include ROOT_PATH . '/../lib/medoo.php';
include ROOT_PATH . '/../lib/Curl.php';
$db = new medoo(array('database_type' => 'mysql', 'database_name' => 'fayuan', 'server' => 'localhost', 'username' => 'root', 'password' => '123456', 'port' => 3306, 'charset' => 'utf8', 'option' => array(PDO::ATTR_CASE => PDO::CASE_NATURAL)));
$curl = new Curl();
$id = 2250;
while ($id <= 1239000) {
$url = "http://shixin.court.gov.cn/detail?id={$id}";
$resArr = getHtml($url);
echo "{$id}\r\n";
if (is_array($resArr) && !empty($resArr)) {
//判断数据是否存在
print_r($resArr);
$i = $db->insert('shixin', $resArr);
if ($i <= 0) {
print_r($db->error());
die;
}
}
$id++;
}
function getHtml($url)
{
global $curl;
$curl->setUrl($url);
$html = $curl->run();
return json_decode($html, true);
}
<?php
// phpinfo();
require 'vendor/autoload.php';
$db = new medoo(['database_type' => 'mysql', 'database_name' => 'test', 'server' => 'localhost', 'username' => 'root', 'password' => '', 'option' => [PDO::ATTR_CASE => PDO::CASE_NATURAL]]);
$r = $db->insert("user", []);
var_dump($r);
var_dump($db->log());
var_dump($db->error());
<?php
require_once '../vendor/autoload.php';
echo "Hello World";
$file = '../storage/database.db';
if (is_writable('../storage/database.local.db')) {
$file = '../storage/database.local.db';
}
$database = new medoo(['database_type' => 'sqlite', 'database_file' => '../storage/database.db']);
$comment = new SitePoint\Comment($database);
$comment->setEmail('*****@*****.**')->setName('Bruno Skvorc')->setComment('It works!')->setComment('Hooray! Saving comments works!')->save();
dump($database->error());
?>
<!doctype html>
<html class="no-js" lang="">
<head>
<meta charset="utf-8">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<title></title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="apple-touch-icon" href="apple-touch-icon.png">
<!-- Place favicon.ico in the root directory -->
<link rel="stylesheet" href="css/normalize.css">
<link rel="stylesheet" href="css/main.css">
<script src="js/vendor/modernizr-2.8.3.min.js"></script>
</head>
<body>
<?php
defined("TEMPLATES_PATH") or define("TEMPLATES_PATH", realpath(dirname(__FILE__) . '/view'));
defined("LIBRARY_PATH") or define("LIBRARY_PATH", realpath(dirname(__FILE__) . '/lib'));
include LIBRARY_PATH . '/medoo.min.php';
if (isset($_GET['install']) and !file_exists(LIBRARY_PATH . '/database.db') and isset($_POST['username']) and isset($_POST['pwd']) and isset($_POST['rpt']) and $_POST['pwd'] == $_POST['rpt']) {
$db = new medoo(LIBRARY_PATH . '/database.db');
$db->query("CREATE TABLE users (username TEXT,password TEXT);");
$db->query("CREATE TABLE settings (setting TEXT,value TEXT);");
$db->query("CREATE TABLE hosts (domain TEXT,checkInTime TEXT,description TEXT);");
$db->insert("users", ["username" => strtolower($_POST['username']), "password" => password_hash($_POST['pwd'], PASSWORD_DEFAULT)]);
$db->insert("settings", ["setting" => "secretKey", "value" => rand()]);
if (!$db->error()[0] == "00000") {
unlink(LIBRARY_PATH . '/database.db');
$noticeMessage = "An error occurred while saving the database.";
} else {
$noticeMessage = "Successfully installed DropPoint control. Please login.";
}
}
if (!file_exists(LIBRARY_PATH . '/database.db')) {
include TEMPLATES_PATH . '/setup.php';
exit;
}
$db = new medoo(LIBRARY_PATH . '/database.db');
$secretCode = $db->get("settings", "value", ["setting" => "secretKey"]);
function dbHasError()
{
global $db;
if ($db->error()[0] == "00000") {
return false;
} else {
$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']);
}
});
