Lena2012
Новичок
Добрый день, подскажите, пожалуйста, где ошибка в синтаксисе? Спасибо!
PHP:
<?php
include("Tools/db.php");
$mydb = new ddb();
$mydb->connect("localhost","root","","mydatabasetest");
if( $mydb->connected )
{
?>
<form action="" method="POST">
<table>
<tr>
<td>
Types Of Tours:
</td><td>
<input name="TypesOfTours" type="text">
</td></tr>
<tr>
<td>Name Of Operator:</td>
<td><input name="NameOfOperator" type="text" /></td>
</tr>
<tr>
<td>Short Description</td>
<td><textarea name="ShortDescription" cols="45" rows="5"></textarea></td>
</tr>
<tr>
<td>Full Description</td><td><textarea name="FullDescription" cols="45" rows="5"></textarea></td></tr>
<tr>
<td>Price For Adults</td>
<td><input name="PriceForAdults" type="text" /></td>
</tr>
<tr>
<td>Price For Children</td>
<td><input name="PriceForChildren" type="text" /></td>
</tr>
<tr>
<td>Price For Charter</td>
<td><input name="PriceForCharter" type="text" /></td>
</tr>
<tr>
<td>Path to Big Image</td>
<td><input name="BigImg" type="text" /></td>
</tr>
<tr>
<td>Path to Small Image</td>
<td><input name="SmallImg" type="text" /></td>
</tr>
<tr>
<td>Path to Preview Image</td>
<td><input name="PreviewImg" type="text" /></td>
</tr>
<tr><td>
</td><td>
<input type="submit" value="Save to DB">
</td></tr>
<tr><td>
</td><td>
</td></tr>
</table>
</form>
<?php
$TypesOfTours = $_POST["TypesOfTours"];
if( !empty($TypesOfTours) )
{
$NameOfOperator = $_POST["NameOfOperator"];
if( !empty($NameOfOperator) )
$Short = $_POST["ShortDescription"];
if( !empty($if( !empty($Short) )
$Full = $_POST["FullDescription"];
if( !empty($if( !empty($Full) )
$Adult = $_POST["PriceForAdults"];
if( !empty($if( !empty($Adults) )
$Child = $_POST["PriceForChildren"];
if( !empty($if( !empty($Child) )
$PriceForCharter = $_POST["PriceForCharter"];
if( !empty($if( !empty($PriceForCharter) )
$BigImg = $_POST["BigImg"];
if( !empty($if( !empty($BigImg) )
$SmallImg = $_POST["SmallImg"];
if( !empty($if( !empty($SmallImg) )
$PreviewImg = $_POST["PreviewImg"];
if( !empty($if( !empty($PreviewImg) )
}
{
$sql = "INSERT INTO testdata SET ";
$sql .= "TypesOfTours='".$TypesOfTours."', ";
$sql .= "NameOfOperator='".$NameOfOperator."', ";
$sql .= "ShortDescription='".$Short."'";
$sql .= "FullDescription='".$Full."', ";
$sql .= "PriceForAdults='".$Adult."'";
$sql .= "PriceForChildren='".$Child."'";
$sql .= "PriceForCharter='".$PriceForCharter."'";
$sql .= "BigImg='".$BigImg."', ";
$sql .= "SmallImg='".$SmallImg."'";
$sql .= "PreviewImg='".$PreviewImg."'";
if( $mydb->writex($sql) )
{
print "Successful Add : ".$mydb->last_insert_id."<br>";
}
}
}
$searchtype = strtolower($_GET["TypesOfTours"]); //"coffee";
$mydb->readx( "SELECT * FROM testdata WHERE Type LIKE '%|".$searchtype."|%'",true );
if( $mydb->resultcount() > 0 )
{
// display data
foreach( $mydb->data as $dataline )
{
print $dataline["ID"]." - ".$dataline["TypesOfTours"]." ".$dataline["NameOfOperator"]." ".$dataline["ShortDescription"]." ".$dataline["FullDescription"]." ".$dataline["PriceForAdults"]." ".$dataline["PriceForChildren"]." ".$dataline["PriceForCharter"]." ".$dataline["BigImg"]." ".$dataline["SmallImg"]." ".$dataline["PreviewImg"]"<br />";
}
}
?>
