script จัดเรียงตามหัวตาราง ทำยังไงคะ
Posted: 03/07/2014 5:14 pm
จะทำสคริปต์จัดเรียงตามหัวตารางต้องทำยังไงคะ
เว็บบอร์ด PHP ใช้งานจริงใน ธุรกิจ ด้วยเทคโนโลยี Ajax HTML5 Framework SQL CMS CRM ERP Hosting
https://www.mindphp.com/forums/
เรียงหัวตารางอะไรbuay wrote:จะทำสคริปต์จัดเรียงตามหัวตารางต้องทำยังไงคะ
Code: Select all
function load_data(k,d)
{
$(".content").html('<div style="text-align:center"><img src="../images/loading_wh.gif"></div>');
$(".content").load("page3.php?k="+k+"&d="+d+"&rand={TIME}");
}
Code: Select all
<td align="center">{L_NUM}</td>
<td align="center" onclick="load_data('a','{DD}')" onmouseover="this.style.cursor='pointer';">{L_CAR}</td>
<td align="center">{L_TIME}</td>
<td align="center">{L_W}</td>
<td align="center">{L_WIN}</td>
<td align="center">{L_WOUT}</td>
<td align="center" onclick="load_data('b','{DD}')" onmouseover="this.style.cursor='pointer';">{L_TYPE}</td>
<td align="center" onclick="load_data('c','{DD}')" onmouseover="this.style.cursor='pointer';">{L_NAME}</td>
Code: Select all
$or = array('TRUCK ASC','PRODUCT ASC','COMPANY ASC','TMIN ASC');
if($_GET['k']=='a'){
$fd = $or[0];
}else if($_GET['k']=='b'){
$fd = $or[1];
}else if($_GET['k']=='c'){
$fd = $or[2];
}else{
$fd = $or[3];
}
$sql = "select
TRUCK,
TMIN,
TMOUT,
(W1-W2)/1000 AS sum_w,
(W1/1000) AS car_in ,
(W2/1000) AS car_out,
PRODUCT,
COMPANY,
(W1-W2)/1000 AS wa,
(W1-W2)/1000 AS wb
FROM wdata
WHERE dayin=".set_f_date($sql_m_b)."
ORDER BY ".$fd."";
Code: Select all
function load_data(k,s,d)
{
$(".content").html('<div style="text-align:center"><img src="../images/loading_wh.gif"></div>');
$(".content").load("page3.php?k="+k+"&s="+s+"&d="+d+"&rand={TIME}");
}
Code: Select all
$or = array('TRUCK ASC','PRODUCT ASC','COMPANY ASC','TMIN ASC','TRUCK DESC','PRODUCT DESC','COMPANY DESC','TMIN DESC');
if($_GET['s']=='DESC'||$_GET['s']==''){
$template->assign_vars(array(
'S' => 'ASC',
));
}else {
$template->assign_vars(array(
'S' => 'DESC',
));
}
if($_GET['k']=='a'){
if($_GET['s']!='ASC'){
$fd = $or[0];
}else{
$fd = $or[4];
}
}else if($_GET['k']=='b'){
if($_GET['s']!='ASC'){
$fd = $or[1];
}else{
$fd = $or[5];
}
}else if($_GET['k']=='c'){
if($_GET['s']!='ASC'){
$fd = $or[2];
}else{
$fd = $or[6];
}
}else{
$fd = $or[3];
}
$sql = "select
TRUCK,
TMIN,
TMOUT,
(W1-W2)/1000 AS sum_w,
(W1/1000) AS car_in ,
(W2/1000) AS car_out,
PRODUCT,
COMPANY,
(W1-W2)/1000 AS wa,
(W1-W2)/1000 AS wb
FROM wdata
WHERE dayin=".set_f_date($sql_m_b)."
ORDER BY ".$fd."";
Code: Select all
<tr bgcolor="#CCCCCC">
<td align="center">{L_NUM}</td>
<td align="center" onclick="load_data('a','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_CAR}</td>
<td align="center">{L_TIME}</td>
<td align="center">{L_W}</td>
<td align="center">{L_WIN}</td>
<td align="center">{L_WOUT}</td>
<td align="center" onclick="load_data('b','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_TYPE}</td>
<td align="center" onclick="load_data('c','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_NAME}</td>
</tr>