各位高手,我这里出现这样的问题,在一个页面中可以显示数据库的内容,而另一个页面却无法显示,两个网页唯一的区别是:一个是index.php?module=tryout&page=admin_tryout_open;另一个是index.php?module=tryout&mode=tryout_toaudit_list&page=admin_tryout_toaudit,请问这是为什么,如何才能让另一个页面也显示数据库的内容?请各位大侠多帮忙,谢谢
//tpl内容1是:
<td width="250" height="50">限制日期
<input name="LIMIT_DATE" type="text" class="app_textfield" maxlength="255" value="{$da_tryout->tryout_key_limit_date}">
</td>
//tpl内容2是:
<tr>
<td class="app_table_left">期限:</td>
<td class="app_table_right"><input type="text" name="USER_TIME_LIMIT" class="app_textfield" value="{$da_tryout->tryout_key_limit_date}" maxlength="10"></td>
</tr>
调用的都是
function tryout_req_list_get($search_array,$limit='',$offset=''){
global $conn;
$this->error = false;
$this->error_message ="";
$sql = "select * from USER_REQUISITION,REQUISITION_INFO ";
$sql.= " where 1=1 ";
if(trim($search_array["REQUEST_STATE"])<>"") $sql.= " and REQUEST_STATE='".trim($search_array["REQUEST_STATE"])."'";
$sql.= " and USER_REQUISITION.REQUISITION_ID=REQUISITION_INFO.REQUISITION_ID";
if(trim($search_array["order_by"])<>""){$sql.=" order by ".trim($search_array["order_by"])." ".trim($search_array["order_desc"]);}
else $sql.=" order by USER_REQUISITION.OPRATE_TIME DESC";
if($limit <> "")
$sql.= " limit ".$limit;
if($offset <> "")
$sql.= " offset ".$offset;
$res = $conn->GetAll($sql);
if($res===false){
$this->error = true;
$this->error_message = "got lost!";
return false;
}
$this->tryout_req_list=$res;
$sql = "select SYSDAT_KEY,CREATE_DATE,LIMIT_DATE,CHILDREN_COUNT from TRYOUT_KEY where TRYOUT_KEY_ID = (select max(TRYOUT_KEY_ID) from TRYOUT_KEY)";
$ressql = $conn->GetRow($sql);
$this->tryout_key = $ressql["SYSDAT_KEY"];
$this->tryout_key_create_time = $ressql["CREATE_DATE"];
$this->tryout_key_limit_date = $ressql["LIMIT_DATE"];//tpl显示的内容
$this->tryout_key_children_count = $ressql["CHILDREN_COUNT"];
return true;
}
//tpl内容1是:
<td width="250" height="50">限制日期
<input name="LIMIT_DATE" type="text" class="app_textfield" maxlength="255" value="{$da_tryout->tryout_key_limit_date}">
</td>
//tpl内容2是:
<tr>
<td class="app_table_left">期限:</td>
<td class="app_table_right"><input type="text" name="USER_TIME_LIMIT" class="app_textfield" value="{$da_tryout->tryout_key_limit_date}" maxlength="10"></td>
</tr>
调用的都是
function tryout_req_list_get($search_array,$limit='',$offset=''){
global $conn;
$this->error = false;
$this->error_message ="";
$sql = "select * from USER_REQUISITION,REQUISITION_INFO ";
$sql.= " where 1=1 ";
if(trim($search_array["REQUEST_STATE"])<>"") $sql.= " and REQUEST_STATE='".trim($search_array["REQUEST_STATE"])."'";
$sql.= " and USER_REQUISITION.REQUISITION_ID=REQUISITION_INFO.REQUISITION_ID";
if(trim($search_array["order_by"])<>""){$sql.=" order by ".trim($search_array["order_by"])." ".trim($search_array["order_desc"]);}
else $sql.=" order by USER_REQUISITION.OPRATE_TIME DESC";
if($limit <> "")
$sql.= " limit ".$limit;
if($offset <> "")
$sql.= " offset ".$offset;
$res = $conn->GetAll($sql);
if($res===false){
$this->error = true;
$this->error_message = "got lost!";
return false;
}
$this->tryout_req_list=$res;
$sql = "select SYSDAT_KEY,CREATE_DATE,LIMIT_DATE,CHILDREN_COUNT from TRYOUT_KEY where TRYOUT_KEY_ID = (select max(TRYOUT_KEY_ID) from TRYOUT_KEY)";
$ressql = $conn->GetRow($sql);
$this->tryout_key = $ressql["SYSDAT_KEY"];
$this->tryout_key_create_time = $ressql["CREATE_DATE"];
$this->tryout_key_limit_date = $ressql["LIMIT_DATE"];//tpl显示的内容
$this->tryout_key_children_count = $ressql["CHILDREN_COUNT"];
return true;
}
index.php?module=tryout&mode=tryout_toaudit_list&page=admin_tryout_toaudit //这个叶面可以显示
if("tryout_toaudit_list"== $mode){
$search_array=$_POST;
$search_array["REQUEST_STATE"]=1;
$da_tryout->tryout_req_list_count_get($search_array);
if($da_tryout->error){
$messageStack->add($da_tryout->error_message, 'error');
}
else{
////初始的分页,和检索条件的保存////
$search_array["order_by"]=trim($_GET['order_by']);
$order_by=trim($_GET['order_by']);
$search_array["order_desc"]=trim($_GET['order_desc']);
$order_desc=trim($_GET['order_desc']);
$pages=$_GET['trav'];
if($pages=="")$pages=1;
if(($pages*$each_page_number) > $da_tryout->tryout_req_list_count){$pages=ceil($da_tryout->tryout_req_list_count/$each_page_number);}
$url="index.php?module=tryout&mode=tryout_toaudit_list&page=admin_tryout_toaudit";
if($order_by <> "") $url=$url."&order_by=".$order_by."&order_desc=".$order_desc;
$c_page=new pages($each_page_number,$da_tryout->tryout_req_list_count,$pages,$url,'trav','');
$c_page->display();
$da_tryout->tryout_req_list_get($search_array,$each_page_number,intval($c_page->get_offset()));
if($da_tryout->error){
$messageStack->add($da_tryout->error_message, 'error');
}
}
}
如果要显示
(1)就用第一个
(2)修改mode=tryout_toaudit_list,page=admin_tryout_toaudit时执行的代码PS:代码没细看,仅供参考
case "tryout":
include ("../modules/module_tryout.php");
if($page=="" or $page=="admin_tryout_toaudit"){$smarty->display("admin_tryout_toaudit.tpl");}
elseif($page=="admin_tryout_totrue"){$smarty->display("admin_tryout_totrue.tpl");}
elseif($page=="admin_tryout_users"){$smarty->display("admin_tryout_users.tpl");}
elseif($page=="admin_tryout_open"){$smarty->display("admin_tryout_open.tpl");}
break;
admin_tryout_open.tpl这个是添加的叶面
的前面??