" width="">
$tntcmnft="tntcmnftisok";
include "../main/tntcmmn.html";?>
|
" width=""> |
" width=""> |
/img/main/title_sec.gif" align="absmiddle" border="0">Search
results
|
/img/main/spacer.gif" width="2" height="1" align="absmiddle" border="0"> |
|
//start of image board basic
//dbquery factors
if(isset($_GET['nMt']) && $_GET['nMt']){
$nMt=$_GET['nMt'];
}
if(isset($_GET['keywd']) && $_GET['keywd']){
$keywd=$_GET['keywd'];
}
if(isset($_GET['mCt']) && $_GET['mCt']){
$mCt=$_GET['mCt'];
}
if(!$mCt){
$mCt_dcrpt="All";
}else{
$mCt_dcrpt=urldecode($mCt);
}
$tblname=$tinatouch_srch; //table name *****
$bdbkimg_path="$img_path/img/main"; // board background image path *****
$odrcri="order by id"; //order factor *****
$odrpro="desc"; //desc or asc *****
$hor_nb=5; //horigental number-image
$ver_line_nb=4; //vertical line number
$hor_nb1=$hor_nb-1;
$limit=$hor_nb*$ver_line_nb;
$gallery_img_path=$img_path.'/abat/itmimg/';
// list name
$list_name="item";
// basic query by page $nMt *****
// restate query with adding Search, etc *****
if($nMt=="iTscRt3S"){ //page divide
if($mCt && !$keywd){
$findwhr='where prdt_sales_yn=\'Y\' and prdt_srch like \'%'.$mCt_dcrpt.'%\'';
}else if($mCt && $keywd){
$findwhr='where prdt_sales_yn=\'Y\' and prdt_srch like \'%'.$mCt_dcrpt.'%\' and prdt_srch like \'%'.$keywd.'%\'';
}else if(!$mCt && $keywd){
$findwhr='where prdt_sales_yn=\'Y\' and prdt_srch like \'%'.$keywd.'%\'';
}else{
$findwhr='where prdt_sales_yn=\'Y\' and prdt_srch like \'%alanjrkimisking%\'';
}
}else{
$findwhr='where prdt_sales_yn=\'Y\' and prdt_srch like \'%alanjrkimisking%\'';
}
//page manager
$pgRmN='?nMt='.$nMt; //any page 1st factor
$addfactor='&mCt='.$mCt; //add more page factors *****
if($keywd){
$addfactor=$addfactor.'&keywd='.$keywd; //search add address *****
//echo "e: $addfactor" ;
}
//page detect
$psver=$_GET['psver'];
$pgn=$_GET['pgn'];
if(!$psver){
$psver=0;
}else{
$psver=$psver+0;
}
if(!$pgn){
$pgn=1;
}else{
$pgn=$pgn+0;
}
$boardqry_num=mysql_query("select * from $tblname $findwhr $odrcri $odrpro");
$board_numrows=mysql_num_rows($boardqry_num);
if(!$board_numrows){
}else{
if($psver || $pgn){
if($psver==0 || $psver%$limit==0){
if($psver >= $board_numrows || !is_int($psver)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$pgn_limitno=ceil($board_numrows/(10*$limit));
if($pgn >= 1 && $pgn <= $pgn_limitno){
if(!is_int($pgn)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{
}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$psverchk=$psver/$limit;
if($psverchk >= ($pgn*10-10) && $psverchk < $pgn*10){
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
}
}
$total_page_num=$board_numrows/$limit;
$total_page=ceil($total_page_num);
$aNo=$board_numrows-$psver;
$str_sql= "select * from $tblname $findwhr $odrcri $odrpro limit $psver,$limit" ;
//echo "L173: $str_sql" ;
$boardqry=mysql_query($str_sql);
?>
$mCt_dcrpt, Your Keyword : $keywd");?>
|
|
1");
}else{
$hpage=$psver/$limit;
$hhppge=$hpage+1;
echo("$hhppge");
}
echo (" / $total_page | Total $board_numrows item(s).");?> |
|
| Sorry, we don't have data. Please enter your another key words. | ");
echo("");
}else{?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
//echo "e: $PHP_SELF$pgRmN$addfactor&psver=$nowpassover&pgn=$pgn" ;
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
|
$aNo=0;
while($boardqry_rslt=mysql_fetch_array($boardqry)){
$list_qry=mysql_query("select * from $tinatouch_prdt_product where prdt_id='$boardqry_rslt[prdt_id]'");
$list_numrows=mysql_num_rows($list_qry);
if(!$list_numrows){
$prdt_name="";
}else{
$list_qry_rslt=mysql_fetch_array($list_qry);
$prdt_name=$list_qry_rslt[prdt_name];
if(strlen($prdt_name) > 12){
$prdt_name=substr($prdt_name,0,11);
$prdt_name=$prdt_name.'..';
}else{}
$prdt_name=$list_qry_rslt[prdt_name];
$prdt_number=$list_qry_rslt[prdt_id];
$img_name=$list_qry_rslt[img1_filename];
}
$Vno=$aNo%$hor_nb;
if($Vno==0){?>
}?>
No.$prdt_number $prdt_name");?>
|
|
|
|
}else{
echo "We have nothing in this series.";
}?>
|
}$aNo++;}?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
//bottom paging
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
//echo "a: $addfactor " ;
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
|
}?> |
|