include("phpmyfunction.php");
connectDB();
$select_label = array("All word", "Keyword","Topic", "Author", "Abstract", "Content");
$select_value = array("all", "keyword","topic", "author", "abstract", "full");
$command = $_GET['command'];
$vol = $_GET['vol'];
$sel_vol = $_GET['sel_vol'];
if ($command == "") {
?>
$row_vol_last = mysql_fetch_array($result_vol_last);
$vol_last = $row_vol_last['vol'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$vol_last' ORDER BY no DESC";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
?>
|
|
|
|
// include("phpmyfunction.php");
//connectDB();
$select_label = array("All word", "Keyword","Topic", "Author", "Abstract", "Content");
$select_value = array("all", "keyword","topic", "author", "abstract", "full");
}
if ($command == "vol") {
?>
//$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol' AND no='$selno'";
$selvol = $_GET['selvol'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol'";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$sql_vol_menu = "SELECT DISTINCT `vol` FROM `journal2_vol` ORDER BY vol DESC";
$result_vol_menu = mysql_query($sql_vol_menu);
?>
|
|
|
|
$sql_vol_last = "SELECT DISTINCT `vol` FROM `journal2_vol` ORDER BY vol DESC";
$result_vol_last = mysql_query($sql_vol_last);
$row_vol_last = mysql_fetch_array($result_vol_last);
$vol_last = $row_vol_last['vol'];
$vol_last = $_GET['selvol'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$vol_last' ORDER BY no DESC";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
?>
print $j_name?>
Volume print $vol?> No. print $no?> print $m_start." - ".$m_end." ".$year?>
|
for ($i=0; $i".$He_ARR[$i]."";
//print "".$header." ";
// $vol = $_GET['vol'];
// $no = $_GET['no'];
// $header = $_GET['header'];
$sql_topic = "SELECT * FROM `journal2_topic` WHERE vol='$vol' AND no='$no' AND header='$header' ORDER BY page_start";
$result_topic = mysql_query($sql_topic);
while($row_topic = mysql_fetch_array($result_topic)) {
$ids_topic = $row_topic['ids'];
$pagestart = $row_topic['page_start'];
$topic = $row_topic['topic'];
$author = str_replace("\n", ' ', $row_topic['author']);
$pdf = $row_topic['pdf'];
?>
if ($header == "Editorial Note") {
print "";
print "".$author."";
}else{
?>
print $topic?>
}?>
|
print $pagestart?>
|
if ($header != "Editorial Note") { print "$author";}?>
if ($pdf != "") {
print " [ PDF ]";
}
}
print "
";
}
?>
|
} else if ($command == "vol") {
?>
$sql_vol_menu = "SELECT DISTINCT `vol` FROM `journal2_vol` ORDER BY vol DESC";
$result_vol_menu = mysql_query($sql_vol_menu);
?>
$selvol = $_GET['selvol'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol' ORDER BY no";
$result_vol = mysql_query($sql_vol);
while($row_vol = mysql_fetch_array($result_vol)) {
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
?>
print $j_name?>
Volume
print $vol?>
No.
print $no?>
print $m_start." - ".$m_end." ".$year?> |
}?>
} else if ($command == "topic") {
?>
$sql_vol_menu = "SELECT DISTINCT `vol` FROM `journal2_vol` ORDER BY vol DESC";
$result_vol_menu = mysql_query($sql_vol_menu);
?>
|
|
|
|
$selvol = $_GET['selvol'];
$selno = $_GET['selno'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol' ORDER BY no DESC";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
?>
print $j_name?>
Volume print $selvol?> No. print $no?> print $m_start." - ".$m_end." ".$year?>
|
for ($i=0; $i".$He_ARR[$i]."";
//print "".$header." ";
$sql_topic = "SELECT * FROM `journal2_topic` WHERE vol='".$_GET['selvol']."' AND no='".$_GET['selno']."' AND header='".$header."' ORDER BY page_start";
$result_topic = mysql_query($sql_topic);
while($row_topic = mysql_fetch_array($result_topic)) {
$ids_topic = $row_topic['ids'];
$pagestart = $row_topic['page_start'];
$topic = $row_topic['topic'];
$author = str_replace("\n", ' ', $row_topic['author']);
$pdf = $row_topic['pdf'];
?>
if ($header == "Editorial Note") {
print "";
print "".$author."";
}else{
?>
print $topic?>
}?>
|
print $pagestart?>
|
if ($header != "Editorial Note") { print " $author";}?>
if ($pdf != "") {
print " [ PDF ]";
}
}
print "
";
}
?>
|
$command = $_GET['command'];
$selvol = $_GET['selvol'];
$selno = $_GET['selno'];
} else if ($command == "preview") {
?>
$selvol = $_GET['selvol'];
$selno = $_GET['selno'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol' AND no='$selno'";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
$sql_topic = "SELECT * FROM `journal2_topic` WHERE ids='$selids'";
$result_topic = mysql_query($sql_topic);
$row_topic = mysql_fetch_array($result_topic);
$topic = $row_topic['topic'];
$page_start = $row_topic['page_start'];
$author = str_replace("\n", " \n", $row_topic['author']);
$abstract = str_replace("\n", " \n", $row_topic['abstract']);
$full = str_replace("\n", " \n", $row_topic['full']);
$referrence = str_replace("\n", " \n", $row_topic['referrence']);
//$abstract = str_replace(" ", " ", $abstract);
//$full = str_replace(" ", " ", $full);
//$referrence = str_replace(" ", " ", $referrence);
$keyword = $row_topic['keyword'];
$pdf = $row_topic['pdf'];
$doc = $row_topic['doc'];
$pic = $row_topic['pic'];
$pdf_size = $row_topic['pdf_size'];
$doc_size = $row_topic['doc_size'];
?>
print $topic?>
print $author?>
Abstract
print $abstract?>
Keyword : print $keyword?>
|
if ($full != "") {?>
echo $full?>
Referrence :
print $referrence?> |
}?>
if ($pdf != '' || $doc != "") {?>
Download Full
Paper
|
print $pdf?>
[ printf("%.2f",$pdf_size/1024)?>
Kb] |
}?>
} else if ($command == "note") {
?>
$selvol = $_GET['selvol'];
$selno = $_GET['selno'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$selvol' AND no='$selno'";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
$issn = $row_vol['issn'];
$sql_topic = "SELECT * FROM `journal2_topic` WHERE vol='$selvol' AND no='$no' AND header='Editorial Note'";
$result_topic = mysql_query($sql_topic);
$row_topic = mysql_fetch_array($result_topic);
$page_start = $row_topic['page_start'];
$author = str_replace("\n", " \n", $row_topic['author']);
$full = str_replace("\n", " \n", $row_topic['full']);
//$full = str_replace(" ", " ", $full);
?>
Editorial Note
print $author?>
} else if ($command == "search") {
?>
$sql_vol_menu = "SELECT DISTINCT `vol` FROM `journal2_vol` ORDER BY vol DESC";
$result_vol_menu = mysql_query($sql_vol_menu);
?>
Volume
$menu_vol = $_GET['menu_vol'];
$selvol = $_GET['selvol'];
while($row_vol_menu = mysql_fetch_array($result_vol_menu)) {
$menu_vol = $row_vol_menu['vol'];
print "[ $menu_vol ]";
}
?>
|
if($nat != 1) {?>
}else{ ?>
if($from=='all'){
$sql_topic = "SELECT * FROM `journal2_topic` WHERE topic LIKE '%$key%' OR author LIKE '%$key%' OR abstract LIKE '%$key%' OR `full` LIKE '%$key%'";
}else{
$sql_topic = "SELECT * FROM `journal2_topic` WHERE `$from` LIKE '%$key%'";
}
$result_topic = mysql_query($sql_topic);
$totalrecord = mysql_num_rows($result_topic);
$pagesize = 10;
$totalpage = (int) ($totalrecord / $pagesize);
if (($totalrecord % $pagesize) != 0) {
$totalpage += 1;
}
if (isset($pageid)) {
$start = $pagesize * ($pageid - 1);
$last = $start + $pagesize - 1;
}else {
$pageid = 1;
$start = 0;
$last = $pagesize - 1;
}
?>
Page :
if($totalrecord != 0) {
for ($i=1; $i<=$totalpage; $i++) {
if ($i == $pageid) {
print "$i" . " ";
}else {
print " [ $i ] "; ///?Volume????????????????
}
}
}else{
print "No Word $key In Database";
}
?>
|
Results |
if($from=='all'){
$sql_topic = "SELECT * FROM `journal2_topic` WHERE topic LIKE '%$key%' || author LIKE '%$key%' || abstract LIKE '%$key%' || full LIKE '%$key%' ORDER BY vol DESC LIMIT $start, $pagesize;";
}else{
$sql_topic = "SELECT * FROM `journal2_topic` WHERE $from LIKE '%$key%' ORDER BY vol DESC LIMIT $start, $pagesize;";
}
$result_topic = mysql_query($sql_topic);
while($row_topic = mysql_fetch_array($result_topic)) {
$ids_topic = $row_topic['ids'];
$vol_topic = $row_topic['vol'];
$no_topic = $row_topic['no'];
$topic = $row_topic['topic'];
$pdf = $row_topic['pdf'];
$pagestart = $row_topic['page_start'];
$author = str_replace("\n", ' ', $row_topic['author']);
?>
$vol_topic = $_GET['vol_topic'];
$no_topic = $_GET['no_topic'];
$sql_vol = "SELECT * FROM `journal2_vol` WHERE vol='$vol_topic' AND no='$no_topic'";
$result_vol = mysql_query($sql_vol);
$row_vol = mysql_fetch_array($result_vol);
$j_name = $row_vol['j_name'];
$vol = $row_vol['vol'];
$no = $row_vol['no'];
$m_start = $row_vol['m_start'];
$m_end = $row_vol['m_end'];
$year = $row_vol['year'];
?>
Volume print $vol?> No. print $no?> print $m_start." - ".$m_end." ".$year?>
print $topic?> |
print $pagestart?> |
print $author?>
if ($pdf != "") {
print "[ PDF ]";
}
?>
|
}?>
}?>
}
closeDB();
?>
//include("footer.php");
?>
|
|
|
|
|
|
|
|
|
|
|
include("foot.php");?> |
|
|