I want to add form data and images using one form in php. I'm using php,ajax and mysql.When I run images insert code and data insert code seperately ; they worked. But when I put in the same php form data insert part doesn't work. Please tell me where I goes wrong
This is my php page
-
<?php
-
session_start();
-
require_once ('dbconnect.php');
-
require_once ('commonFunctions.php');
-
-
<script language="javascript" src="ajax.js"></script>
-
-
-
<script type="text/javascript">
-
function add_file_field(){
-
var container=document.getElementById('file_container');
-
var file_field=document.createElement('input');
-
file_field.name='images[]';
-
file_field.type='file';
-
container.appendChild(file_field);
-
var br_field=document.createElement('br');
-
container.appendChild(br_field);
-
}
-
</script>
-
-
</head>
-
-
<?
-
-
$make= "";
-
-
-
if(isset($_GET['Submit'])==2){
-
$make=$_GET['make'];
-
getVehicleModel($make);
-
return;
-
}
-
-
if(isset($_GET['S'])==1){
-
-
echo $make;
-
$make=$_GET['make'];
-
$model=$_GET['model'];
-
$type=$_GET['type'];
-
$year=$_GET['year'];
-
$month=$_GET['month'];
-
$fuel=$_GET['fuel'];
-
$transmission=$_GET['transmission'];
-
$displacement=$_GET['displacement'];
-
$color=$_GET['color'];
-
$milage=$_GET['milage'];
-
$price=$_GET['price'];
-
$other=$_GET['other'];
-
//---------------------insert data to vehicles table-------------------------------------------
-
$sql = "INSERT INTO vehicles VALUES('','$make','$model','$type','$year','$month','$fuel','$transmission','$color','$price','$displacement','$milage','$other')";
-
-
$result = mysql_query($sql);
-
echo "SUCCESS";
-
-
-
//$vehicles_pk = mysql_insert_id();
-
-
if (!$result)
-
{
-
echo "Error in SQL query: " . mysql_error();
-
}
-
else{
-
-
$message = "<p class=message>Successfully Inserted !</p>";
-
}
-
-
return;
-
}
-
-
-
-
if (isset($_POST['Submit'])) {
-
$number_of_file_fields = 0;
-
$number_of_uploaded_files = 0;
-
$number_of_moved_files = 0;
-
$uploaded_files = array();
-
$upload_directory = dirname(__file__) . '/vehicles/';
-
-
-
-
for ($i = 0; $i < count($_FILES['images']['name']); $i++) {
-
$number_of_file_fields++;
-
if ($_FILES['images']['name'][$i] != '') {
-
$number_of_uploaded_files++;
-
$uploaded_files[] = $_FILES['images']['name'][$i];
-
if (move_uploaded_file($_FILES['images']['tmp_name'][$i], $upload_directory . $_FILES['images']['name'][$i])) {
-
$number_of_moved_files++;
-
}
-
-
}
-
-
}
-
-
$name= implode(',', $uploaded_files);
-
echo $name;
-
-
-
}
-
?>
-
-
-
-
<table width="566" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" >
-
-
<!--------------body-------------------------------------------------------------->
-
<tr>
-
<td>
-
<form name="frm" method="post" enctype="multipart/form-data" action="">
-
<!--<form id="addvehicle" method="post" enctype="multipart/form-data" name="addvehicle">-->
-
<table cellspacing="5"><br />
-
<tr><td colspan="2"><? //echo $message; ?></td></tr>
-
<tr>
-
<td>Make :</td>
-
<td>
-
<?php getVehicleMake();
-
?>
-
-
</td>
-
<!--<td>Add New</td>
-
<td><input name="" type="radio" value="" /><input name="c" type="text" value="" /></td>-->
-
</tr>
-
<tr>
-
<? //------------------ this is reciveing ajax sending selected vahicle make-------------------------- ?>
-
-
<td>Model :</td>
-
<td>
-
<div id='txtHint'>
-
<?
-
getVehicleMakeForStockAdmin($make);
-
?>
-
</div>
-
</td>
-
</tr>
-
<tr>
-
<td>Type :</td>
-
<td colspan="3">
-
<? getVehicleType();?>
-
</td>
-
</tr>
-
-
<tr>
-
<td>Year :</td>
-
<td><? getVehicleYear(); ?>Month :<? getVehicleMonth(); ?>
-
</td>
-
</tr>
-
-
-
<tr><td>Images</td>
-
<td>
-
<div id="file_container">
-
<input name="images[]" type="file" />
-
<br />
-
</div>
-
<a href="javascript:void(0);" onClick="add_file_field();">Add another</a><br />
-
</td>
-
-
</tr>
-
</form>
-
<tr>
-
<td align="right" colspan="2">
-
-
<button type="submit" name="Submit" style="border: 0; background: transparent; cursor: pointer;" onclick="addVehicle();"> <img src="http://bytes.com/images/searchBtn.jpg" />
-
</button>
-
</td>
-
</tr>
-
</table>
-
-
</td>
-
</tr>
-
-
<tr>
-
<td><?php require_once 'footer.php'; ?>
-
</td>
-
</tr>
-
</table>
-
-
<!-------------------------end stock search---------------------------------------- -->
-
</body>
</html> -
This is ajax code to get data
-
function addVehicle(){
-
-
var dropdownIndex = document.getElementById('Make').selectedIndex;
-
var make = document.getElementById('Make')[dropdownIndex].value;
-
var dropdownIndex = document.getElementById('Model').selectedIndex;
-
var model = document.getElementById('Model')[dropdownIndex].value;
-
var dropdownIndex = document.getElementById('Type').selectedIndex;
-
var type = document.getElementById('Type')[dropdownIndex].value;
-
var dropdownIndex = document.getElementById('Year').selectedIndex;
-
var year = document.getElementById('Year')[dropdownIndex].value;
-
-
-
-
var request = GetXmlHttpObject();
-
var url="stockAdmin.php";
-
url=url+"?make="+make+"&model="+model+ "&type="+type+ "&year="+year+"&S="+1;
-
-
-
url=url+"&sid="+Math.random();
-
request.onreadystatechange=stateChanged;
-
request.open("GET",url,true);
-
-
;
-
request.send(null);
-
-
function stateChanged()
-
{
-
if (request.readyState==4)
-
{
-
-
document.getElementById("a").innerHTML=request.responseText;
-
document.frm.reset();
-
-
}
-
}
-
-
}
-
-