wordpress增删改查

 wordpress 焦点图插件-增删改查操作 2012-02-01 15:39:14

分类： 系统运维

该插件在wordpress-3.3.1-zh_CN版本下开发，主要用于在后台管理首页焦点图（图片轮播）。
存放焦点图信息的表 focusphoto(id,photourl,linkto,title,description)
该插件包括2个文件 focusphoto.php和focusphoto-admin.php

效果如图：


具体代码如下：
focusphoto.php 包含以下函数：
focusphoto_install() 创建表focusphoto(id,photourl,linkto,title,description)
focusphoto_uninstall() 删除表
editfocusphoto_menu() focusphoto_admin_actions() 在后台添加“设置》焦点图管理”导航链接
  1. <?php
  2. /*
  3. Plugin Name: 焦点图插件
  4. Plugin URI: http://hzm.blog.chinaunix.net
  5. Description: 该插件在wordpress-3.3.1-zh_CN版本下开发，主要用于在后台管理首页焦点图（图片轮播）
  6. Author: Henry Poter
  7. Version: 1.0
  8. Author URI: http://hzm.blog.chinaunix.net
  9. */
  11. register_activation_hook(__FILE__ , 'focusphoto_install' );
  12. register_deactivation_hook(__FILE__ , focusphoto_uninstall);
  13. function focusphoto_install() {
  14.     global $wpdb;
  15.     $table = $wpdb->prefix . 'focusphoto';
  16.     $sql = "create table $table(
  17.                  id int auto_increment primary key,
  18.                  photourl varchar(200),
  19.                  linkto varchar(200),
  20.                  title varchar(255),
  21.                  description varchar(1000)
  22.                  ) CHARSET=UTF8";
  23.     $wpdb->query($sql);
  24. }
  25. function focusphoto_uninstall(){
  26.     global $wpdb;
  27.     $table = $wpdb->prefix . 'focusphoto';
  28.     $sql = "drop table $table";
  29.     $wpdb->query($sql);
  30. }
  33. function editfocusphoto_menu()
  34. {
  35.     global $wpdb;
  36.    include 'focusphoto-admin.php';
  37. }
  39. function focusphoto_admin_actions()
  40. {
  41.     add_options_page("焦点图管理", "焦点图管理", 1,
  42. "Focus-photo", "editfocusphoto_menu");
  43. }
  45. add_action('admin_menu', 'focusphoto_admin_actions');
  46. ?>

