<?php
session_start();
//Check the logo status
//if(!isset($_SESSION['userid'])){
//header("Location:login.php");
//exit();
//}
//$userid = $_SESSION['userid'];
//$username = $_SESSION['username'];
//DB connection
include('conn.php');
require("head.php");
$pn=$_GET["partnumber"];echo "pn".$pn;
?>
<table width="100%">
<tr><td class="frame1"><b>Accredited Inventory -- Search Result</b></td></tr>
<tr><td width="80%" align="center">
<table align="center">
<?php
$pagesize=2;
$page=$_GET["page"];
$a="select count(*) as count from partinventory where partnumber like '%".$pn."%'";
$b=mysql_query($a);
$c=mysql_fetch_array($b);
$count=$c['count']; echo $count;
If(empty($_GET["page"])||$_GET["page"])
{ $page=0;
}else {
$page=$_GET["page"];
}
If($page>=ceil($count/$pagesize)) {
$page=ceil($count/$pagesize)-1;
}
$d="select * from partinventory where partnumber like '%".$pn."%' limit ".$page*$pagesize.$pagesize;
$e=mysql_query($d);
while($rs=mysql_fetch_array($e)) {
echo "<tr><td>".$rs['partnumber']."</td></tr>";
}
echo "page=".$page;
//翻页
If($page==0) {
If($count<=$pagesize) {
echo "First Page|Last Page";
}else{
Echo "First Page|<a href=".$_SERVER['PHP_SELF']."?page=".($page+1).">Next Page</a>";
}
}else if($page< ceil($count/$pagesize)-1) {
echo"<a href=".$_SERVER['PHP_SELF']."?page=".($page-1).">Previous Page<a>|<a href=".$_SERVER['PHP_SELF']."?page=".($page+1).">Next Page</a>";
}else if($page==ceil($count/$pagesize)-1) {
echo "<a href=".$_SERVER['PHP_SELF']."?page=".($page-1).">Previous Page<a>|Last Page";
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close($conn);
require("bottom.html");
?>
session_start();
//Check the logo status
//if(!isset($_SESSION['userid'])){
//header("Location:login.php");
//exit();
//}
//$userid = $_SESSION['userid'];
//$username = $_SESSION['username'];
//DB connection
include('conn.php');
require("head.php");
$pn=$_GET["partnumber"];echo "pn".$pn;
?>
<table width="100%">
<tr><td class="frame1"><b>Accredited Inventory -- Search Result</b></td></tr>
<tr><td width="80%" align="center">
<table align="center">
<?php
$pagesize=2;
$page=$_GET["page"];
$a="select count(*) as count from partinventory where partnumber like '%".$pn."%'";
$b=mysql_query($a);
$c=mysql_fetch_array($b);
$count=$c['count']; echo $count;
If(empty($_GET["page"])||$_GET["page"])
{ $page=0;
}else {
$page=$_GET["page"];
}
If($page>=ceil($count/$pagesize)) {
$page=ceil($count/$pagesize)-1;
}
$d="select * from partinventory where partnumber like '%".$pn."%' limit ".$page*$pagesize.$pagesize;
$e=mysql_query($d);
while($rs=mysql_fetch_array($e)) {
echo "<tr><td>".$rs['partnumber']."</td></tr>";
}
echo "page=".$page;
//翻页
If($page==0) {
If($count<=$pagesize) {
echo "First Page|Last Page";
}else{
Echo "First Page|<a href=".$_SERVER['PHP_SELF']."?page=".($page+1).">Next Page</a>";
}
}else if($page< ceil($count/$pagesize)-1) {
echo"<a href=".$_SERVER['PHP_SELF']."?page=".($page-1).">Previous Page<a>|<a href=".$_SERVER['PHP_SELF']."?page=".($page+1).">Next Page</a>";
}else if($page==ceil($count/$pagesize)-1) {
echo "<a href=".$_SERVER['PHP_SELF']."?page=".($page-1).">Previous Page<a>|Last Page";
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close($conn);
require("bottom.html");
?>