 |
|
ผมสร้าง database ไว้2 table ดังนี้
Code
$sql[0] = "CREATE TABLE hsa25 (
id int(11) NOT NULL auto_increment,
cline varchar(5) NOT NULL default '',
carlender date NOT NULL,
Hour varchar(5) NOT NULL default '',
min varchar(5) NOT NULL default '',
cShift varchar(5) NOT NULL default '',
cMachine varchar(30) NOT NULL default '',
cNumber varchar(30) NOT NULL default '',
problem varchar(200) NOT NULL default '',
name varchar(30) NOT NULL default '',
cPosition varchar(15) NOT NULL default '',
cSection varchar(15) NOT NULL default '',
Hour1 varchar(5) NOT NULL default '',
min1 varchar(5) NOT NULL default '',
sum1 smallint,
cdowntime varchar(20) NOT NULL default '',
name1 varchar(30) NOT NULL default '',
cdate date NOT NULL default '',
Hour2 varchar(5) NOT NULL default '',
min2 varchar(5) NOT NULL default '',
cause varchar(200) NOT NULL default '',
action varchar(200) NOT NULL default '',
name2 varchar(30) NOT NULL default '',
name3 varchar(30) NOT NULL default '',
name4 varchar(30) NOT NULL default '',
PRIMARY KEY (id)) ";
// สร้างตาราง hsa3.5
Code
$sql[1] = "CREATE TABLE hsa35 (
id int(11) NOT NULL auto_increment,
cline varchar(5) NOT NULL default '',
carlender date NOT NULL,
Hour varchar(5) NOT NULL default '',
min varchar(5) NOT NULL default '',
cShift varchar(5) NOT NULL default '',
cMachine varchar(30) NOT NULL default '',
cNumber varchar(30) NOT NULL default '',
problem varchar(200) NOT NULL default '',
name varchar(30) NOT NULL default '',
cPosition varchar(15) NOT NULL default '',
cSection varchar(15) NOT NULL default '',
Hour1 varchar(5) NOT NULL default '',
min1 varchar(5) NOT NULL default '',
sum1 smallint,
cdowntime varchar(20) NOT NULL default '',
name1 varchar(30) NOT NULL default '',
cdate date NOT NULL default '',
Hour2 varchar(5) NOT NULL default '',
min2 varchar(5) NOT NULL default '',
cause varchar(200) NOT NULL default '',
action varchar(200) NOT NULL default '',
name2 varchar(30) NOT NULL default '',
name3 varchar(30) NOT NULL default '',
name4 varchar(30) NOT NULL default '',
PRIMARY KEY (id)) ";
ถ้าจะsearch 2 table มารวมกันจะต้องเขียนคำสั่งยังไงครับ
ผมเขียนแล้วแต่ไม่ได้ครับ
search.php
Code (PHP)
<html>
<head>
<title>Downtime</title>
</head>
<body>
<form name="frmSearch" method="get" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
<table width="599" border="1">
<tr>
<th>Keyword
<input name="txtKeyword" type="text" id="txtKeyword" value="<?php echo $_GET["txtKeyword"];?>">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<body bgcolor="#CECECE">
<font class="Big"><b>ผลการค้นหา คำว่า <?php echo $txtKeyword ; ?></b></font>
<br>
<br>
<?php
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("datadowntime");
$strSQL = "SELECT * FROM hsa25 inner join hsa35 on hsa25.id = hsa35.id WHERE (carlender LIKE '%".$_GET["txtKeyword"]."%' ) ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 2; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);
?>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">ID </div></th>
<th width="98"> <div align="center">Line </div></th>
<th width="198"> <div align="center">Shift </div></th>
<th width="97"> <div align="center">cuse </div></th>
<th width="59"> <div align="center">problem</div></th>
<th width="71"> <div align="center">sum </div></th>
</tr>
<?php
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><div align="center"><?php echo $objResult["id"];?></div></td>
<td><?php echo $objResult["cline"];?></td>
<td><?php echo $objResult["cShift"];?></td>
<td><div align="center"><?php echo $objResult["cuse"];?></div></td>
<td align="right"><?php echo $objResult["problem"];?></td>
<td align="right"><?php echo $objResult["sum1"];?></td>
</tr>
<?php
}
?>
</table>
<br>
Total <?php echo $Num_Rows;?> Record : <?php echo $Num_Pages;?> Page :
<?php
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
}
mysql_close($objConnect);
}
?>
</body>
</html>
รบกวนช่วยหน่อยครับ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-12-01 00:41:38 |
By :
naruto |
View :
4690 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
