Simple operation of ThinkPHP database access, thinkphp database access_PHP tutorial

Simple operation of ThinkPHP database access, thinkphp database access

Comparing traditional sql with sql in ThinkPHP Taking the user table as an example

　

<span>$user</span>=M('user'<span>);
</span>1: SELECT * FROM user----------<span>$user</span>-><span>select();
</span>2: SELECT* FORM user WHERE id=2---------<span>$user</span>->find(2<span>);
</span>3: SELECT username FORMuser-----<span>$user</span>->field('username')-><span>select();<br />4: DELETE FORM username WHEREid=2------$user->delete(2);<br />5: UPDATE user SET username='newUsername' WHERE id=2-------$data['username']='newUsername' $user->save($data);<br />6: INSERT INTO user (name,password)VALUES('php','phpPwd')------$data['name']='php' $data['password']='phpPwd'  $user->add($data);                               </span>

http://www.bkjia.com/PHPjc/1029945.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1029945.htmlTechArticle Simple operation of ThinkPHP database access, thinkphp database access traditional sql and ThinkPHP sql compared with the user table For example $user =M('user' ); 1: SELECT * FROM user---------- $u...