Travel, . , , , , , , .
.
HTML- .
<HTML>
<HEAD>
<TITLE> "Travel" - </TITLE>
</HEAD>
<BODY>
<H1> "Travel".</H1>
<H2> .</H2>
<FORM method="POST" action="example.php">
<<INPUT type="hidden" name="posted" value="true">
:<br>
<SELECT name="Otpravka">
<OPTION value="DateOtpravki">
<OPTION value="Number">
</SELECT><br>
:<br>
<INPUT name="First" type=TEXT><br>
<INPUT type=submit value=""></form>
</BODY>
</HTML>
Web- , . . . . , action form. example.php.
- .
<HTML>
<HEAD>
<STYLE type="text/css">
.center { text-align: center; }
</STYLE>
<TITLE> "Travel" - </title></head>
<BODY>
<H1> "Travel".</H1>
<H2> .</H2>
<?php
if (isset($_POST['posted']))
{
$Otpravka = $_POST['Otpravka'];
$First = $_POST['First'];
trim($search_term); //
if ($Otpravka == "" or $First == "")
{ echo " . , ."; exit; } //
$Otpravka =addslashes($Otpravka);
$First = addslashes($First);
$db = mysql_pconnect("localhost", "root", ""); //
if (!$db)
{ echo " : MySQL . , .";
exit; }
mysql_SELECT_db("Travel"); //
$query = "SELECT Putevka.DateOtpravki, Putevka.Number, Putevka.DateVozvr, Turist.SecondName, Turist.FirstName, Turist.Patronym, Turist.SeriaPassport, Turist.NumberPassport, Turoperator.Name,
|
|
Hotel.Names, Hotel.Class
FROM Putevka, Turist, Turoperator, Hotel
WHERE Turist.Id = Putevka.Cod_Turist AND Turoperator.Id = Putevka.Cod_Operator AND Hotel.Id = Putevka.Cod_Hotel AND ".$Otpravka." LIKE '%".$First."%'";
$result = mysql_query($query); //
$num_rows = mysql_num_rows($result);
//
echo "<p> <h3> : ".$num_rows.".</h3></p>";
echo "<table cellpadding=5 border=2>\n";
echo "<tr><th width=100> </th>
<TH width=100></TH><th width=100></th>
<TH width=100></TH>
<TH width=100> </th><th width=100> </TH>
<TH width=100> </th>
<TH width=100></th></tr>\n";
for ($i=0; $i<$num_rows; $i++)
{ $row = mysql_fetch_array($result);
//
echo "<TR><TD class \"center\">$row[Number]</TD>
<TD>$row[SecondName]</TD>
<TD>$row[FirstName]</TD>
<TD>$row[Patronym]</TD>
<TD>$row[DateOtpravki]</TD>
<td>$row[DateVozvr]</TD>
<TD class=\"center\">$row[Names]</TD>
<TD class=\"center\">$row[Name]</TD></TR>\n"; } }
?>
</BODY>
</HTML>
, Travel . . , , . . , , .
. , . , Putevka ( Number, DateOtpravki, DateVozvr), Turist ( SecondName, FirstName, Patronym), Hotel ( Name) Turoperator ( Name).
. , , , , , , , .
8.37, , 2010-05-18. Travel , : , .
, , MySQL , .