从PHP中发布数据并插入表格[关闭]

Question

I am getting data from iphone using php but when i insert post data in table it gives error

   mysql_select_db("emriphone", $con);

   $providernpi=$_POST['ProviderNPI'];
  $patienid=$_POST['PatientID'];
  $fileurl=$_POST['FileURL'];
 $filetype=$_POST['FileTYPE'];
 $datasynid=$_POST['DataSynID'];





$query = "INSERT into AppointmentDataSync      (ProviderNPI,PatientID,FileURL,FileType,DataSyncID) VALUES('$providernpi','$patientid','$fileurl','$filetype','$datasynid')"

 $con = mysql_query($query,$con);
$cnt  = mysql_num_rows($con);
echo($providernpi)
  ?>

Answer 1

I think your query statement will be like this

$query = "INSERT into AppointmentDataSync      (ProviderNPI,PatientID,FileURL,FileType,DataSyncID) VALUES('".$providernpi."','".$patientid."','".$fileurl."','".$filetype."','".$datasynid."')";

EDIT

mysql_query($query);
printf("Records inserted: %d
", mysql_affected_rows());