 |
|
ดึงข้อมูลจากตารางฐานข้อมูล access ครับ
<html>
<body>
<form name="form" method="post" action="">
กรุณากรอกชื่อที่ต้องการค้นหา
<input type="text" name="search_name1" value="<?=$search_name;?>">
<input type="submit" name="Submit" value="Search">
</form>
<?
if(empty($search_name))
{
?><hr>
กรุณากรอกข้อมูลด้วยครับ
<?
}
else
{
$dsn_name = "DBweb";
$username ="";
$password ="";
$con = odbc_connect($dsn_name, $username, $password);
$sql = "SELECT * FROM STOCKON
WHERE CodeCut Like '%$search_name%'";
$execute= odbc_exec($con,$sql);
?>
<BODY background="images/1.jpg" LEFTMARGIN="0" TOPMARGIN="0" onLoad="document.frmlogin.username.focus();">
<TABLE WIDTH="100%" HEIGHT="65" BORDER="0" CELLSPACING="0">
<TR>
<TD WIDTH="41%" HEIGHT="60" BACKGROUND="images/backblue1.gif"><img src="images/com.jpg" width="500" height="50"></TD>
<TD WIDTH="7%" BACKGROUND="images/backblue2.gif"> </TD>
<TD WIDTH="52%" VALIGN="BOTTOM" BACKGROUND="images/backblue3.gif"> </TD>
</TR>
</TABLE
<marquee><font size="20" face="Tahoma" color="red"><u>ร า ย ง า น สิ น ค้ า ค ง เ ห ลื อ 2 0 0 8</u></font></marquee>
<table border="1" width="900" height = "10">
<tr>
<td width="130">
<font size="2" face="Verdana">
<div align="center"><B>รหัสสินค้า<B></div>
</font>
</td>
<td width="50">
<font size="2" face="Verdana">
<div align="center"><B>ชนิด<B></div>
</font>
</td>
<td width="50">
<font size="2" face="Verdana">
<div align="center"><B>สี<B></div>
</font>
</td>
<td width="50">
<font size="2" face="Verdana">
<div align="center"><B>ขนาด<B></div>
</font>
</td>
<td width="50">
<font size="2" face="Verdana">
<div align="center"><b>หนา<b></div>
</font>
</td>
<td width="50">
<font size="2" face="Verdana">
<div align="center"><B>เกรด<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>เข้า<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>เข้า/น.<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>ออก<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>ออก/น.<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>คงเหลือ<B></div>
</font>
</td>
<td width="75">
<font size="2" face="Verdana">
<div align="center"><B>คงเหลือ/น.<B></div>
</font>
</td>
</tr>
</body>
</table>
<?
$i=1;
while(odbc_fetch_row($execute,$i))
{
$CodeCut=odbc_result($execute,"CodeCut");
$Product=odbc_result($execute,"Product");
$PCOL=odbc_result($execute,"PCOL");
$CodeSize=odbc_result($execute,"CodeSize");
$PTHI=odbc_result($execute,"PTHI");
$PGRD=odbc_result($execute,"PGRD");
$INS=odbc_result($execute,"INS");
$INW=odbc_result($execute,"INW");
$OUTS=odbc_result($execute,"OUTS");
$OUTW=odbc_result($execute,"OUTW");
$BLS=odbc_result($execute,"BLS");
$BLW=odbc_result($execute,"BLW");
?>
<table border="1" width="900" height="20">
<body bgcolor="#CCFFFF" >
<tr>
<td width ="130">
<font size="2" face="tahoma" FONT COLOR=#0000FF>
<B><? echo "$CodeCut";?></B>
</tr>
</font>
</td>
<td width="50">
<div align="center">
<font size="2" face="Verdana" FONT COLOR=#CC0033>
<? echo "$Product";?>
</font>
</div>
</td>
<td width="50">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#CC0033>
<? echo "$PCOL";?>
</font>
</div>
</td>
<td width="50">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#CC0033>
<? echo "$CodeSize";?>
</div>
</td>
<td width="50">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#CC0033>
<? echo "$PTHI";?>
</font>
</div>
</td>
<td width="50" >
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#CC0033>
<? echo "$PGRD";?>
</font>
</div>
</td>
<td width="75" >
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#0000FF >
<? echo "$INS";?>
</font>
</div>
</td>
<td width="75">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#0000FF >
<? printf ("%.2f",$INW);?>
</font>
</div>
</td>
<td width="75">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#0000FF >
<? echo "$OUTS";?>
</font>
</div>
</td>
<td width="75" >
<div align="right">
<font size="2" face="Verdana"FONT COLOR=#0000FF >
<? printf ("%.2f",$OUTW);?>
</font>
</div>
</td>
<td width="75">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#0000FF >
<B><? echo "$BLS";?></B>
</font>
</div>
</td>
<td width="75">
<div align="right">
<font size="2" face="Verdana" FONT COLOR=#0000FF >
<B><? printf ("%.2f",$BLW);?></B>
</font>
</div>
</td>
</tr>
</table>
</BODY>
<?
$i++;
}
?>
<?
}
odbc_code
?>
</body>
</html>
พอกดค้นหาข้อมูลแล้วเหมือน คำสั่ง else ไม่ทำงาน รบกวนหน่อยครับ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
28 ก.พ. 2551 16:20:20 |
By :
ruschanon |
View :
1337 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
