Bersama kita perkemaskan forum ini sementara forum asal dalam pemulihan.
Home
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>CONFERENCE SLOT</title>
<meta name="Microsoft Theme" content="none, default">
</head>
<body background="main_bg.gif">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="797" height="543">
<!-- MSTableType="layout" -->
<tr>
<td valign="top" colspan="2" height="74">
<!-- MSCellType="ContentHead" -->
<img border="0" src="Uum.jpg" width="794" height="201"></td>
</tr>
<tr>
<td msopnltype="NavBody" rowspan="2" width="137">
<!-- MSCellType="NavBody" -->
</td>
<td valign="top" height="420" align="center">
<!-- MSCellType="ContentBody" -->
<p align="center"> </p>
<p align="center"> </p>
<p align="center"><b><font size="5">CONFERENCE SLOT</font></b></p>
</td>
</tr>
<tr>
<?php
$db = mysql_connect("localhost","","");
if (!mysql_select_db('seminar'))
die('Error selecting Database!');
$result = mysql_query("SELECT * FROM student");
echo "<table class=mediumtxt border=1 align=center bgcolor=#9FABFD background=FROSBLLT_GIF.jpg>";
echo "<tr><td><b>Code</b></td><td><b>Date</b></td>
<td ><b>Time</b></td>
<td><b>Room</b></td>
<td><b>Conference Title</b></td>
<td><b>Presenter Name</b></td></tr>";
while ($myrow = mysql_fetch_array($result)) {
echo "<tr><td>";
echo $myrow["code"];
echo "</td><td>";
echo $myrow["date"];
echo "</td><td>";
echo $myrow["time"];
echo "</td><td>";
echo $myrow["room"];
echo "</td><td>";
echo $myrow["title"];
echo "</td><td>";
echo $myrow["name"];
echo "</td></tr>";
}
echo "</table>";</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
?></body>
<td valign="top" height="49" width="660">
<!-- MSCellType="ContentFoot" -->
</td>
</html>
<?php
$room=$_POST[room];
$result = mysql_query("SELECT * FROM student where room='$room'");
?>
Kena tulis statement OR atau AND selepas WHERE statement (Cth mcm jebat punya code tu)syira86 wrote:
thnx en.jebat reply tp cmne nk wat utk 3 carian data???
$query=mysql_query("SELECT <columnname1>,<columnname2>,<columnname3> from <tablename> where <columnname1>='<sumting>' OR <columnname2>='<sumting>' OR <columnname3>='<sumting>'");
while($row=mysql_fetch_assoc($query))
{
/*Arahan output 3 column yg terlibat (bleh pilih salah satu atau nk papar kesemuanya)*/
echo $row['<column1>'];
echo $row['<column2>'];
echo $row['<column3>'];
}
"<columnname1> LIKE '%<sumting>' OR '%<sumting>%' OR '<sumting>%'"
<?php
// ** MySQL settings ** //
define('DB_NAME', 'db_myProject');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_HOST', 'localhost');
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>
// ** PHP search Date ** //
<?php
$Calendar = $_POST['Calendar1'];
$Select1= $_POST['Select1'];
//Convert Calendar "/" kepada "-"
$format = '%Y-%m-%d';
$Calendar =strtotime($Calendar);
$Calendar = strftime($format, $Calendar );
//Select1 = Listbox form submit. sebagai contoh dalam listbox ada 12am - 12pm dan 12pm - 12am
if ($Select1 =='Morning')
{
$Morning1 = "00:00:00";
$Morning2 = "12:00:00";
}
else
{
$Morning1 = "12:00:01";
$Morning2 = "23:00:59";
}
mysql_select_db("Room", $con);
$result = mysql_query("SELECT * FROM Room where Date2 = '".$Calendar."' and Time2 BETWEEN '".$Morning1."' AND '".$Morning2."' ");
echo "<table border=1>
<tr>
<th>Room</th>
<th>Date</th>
<th>Time</th>
<th></th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Room'] . "</td>";
echo "<td>" . $row['Date2'] . "</td>";
echo "<td>" . $row['Time2'] . "</td>";
echo "<td><a href=Delete.php?Name1=".$row['Room'].">Delete</a></td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
}
?>
while($myrow = mysql_fetch_assoc($maklumat)) {
<?php
$room=$_POST[room];
$date=$_POST[date];
$time=$_POST[time];
$db = mysql_connect("localhost","","");
if (!mysql_select_db('seminar'))
die('Error selecting Database!');
$maklumat=mysql_query("SELECT code,date,time,room,title,name from student where date='$date' AND time='$time' AND room='$room'");
$row=mysql_fetch_assoc($maklumat);
echo
"<table class=mediumtxt width=771 align=center border=1>";
echo "<tr><td><b>PaperCode</b></td><td><b>Date</b></td>
<td ><b>Time</b></td>
<td><b>Room</b></td>
<td><b>Conference Title</b></td>
<td><b>Presenter Name</b></td></tr>";
while ($myrow = mysql_fetch_assoc($maklumat)) {
echo "<tr><td>";
echo $myrow["code"];
echo "</td><td>";
echo $myrow["date"];
echo "</td><td>";
echo $myrow["time"];
echo "</td><td>";
echo $myrow["room"];
echo "</td><td>";
echo $myrow["title"];
echo "</td><td>";
echo $myrow["name"];
echo "</td></tr>";
}
echo "</table></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
";
?>
<?php
echo"<form method='POST' action='conference_slot2.php'>";
echo"<select name='date'>
<option>23/03/2009</option>
<option>24/03/2009</option>
<option>25/03/2009</option>
</select>
<select name='time'>
<option>9-11am</option>
<option>11-1.3</option>
<option>2-5.30</option>
</select>
<select name='room'>
<option>dkg4/1</option>
<option>dkg4/2</option>
<option>dkg4/3</option>
</select>
<input type='submit' value='Search' name='B1'></form>";
?>
