MySQL Travel, - Hotel, Putevka, Turist Turoperator.
. . . , , , , .
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">
<<TABLE border=0> <TR><TD>:</TD>
<TD><INPUT name="SecondName" type="text"></TD>
</TR><TR><TD>:</td>
<TD><INPUT name="FirstName" type="text"></TD>
</TR><TR> <TD>: </td>
<TD><INPUT name="Patronym" type="text"></TD>
</TR><TR><TD> :</TD>
<TD><INPUT name="SeriaPassport" type="text"></TD>
</TR><TR><TD> :</TD>
<TD><INPUT name="NumberPassport" type="text"></TD>
<TR><TD colspan=2><INPUT type="submit" value=""></TD></TR>
</TABLE>
</FORM>
</BODY>
</HTML>
Web- , , . . , action form. example.php.
- .
<HTML>
<HEAD>
<TITLE> "Travel" -
</TITLE>
</HEAD>
<BODY>
<H1> "Travel".</H1>
<H2> .</H2>
<?php
if (isset($_POST['posted']))
{ $SecondName = $_POST['SecondName'];
$FirstName = $_POST['FirstName'];
$Patronym = $_POST['Patronym'];
$SeriaPassport = $_POST['SeriaPassport'];
$NumberPassport = $_POST['NumberPassport'];
//
if ($SecondName == "" or $FirstName == "" or $Patronym == ""or $SeriaPassport == ""or $NumberPassport == "")
{ echo " - "; exit; }
|
|
$SecondName = addslashes($SecondName);
$FirstName = addslashes($FirstName);
$Patronym = addslashes($Patronym);
$SeriaPassport = addslashes($SeriaPassport);
$NumberPassport = addslashes($NumberPassport);
$db = @mysql_pconnect("localhost", "root");
if (!$db)
{ echo " : MySQL . , ."; exit; }
mysql_SELECT_db("Travel");
$query = "INSERT INTO Turist(SecondName, FirstName, Patronym,SeriaPassport,NumberPassport) VALUES ('".$SecondName."','".$FirstName."','".$Patronym."','".$SeriaPassport."','".$NumberPassport."')";
$result = mysql_query($query);
if($result)
echo "<H3> .</H3>"; }
?>
</BODY>
</HTML>
, Travel. Turist SecondName, FirstName, Patronym, SeriaPassport NumberPassport. . , . . , . , Turist , . , , , . .
8.35, Turist : 5304 096572.