I am trying to upload image by the below code and i am getting the file name from input file field.
if(isset($_REQUEST['requestsubmit']))
{
$field_values_array1 = $_REQUEST['name'];
$field_values_array2 = $_REQUEST['address'];
$field_values_array3 = $_REQUEST['image'];
foreach($field_values_array1 as $k=>$value1){}
foreach($field_values_array2 as $k=>$value2){}
foreach($field_values_array3 as $k=>$value3){
$insert ="INSERT INTO `infotown_house`.`test` (`id`, `userName`, `cat`, `image`) VALUES (NULL, '".$field_values_array1[$k]."', '".$field_values_array2[$k]."', '".$field_values_array3[$k]."')";
mysql_query($insert);
Suggestion #1: don't use $_REQUEST >>> use $_FILE
Suggestion #2: don't use mysql_* >>> use mysqli_*
Suggestion #3: your foreach loop is shitty - is there some code missing?
Suggestion #4: don't use queries within loops if it is not neccessary
Suggestion #5: 'id' is not neccessary to be set, if it is auto increment
Suggestion #6: You need to save the uploaded Image. you can use move_uploaded_file() to do it