index.php

<?php
/**
 * 项目前台入口文件
 * User: RJ
 * Date: 2017/02
 * Blog: http://nearby.wang
 * Mail: finallybad@gmail.com
 */
echo "<meta charset='utf-8'>";
require_once 'core/App.class.php';
require_once 'config/constants.php';

//注册一个
define('APP','app');
spl_autoload_register(array('App','myAutoloader'));
try{
    App::run();
}catch(MyException $e){
    $e->showError($e->getMessage());
}

$db = Model::getStringleton();

//直接执行sql语句
//$result = $db->queryString('select * from users where username=:username',array(':username'=>'zhang'));

//查询某个表
//$result = $db->select('users');

//查询某个表，并增加where条件
//$result = $db->where('where username=:username')->select('users',array(':username'=>'zhang'));

//查询单条数据
//$result = $db->where('where id=:id')->find('users',array(':id'=>'3'));

//更新数据
//$data = array(':username'=>'lisi',':userpass'=>md5(456789));
//$where = array(':id'=>9);
//$result = $db->where('where id=:id')->update('users',$data,$where);

//删除数据
// $result = $db->where('where id=:id')->delete('users',array('id'=>5));

//插入数据
$data = array(':username'=>'zhang6',':userpass'=>md5(123456),':create_time'=>time());
$result = $db->insert('users',$data);

echo "<pre>";
print_r($result);