ThinkPHP的数据库访问的简单操作,thinkphp数据库访问
传统的sql与ThinkPHP中的sql相比较 以user表为例
1 2 3 4 | <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.htmlTechArticleThinkPHP的数据库访问的简单操作,thinkphp数据库访问 传统的sql与ThinkPHP中的sql相比较 以user表为例 $user =M('user' ); 1: SELECT * FROM user---------- $u...