Home  >  Article  >  php教程  >  ThinkPHP的数据库访问的简单操作,thinkphp数据库访问

ThinkPHP的数据库访问的简单操作,thinkphp数据库访问

WBOY
WBOYOriginal
2016-06-13 08:58:141294browse

ThinkPHP的数据库访问的简单操作,thinkphp数据库访问

              传统的sql与ThinkPHP中的sql相比较   以user表为例

     

<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>

 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn