Home > Article > Backend Development > Simple operation of ThinkPHP database access, thinkphp database access_PHP tutorial
Simple operation of ThinkPHP database access, thinkphp database access_PHP tutorial
- WBOYOriginal
- 2016-07-13 09:46:56745browse
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>
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
Previous article：PHP extensible verification class example (can verify email, mobile phone number, URL, etc.), example url_PHP tutorialNext article：PHP extensible verification class example (can verify email, mobile phone number, URL, etc.), example url_PHP tutorial