ThinkPHP's CURD basic operations, thinkphpcurd_PHP tutorial

Basic operations of ThinkPHP’s CURD, thinkphpcurd

Speaking of CURD, anyone who knows some SQL knows that it is adding, deleting, modifying, and checking. When building a business system, this is often indispensable. CURD, I have just come into contact with ThinkPHP recently. The flexibility of ThinkPHP is much easier to use than native PHP. Let me briefly introduce my learning experience.

To learn how ThinkPHP operates MySQL, you must first have MySQL, and then the PHP operating environment.

wamp can help you solve the configuration trouble. There is a lot of information about wamp, just Baidu.

The following is a brief introduction to the process of adding, deleting, modifying and checking in ThinkPHP.

1. Create a database and name it t_user.

The code is:

　

　DROP TABLE IF EXISTS `t_user`;
　　　　　　CREATE TABLE `t_user` (
　　　　　　`userid` int(11) NOT NULL,
　　　　　　`username` varchar(25) DEFAULT NULL,
　　　　　　`usersex` varchar(6) DEFAULT NULL,
　　　　　　`userage` int(6) DEFAULT NULL,
　　　　　　PRIMARY KEY (`userid`)
　　　　　　) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Create a project, name it thinkPHP_Text, and import the thinkphp core package.

Configure the index.php file.

Start the project and automatically generate the directory. As shown below:

2. Regarding the add() operation of thinkphp.

Create an action file for index, name it IndexController.class.php, and write a function insertUser(). In the control layer, you need to get the value passed by the frontend.

<span>/*</span><span>*
* 添加用户信息
* 编码时间：2015-05-28
</span><span>*/</span>
<span>public</span> <span>function</span> insertUser(<span>$id</span>,<span>$name</span>,<span>$sex</span>,<span>$age</span><span>){
</span><span>$this</span>->db(1,"DB_CONFIG1")->db(1<span>);
</span><span>$condition</span> = <span>array</span>(<span>//</span><span>定义要添加的数据，放在一个数组里，命名为$condition</span>
'userid' => <span>$id</span>,
'username' => <span>$name</span>,
'usersex' => <span>$sex</span>,
'userage' => <span>$age</span>,<span>
);
</span><span>$addInfo</span> = <span>$this</span>->db(1,"DB_CONFIG1")->add(<span>$condition</span>);<span>//</span><span>执行sql语句，insert</span>
<span>if</span>(<span>$addInfo</span><span>){
</span><span>header</span>("Location: http://localhost/thinkPHP_Text/index.php"<span>); 
}
</span><span>echo</span> <span>$this</span>->getLastSql();<span>//</span><span>调试用，输出sql语句</span>
<span>return</span> <span>$addInfo</span><span>; 
}
</span><span>/*</span><span>*</span>

In the model layer, remember the naming method. In this configuration, it is named UserModel.class.php, and corresponds to:

<span> 1</span>  <span>/*</span><span>*
</span><span> 2</span> <span>   * 添加用户信息
</span><span> 3  </span><span>  * 编码时间：2015-05-28
</span><span> 4</span>  <span>*/</span>
<span> 5</span>     <span>public</span><span> function insertUser($id,$name,$sex,$age){
</span><span> 6</span>             $<span>this</span>->db(<span>1</span>,<span>"</span><span>DB_CONFIG1</span><span>"</span>)->db(<span>1</span><span>);
</span><span> 7</span>             $condition = array(<span>//</span><span>定义要添加的数据，放在一个数组里，命名为$condition</span>
<span> 8</span>                 <span>'</span><span>userid</span><span>'</span> =><span> $id,
</span><span> 9</span>                 <span>'</span><span>username</span><span>'</span> =><span> $name,
</span><span>10</span>                 <span>'</span><span>usersex</span><span>'</span> =><span> $sex,
</span><span>11</span>                 <span>'</span><span>userage</span><span>'</span> =><span> $age,
</span><span>12</span> <span>            );
</span><span>13</span>             $addInfo = $<span>this</span>->db(<span>1</span>,<span>"</span><span>DB_CONFIG1</span><span>"</span>)->add($condition);<span>//</span><span>执行sql语句，insert</span>
<span>14</span>             <span>if</span><span>($addInfo){
</span><span>15</span>                     header(<span>"</span><span>Location: http://localhost/thinkPHP_Text/index.php</span><span>"</span><span>); 
</span><span>16</span> <span>                }
</span><span>17</span>             echo $<span>this</span>->getLastSql();<span>//</span><span>调试用，输出sql语句</span>
<span>18</span>             <span>return</span><span> $addInfo;                
</span><span>19</span>         }

This is the core code of the add operation.

Please download the specific code from the link below. See the comments for details:

http://pan.baidu.com/s/1hq7wfnm

http://www.bkjia.com/PHPjc/1007359.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1007359.htmlTechArticleThinkPHP’s basic CURD operation, thinkphpcurd Speaking of CURD, anyone who knows SQL knows that it is adding, deleting, modifying, and checking. When working on business systems, CURD is often indispensable, and I have just come into contact with it recently...