getLinkSort PHP Code Examples

Example #1

0

Show file

File: news.php Project: ece4u/ece4cWeb

?>
">Thứ tự </a></th>
		<th width="48" class="title"><a class="title" href="<?php 
echo getLinkSort(11);
?>
">Không hiển thị</a></th>
		<th width="88" class="title"><a class="title" href="<?php 
echo getLinkSort(12);
?>
">Ngày tạo lập</a></th>
		<th width="90" class="title"><a class="title" href="<?php 
echo getLinkSort(13);
?>
">Lần hiệu chỉnh trước</a></th>
		<th width="40" class="title"><a class="title" href="<?php 
echo getLinkSort(14);
?>
">Ngôn ngữ</a></th>
	</tr>
  
<?php 
$sortby = 'order by date_added';
if ($_REQUEST['sortby'] != '') {
    $sortby = 'order by ' . (int) $_REQUEST['sortby'];
}
$direction = $_REQUEST['direction'] == '' || $_REQUEST['direction'] == '0' ? 'desc' : '';
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableConfig} where {$parentWhereConfig} and {$where} {$sortby} {$direction} limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = mysql_query($sql, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
    $parent = getRecord($tableCategoryConfig, 'id = ' . $row['parent']);

Example #2

0

Show file

File: order.php Project: ece4u/ece4cWeb

		<th width="20" class="title">ID</th>
		<th class="title"><a class="title" href="<?php 
echo getLinkSort(2);
?>
">Mã SP</a></th>
		<th class="title">Số lượng SP</th>    
		<th class="title"><a class="title" href="<?php 
echo getLinkSort(3);
?>
">Tên khách hàng</a></th>
		<th width="90" class="title"><a class="title" href="<?php 
echo getLinkSort(4);
?>
">Ngày tạo lập</a></th>
		<th width="90" class="title"><a class="title" href="<?php 
echo getLinkSort(5);
?>
">Lần hiệu chỉnh trước</a></th>
	</tr>
  
<?php 
$sortby = 'order by date_added';
if ($_REQUEST['sortby'] != '') {
    $sortby = 'order by ' . (int) $_REQUEST['sortby'];
}
$direction = $_REQUEST['direction'] == '' || $_REQUEST['direction'] == '0' ? 'desc' : '';
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from tbl_order {$sortby} {$direction} limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = mysql_query($sql, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
    $cust = getRecord("tbl_member", 'id=' . $row['member_id']);

Example #3

0

Show file

File: orders.php Project: bestwishforyou95/congnghemoitruong

    $trDetele_1title = "<th width=\"20\" class=\"title\"><input type=\"checkbox\" name=\"chkall\" onClick=\"chkallClick(this);\"></th>";
    $trDetele_2title = "<th  align=\"center\" valign=\"middle\" class=\"title\">&nbsp;</th>";
    $trDetele_1bottom = "<td></td>";
    $trDeteleAllbottom = "<input type=\"submit\" value=\"" . TDELETESELECTSD . "\" name=\"btnDel\" onClick=\"return confirm('" . AAREYOUDELETE . "');\" class=\"button\">";
}
//SAC DINH THANH VIEN NAY CO CHO XOA KO==============
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
if ($totalEdit > 0) {
    $trEdit_1title = "<th  align=\"center\" valign=\"middle\" class=\"title\">&nbsp;</th>";
    $trEdit_1bottom = "<td></td>";
}
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
if (isset($_GET['btnsearch-advance-other'])) {
    $countNUMEMAILTITLE = "<th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#\">Số lần mua</a></th>";
}
$processFrameShowHtmlTr = "\n\t<tr>\n\t  " . $trDetele_1title . "\n\t   " . $trEdit_1title . "\n\t  " . $trDetele_2title . "\t\n\t\t<th width=\"17\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">" . TID . "</a></th>\n\t    <th width=\"57\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Điện thoại</a></th>\n      <th width=\"223\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">" . TNAME . " </a></th>\t\n\t  <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(4) . "\">Email</a></th>\n\t  {$countNUMEMAILTITLE}\n\t  " . $trAddImage_title . "\n\t  \n\t  <th width=\"161\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(30) . "\"> " . TSORT . "</a></th>\n\t  <th width=\"83\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(12) . "\">Đã xác thực</a></th>\n\t  <th width=\"83\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(11) . "\">Đã giao hàng</a></th>\n\t  <th width=\"83\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(31) . "\">" . TSHOW . "</a></th>\n\t  <th width=\"52\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(34) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"53\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(35) . "\">" . TLASTUPDATED . "</a></th>\n    </tr>\n";
//TIEU DE CUA COT=====================================================================[[[[[[[[[[[[[[[[[[[]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
if ($_REQUEST['sortby'] == '') {
    $sortbyNum = 'order by last_modified desc';
} else {
    $sortbyNum = $sortby . " " . $direction;
}
//KET NOI DU LIEU LAY NOI DUNG TRANG=============================[[[[[[[[[[[[[[[[[=====================]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
if (isset($_GET['btnsearch-advance-other'])) {
    $datefrom = $_GET['date-from'];
    $dateto = $_GET['date-to'];
    $filldate = $_GET['choose-date'];
    $fillmail = $_GET['fillemail'];
    $chkdelivery = $_GET['choose-delivery'];
    $chkauthentic = $_GET['choose-authentic'];
    /** Loc theo ngay */

Example #4

0

Show file

File: image.php Project: bestwishforyou95/congnghemoitruong

	  <th width="96" align="center" valign="middle" class="title"><a class="title" href="<?php 
echo getLinkSort(6);
?>
"><?php 
echo TSHOW;
?>
</a></th>
	  <th width="105" class="title"><a class="title" href="<?php 
echo getLinkSort(7);
?>
"><?php 
echo TDATEESTABLISHED;
?>
</a></th>
	  <th width="94" align="center" valign="middle" class="title"><a class="title" href="<?php 
echo getLinkSort(8);
?>
">
	    <?php 
echo TLASTUPDATED;
?>
	  </a></th>
    </tr>
  
<?php 
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableImageId} where {$whereComment} and {$whereStatus}  order by typeivm desc  limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    $nameCategory = getRecord($tableConfigId, 'id = ' . $row['id_parent']);

Example #5

0

Show file

File: city.php Project: bestwishforyou95/congnghemoitruong

    $trEdit_1bottom = "<td></td>";
}
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
//CHO THEM NHIEU HINH================================
if ($defaulType['type_image_many'] == '1' and $totalConfigModuleLevelIdImage > 0) {
    $trAddImage_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TIMAGE . "</a></th>\n";
    $trAddImage_Bottom = "\n<td></td>\n";
}
//CHO THEM NHIEU HINH================================KET THUC
//CHO THEM COMMENT================================
if ($defaulType['type_comment'] == '1' and $totalConfigModuleLevelIdComment > 0) {
    $trAddComment_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TCOMMENT . "</a></th>\n";
    $trAddComment_Bottom = "\n<td></td>\n";
}
//CHO THEM COMMENT================================KET THUC
$processFrameShowHtmlTr = "\n\t<tr>\n\t  " . $trDetele_1title . "\n\t   " . $trEdit_1title . "\n\t  " . $trDetele_2title . "\t\n\t\t<th width=\"17\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">" . TID . "</a></th>\n\t\n      <th width=\"223\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">" . TNAME . " </a></th>\t\n\t \n\t  \n\t  " . $trAddImage_title . "\n\t " . $trAddComment_title . "\n\t  \n\t  <th width=\"161\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(30) . "\"> " . TSORT . "</a></th>\n\t  <th width=\"83\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(31) . "\">" . TSHOW . "</a></th>\n\t  <th width=\"52\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(34) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"53\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(35) . "\">" . TLASTUPDATED . "</a></th>\n    </tr>\n";
//TIEU DE CUA COT=====================================================================[[[[[[[[[[[[[[[[[[[]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
if ($_REQUEST['sortby'] == '') {
    $sortbyNum = 'order by last_modified desc';
} else {
    $sortbyNum = $sortby . " " . $direction;
}
//KET NOI DU LIEU LAY NOI DUNG TRANG=============================[[[[[[[[[[[[[[[[[=====================]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableCityId} where {$whereComment}  {$sortbyNum}   limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    //BAT DAU VONG WHILE------------------------------
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    //LAY URL CUA SAN PHAM========================================================================
    /*$moduleUrlLangNameHtml		=	"";

Example #6

0

Show file

File: user_config.php Project: bestwishforyou95/congnghemoitruong

include 'updateOrder.php';
//Update Show
include 'updateShow.php';
if ($_GET['code'] == 1) {
    $errMsg = 'Successfully updated.';
}
//kiem  tra cap nhat thanh cong hay chua
$pageindex = createPage(countRecord($tableUser, $parentWhereConfig), './?act=' . $actUser . '&codeParent=' . $_REQUEST['codeParent'] . '&name=' . $_REQUEST['name'] . '&ma=' . $_REQUEST['ma'] . '&page=', $MAXPAGE, $page, '30', $_lang_A);
//phan trang
$pageindexHtml = $totalItems > $MAXPAGE ? '<td height="30" class="smallfont" align="left" valign="middle" >Page :' . $pageindex . '</td>' : '';
if ($errMsg != '') {
    $errMsgHtml = '<p align=center class="err">' . $errMsg . '<br></p>';
}
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableUser}";
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    if ($row['status'] == 0) {
        $showNotshow = " <a href=\"./?act=" . $actUser . "&action=notshow&codeParent=" . $_REQUEST['codeParent'] . "&id=" . $row['id'] . "&page=" . $_REQUEST['page'] . "&lang=" . $_lang_A . "\"><img border=\"0\" src=\"images/show.gif\" alt=\"" . TSHOW . "\" height=\"20\"/></a>";
    } else {
        $showNotshow = "<a href=\"./?act=" . $actUser . "&action=show&codeParent=" . $_REQUEST['codeParent'] . "&id=" . $row['id'] . "&page=" . $_REQUEST['page'] . "&lang=" . $_lang_A . "\"><img border=\"0\" src=\"images/notshow.gif\" alt=\"" . TNOTSHOW . "\" height=\"20\"/></a>";
    }
    $processFrameShowHtmlTr .= "\n<tr>\n\t\t<td align=\"center\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n\t\t<input type=\"checkbox\" name=\"chk[]\" value=\"" . $row['id'] . "\"></td>\n\t\t<td width=\"34\" align=\"center\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n\t\t\t<a href=\"./?act=" . $actUser . "_m&page=" . $_REQUEST['page'] . "&codeParent=" . $_REQUEST['codeParent'] . "&id=" . $row['id'] . "&lang=" . $_lang_A . "\">" . TEDIT . "</a>\t\t</td>\n        <td width=\"41\" align=\"center\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n\t\t\t<a \n\t\t\t\tonClick=\"return confirm('Are you sure you want to delete?');\" \n\t\t\t\thref=\"./?act=" . $actUser . "&action=del&page=" . $_REQUEST['page'] . "&codeParent=" . $_REQUEST['codeParent'] . "&id=" . $row['id'] . "&lang=" . $_lang_A . "\"\n\t\t\t>" . TDELETE . "</a>\t\t</td>\n\t    <td bgcolor=\"" . $color . "\" class=\"smallfont\" align=\"center\">" . $row['id'] . "</td>\t\t\t\n\t\t<td align=\"left\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">" . $row['name'] . "</td>\t\t\t\n\t\t<td align=\"left\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">" . $row['uid'] . "</td>\n\t\t<td align=\"left\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">" . $row['phone'] . "</td>\t\t\t\t\n\t\t<td align=\"center\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n\t\t\n\t\t<input type=\"hidden\" value=\"" . $row['id'] . "\" name=\"hID[]\"/>\n        <input type=\"text\" value=\"" . $row['sort'] . "\" size=\"2\" name=\"txtOrder[]\"/>\n\t\t\n\t\t\n\t\t</td>\n\t\t<td align=\"center\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n\t\t\t\t\n\t\t\t\n\t\t\t" . $showNotshow . "\n\t\t\t\n\t\t\t\n\t  </td>\n\t\t<td align=\"center\" valign=\"middle\" bgcolor=\"" . $color . "\" class=\"smallfont\">" . $row['dateAdd'] . "</td>\n\t\t<td bgcolor=\"" . $color . "\" class=\"smallfont\" align=\"center\">" . $row['dateModify'] . "</td>\n\t</tr>\n";
}
$processFrameShowHtml = "\n<form method=\"POST\" action=\"./\" name=\"frmForm\" enctype=\"multipart/form-data\">\n<input type=\"hidden\" name=\"page\" value=\"" . $page . "\">\n<input type=\"hidden\" name=\"codeParent\" value=\"" . $_REQUEST['codeParent'] . "\">\n<input type=\"hidden\" name=\"act\" value=\"" . $actUser . "\">\n\n\n\n<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\n\t<tr>\n\t\t" . $pageindexHtml . "\n\t\t\n\t</tr>\n\t\n\t\n\t\n\t\n\t\n</table>\n\n<table border=\"1\" cellpadding=\"2\" bordercolor=\"#C9C9C9\" width=\"100%\">\n\t<tr>\n\t  <th width=\"20\" class=\"title\"><input type=\"checkbox\" name=\"chkall\" onClick=\"chkallClick(this);\"></th>\n\t  <th class=\"title\" colspan=\"2\" rowspan></th>\t\t\n\t\t<th width=\"18\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">ID</a></th>\n\t  <th width=\"235\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(4) . "\">" . TNAME . "  </a></th>\t\t\t\n\t  <th width=\"115\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(3) . "\">" . ADUSER . "</a></th>\n\t  <th width=\"126\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(3) . "\">" . TFTEL . "</a></th>\t\t\t\t\n\t  <th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\"> " . TSORT . "</a></th>\n\t  <th width=\"67\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(6) . "\">" . TSHOW . "</a></th>\n\t  <th width=\"91\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(7) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"109\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">" . TLASTUPDATED . "</a></th>\n    </tr>\n  \n" . $processFrameShowHtmlTr . "\n\n<tr>\n\t  <td width=\"20\"></td>\n\t\t<td colspan=\"2\"></td>\t\t\n\t\t<td width=\"18\"></td>\n\t\t<td></td>\t\t\n\t\t<td></td>\t\t\t\t\n\t\t<td></td>\n\t\t<td>\n\t\t<span class=\"title\">\n\t\t  <input type=\"submit\" value=\"Update\" name=\"btnOrder\" class=\"button\">\n\t  </span>\n\t  </td>\n\n\t\t<td>&nbsp;</td>\n\t\t<td></td>\n\t\t<td></td>\n\t\t\n\t\n\t</tr>\n</table>\n\n<table width=\"100%\">\n\t<tr>\n\t\t<td width=\"30%\">\n<input type=\"submit\" value=\"Delete selected\" name=\"btnDel\" onClick=\"return confirm('Are you sure you want to delete?');\" class=\"button\">\n<input type=\"button\" value=\"Add new\" name=\"btnNew\" onClick=\"window.location='./?act=" . $actUser . "_m&page=" . $_REQUEST['page'] . "&codeParent=" . $_REQUEST['codeParent'] . "&lang=" . $_lang_A . "'\" class=\"button\">\n\t\t</td>\n\t</tr>\n</table>\n\n\n\n</form>\n<script language=\"JavaScript\">\nfunction chkallClick(o) {\n  \tvar form = document.frmForm;\n\tfor (var i = 0; i < form.elements.length; i++) {\n\t\tif (form.elements[i].type == \"checkbox\" && form.elements[i].name!=\"chkall\") {\n\t\t\tform.elements[i].checked = document.frmForm.chkall.checked;\n\t\t}\n\t}\n}\n</script>\n\n\n" . $errMsgHtml . "\n\n<table width=\"100%\">\n\t<tr><td height=\"10\"></td></tr>\n\t<tr><td class=\"smallfont\">Total row : <b>" . countRecord($tableUser, $parentWhereConfig) . "</b></td></tr>\n</table>";
?>

Example #7

0

Show file

File: member.php Project: ece4u/ece4cWeb

?>
">Uid</a></th>
		<th class="title"><a class="title" href="<?php 
echo getLinkSort(12);
?>
">Pass</a></th>
		<th width="50" class="title"><a class="title" href="<?php 
echo getLinkSort(14);
?>
">Không hiển thị</a></th>
		<th width="90" class="title"><a class="title" href="<?php 
echo getLinkSort(15);
?>
">Ngày tạo lập</a></th>
		<th width="90" class="title"><a class="title" href="<?php 
echo getLinkSort(16);
?>
">Lần hiệu chỉnh trước</a></th>
	</tr>
  
<?php 
$sortby = 'order by date_added';
if ($_REQUEST['sortby'] != '') {
    $sortby = 'order by ' . (int) $_REQUEST['sortby'];
}
$direction = $_REQUEST['direction'] == '' || $_REQUEST['direction'] == '0' ? 'desc' : '';
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from tbl_member where {$where} {$sortby} {$direction} limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = mysql_query($sql, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';

Example #8

0

Show file

File: product_special.php Project: ece4u/ece4cWeb

?>
">Thứ tự sắp xếp</a></th>
		<th width="75" class="title"><a class="title" href="<?php 
echo getLinkSort(4);
?>
">Không hiển thị</a></th>
		<th width="134" class="title"><a class="title" href="<?php 
echo getLinkSort(5);
?>
">Ngày tạo lập</a></th>
		<th width="133" class="title"><a class="title" href="<?php 
echo getLinkSort(6);
?>
">Lần hiệu chỉnh trước</a></th>
		<th width="40" class="title"><a class="title" href="<?php 
echo getLinkSort(7);
?>
">Ngôn ngữ</a></th>
	</tr>
  
<?php 
$sortby = 'order by date_added';
if ($_REQUEST['sortby'] != '') {
    $sortby = 'order by ' . (int) $_REQUEST['sortby'];
}
$direction = $_REQUEST['direction'] == '' || $_REQUEST['direction'] == '0' ? 'desc' : '';
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableConfig} where {$where} {$sortby} {$direction} limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = mysql_query($sql, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
    $pro = getRecord($tableCategoryConfig, 'id=' . $row['product_id']);

Example #9

0

Show file

File: voucherpublic111.php Project: bestwishforyou95/congnghemoitruong

$pageindex = createPage($totalItems, './?act=voucherpublic&page=', $MAXPAGE, $page, '30');
//phan trang
$showPageIndex = $totalItems > $MAXPAGE ? '<td height="30" class="smallfont" align="left" valign="middle" >' . TPAGE . ' :' . $pageindex . '</td>' : '';
if ($totalDetele > 0) {
    $trDetele_1title = "<th width=\"20\" class=\"title\"><input type=\"checkbox\" name=\"chkall\" onClick=\"chkallClick(this);\"></th>";
    $trDetele_2title = "<th  align=\"center\" valign=\"middle\" width=\"50\" class=\"title\">&nbsp;</th>";
    $trDetele_1bottom = "<td></td>";
    $trDeteleAllbottom = "<input type=\"submit\" value=\"" . TDELETESELECTSD . "\" name=\"btnDel\" onClick=\"return confirm('" . AAREYOUDELETE . "');\" class=\"button\">";
}
//SAC DINH THANH VIEN NAY CO CHO XOA KO==============
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
if ($totalEdit > 0) {
    $trEdit_1title = "<th  align=\"center\" width=\"50\" valign=\"middle\" class=\"title\">&nbsp;</th>";
    $trEdit_1bottom = "<td></td>";
}
$processFrameShowHtmlTr = "\n\t<tr>\n\t  " . $trDetele_1title . "\n\t   " . $trEdit_1title . "\n\t  " . $trDetele_2title . "\t\n\t\t<th width=\"17\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">" . TID . "</a></th>\n        <th width=\"100\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Tên thành viên</a></th>\n        <th width=\"100\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Email</a></th>\n\t    <th width=\"100\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Mã khuyến mãi</a></th>\n\t  <th width=\"120\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(4) . "\">Phần trăm giảm giá</a></th>\n      <th width=\"50\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">Tình trạng</a></th>\t\n\t  <th width=\"72\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(34) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"73\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(35) . "\">Ngày hết hạn</a></th>\n    </tr>\n";
$sql = "select * from tbl_voucher where type=1 order by date_from desc limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    //BAT DAU VONG WHILE------------------------------
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    $date_from = date("d/m/Y H:i:s", $row['date_from']);
    $date_to = date("d/m/Y H:i:s", $row['date_to']);
    $processFrameShowHtmlTr .= "\n\n\n\n<tr>\n\t\t<td colspan=\"16\" align=\"left\" valign=\"middle\" bgcolor=\"#FFFFFF\" class=\"smallfont\" style=\"padding-left:24px; font-size:11px; color:#CCCCCC\">\n\t\t\n\t\t\n\t\t<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n  <tr>\n    <td width=\"70%\" align=\"left\" valign=\"middle\" class=\"smallfont\" style=\"font-size:11px; color:#CCCCCC\">\n\t\t<div id=\"type_member_div" . $row['id'] . "\"></div></td>\n  \n  </tr>\n</table>\n\t\t</td>\n\t</tr>\n\n\n\n\n";
    if ($totalDetele > 0) {
        $trDetele_2 = "\n<td width=\"30\" align=\"center\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n<a onClick=\"return confirm('" . AAREYOUDELETE . "');\" href=\"./?act=voucherpublic&action=del&id=" . $row['id'] . "&page=" . $_REQUEST['page'] . "\">" . TDELETE . "</a></td>\n";
        $trDetele_2All = "\n<td align=\"center\" bgcolor=\"" . $color . "\" class=\"smallfont\">\n<input type=\"checkbox\" name=\"chk[]\" value=\"" . $row['id'] . "\"></td>\n";
    } else {
        $trDetele_2 = "";
        $trDetele_2All = "";

Example #10

0

Show file

File: voucherprivate.php Project: bestwishforyou95/congnghemoitruong

    $trEdit_1bottom = "<td></td>";
}
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
//CHO THEM NHIEU HINH================================
if ($defaulType['type_image_many'] == '1' and $totalConfigModuleLevelIdImage > 0) {
    $trAddImage_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TIMAGE . "</a></th>\n";
    $trAddImage_Bottom = "\n<td></td>\n";
}
//CHO THEM NHIEU HINH================================KET THUC
//CHO THEM COMMENT================================
if ($defaulType['type_comment'] == '1' and $totalConfigModuleLevelIdComment > 0) {
    $trAddComment_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TCOMMENT . "</a></th>\n";
    $trAddComment_Bottom = "\n<td></td>\n";
}
//CHO THEM COMMENT================================KET THUC
$processFrameShowHtmlTr = "\n\t<tr>\n\t  " . $trDetele_1title . "\n\t   " . $trEdit_1title . "\n\t  " . $trDetele_2title . "\t\n\t\t<th width=\"17\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">" . TID . "</a></th>\n\t    <th width=\"57\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Điện thoại</a></th>\n      <th width=\"150\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">" . TNAME . " </a></th>\t\n      <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Tổng tiền đã mua</th>\n      <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Phiếu giảm giá theo thành viên</th>\t\t\n      <th width=\"50\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(31) . "\">Tình trạng</a></th>\n\t  <!--<th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Loại thành viên</th>-->\n\t  <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(4) . "\">Email</a></th>\n\t  \n\t  <th width=\"52\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(34) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"53\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(35) . "\">" . TLASTUPDATED . "</a></th>\n    </tr>\n";
//TIEU DE CUA COT=====================================================================[[[[[[[[[[[[[[[[[[[]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
if ($_REQUEST['sortby'] == '') {
    $sortbyNum = 'order by last_modified desc';
} else {
    $sortbyNum = $sortby . " " . $direction;
}
//KET NOI DU LIEU LAY NOI DUNG TRANG=============================[[[[[[[[[[[[[[[[[=====================]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableMemberId} where {$whereComment}  {$sortbyNum}   limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    //BAT DAU VONG WHILE------------------------------
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    //LAY URL CUA SAN PHAM========================================================================
    /*$moduleUrlLangNameHtml		=	"";

Example #11

0

Show file

File: member.php Project: bestwishforyou95/congnghemoitruong

    $trEdit_1bottom = "<td></td>";
}
//SAC DINH THANH VIEN NAY CO CHO SUA KO==============
//CHO THEM NHIEU HINH================================
if ($defaulType['type_image_many'] == '1' and $totalConfigModuleLevelIdImage > 0) {
    $trAddImage_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TIMAGE . "</a></th>\n";
    $trAddImage_Bottom = "\n<td></td>\n";
}
//CHO THEM NHIEU HINH================================KET THUC
//CHO THEM COMMENT================================
if ($defaulType['type_comment'] == '1' and $totalConfigModuleLevelIdComment > 0) {
    $trAddComment_title = "\n<th width=\"58\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"#1\">" . TCOMMENT . "</a></th>\n";
    $trAddComment_Bottom = "\n<td></td>\n";
}
//CHO THEM COMMENT================================KET THUC
$processFrameShowHtmlTr = "\n\t<tr>\n\t  " . $trDetele_1title . "\n\t   " . $trEdit_1title . "\n\t  " . $trDetele_2title . "\t\n\t\t<th width=\"17\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(1) . "\">" . TID . "</a></th>\n\t    <th width=\"57\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(5) . "\">Điện thoại</a></th>\n      <th width=\"223\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(8) . "\">" . TNAME . " </a></th>\t\n      <!--<th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Phiếu giảm giá theo thành viên</th>\n      <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Phiếu giảm giá đại trà</th>-->\t\t\n\t  <!--<th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\">Loại thành viên</th>-->\n\t  <th width=\"72\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(4) . "\">Email</a></th>\n\t  \n\t  " . $trAddImage_title . "\n\t " . $trAddComment_title . "\n\t  \n\t  <th width=\"161\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(30) . "\"> " . TSORT . "</a></th>\n\t  <th width=\"83\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(31) . "\">" . TSHOW . "</a></th>\n\t  <th width=\"52\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(34) . "\">" . TDATEESTABLISHED . "</a></th>\n\t  <th width=\"53\" align=\"center\" valign=\"middle\" class=\"title\"><a class=\"title\" href=\"" . getLinkSort(35) . "\">" . TLASTUPDATED . "</a></th>\n    </tr>\n";
//TIEU DE CUA COT=====================================================================[[[[[[[[[[[[[[[[[[[]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
if ($_REQUEST['sortby'] == '') {
    $sortbyNum = 'order by last_modified desc';
} else {
    $sortbyNum = $sortby . " " . $direction;
}
//KET NOI DU LIEU LAY NOI DUNG TRANG=============================[[[[[[[[[[[[[[[[[=====================]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
$sql = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableMemberId} where {$whereComment}  {$sortbyNum}   limit " . $p * $MAXPAGE . "," . $MAXPAGE;
$SqlReport = "select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from {$tableMemberId} where {$whereComment}  {$sortbyNum} ";
$result = @mysql_query($sql, $conn);
$i = 0;
while ($row = @mysql_fetch_array($result)) {
    //BAT DAU VONG WHILE------------------------------
    $color = $i++ % 2 ? '#d5d5d5' : '#e5e5e5';
    //LAY URL CUA SAN PHAM========================================================================

PHP getLinkSort Examples