Здравейте, това ми е кода
След като потвърдя първата форма не ми се отпечатват променливите моля за помощ
Код:
<?php
$kamion = $_GET['kamion'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>demo</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<form method="GET" action="index.php?page=">
<table cellpadding="0" cellspacing="0" width="300px" >
<tr>
<td width="200px">Камион<input type="text" name="kamion" value="<?php echo $kamion; ?>" size="30"></td>
<td width="200px">Дата<input type="text" name="start_date" value="" size="30"></td>
<td width="100px"><input type="submit" name="search" value="search"></td>
<td width="100px"><input type="hidden" name="page" value="razhodtr" /></td>
</tr>
</table>
</form>
<?php
// First connect to database
$tarsene = $_GET['search'];
$host = "localhost";
$dbuser = "root";
$dbpass = "";
$db = "programa";
$con = mysql_connect($host, $dbuser, $dbpass);
mysql_query("SET CHARACTER SET utf8");
if(!$con){
die(mysql_error());
}
$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
}
if($tarsene) {
$kamion = $_GET['kamion'];
$type = $_GET['start_date'];
if(!$kamion) { echo "no entry"; exit(); }
else if(!$type) { echo "Не е въведена дата"; exit(); }
else {
$query = " SELECT * FROM spisak_omsan WHERE kamion = '%$kamion%' AND data_trugvane LIKE '%$type%'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_numrows($result);
while($row = mysql_fetch_array($result))
{
$trailer = $row['vlekach'];
$driver_1 = $row['shofior_evropa'];
$driver_2 = $row['shofior_evropa2'];
$driver_3 = $row['shofior_turcia'];
$driver_4 = $row['shofior_turcia2'];
$start_date = $row['data_trugvane'];
$end_date = $row['data_pribirane'];
}
echo "<table>";
echo "<tr>";
echo "<td colspan=\"2\">Разходи за отчет за международен превоз до Турция на влекач <strong><?php echo $_GET[kamion]; ?></strong></td>
<td colspan=\"2\">За периода:</td>
<td>От: <input type=\"text\" id=\"start_date\" name=\"start_date\" style=\"width:100px; border:1px solid #000;\" /></td>
<td>До: <input type=\"text\" id=\"end_date\" name=\"end_date\" style=\"width:100px; border:1px solid #000;\" /></td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"2\">Име на шофьор: <input type=\"text\" id=\"driver\" name=\"driver\" style=\"width:150px; border:1px solid #000;\" value=\" <?php echo $driver_1; ?>\" /></td><td colspan=\"2\"></td>";
echo "<td>Влекач: <input type=\"text\" id=\"vlekach_number\" name=\"vlekach_number\" style=\"width:100px; border:1px solid #000;\" value=\"<?php echo $_GET[kamion]; ?> \" /></td>";
echo "<td>Ремарке: <input type=\"text\" id=\"remarke_number\" name=\"remarke_number\" style=\"width:100px; border:1px solid #000;\" value=\"<?php echo $remarke; ?>\" /></td>";
echo "</tr>";
echo "</table>";
}
}
?>
</body>
</html>
