// session start
define("SESSION_ON", true);
// define project's config
define("CONFIG", '/conf/web.php');
// debug switch
define("DEBUG", true);
// include framework entrance file
include './common.php';
// simplify use class
use pt\framework\debug\console as debug;
use pt\framework\template;
use pt\framework\db;
// include your project common functions.
// this is a demo that have some useful functions.
include COMMON_PATH . 'web_func.php';
if ($_POST) {
if (empty($_POST['username']) || empty($_POST['password'])) {
json_return(null, 1, 'Username / Password can\'t be empty.');
}
$db = db::init();
$user = $db->prepare("SELECT `id`,`username`,`password`,`md` FROM `a_user` WHERE BINARY `username`=:user")->execute(array(':user' => $_POST['username']));
if (!$user || $user[0]['password'] != md5(md5($_POST['password']) . $user[0]['md'])) {
json_return(null, 1, 'Incorrect password.');
} else {
$_SESSION['uid'] = $user[0]['id'];
json_return(1);
}
}
template::display('login');
// Delete
// Delete
case 'delete':
if ($_POST) {
$id = (int) $_POST['id'];
$db = db::init();
$db->beginTrans();
$rs = $db->prepare("DELETE FROM `a_good` WHERE `id`=:id")->execute(array(':id' => $id));
if (false === $rs) {
$db->rollback();
json_return(null, 1, 'Operation failed.');
}
action::exec('delete', $id);
if ($db->commit()) {
json_return(1);
}
json_return(null, 9, 'Operation failed.');
}
break;
// List page
// List page
case 'default':
default:
$keyword = '';
template::assign('keyword', $keyword);
$db = db::init();
$sql = "SELECT * FROM `a_good` WHERE `user`=:uid ORDER BY `id` DESC";
$list = $db->prepare($sql)->execute(array(':uid' => $uid));
template::assign('list', $list);
template::display('index');
}
