Code: Select all
<?php
<html>
<head><title></title></head>
<body>
<?php
if (isset($_POST['Search'])) {
http://localhost/search.php
}
<form method="post" action="search.php">
<table border="0" width="75%">
<td width="15%">
<p align="right">Call No:</p>
</td>
<td width="57%"><input type="text" name="call_no" size="20"></td>
</td>
<td width="57%">
<input type="submit" value="Search" name="Search">
</body>
</html>
?>The other file that i have created to process the query is search.php which is looks like:
Code: Select all
<?php
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("library",$db) or die(mysql_error());
$sql = "Select FROM book WHERE call_no=('{$_POST['call_no']}')";
$result = mysql_query($sql);
?>
<table border=2>
<tr>
<td>call_no</td>
<td>title</td>
<td>author1</td>
<td>author2</td>
<td>publisher</td>
<td>isbn</td>
<td>price</td>
<td>no_of_page</td>
<td>edition</td>
<td>category</td>
</tr>
<?php
while ($myrow = mysql_fetch_row($result))
{
echo '<tr>';
for($i=0; $i<10; $i++)
{
echo '<td>'.$myrow[$i].'</td>';
}
echo '</tr>';
}
?>
</table>
?>Can i call a php file like this from the if block?:
Code: Select all
<?php
http://localhost/search.php
?>