tech.lab/table1.php at master · LEV13/tech.lab · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php

include('db.php');


?>

<form method="post" action="insert.php">
<table bgcolor="FFFFFF" border="0" width="600" height="" cellspacing="0" cellpadding="0" >
<td rowspan="17" width="50" height="" ></td>
<td class="gg">Марка</td><td class="gg"><select name="marka">
<?

		$marka=mysql_query("SELECT * FROM marki");
		$mq=mysql_fetch_array($marka) ;

		do
		{
			echo '<option value="'.$mq['marka'].'">'.$mq['marka'].'</option>';
		}
		while($mq = mysql_fetch_array($marka))

?>
</select></td>
<tr><td class="gg">Модель</td><td class="gg"><input type="text" name="model"/></td></tr>
<tr><td class="gg">Год выпуска</td><td class="gg"><select name="year">
<?php
       for($i = 2004; $i <= date(2015); $i++) {
 print('<option value="' . $i . '"' . ($i == date('Y', $row["date"]) ? ' selected="selected"' : '') . '>' . $i . '</option>');
}
     ?>
</select></td>
<tr><td class="gg">Тип кузова</td><td class="gg"><select name="bodywork">
<?

		$bodywork=mysql_query("SELECT * FROM bodywork");
		$dz=mysql_fetch_array($bodywork) ;

		do
		{
			echo '<option value="'.$dz['type'].'">'.$dz['type'].'</option>';
		}
		while($dz = mysql_fetch_array($bodywork))

?>
</select></td>
<td rowspan="14" width="50" height="" ></td>
</tr>
<tr><td class="gg">Длина</td><td class="gg"><input type="text" name="length"/></td></tr>
<tr><td class="gg">Ширина</td><td class="gg"><input type="text" name="width"/></td></tr>
<tr><td class="gg">Высота</td><td class="gg"><input type="text" name="height"/></td></tr>
<tr><td class="gg">Объем двигателя</td><td class="gg"><input type="text" name="engine"/></td></tr>
<tr><td class="gg">Мощность</td><td class="gg"><input type="text" name="power"/></td></tr>
<tr><td class="gg">Расположение цилиндров</td><td class="gg"><select name="Pcylinders">
<?

		$Pcylinders=mysql_query("SELECT * FROM Pcylinders");
		$dp=mysql_fetch_array($Pcylinders) ;

		do
		{
			echo '<option value="'.$dp['type'].'">'.$dp['type'].'</option>';
		}
		while($dp = mysql_fetch_array($Pcylinders))

?>
   </select></td></tr>
<tr><td class="gg">Количество цилиндров</td><td class="gg"><select name="Ncylinders">
<?

		$Ncylinders=mysql_query("SELECT * FROM Ncylinders");
		$dn=mysql_fetch_array($Ncylinders) ;

		do
		{
			echo '<option value="'.$dn['number'].'">'.$dn['number'].'</option>';
		}
		while($dn = mysql_fetch_array($Ncylinders))

?>
   </select></td></tr>
<tr><td class="gg">Топливо</td><td class="gg"><select name="fuel">
<?

		$benzin=mysql_query("SELECT * FROM benzin");
		$dv=mysql_fetch_array($benzin) ;

		do
		{
			echo '<option value="'.$dv['type'].'">'.$dv['type'].'</option>';
		}
		while($dv = mysql_fetch_array($benzin))

?>
   </select>
		</td></tr>
<tr><td class="gg">Максимальная скорость</td><td class="gg"><input type="text" name="speed"/></td></tr>
<tr><td class="gg">Время разгона (0-100 км/час)</td><td class="gg"><input type="text" name="acceleration"/></td></tr>
<tr><td class="gg">Расход топлива на шоссе</td><td class="gg"><input type="text" name="highway"/></td></tr>
<tr><td class="gg">Расход топлива в городе</td><td class="gg"><input type="text" name="city"/></td></tr>
<td class="gg">Дата добавления</td><td class="gg"><input type="text" name="data"/>
</table>
</tr>
<input type="submit" name="ok" value="Добавить" />
</form>