searching record given the form

<?php
session_start();
error_reporting(E_ERROR && ~E_NOTICE && ~E_WARNING);
ob_start();
$link = mysql_connect('localhost', 'root', 'test');
if (!$link)
{
die('Could not connect: ' . mysql_error());
}
if (isset($_POST["Submit"]))
{
$deptfrom= "'".$_POST['depfrom']."'";
$arrfrom = "'".$_POST['arrfrom']."'";
$dept = "'".$_POST['dept']."'";
$depto = "'".$_POST['depto']."'";
$arrto = "'".$_POST['arrto']."'";
$grant = "'".$_POST['grant']."'";
$depdate ="'".$_POST['depdate']."'";
$arrdate ="'".$_POST['arrdate']."'";
trim($depdate);
trim(arrdate);
if(!$deptfrom || !$arrfrom || !$dept || !$depto || !$arrto || !$grant || !$depdate || !$arrdate)
{
echo "you have some empty fields";
}

switch($_POST["Submit"])
{
case 'Submit':
{
//$str_query = "INSERT INTO book(depfrom,arrfrom,dept,depto,arrto,grant,depdat e,arrdate) VALUES($depfrom,$arrfrom,$dept,$depto,$arrto,$gran t,$depdate,$arrdate)";
$str_query = "INSERT INTO book(depfrom,arrfrom,dept,depto,arrto,granter,depd ate,arrdate) VALUES($deptfrom,$arrfrom,$dept,$depto,$arrto,$gra nt,$depdate,$arrdate)";
$mysql_access = mysql_pconnect("localhost", "root", "test");
if (!$mysql_access)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("flight");

break;
}

}

}
$result = mysql_query($str_query, $mysql_access);
$numof_rows=mysql_num_rows($result);
if($numof_rows==1)
if($_POST['Submit']=="search")

