How to insert data in mysql data base table
Posted
by
user1289538
on Stack Overflow
See other posts from Stack Overflow
or by user1289538
Published on 2012-03-24T05:25:17Z
Indexed on
2012/03/24
5:29 UTC
Read the original article
Hit count: 123
php
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)
?>
© Stack Overflow or respective owner