focusphoto-admin.php 包含以下4个函数：
focusphoto_list() 焦点图列表
focusphoto_delete($photoid) 删除指定$photoid的记录
focusphoto_edit($photoid)  编辑指定$photoid的记录
focusphoto_add() 添加焦点图
  1. <?php
  3. /*
  4.  * Created on Jan 31, 2012
  5.  * Author: Henry Poter
  6.  */
  8. function focusphoto_list() {
  9.     global $wpdb;
  10.     $addlink = site_url()."/wp-admin/options-general.php?page=Focus-photo&act=addfocusphoto";
  11.     $photos = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "focusphoto order by id desc limit 10");
  12.     //print_r($photos);
  13.     if (count($photos) <= 0) {
  14. ?>
  15. <div id="icon-edit" class="icon32 icon32-posts-post"><br></div>
  16. <h2>焦点图 <a href="<?php echo $addlink; ?>" class="add-new-h2">添加焦点图</a> </h2>
  17. <?php
  18.         echo "<p style='color:red;'>暂时没有焦点图，请<a href='$addlink'>点击添加</p>";
  19.     } else {
  20. ?>
  21. <div id="icon-edit" class="icon32 icon32-posts-post"><br></div>
  22. <h2>焦点图 <a href="<?php echo $addlink; ?>" class="add-new-h2">添加焦点图</a> </h2>
  23.   <table class="wp-list-table widefat fixed posts" cellspacing="0">
  24.     <thead>
  25.      <tr>
  26.         <th scope="col" class="manage-column column-cb check-column" style="">
  27.         <input type="checkbox">
  28.         </th>
  29.         <th scope="col" class="manage-column column-title" style="">
  30.         <span>标题</span><span class="sorting-indicator"></span>
  31.         </th>
  32.         <th scope="col" class=" manage-column column-title" style="">
  33.         <span>图片地址</span><span class="sorting-indicator"></span>
  34.         </th>
  35.         <th scope="col" class="manage-column column-title" style="">链接到</th>
  36.         </tr>
  37.     </thead>
  38.     <tbody id="the-list">
  39. <?php foreach ($photos as $photo) {?>
  40.             <tr id="post-1" class="post-1 post type-post status-publish format-standard hentry category-uncategorized iedit author-self" valign="top">
  41.                 <th scope="row" class="check-column"><input type="checkbox" name="post[]" value="<?php echo $photo->id;?>"></th>
  42.                 <td class="post-title page-title column-title">
  43.                  <strong><a class="row-title" href="?page=Focus-photo&act=editfocusphoto&photoid=<?php echo $photo->id;?>" title="<?php echo $photo->title;?>"><?php echo $photo->title;?></a></strong>
  44.                  <div class="row-actions"><span class="edit">
  45.                  <a href='?page=Focus-photo&act=editfocusphoto&photoid=<?php echo $photo->id;?>'>编辑</a> | </span>
  46.                  <span class="inline hide-if-no-js"><a href='?page=Focus-photo&act=deletefocusphoto&photoid=<?php echo $photo->id;?>'>删除</a> | </span>
  47.                  <span class="view"><a href="<?php echo $photo->photourl;?>" rel="permalink">查看焦点图</a></span>
  48.                  <span class="view"><a href="<?php echo $photo->linkto;?>" rel="permalink">查看相关链接</a></span>
  49.                  </div>
  50.                 </td>
  51.               <td class="post-title page-title column-title"><?php echo $photo->photourl;?></td>
  52.              <td class="author column-author"><?php echo $photo->linkto;?></td>
  53.             </tr>
  54. <?php }//end foreach
  56. }//end if
  57. ?>
  58.         </tbody>
  59. </table>
  60. <?php
  63.     if (isset ($_GET['photoid']) && $_GET['act'] == "editfocusphoto") {
  64.         $photoid = $_GET['photoid'];
  65.         focusphoto_edit($photoid);
  66.     }
  68.     if (isset ($_GET['photoid']) && $_GET['act'] == "deletefocusphoto") {
  69.         $photoid = $_GET['photoid'];
  70.         focusphoto_delete($photoid);
  71.     }
  73.     if (isset ($_GET['act']) && $_GET['act'] == "addfocusphoto") {
  74.         focusphoto_add();
  75.     }
  77. } //end focusphoto_list()
  79. function focusphoto_delete($photoid) {
  80.     global $wpdb;
  81.     if (!is_numeric($photoid)) {
  82.         die("<p style='color:red;'>参数photoid错误！</p>");
  83.     }
  84.     $table = $wpdb->prefix . 'focusphoto';
  85.     $result = $wpdb->query("DELETE FROM $table WHERE id = $photoid ");
  86.     if ($result == 1) {
  87.         echo "<script langue='javascript'> alert('删除成功！');</script>";
  88.         header("location: " . $_SERVER['REQUEST_URI']);
  89.     }
  90. }
  92. function focusphoto_edit($photoid) {
  93.     global $wpdb;
  94.     if (!is_numeric($photoid)) {
  95.         die("<p style='color:red;'>参数photoid错误！</p>");
  96.     }
  97.     if (isset ($_POST['editphoto'])) {
  98.         $newphoto = array (
  99.             "photourl" => $_POST['photourl'],
  100.             "linkto" => $_POST['linkto'],
  101.             "title" => $_POST['title']
  102.         );
  103.         print_r($newphoto);
  105.         $result = $wpdb->update($wpdb->prefix . "focusphoto", $newphoto, array (
  106.             'id' => $photoid
  107.         ), $format = null, $where_format = null);
  108.         //if($result == 1){
  109.         echo "<script langue='javascript'> alert('编辑成功！');</script>";
  110.         header("location: " . site_url().'/wp-admin/options-general.php?page=Focus-photo');
  111.         //}
  112.     }
  113.     $photo = $wpdb->get_results("SELECT * FROM " .
  114.     $wpdb->prefix . "focusphoto" . " WHERE id=$photoid");
  115.     // print_r($photo);
  116. ?>
  117. <br/>
  118. <form action="" method="post">
  119.      <table class="widefat" cellspacing="0" >
  120.      <thead>
  121.      <tr>
  122.         <th scope="col" class="manage-column column-title" colspan="4">编辑焦点图
  123.         </th>
  124.      </tr>
  125.     </thead>
  126.       <tbody>
  127.         <tr><td></td><td></td></tr>
  128.         <tr><td>图片地址</td><td><input size="80" tabindex="1" autocomplete="off" type='text' value='<?php echo $photo[0]->photourl ;?>' name='photourl' > </td></tr>
  129.         <tr><td>链接到</td><td><input size="80" tabindex="2" type='text' value='<?php echo $photo[0]->linkto ;?>' name='linkto' ></td></tr>
  130.         <tr><td>标题</td><td><input size="80" tabindex="3" type='text' value='<?php echo $photo[0]->title ;?>' name='title' ></td></tr>
  131.         <tr><td></td><td><input tabindex="4" type='submit' name='editphoto' value='保存' style='80px;'></td></tr>
  132.        </tbody>
  133.      </table>
  134.    </form>
  136. <?php
  138. } //end focusphoto_edit()
  140. function focusphoto_add() {
  141.     global $wpdb;
  142.     if (isset ($_POST['addphoto'])) {
  143.         $photo = array (
  144.             "photourl" => $_POST['photourl'],
  145.             "linkto" => $_POST['linkto'],
  146.             "title" => $_POST['title']
  147.         );
  148.         $wpdb->insert($wpdb->prefix . "focusphoto", $photo);
  149.         header("location: " . $_SERVER['REQUEST_URI']);
  150.     }
  151. ?>
  152. <br/>
  153.    <form action="" method="post">
  155.      <table class="widefat" cellspacing="0">
  156.      <thead>
  157.      <tr>
  158.         <th scope="col" class="manage-column column-title" colspan="4">添加焦点图
  159.         </th>
  160.      </tr>
  161.     </thead>
  162.       <tbody>
  163.        <tr><td></td><td></td></tr>
  164.         <tr><td>图片地址</td><td><input size="80" tabindex="1" type='text' value='' name='photourl' > </td></tr>
  165.         <tr><td>链接到</td><td><input size="80" tabindex="2" type='text' value='' name='linkto' ></td></tr>
  166.         <tr><td>标题</td><td><input size="80" tabindex="3" type='text' value='' name='title' ></td></tr>
  167.         <tr><td></td><td><input tabindex="4" type='submit' name='addphoto' value='添加' style='80px;'></td></tr>
  168.       </tbody>
  169.      </table>
  170.    </form>
  171. <?php
  173. } //end focusphoto_add()
  175. focusphoto_list();
  176. ?>
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/qqyuhaitao/p/3291820.html