How to insert data in mysql data base table
- by user1289538
I am inserting data in MySQL data base but in field it does not insert data. I am using following code
$providernpi=$_POST['ProviderNPI'];
$patienid=$_POST['PatientID'];
$fileurl=$_POST['FileURL'];
$filetype=$_POST['FileTYPE'];
$datasynid=$_POST['DataSynID'];
$appointmentlistingsid=$_POST ['AppointmentListingsID'];
$query=("INSERT INTO AppointmentDataSync (ProviderNPI,PatientID, FileURL,FileType,DataSyncID,AppointmentListingsID)
VALUES ('$providernpi', '$patientid','$fileurl','$filetype','$datasynid','$appointmentlistingid')");
mysql_query($query,$con);
printf("Records inserted: %d\n", mysql_affected_rows());
echo($patienid)
?>
