php配合jquery实现增删操作_PHP教程

后台使用php，前台引用jquery，实现增删操作，代码如下：

<span  1</span> <span><script type="text/javascript" src="http://keleyi.com/keleyi/pmedia/jquery/jquery-1.10.2.min.js"></script></span> 
<span  2</span> <?<span php 
</span><span  3</span> <span header</span>("Content-type: text/html; charset=utf-8"<span ); 
</span><span  4</span> <span //</span><span mysql_connect 建立连接,mysql_close($link)关闭非永久连接，mysql_pconnect 建立永久连接 
</span><span  5</span> <span //mysql_error返回mysql函数错误信息，mysql_errno返回mysql函数错误号码 
</span><span  6</span> <span //mysql_set_charset 设置用户端字符集，mysql_select_db 选择连接数据库 
</span><span  7</span> <span //mysql_query 执行查询，mysql_num_rows返回查询记录条数 
</span><span  8</span> <span //mysql_affected_rows返回受影响的记录条数，mysql_free_result 释放结果集内存 
</span><span  9</span> <span //mysql_fetch_row 返回列举阵列记录，mysql_fetch_assoc 返回关联阵列记录 
</span><span 10</span> <span //mysql_fetch_array 返回关联阵列或数字阵列记录，mysql_fetch_object 返回物件形式记录 
</span><span 11</span> <span //mysql_fetch_result 取得结果集资料 
</span><span 12</span> <span //%s 字符串,%c 一个ASCII字符,%d 一个整数,%u 一个符号数,%x 一个十六进制数 </span>
<span 13</span> <span mysql_query</span>("set charaset set utf-8"<span ); 
</span><span 14</span> <span $message</span>=@<span $_POST</span>["message"<span ]; 
</span><span 15</span> <span $shanchu</span>=@<span $_POST</span>["shanchu"<span ]; 
</span><span 16</span> <span $top_title</span>="PHP基础练习"<span ; 
</span><span 17</span> <span $con</span>=<span mysql_connect</span>("localhost","root",""<span ); 
</span><span 18</span> <span //</span><span 连接数据库  </span>
<span 19</span> mysql_set_charset('utf-8',<span $con</span><span ); 
</span><span 20</span> <span mysql_select_db</span>("dbl",<span $con</span><span ); 
</span><span 21</span> <span //</span><span 定义数据库命令查询 </span>
<span 22</span> <span $sql</span>="select `message` ,`time`,`id` from message order by id desc limit 0,30"<span ; 
</span><span 23</span> <span //</span><span 执行数据库查询  http://www.cnblogs.com/roucheng/</span>
<span 24</span> <span $rs</span>=<span mysql_query</span>(<span $sql</span>,<span $con</span><span ); 
</span><span 25</span> <span $time</span>=<span date</span>('Y-m-d h:i:s',<span time</span><span ()); 
</span><span 26</span> <span //</span><span 获取条数 </span>
<span 27</span> 
<span 28</span> <span $num_rows</span>=<span mysql_num_rows</span>(<span $rs</span>);<span //</span><span mysql_num_rows返回查询记录条数 </span>
<span 29</span> <span if</span> (<span isset</span>(<span $_POST</span>["submits"<span ])) { 
</span><span 30</span> <span if</span>(!<span $_POST</span>["message"]==<span null</span><span ){ 
</span><span 31</span> <span $queryinsert</span>=<span sprintf</span>("insert into message (message,time) values('%s','%s')", 
<span 32</span> <span $_POST</span>['message'],<span $time</span><span ); 
</span><span 33</span> <span mysql_query</span>(<span $queryinsert</span>,<span $con</span><span ); 
</span><span 34</span> <span } 
</span><span 35</span>     <span if</span>(<span $_POST</span>["message"]==<span null</span><span ){ 
</span><span 36</span> <span echo</span> ""<span ; 
</span><span 37</span> <span } 
</span><span 38</span> <span header</span>("Location:http://localhost/table.php"<span ); 
</span><span 39</span> <span } 
</span><span 40</span> 
<span 41</span> <span if</span>(<span isset</span>(<span $_GET</span>["ClearTd"]) && <span intval</span>(<span $_GET</span>['ClearTd'<span ])){ 
</span><span 42</span> <span $querydelete</span>="delete from message where id=".<span $_GET</span>['ClearTd'<span ]; 
</span><span 43</span>     <span mysql_query</span>(<span $querydelete</span>,<span $con</span><span ); 
</span><span 44</span> <span header</span>("Location:http://localhost/table.php"<span );    
</span><span 45</span> <span } 
</span><span 46</span> ?> 
<span 47</span> 
<span 48</span> <form method="post" action="table.php"> 
<span 49</span> <textarea  name="message" id="message"></textarea> 
<span 50</span> <input type="submit" name="submits"> 
<span 51</span> </form> 
<span 52</span> 
<span 53</span> <ul> 
<span 54</span> <?php <span while</span>(<span $row</span>=<span mysql_fetch_array</span>(<span $rs</span>,<span MYSQL_ASSOC)) 
</span><span 55</span> <span { 
</span><span 56</span> ?> 
<span 57</span> <li> 
<span 58</span> <?php <span foreach</span>(<span $row</span> <span as</span> <span $tiao</span><span ){ 
</span><span 59</span> <span echo</span> <span $tiao</span><span ; 
</span><span 60</span> }?> 
<span 61</span>     <a name="ClearTd" href="?ClearTd=<?php echo <span $row</span>['id'];?>">删除</a> 
<span 62</span> </li>       
<span 63</span> <?php } ?> 
<span 64</span> </ul> 

 

 

http://www.bkjia.com/PHPjc/626643.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/626643.htmlTechArticle后台使用php，前台引用jquery，实现增删操作，代码如下： script type="text/javascript" src="http://keleyi.com/keleyi/pmedia/jquery/jquery-1.10.2.min.js"/script ?...