Код:
<?php
define('IN_PHPBB', true);
$phpbb_root_path ='forum/';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
?>
<?php
include('config.php');//добавяме config файла
?>
<form action="" method="post" enctype="multipart/form-data">
<div style='margin: 0 10px;'>
<table width="700" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="120" class="stitlema">*Категория: </td><td>
<select name="id_cat" class="select">
<option value="1">Продава имот</option>
<option value="2">Наема имот</option>
<option value="3">Купува имот</option>
<option value="4">Отдава имот</option>
</select>
</td>
<td width="120" class="stitlema">Година: </td><td>
<select name="godini" class="select">
<option value="не е попълнено">---</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1960">1960</option>
<option value="1950">1950</option>
<option value="1940">1940</option>
<option value="1930">1930</option>
<option value="1920">1920</option>
<option value="1910">1910</option>
<option value="1900">1900</option>
</select><br>
</td>
<tr>
<td width="120" class="stitlema">Подкатегория: </td><td>
<select name="podcat" class="select">
<option value="1-стаен">1-стаен</option>
<option value="2-стаен">2-стаен</option>
<option value="3-стаен">3-стаен</option>
<option value="4-стаен">4-стаен</option>
<option value="многостаен">многостаен</option>
<option value="мезонет">мезонет</option>
<option value="ателие">ателие</option>
<option value="етаж от къща">етаж от къща</option>
<option value="таван">таван</option>
<option value="къща">къща</option>
<option value="вила">вила</option>
<option value="офис">офис</option>
<option value="бизнес сграда">бизнес сграда</option>
<option value="промишлен имот">промишлен имот</option>
<option value="магазин">магазин</option>
<option value="заведение">заведение</option>
<option value="склад">склад</option>
<option value="гараж">гараж</option>
<option value="хотел">хотел</option>
<option value="парцел">парцел</option>
<option value="зем. земя">зем. земя</option>
<option value="гори">гори</option>
</select>
</td>
<td width="120" class="stitlema"><br>*Телефон: </td><td>
<input type="text" name="tel" class="imputcss">
</td>
<tr>
</td>
<td width="120" class="stitlema">Местоположение: </td><td>
<select name="grad" class="select">
<option value="не е попълнено">---</option>
<option value="София">София</option>
<option value="Пловдив">Пловдив</option>
<option value="Бургас">Бургас</option>
<option value="Варна">Варна</option>
<option value="Айтос">Айтос</option>
<option value="Асеновград">Асеновград</option>
<option value="Благоевград">Благоевград</option>
<option value="Ботевград">Ботевград</option>
<option value="Велико Търново">Велико Търново</option>
<option value="Велинград">Велинград</option>
<option value="Видин">Видин</option>
<option value="Враца">Враца</option>
<option value="Габрово">Габрово</option>
<option value="Горна Оряховица">Горна Оряховица</option>
<option value="Гоце Делчев">Гоце Делчев</option>
<option value="Димитровград">Димитровград</option>
<option value="Добрич">Добрич</option>
<option value="Дупница">Дупница</option>
<option value="Казанлък">Казанлък</option>
<option value="Карлово">Карлово</option>
<option value="Карнобат">Карнобат</option>
<option value="Кърджали">Кърджали</option>
<option value="Кюстендил">Кюстендил</option>
<option value="Ловеч">Ловеч</option>
<option value="Лом">Лом</option>
<option value="Монтана">Монтана</option>
<option value="Нова Загора">Нова Загора</option>
<option value="Пазарджик">Пазарджик</option>
<option value="Панагюрище">Панагюрище</option>
<option value="Перник">Перник</option>
<option value="Петрич">Петрич</option>
<option value="Пещера">Пещера</option>
<option value="Плевен">Плевен</option>
<option value="Попово">Попово</option>
<option value="Разград">Разград</option>
<option value="Русе">Русе</option>
<option value="Самоков">Самоков</option>
<option value="Сандански">Сандански</option>
<option value="Свищов">Свищов</option>
<option value="Севлиево">Севлиево</option>
<option value="Силистра">Силистра</option>
<option value="Сливен">Сливен</option>
<option value="Смолян">Смолян</option>
<option value="Стара Загора">Стара Загора</option>
<option value="Троян">Троян</option>
<option value="Търговище">Търговище</option>
<option value="Харманли">Харманли</option>
<option value="Хасково">Хасково</option>
<option value="Ямбол">Ямбол</option>
</select>
</td>
<td width="120" class="stitlema">*E-mail: </td><td>
<input type="text" name="email" class="imputcss">
</td>
</tr>
<tr>
<td width="120" class="stitlema"><br>Район:
</td><td>
<input type="text" name="raion" class="imputcss" >
</td>
<td width="120" class="stitlema">Валидност: </td><td>
<select name="validnost" class="select">
<option value="7">7 дена</option>
<option value="14">14 дена</option>
<option value="30">30 дена</option>
</select>
</td>
</tr>
<tr>
<td width="120" class="stitlema">Квадратура: </td><td>
<input type="text" name="kwadratyra" class="imputcss">
</td>
</tr>
<tr>
<td width="120" class="stitlema"><br>Етаж:</td><td>
<select name="etaj" class="select">
<option value="Партер">Партер</option>
<option value="1-ви">1-ви</option>
<option value="2-ри">2-ри</option>
<option value="3-ти">3-ти</option>
<option value="4">4-ти</option>
<option value="5">5-ти</option>
<option value="6">6-ти</option>
<option value="7">7-ми</option>
<option value="8">8-ми</option>
<option value="9">9-ми</option>
<option value="10">10-ми</option>
<option value="11">11-ми</option>
<option value="12">12-ми</option>
<option value="13">13-ми</option>
<option value="14">14-ми</option>
<option value="15">15-ми</option>
<option value="16">16-ми</option>
<option value="17">17-ми</option>
<option value="18">18-ми</option>
<option value="19">19-ми</option>
<option value="20">20-ми</option>
<option value="21">21-ми</option>
<option value="22">22-ми</option>
<option value="23">23-ми</option>
<option value="24">24-ти</option>
<option value="25">25-ти</option>
<option value="26">26-ти</option>
</select>
</td>
</tr>
<tr>
<td width="120" class="stitlema">ТЕЦ:</td><td>
<select name="tec" class="select">
<option value="не е попълнено">---</option>
<option value="Да">Да</option>
<option value="Не">Не</option>
</select>
</td>
</tr>
<tr>
<td width="120" class="stitlema"><br>Телефон: </td><td>
<select name="telefon" class="select">
<option value="не е попълнено">---</option>
<option value="Да">Да</option>
<option value="Не">Не</option>
</select>
</td>
</tr>
<tr>
<td width="120" class="stitlema">*Цена:
<select name="valuta" class="selectcena">
<option value="EU">EU</option>
<option value="лв.">лв.</option>
<option value="USD">USD</option>
</select>
</td><td>
<input type="text" name="cena" class="imputcss" >
</td>
</tr>
</table>
<br>
<table width="500" border="0" cellpadding="0" cellspacing="0" >
<tr>
</tr>
<tr>
<td colspan="3">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="500">
<tr>
<td valign="top" class="stitlema">Автор: <input type="text" name="username" value="<?=$user->data['username'];?>" readonly="readonly" class="imputcss" ><br/>*Заглавие:
<br><input type="text" name="title" MAXLENGTH="50" class="imputcss2"> (максимум 50 знака)
<br>
Кратко описание:
<br><textarea rows="4" name="imot" cols="40" type="text" class="imputcss3"></textarea></td>
<tr>
<td valign="top" class="stitlema"><br>Добави снимка: <input name="file" type="file" size="36" /></td>
</tr>
<tr>
<td valign="top" class="stitlema">Добави снимка: <input name="file2" type="file" size="36" /></td>
</tr>
<tr>
<td valign="top" class="stitlema">Добави снимка: <input name="file3" type="file" size="36" /></td>
</tr>
<tr>
<td valign="top" class="stitlema">Добави снимка: <input name="file4" type="file" size="36" /></td>
</tr>
</table>
</div>
<b><i> Максимален размер = 1.5 MB</b></i><br>
<b><i>Всички полета маркирани с * са задължителни!</b></i>
<br>
<form action="" method="post" enctype="multipart/form-data">
<input class="button" type="reset" value="Изчисти" />
<input class="button" name="imoti" type="submit" value="Добави">
</form>
<?php
echo "
<input type=\"hidden\" value=\"".date("j")."\" name=\"den\">
<input type=\"hidden\" value=\"".date("m")."\" name=\"mesec\">
<input type=\"hidden\" value=\"".date("Y")."\" name=\"godina\">
<input type=\"hidden\" value=\"".$_SERVER['REMOTE_ADDR']."\" name=\"ip\">";
?>
<?php
if ($_POST['imoti']) {
$data = time()+($_POST['datadel']*86400);
$username = $_POST['username'];
$imot = $_POST['imot'];
$tel = $_POST['tel'];
$datadel = $_POST['datadel'];
$cena = $_POST['cena'];
$valuta = $_POST['valuta'];
$ip = $_POST['ip'];
$podcat = $_POST['podcat'];
$den = $_POST['den'];
$mesec = $_POST['mesec'];
$godina = $_POST['godina'];
$id_im = $_POST['id_im'];
$grad = $_POST['grad'];
$godini = $_POST['godini'];
$email = $_POST['email'];
$title = $_POST['title'];
$kwadratyra = $_POST['kwadratyra'];
$etaj = $_POST['etaj'];
$tec = $_POST['tec'];
$telefon = $_POST['telefon'];
$id_cat = $_POST['id_cat'];
$raion = $_POST['raion'];
$file = $_FILES['file']['name'];
$tmp_file = $_FILES['file']['tmp_name'];
$size = $_FILES['file']['size'];
$file2 = $_FILES['file2']['name'];
$tmp_file2 = $_FILES['file2']['tmp_name'];
$size2 = $_FILES['file2']['size'];
$file3 = $_FILES['file3']['name'];
$tmp_file3 = $_FILES['file3']['tmp_name'];
$size3 = $_FILES['file3']['size'];
$file4 = $_FILES['file4']['name'];
$tmp_file4 = $_FILES['file4']['tmp_name'];
$size4 = $_FILES['file4']['size'];
$pic1="pic/";
$pic2="pic/";
$pic3="pic/";
$pic4="pic/";
if($podcat==NULL|$cena==NULL|$title==NULL|$email==NULL|$tel==NULL) {
echo "<b>Не сте попълнили задължителните полетата!</b>";
}else{
$chars="set NAMES cp1251";mysql_query($chars);
$checkimot = mysql_query("SELECT imot FROM imoti WHERE imot='$imot'");
$checkname= mysql_num_rows($checkimot);
if ($checkname>0) {
// опа.!
echo "Такава обява вече е била добавена!";
}else{
$max_size = 1572864;
$extensions = array('gif','jpg','png','jpeg');
$extension_file = end(explode(".",$file));
$extension_file = strtolower($extension_file);
if ($size>$max_size || $size2>$max_size || $size3>$max_size || $size4>$max_size) { echo "картинката е по-голяма от 1.5 MB!";} else{
$upload = move_uploaded_file($_FILES['file']['tmp_name'],$pic1.'/'.$_FILES['file']['name']);
$upload2 = move_uploaded_file($_FILES['file2']['tmp_name'],$pic2.'/'.$_FILES['file2']['name']);
$upload3 = move_uploaded_file($_FILES['file3']['tmp_name'],$pic3.'/'.$_FILES['file3']['name']);
$upload4 = move_uploaded_file($_FILES['file4']['tmp_name'],$pic4.'/'.$_FILES['file4']['name']);
}
// никой не е добял...
$username = htmlspecialchars($username);
$imot = htmlspecialchars($imot);
$datadel = htmlspecialchars($datadel);
$tel = htmlspecialchars($tel);
$cena = htmlspecialchars($cena);
$valuta = htmlspecialchars($valuta);
$podcat = htmlspecialchars($podcat);
$den = htmlspecialchars($den);
$mesec = htmlspecialchars($mesec);
$godina = htmlspecialchars($godina);
$id_im = htmlspecialchars($id_im);
$grad = htmlspecialchars($grad);
$godini = htmlspecialchars($godini);
$email = htmlspecialchars($email);
$title = htmlspecialchars($title);
$kwadratyra = htmlspecialchars($kwadratyra);
$etaj = htmlspecialchars($etaj);
$tec = htmlspecialchars($tec);
$telefon = htmlspecialchars($telefon);
$id_cat = htmlspecialchars($id_cat);
$raion = htmlspecialchars($raion);
// превръщаме полетата да не са в html
//всичко е перфректно да добавяме
$chars="set NAMES cp1251";mysql_query($chars);
$query = mysql_query("INSERT INTO `imoti` (cena, title, imot, grad, podcat, id_cat, den, email, tel, ip, godina, mesec, godini, datadel, valuta, kwadratyra, etaj, telefon, tec, id_im, pic, pic2, pic3, pic4, raion, username) VALUES('$cena','$title','$imot','$grad','$podcat','$id_cat','$den','$email','$tel','$ip','$godina','$mesec','$godini','$data','$valuta','$kwadratyra','$etaj','$telefon','$tec','$id_im','$file','$file2','$file3','$file4','$raion','$username')") or die(mysql_error());
echo "<br /><b>Успешно добавихте обявата! Тя ще бъде прегледана от администратора и ако отговаря на правилата ще бъде публикувана!</b>";
}
}
}
else
{
//формата не е използвана
echo ("");
}
?>
Когато файла изглежда така не добавя записа и ми дава тази грешка: Incorrect integer value: '' for column 'id_im' at row 1
махам кода за интеграцията:
<?php
define('IN_PHPBB', true);
$phpbb_root_path ='forum/';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
?>
и всичко си работи на 6... Помощ :?