<form name="dobv" method="post" action="dobv.php">
<?PHP
die("Не могу подключиться к серверу MySQL"); die("Не могу найти БД santehnika"); /* составить запрос для вставки информации о клиенте в таблицу */
$id = (int)$_GET['id'];
SELECT `imgv`.`id`,
`vanni`.`id_v` ,
`vanni`.`name_v` ,
`vanni`.`dlina_v`,
`vanni`.`shirina_v`,
`vanni`.`visota_v`,
`vanni`.`obyem_v`,
`vanni`.`forma_v`,
`vanni`.`tip_v`,
`vanni`.`firma_v` ,
`vanni`.`strana_v` ,
`vanni`.`opisanie_konf_v` ,
`vanni`.`cena_v`
FROM vanni
INNER JOIN imgv
ON `vanni`.`id_v` = `imgv`.`tov_v`
WHERE `vanni`.`id_v` ='.$id);
if(!isset($rgData['id'])) {
}
if ($rgData['cena_v']!=0){
if($rgData['visota_v']!=0){
echo "<table><tr class='tb'><td> <table>
<tr><td><b><font color=teal size=5px>".$rgData['name_v']." </font></b></td></tr>
<tr><td><img class='of' src='image_v.php?id=".$rgData['id']." alt='' /></td></tr> </table></td>
<td><table><tr><td><table class='tb'>
<tr><td width=100px><b><font color=#4B4B4B>Длина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['dlina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Ширина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['shirina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Высота, см:</font></b></td><td><font color=#4B4B4B>".$rgData['visota_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Объем, л:</font></b></td><td><font color=#4B4B4B>".$rgData['obyem_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Форма:</font></b></td><td><font color=#4B4B4B>".$rgData['forma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Тип:</font></b></td><td><font color=#4B4B4B>".$rgData['tip_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Фирма:</font></b></td><td><font color=#4B4B4B>".$rgData['firma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Страна:</font></b></td><td><font color=#4B4B4B>".$rgData['strana_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Описание:</font></b></td><td><font color=#4B4B4B>".$rgData['opisanie_konf_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B> Цена:</font></b></td><td><b><font color=#B70707 size=6px>".$rgData['cena_v']." руб</b></font></td></tr>
</table></td></tr><tr><td></td></tr> </table></td></tr></table>"; }
else {echo "<table><tr class='tb'><td> <table>
<tr><td><b><font color=teal size=5px>".$rgData['name_v']." </font></b></td></tr>
<tr><td><img class='of' src='image_v.php?id=".$rgData['id']." alt='' /></td></tr> </table></td>
<td><table><tr><td><table class='tb'>
<tr><td width=100px><b><font color=#4B4B4B>Длина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['dlina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Ширина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['shirina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Объем, л:</font></b></td><td><font color=#4B4B4B>".$rgData['obyem_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Форма:</font></b></td><td><font color=#4B4B4B>".$rgData['forma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Тип:</font></b></td><td><font color=#4B4B4B>".$rgData['tip_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Фирма:</font></b></td><td><font color=#4B4B4B>".$rgData['firma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Страна:</font></b></td><td><font color=#4B4B4B>".$rgData['strana_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Описание:</font></b></td><td><font color=#4B4B4B>".$rgData['opisanie_konf_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B> Цена:</font></b></td><td><b><font color=#B70707 size=6px>".$rgData['cena_v']." руб</b></font></td></tr> </table></td></tr><tr><td></td></tr>
</table></td></tr></table>"; }}
else{
if($rgData['visota_v']!=0){
echo "<table><tr class='tb'><td> <table>
<tr><td><b><font color=teal size=5px>".$rgData['name_v']." </font></b></td></tr>
<tr><td><img class='of' src='image_v.php?id=".$rgData['id']." alt='' /></td></tr>
</table> </td><td>
<table><tr><td><table class='tb'>
<tr><td width=100px><b><font color=#4B4B4B>Длина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['dlina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Ширина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['shirina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Высота, см:</font></b></td><td><font color=#4B4B4B>".$rgData['visota_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Объем, л:</font></b></td><td><font color=#4B4B4B>".$rgData['obyem_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Форма:</font></b></td><td><font color=#4B4B4B>".$rgData['forma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Тип:</font></b></td><td><font color=#4B4B4B>".$rgData['tip_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Фирма:</font></b></td><td><font color=#4B4B4B>".$rgData['firma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Страна:</font></b></td><td><font color=#4B4B4B>".$rgData['strana_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Описание:</font></b></td><td><font color=#4B4B4B>".$rgData['opisanie_konf_v']."</font></td></tr>
</table></td></tr><tr><td></td></tr> </table></td></tr></table>"; }
else {echo "<table><tr class='tb'><td> <table>
<tr><td><b><font color=teal size=5px>".$rgData['name_v']." </font></b></td></tr>
<tr><td><img class='of' src='image_v.php?id=".$rgData['id']." alt='' /></td></tr>
</table> </td><td>
<table><tr><td><table class='tb'>
<tr><td width=100px><b><font color=#4B4B4B>Длина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['dlina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Ширина, см:</font></b></td><td><font color=#4B4B4B>".$rgData['shirina_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Объем, л:</font></b></td><td><font color=#4B4B4B>".$rgData['obyem_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Форма:</font></b></td><td><font color=#4B4B4B>".$rgData['forma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Тип:</font></b></td><td><font color=#4B4B4B>".$rgData['tip_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Фирма:</font></b></td><td><font color=#4B4B4B>".$rgData['firma_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Страна:</font></b></td><td><font color=#4B4B4B>".$rgData['strana_v']."</font></td></tr>
<tr><td><b><font color=#4B4B4B>Описание:</font></b></td><td><font color=#4B4B4B>".$rgData['opisanie_konf_v']."</font></td></tr>
</table></td></tr><tr><td></td></tr> </table></td></tr></table>";}
//show description or whatever you want
SELECT `komplektacija_v`.`name_kv` , `komplektacija_v`.`opisanie_kompl_kv` , `komplektacija_v`.`cena_kv`
FROM komplektacija_v
INNER JOIN vanni ON `vanni`.`id_v` = `komplektacija_v`.`tovar_kv`
WHERE `komplektacija_v`.`tovar_kv` ='.$id);
echo "<b><font color=teal>Комплектация ".$rgData['name_v']. ":</font></b>";
echo "<table border= 2px width=100%>";
echo "<tr><td><font color=#4B4B4B><b>Комплектация</b></font></td><td><font color=#4B4B4B><b>Описание</b></font></td><td><font color=#4B4B4B><b>Цена</b></font></td><td><font color=#4B4B4B><b>Выбор</b></font> </td></tr>";
{
if(!isset($rgData['id'])) {
}
{foreach ($rgData1 as $field);
echo "<tr><td><font color=#4B4B4B>".$rgData1[0]."</font></td>";
echo "<td><font color=#4B4B4B>".$rgData1[1]."</font></td>";
echo "<td><b><font color=#B70707>".$rgData1[2]."</font></b></td><td><font color=#4B4B4B>";?><input type=checkbox name=kompl [checked] >
<?PHP "</font></td></tr>"; }}
echo "</table>"; }
SELECT `do_v`.`name_dov` ,
`do_v`.`cena_dov` ,
`do_v`.`tovar_dov` ,
`vanni`.`id_v` ,
`vanni`.`do_vn`
FROM do_v
INNER JOIN vanni ON `do_v`.`tovar_dov` = `vanni`.`id_v`
WHERE `do_v`.`tovar_dov`='.$id);
if (!$result = $rSelect2)
{
echo "<br>Не могу выполнить запрос<br>";
}
if ($rgData2['do_vn']!=0){
echo "<b><font color=teal>Дополнительные опции ".$rgData['name_v']. ":</font></b>";
echo "<table border= 2px width=100%>";
echo "<tr><td><font color=#4B4B4B><b>Название</b></font></td><td><font color=#4B4B4B><b>Цена</b></font></td><td><font color=#4B4B4B><b>Выбор</b></font> </td></tr>";
echo "<tr><td><font color=#4B4B4B>".$rgData2[0]."</font></td>";
echo "<td><b><font color=#B70707>".$rgData2[1]."</font></b></td><td>"?><input type="radio" name="dopv" [checked]>
<?PHP "</td></tr>";}
echo "</table>";
?>
<input type="submit" name="Submit" value="Выбрать" >
</form>