php配合jquery实现增删操作_PHP教程
- WBOY原创
- 2016-07-13 17:17:02894浏览
后台使用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>
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn