






|
$handle = mysql_connect("localhost","shrimpbase","69Mxam0p");
if ( !$handle){ print ("Connect Fail"); }
else{ mysql_select_db("shrimpbase",$handle); }
$keyfield = strtolower(rtrim($keyfield));
$keyfield2 = strtolower(rtrim($keyfield2));
//Generate array
$fieldarr["thai"][0]="author_t";
$fieldarr["thai"][1]="title_t";
$fieldarr["thai"][2]="import_t";
$fieldarr["thai"][3]="abstract_t";
$fieldarr["eng"][0]="author_eng";
$fieldarr["eng"][1]="title_eng";
$fieldarr["eng"][2]="import_eng";
$fieldarr["eng"][3]="abstract_eng";
$query=" select * from shrimp where ";
if(!empty($keyfield))
$query=$query . "( BINARY ". $fieldarr["thai"][$choice] . " like '%$keyfield%' or BINARY lower( " . $fieldarr["eng"][$choice] . ") like '%$keyfield%' )";
if(!empty($keyfield2))
$query=$query . " $andor_keywords_record2 ( BINARY ". $fieldarr["thai"][$choice2] . " like '%$keyfield2%' or BINARY lower( " . $fieldarr["eng"][$choice2] . ") like '%$keyfield2%' ) ";
//echo $query;
echo " ";
echo "รายงานความก้าวหน้าการวิจัยครั้งที่ 2 (เมษายน-มิถุนายน 2546) | งานวิจัยกุ้งทะเลของประเทศไทย (2530-2546) | ";
echo " ";
$data_query = mysql_query ($query,$handle);
$row_count = mysql_num_rows($data_query);
if ($choice=="0")
{
$detail1="ผู้แต่ง";
}
if ($choice=="1")
{
$detail1="ชื่อเรื่อง";
}
if ($choice=="2")
{
$detail1="คำสำคัญ";
}
echo " ";
echo "ค้นหาด้วย [$detail1 : $keyfield ]";
if ($choice2=="0")
{
$detail2="ผู้แต่ง";
}
if ($choice2=="1")
{
$detail2="ชื่อเรื่อง";
}
if ($choice2=="2")
{
$detail2="คำสำคัญ";
}
if ($andor_keywords_record2=="AND" && !empty($keyfield2))
{
$con="และ";
}
if ($andor_keywords_record2=="OR" && !empty($keyfield2))
{
$con="หรือ";
}
echo " $con ";
if (!empty($keyfield2))
{
echo "[$detail2";
echo " :";
echo " $keyfield2";
echo "]";
}
else
{
echo " ";
}
echo " พบ : $row_count รายการ";
$pagesize=20;
if(empty($page))$page=1;
//Calculate page
//echo "$row_count/$pagesize";
$totalpage=( int) ($row_count/$pagesize);
if( $row_count%$pagesize>0)
$totalpage=$totalpage+1;
echo " ";
if($row_count>0)
{
for($i=0;$i<(($page-1)*$pagesize);$i++) //Fetch until
$arr = mysql_fetch_row ($data_query);
while($arr = mysql_fetch_row ($data_query))
{
echo "";
echo " ";
echo " ";
echo $i+1 .". ";
echo "[$arr[0]] ";
//Display thai bib
if(!empty($arr[2]))
{
$result=$arr[2];
if($choice=="0" && !empty($keyfield)) //Select author
$result= preg_replace("'($keyfield)'si", "\\1", $result)." ";
if($choice2=="0" && !empty($keyfield2) )
$result= preg_replace("'($keyfield2)'si", "\\1", $result)." ";
echo $result;
echo "$arr[4] ";
$result=$arr[6];
if($choice=="1" && !empty($keyfield)) //Select title
$result= preg_replace("'($keyfield)'si", "\\1",$result)." ";
if($choice2=="1" && !empty($keyfield2) )
$result= preg_replace("'($keyfield2)'si", "\\1", $result)." ";
echo $result;
if (!empty($arr[8]))
echo " ". $arr[8]." ";
if (!empty($arr[10]))
echo " ". $arr[10]." ";
if ($arr[11]<>'')
{ echo "$arr[11] "; }
if ($arr[16]<>'')
{ echo "บทคัดย่อ";}
if($arr[3]=='' && $arr[17]<>'') echo " abstract";
if ($arr[18]<>'')
{
echo " [ฉบับเต็ม :";
$vsize=$arr[19]/1024;
echo"".ceil($vsize)."K]";
}
if($arr[3]=='' && $arr[20]<>'')
{
echo " [Fulltext :";
$vsize=$arr[21]/1024;
echo"".ceil($vsize)."K]";
}
echo " ";
}//end if thai bib
if(!empty($arr[3]))
{
// Display EngLish
$result=$arr[3];
if($choice=="0" && !empty($keyfield)) //Select author
$result= preg_replace("'($keyfield)'si", "\\1",$result)." ";
if($choice2=="0" && !empty($keyfield2) )
$result= preg_replace("'($keyfield2)'si", "\\1",$result)." ";
echo $result;
echo "$arr[5] ";
$result=$arr[7];
if($choice=="1" && !empty($keyfield)) //Select title
$result= preg_replace("'($keyfield)'si", "\\1", $result)." ";
if($choice2=="1" && !empty($keyfield2) )
$result= preg_replace("'($keyfield2)'si", "\\1", $result)." ";
echo $result;
if (!empty($arr[9]))
echo " ".$arr[9]." ";
if (!empty($arr[22]))
echo " ".$arr[22]." ";
if ($arr[23]<>'')
{
echo "$arr[23] ";
}
if ($arr[17]<>'')
{ echo " Abstract";}
if($arr[2]=='' && $arr[16]<>'') echo " บทคัดย่อ";
if ($arr[20]<>'')
{
echo " [Fulltext :";
$vsize=$arr[21]/1024;
echo"".ceil($vsize)."K]";
}
if (empty($arr[2]) && $arr[18]<>'')
{
echo " [ฉบับเต็ม :";
$vsize=$arr[19]/1024;
echo"".ceil($vsize)."K]";
}
}//end if arr(3)
if ($i==$row_count) break;
if($i==($page*$pagesize)-1) break;
echo " | ";
echo " ";
$i++;
} //End while tr
echo " ";
echo "";
if ( $totalpage >0) {
echo "Page no. ";
for ($i=1; $i <= $totalpage; $i++)
{
echo "";
echo "$i ";
echo "";
}
}
echo "
";
//echo "";
echo "";
} //end if loop
?>
|