//search id
?>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Flight Booking System</title>
<style>
a, A:link, a:visited, a:active
{color: #0000aa; text-decoration: none; font-family: Tahoma, Verdana; font-size: 12px}
A:hover
{color: #ff0000; text-decoration: none; font-family: Tahoma, Verdana; font-size: 12px}
p, tr, td, ul, li
{color: #000000; font-family: Tahoma, Verdana; font-size: 11px}
th
{background: #DBEAF5; color: #000000;}
.header1, h1
{color: #ffffff; background: #4682B4; font-weight: bold; font-family: Tahoma, Verdana; font-size: 14px; margin: 0px; padding-left: 2px; height: 21px}
.header2, h2
{color: #000000; background: #DBEAF5; font-weight: bold; font-family: Tahoma, Verdana; font-size: 12px;}
.intd
{color: #000000; font-family: Tahoma, Verdana; font-size: 11px; padding-left: 15px;}
.wcell
{background: #FFFFFF; vertical-align: top}
.ctrl
{font-family: Tahoma, Verdana, sans-serif; font-size: 12px; width: 100%;}
.btnform
{border: 0px; font-family: tahoma, verdana; font-size: 12px; background-color: #DBEAF5; width: 100%; height:18px; text-align: center; cursor: hand;}
.btn
{background-color: #DBEAF5; padding: 0px;}
textarea, select,input
{font: 9px Verdana, arial, helvetica, sans-serif; background-color: #DBEAF5;}

/* classes for validator */
.tfvHighlight
{font-weight: bold; color: red;}
.tfvNormal
{font-weight: normal; color: black;}
.copysmall { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #3B3B3B; font-size: 12px; margin-top:3px; margin-bottom:11px; margin-left:0px; margin-right:0px }
.copy { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #3B3B3B; font-size: 13px; margin-top:3px; margin-bottom:11px; margin-left:0px; margin-right:0px }
.copymed { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #3B3B3B; font-size: 14px; margin-top:3px; margin-bottom:11px; margin-left:0px; margin-right:0px }
.copylarge { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #3B3B3B; font-size: 15px; margin-top:3px; margin-bottom:11px; margin-left:0px; margin-right:0px }
.copymedred { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #FF0000; font-size: 14px; margin-top:3px; margin-bottom:11px; margin-left:0px; margin-right:0px }
.copyheader { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #2778CB; font-size: 14px; margin-top:3px; margin-bottom:0px; margin-left:0px; margin-right:0px }
.copyheaderwhite { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 14px; margin-top:3px; margin-bottom:0px; margin-left:0px; margin-right:0px }
.header7, h7 { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #2778CB; font-size: 15px; font-weight: bold }
.copysmalltitle { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #2778CB; font-size: 15px; font-weight: bold }
.copysubtitle { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #2778CB; font-size: 15px }
.copyfooter { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #000000; font-size: 13px }
.copydownload { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #3B3B3B; font-size: 13px }

p { font-family: Trebuchet MS, Verdana, Arial, Helvetica, sans-serif; color: #2778CB; font-size: 15px; font-weight: bold }
p.topmarg { margin-top:12px; margin-bottom:8px; }
p.nobot { margin-top:2px; margin-bottom:0px; }
p.topmargnobot { margin-top:12px; margin-bottom:0px; }
p.nav { color:#FFFFFF; text-align:center; margin-top:8px; margin-bottom:12px; margin-left:3px; margin-right:3px; }
p.foot { font-size:9px; margin-top:3px; margin-bottom:3px; margin-left:3px; margin-right:3px; }

a { color: #003366; text-decoration: none }
a:hover { text-decoration: underline }
a:visited { color: #446185; text-decoration: none }
a:visited:hover { text-decoration: underline }

.copywhite { font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 12px }
.copywhiteB { font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 12px; font-weight: bold }

/*More Information Link Style */
.copy11 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px }

/* Section Headers Style */
.blueheader { font-family: Verdana, Arial, Helvetica, sans-serif; color: #446185; font-size: 13px; font-weight: bold }
.whiteheader { font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 13px; font-weight: bold }

.topics { font-family: Verdana, Arial, Helvetica, sans-serif; color: #CCCCCC; font-size: 11px }
.topicsB { font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 11px; font-weight: bold }
.topicsH { font-family: Verdana, Arial, Helvetica, sans-serif; color: #FFFFFF; font-size: 11px}

h2 { font-size:13px; color:#2778CB; margin-left:0px; margin-right:0px; margin-top:3px; margin-bottom:0px; }
.listitem {
line-height: 15px;
font-size: 11px;
font-family: Verdana, Tahoma, Arial, Helvetica;
font-weight: normal;
color: #262626;
margin-top:4px;
margin-bottom:0px;
margin-left:0px;
margin-right:0px
}

.subtitle_body{
background-image: url(images/subtitle_body.gif);
background-repeat: repeat-x;
color: #035AA4;
font-size: 13px;
font-weight: bold;
}

.subtitle_cap{
height: 25px;
width: 12px;
background : url(images/subtitle_cap.gif);
}
.style6 {font-size: 12px}
</style>
</head>

<body>
<fieldset>
<a href="flight.php"> Home </a> | <a href=grants.php> Add Grant </a> | Log Out | <a href="List.php">List</a>|
</fieldset><br><script language="JavaScript" src="validator.js"></script>

<script language="JavaScript" src="calendar1.js"></script>

<form action="flight.php" method="POST" name="flight" enctype="multipart/form-data" id="form_uploader" onsubmit="return v.exec()">
<table cellpadding="0" cellspacing="0" border="0" width="80%" align="center">
<tr>
<td bgcolor="#4682B4" width="10"><img src="img/pixel.gif" width="10" height="1" border="0"></td>
<td class="header1" nowrap> Flight Booking </td>
<td><img src="img/formtab_r.gif" width="10" height="21" border="0"></td>
<td background="img/line_t.gif" width="100%"> <img src="img/pixel.gif" width="10" height="1" border="0"></td>
</tr>
<tr>
<td background="img/line_l.gif"><img src="img/pixel.gif" border="0"></td>
<td colspan="3">
<img src="img/pixel.gif" width="1" height="10" border="0"><br>
<div align="center"
id="Error_Departments" style="display: block;"></div>
<table cellpadding="0" cellspacing="0" border="0" width="100%" bordercolor='#111111'><tr><td bgcolor="#DBEAF5">
<table cellspacing="1" cellpadding="3" border="0" width="100%">
<tr bgcolor="#ffffff">

<td colspan="11" nowrap="nowrap" id="t_pvisit"><div align="right"></div></td>
</tr>
<tr bgcolor="#ffffff">
<td width="94" nowrap="nowrap" id="t_vtitle"><div align="right">Departure From</div></td>
<td width="142" valign=top><input name="depfrom" value = "<?php print($row->depfrom);?>" type="text" class="ctrl" id="depfrom" size="20" /></td>
<td width="27" valign=top> <div align="right">To </div></td>
<td width="134" valign=top><input name="depto" value = "<?php print($row->depto);?>" type="text" class="ctrl" id="depto" size="20" /></td>

<td width="86" valign=top><div align="right">Departure Date/Time</div></td>
<td width="124"><input name="depdate"value = "<?php print($row->depdate);?>" type="text" class="ctrl" id="depdate" /></td>
<td width="19"><a href="javascript:cal1.popup();"><img src="img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"/></a></td>
</tr>
<tr bgcolor="#ffffff">
<td nowrap="nowrap" id="t_vtitle"><div align="right">Arrival From </div></td>
<td valign=top><input name="arrfrom" value = "<?php print($row->arrfrom);?>" type="text" class="ctrl" id="arrfrom" size="20" /></td>
<td valign=top><div align="right">To</div></td>

<td valign=top><input name="arrto" value = "<?php print($row->arrto);?>" type="text" class="ctrl" id="arrto" size="20" /></td>
<td valign=top><div align="right">Arrival Date/Time</div></td>
<td><input name="arrdate"value = "<?php print($row->arrdate);?>" type="text" class="ctrl" id="arrdate" /></td>
<td><a href="javascript:cal2.popup();"><img src="img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"/></a></td>
</tr>
<tr bgcolor="#ffffff">
<td nowrap="nowrap" id="t_dfrom"><div align="right">Cost Center </div></td>
<td valign=top><select name="dept" class="ctrl" >

<option value="">-- select --
<option value="54">ABD
<option value="36">ADMIN-CGMRC
<option value=27 <?php if($row->dept=="ADMIN-SA") echo "selected";?> >ADMIN-SA<option value=13 <?php if($row->dept=="ADMINISTRATION") echo "selected";?> >ADMINISTRATION<option value=24 <?php if($row->dept=="AED-CPT") echo "selected";?> >AED-CPT<option value=29 <?php if($row->dept=="ASF") echo "selected";?> >ASF<option value=59 <?php if($row->dept=="ASSESMENT") echo "selected";?> >ASSESSMENT<option value=61 <?php if($row->dept=="BUF") echo "selected";?> >BUF<option value=50 <?php if($row->dept=="CDA") echo "selected";?> >CDA<option value=51 <?php if($row->dept=="CDA-PINGILIKANI") echo "selected";?> >CDA-PINGILIKANI<option value=53 <?php if($row->dept=="CLINICAL-KEMRI") echo "selected";?> >CLINICAL-KEMRI<option value=12 <?php if($row->dept=="CLINICAL-WDI") echo "selected";?>>CLINICAL-WD1<option value=32 <?php if($row->dept=="CNF") echo "selected";?> >CNF<option value=47 <?php if($row->dept=="CTL-CHEMISTRY") echo "selected";?> >CTL-CHEMISTRY<option value=40 <?php if($row->dept=="CTL-haematology") echo "selected";?> >CTL-haematology<option value=58 <?php if($row->dept=="DSS") echo "selected";?> >DSS<option value=11 <?php if($row->dept=="ENTOMOLOGY") echo "selected";?> >ENTOMOLOGY<option value=31 <?php if($row->dept=="FOF") echo "selected";?> >FOF<option value=60 <?php if($row->dept=="GARAGE") echo "selected";?> >GARAGE<option value=46 <?php if($row->dept=="HELMINTH STUDY") echo "selected";?> >HELMINTH STUDY<option value=49 <?php if($row->dept=="IAVI LABS-MTWAPA") echo "selected";?> >IAVI LABS-MTWAPA<option value=17 <?php if($row->dept=="IAVI-CHC") echo "selected";?> >IAVI-CHC<option value=42 <?php if($row->dept=="IAVI-LABS") echo "selected";?> >IAVI-LABS<option value=23 <?php if($row->dept=="ICIPE") echo "selected";?> >ICIPE<option value=6 <?php if($row->dept=="ICT") echo "selected";?> >ICT<option value=43 <?php if($row->dept=="IMM-LUCY") echo "selected";?> >IMM-LUCY<option value=44 <?php if($row->dept=="IMMUNOLOGY") echo "selected";?> >IMMUNOLOGY<option value=25 <?php if($row->dept=="JBKF") echo "selected";?> >JBKF<option value=18 <?php if($row->dept=="JNF") echo "selected";?> >JNF<option value=34 <?php if($row->dept=="JNF") echo "selected";?> >JNF<option value=55 <?php if($row->dept=="KDH-admin") echo "selected";?> >KDH-admin<option value=56 <?php if($row->dept=="KDH-OPD") echo "selected";?> >KDH-OPD<option value=57 <?php if($row->dept=="KDH-WARDS") echo "selected";?> >KDH-WARDS<option value=37 <?php if($row->dept=="KMF") echo "selected";?> >KMF<option value=10 <?php if($row->dept=="LABS") echo "selected";?> >LABS<option value=38 <?php if($row->dept=="MICRO-LAB") echo "selected";?> >MICRO-LAB<option value=33 <?php if($row->dept=="MMF") echo "selected";?> >MMF<option value=21 <?php if($row->dept=="MVI") echo "selected";?> >MVI<option value=28 <?php if($row->dept=="OHF") echo "selected";?> >OHF<option value=26 <?php if($row->dept=="PBF") echo "selected";?> >PBF<option value=45 <?php if($row->dept=="PBJ-F") echo "selected";?> >PBJ-F<option value=41 <?php if($row->dept=="RSV-LAB") echo "selected";?> >RSV-LAB<option value=52 <?php if($row->dept=="RTSS") echo "selected";?> >RTSS<option value=16 <?php if($row->dept=="SBR") echo "selected";?> >SBR<option value=20 <?php if($row->dept=="SMF2") echo "selected";?> >SMF2<option value=39 <?php if($row->dept=="TOP LAB") echo "selected";?> >TOP LAB<option value=35 <?php if($row->dept=="TRAINING") echo "selected";?> >TRAINING<option value=19 <?php if($row->dept=="twill-LABS") echo "selected";?> >twill-LABS<option value=48 <?php if($row->dept=="Twill-MalariaGen") echo "selected";?> >Twill-MalariaGen
</select></td>

<td valign=top id="t_dateto"><div align="right">Grant</div></td>
<td valign=top><select name="grant" class="ctrl" >
<option value="">-- select --
<option value="ASF">ASF
<option value="KMF">KMF
<option value="OXMAL">OXMAL
</select></td>
<td valign=top> </td>
<td colspan="2"> </td>
</tr>

<tr bgcolor="#ffffff">
<td id="t_paccom"> </td>
<td colspan="4" bgcolor="#ffffff"><input type="hidden" name="action" value=add />
<input type="hidden" name="flightid" />
</td><td colspan="2">
<div align="left"> <input name="form_submit" type="hidden" id="form_submit" value="form_uploader"> </div></td></tr>
</table></td>
</tr></table>

<img src="img/pixel.gif" width="1" height="10" border="0"><br>
</td>
<td background="img/line_r.gif"><img src="img/pixel.gif" border="0"></td>
</tr>
<tr>
<td width="10"><img src="img/formtab_b.gif" width="10" height="20" border="0"></td>
<td bgcolor="#4682B4" colspan="4" align="right">
<table cellpadding="0" cellspacing="0" border="0">
<tr>

<td class="btn" width="100"><input type="reset" name="Reset" value="Reset" class="btnform"></td>
<td width="1"><img src="img/pixel.gif" width="1" height="18" border="0"></td>
<td class="btn" width="100"><input type="submit" name="Submit" value="Submit" class="btnform"></td>
<td width="1"><img src="img/pixel.gif" width="1" height="18" border="0"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<p></p><p></p>

<?php
echo "<div align=center>";
if(isset($_POST['Submit']))
{
mysql_pconnect("localhost", "root", "test");
mysql_select_db("flight");
$result = mysql_query("select * from book");
$num_rows=mysql_num_rows($result);

echo "<table border=1 rules=all width=99% cellspacing=1 cellpadding=2 bordercolor=#663333><tr bgcolor=#e8e8e8><th scope=col>Depfrom</th>
<th>Arrfrom</th><th>Dept</th><th>Depto</th><th>Arrto</th><th>Grant</th><th>Depdate</th><th>Arrdate</th>";

for($index=0;$index<$num_rows;$index++)
{
$rows=mysql_fetch_array($result);
echo '<tr>
<td> ';
echo $rows[depfrom];
echo'</td> <td> ';
echo htmlspecialchars(stripslashes($rows[arrfrom]));
echo '</td> <td> ';
echo htmlspecialchars(stripslashes($rows[dept]));
echo '</td> <td>  ';
echo htmlspecialchars(stripslashes($rows[depto]));
echo '</td> <td>  ';
echo htmlspecialchars(stripslashes($rows[arrto]));
echo '</td> <td> ';
echo htmlspecialchars(stripslashes($rows[granter]));
echo '</td> <td> ';
echo htmlspecialchars(stripslashes($rows[depdate]));
echo '</td> <td>  ';
echo htmlspecialchars(stripslashes($rows[arrdate]));
echo '</td> </tr>';
}
echo '</table><p>';

}
echo "</div";
?>

<br><br><fieldset><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<table cellpadding=3 cellspacing=0 width=100% border=0 height=22>
<tr bgcolor=#4682B4>
<td nowrap><font color=white>Copyright ©2007 ICT. All rights reserved. KILIFI intranet Version 1.0.1</font><font size=1 color=white> <div align=right>Recommended Browsers: Mozilla FireFox/Internet Explorer</div></font></td>
<td align=right> 

</td>
</tr>
</table>
</body>
</html>
</fieldset><script language="JavaScript">

</script>
<script>
var a_fields = {
'grant': {
'l': 'grant description', // label
'r': true, // required
't': 't_grant', // id of the element to highlight if input not validated

'm': null, // must match specified form field
'mn': 2, // minimum length
'mx': 100 // maximum length
}

},

o_config = {
'to_disable' : ['Submit'],
'alert' : 1
}

// validator constructor call
var v = new validator('frmgrants', a_fields, o_config);

</script>

</body>

Aug 2 '07 #1

Follow Post Reply

1659

mwasif

802

Expert 512MB

Explain what you want to do.

Kindly use code tags when posting your source code. To know how to use appropriate code tags look at Posting Guidelines.

Aug 2 '07 #2

searching record given the form

Post your reply

Similar topics