//connect to database
function db_link()
{
access_id = "root";
db_name = "inv";
@ db = mysql_connect('localhost', access_id, '831025') or
die("Could not connect to database. Please contact with IT supporting team ASAP.");
mysql_query("SET NAMES 'GBK'");
mysql_select_db(db_name);
return db;
}
link = db_link();
//get inquiry criteria,用 POST取得数据也行
sn_id_1 = _REQUEST['sn_id_1'];
sn_id_2 = _REQUEST['sn_id_2'];
//inquiry total pages
sn_sql = "SELECT * FROM sn WHERE 1 ";
if (sn_id_1 != ''){
sn_sql .= "AND sn_id >= '".sn_id_1."' ";
}
if (sn_id_2 != ''){
sn_sql .= "AND sn_id <= '".sn_id_2."' ";
}
sn_sql .= "ORDER BY sn_id DESC ";
sn_res = mysql_query(sn_sql);
total = mysql_num_rows(sn_res);
//show page
pageshow = showpage(total);
//inquiry current page
sn_sql .= " limit offset,num";
sn_res = mysql_query(sn_sql);
sn_num = mysql_num_rows(sn_res);
//output inquiry result as XML
header("Content-Type: text/xml");
if(total > 0){
echo '<?xml version="1.0" encoding="gb2312"?>';
echo '<root>';
echo '<![CDATA[';
echo '<fieldset class="inquiry">
<legend>LIST</legend>
<table class="list">
<tr>
<th class="header">No</th>
<th class="header">SN</th>
<th class="header">Plant</th>
<th class="header">Sales</th>
<th class="header">Act</th>
<th class="header">Type</th>
<th class="header">Status</th>
<th class="header">Release Date</th>
<th class="header">Approve Date</th>
<th class="header">Reject Date</th>
<th class="header">Cancel Date</th>
<th class="header">Close Date</th>
</tr>';
num = offset;
for (i = 0; i < sn_num; i++) {
sn_row = mysql_fetch_array(sn_res);
if (i % 2 == 0) {
echo '<tr class="even" style="cursor:hand" >';
}else{
echo '<tr class="odd" style="cursor:hand" >';
}
echo'<td class="list center">'.(num+1).'</td>
<td class="list right blue">'.sn_row['sn_id'].'</td>
<td class="list center">'.sn_row['sn_plant'].'</td>
<td class="list right">'.sn_row['sn_sales'].'</td>
<td class="list center red">'.sn_row['sn_act'].'</td>
<td class="list center">'.sn_row['sn_type'].'</td>
<td class="list center">'.sn_row['sn_sts'].'</td>
<td class="list left">'.substr(sn_row['sn_rel_date'],0,10).'</td>
<td class="list left">'.substr(sn_row['sn_apv_date'],0,10).'</td>
<td class="list left">'.substr(sn_row['sn_rej_date'],0,10).'</td>
<td class="list left">'.substr(sn_row['sn_can_date'],0,10).'</td>
<td class="list left">'.substr(sn_row['sn_cls_date'],0,10).'</td>
</tr>';
num++;
}
echo '</table>';
echo '<div>'.pageshow.'</div>';
echo '</fieldset>';
echo ']]>';
echo '</root>';
}else{
echo 'find nothing';
}
?>