自定義表單搜索

 

 

當(dāng)你的自定義表單數(shù)據(jù)過(guò)多或者需要查詢某個(gè)單時(shí)，給后臺(tái)的自定義表單加個(gè)簡(jiǎn)單的搜索功能很有必要。

添加教程

 

1、打開(kāi) \dede\templets\diy_main.htm 找到

內(nèi)容列表</div>

 

在它的下面加入

<div style="padding-left:10px;">

         <form name='form1' action="diy_list.php">

                   <input type='hidden' name='action' value='list' />

                   <input type='hidden' name='diyid' value='<?php echo $diy->diyid; ?>' />

                   關(guān)鍵字：

                   <input type='text' name='keyword' size='20' value="<?php echo $keyword; ?>" />

                   <select name="field">

                   <?php

                            foreach($fieldlist as $k=>$fielddata)

                            {

                                     if($k==$field)

                                     {

                                               echo "<option value='{$k}' selected>{$fielddata[0]}</option>\r\n";

                                     }

                                     else

                                     {

                                               echo "<option value='{$k}'>{$fielddata[0]}</option>\r\n";

                                     }

                            }

                   ?>

                   </select>

                   <input type='submit' name='sb' value='確定' class="coolbg np" />

         </form>

</div>

 

2、打開(kāi) \dede\diy_list.php 找到

$query = "SELECT * FROM {$diy->table} ORDER BY id DESC";

 

改成

if(empty($keyword))

{

         $keyword = '';

         $addquery = '';

}

else

{

         $addquery = " WHERE {$field} LIKE '%".trim($keyword)."%' ";

}

$query = "SELECT * FROM {$diy->table} $addquery ORDER BY id DESC";

 

繼續(xù)找到

$datalist->SetParameter('diyid', $diyid);

 

在它的下面加入

$datalist->SetParameter('keyword', $keyword);

$datalist->SetParameter('field', $field);

 

完成。