tp mysql 区间查询_TP连接MYSQL的简单查询及添加

//连接MYSQL

return array(

//'配置项'=>'配置值'

//'APP_DEBUG'=>false,

'DB_TYPE'=>'mysql',

'DB_HOST'=>'localhost',

'DB_USER'=>'root',

'DB_PWD'=>'',

'DB_NAME'=>'thinkphp',

'DB_PORT'=>3306,

'DB_PREFIX'=>'think_',

//'APP_DEBUG'=>false,

/*'DB_TYPE'=>'pdo',

'DB_USER'=>'root',

'DB_PWD'=>'',

'DB_PREFIX'=>'think_',

'DB_DSN'=>'mysql:host=localhost;dbname=thinkphp;charset=UTF8',*/

);

//基本的查询与添加

namespace Home\Controller;

use Think\Controller;

use Think\Model;

//use Home\Model\UserModel;

class UserController extends Controller {

public function index(){

echo "hello world";

}

public function test($user,$pass){

echo 'user:'.$user.'
pass:'.$pass;

}

public function model(){

//echo "model";

//$user=new Model('User');

//var_dump($user);

//var_dump($user->select());

//$user=new UserModel();

//var_dump($user->select());

//$user=M('User');

//var_dump($user->where('id=1')->select());

//var_dump($user->query("select * from think_user"));

//var_dump($user->execute('update think_user set user="蜡笔小新" where id=1'));

$user=M('User');

//var_dump($user->where('id=2')->delete());

var_dump($user->select());

}

public function create(){

//echo "123";

//$user=M("User");

//$data['user']=$_POST['user'];

//$data['email']=$_POST['email'];

//$data['date']=date('Y-m-d H:i:s');

//var_dump($user->create($data));*/

}

public function add(){

$user=M('User');

//$data['user']='胡志明';

//$data['email']='729877497@qq.com';

//$data['date']=date('Y-m-d H:i:s');

$data=$user->create();

$data['date']=date('Y-m-d H:i:s');

$user->data($data)->add();

}

public function aaa(){

$user=M('User');

var_dump($user->select());

}

}