السلام عليكم
لو سمحتم محتاج اعرف اية الغلط فى insert
كل حاجة تمام بس مفيش ادخال بينات فى قاعدة البيانات
لو سمح احد الاعضاء يشرحلى الخطاء
كود PHP:
<?php
/**
* @author haytham
* @copyright 2011
*/
require_once('../Connections/config.php');
function redirect($url)
{
header("Location: $url");
die(); //Exit script just in case the header fails
}
$car_names=stripslashes($_POST['carname']);
$model_car=stripslashes($_POST['modelname']);
$model_year=stripslashes($_POST['modelyaer']);
$time=date("M d Y");
$errors=array();
$name = $_FILES['upimg']['name'];
$tmp_name = $_FILES['upimg']['tmp_name'];
$file_path ="../gallery/$name";
$file_ext ="jpg|gif|png|bmp";
$ok_file = explode("|",$file_ext);//allow file extensions exmple file ,gif,jpg,bmp
$file_type = explode(".",$name);//get extensions exmple .jpg
$ext = strtolower(substr($name,-3)); //convert file to small letter and get last letter
if ($_POST['submit'])
{
//check input
if($car_names || $model_car|| $model_year)
{
if($name)
{
if(basename($name) && in_array($ext, $ok_file) || $file_type[2])
{
//start upload process
move_uploaded_file($tmp_name,$file_path);
$sql="INSERT INTO gallery(id,car_name,car_photo,car_model,model_years,add_time)VALUES
('','$car_names','$file_path','$model_car','$model_year','$time')or die(mysql_error())";
$result=mysql_query($sql);
echo"<font color='gren' size='6'>Upload Succes</font> <br/>";
//echo "<meta http-equiv='refresh' content='0; url='upload.php'>";
//header("Location: upload.php");
}
else
$errors[] ="extation file not valid";
}
else
$errors[] ="please select files";
}
////get file attributes
else
$errors[]="please enter car information";
}
echo "<h1>Upload your image</h1>
<table>
<form method='POST' action='upload.php' enctype='multipart/form-data' >
<td><tr><lable>File:</lable></tr><tr><input type='file' name='upimg' /></tr></td>
<td><tr><lable>Car Name:</lable></tr><tr><input type='text' name='carname'/></tr></td>
<td><tr><lable>Model Name:</lable></tr><tr><input type='text' name='modelname'/></tr></td>
<td><tr><lable>Model Yaer:</lable></tr><tr><input type='text' name='modelyaer'/></tr></td>
<td><tr><input type='submit' name='submit' value='Upload'/></tr></td>
</table></form>
";
foreach($errors as $error)
{
echo "<div><font color=\"red\">$error.</font></div>";
}
?>