This is my PHP code which is not inserting record and always display false.
$con = mysqli_connect("localhost", "XXX", "XXX", "vital");
$fieldName = implode(",",array_keys($data));
$values = '"'.implode('","', array_values($data)).'"';
echo $query = "insert into ".$table." (".$fieldName.") values(".$values.")";
if(mysqli_query($con,$query))
echo "<br>true";
else
echo "<br>false";
It's equivalent SQL query which I directly write into phpmyadmin which is work perfect. Below SQL query which is generated by echo $query
insert into patient
(patient_id,opd_id,patient_name,hospital_name,plot_from_file,entry_date)
values("1234","1233","456","temp","false","2014-08-20");
The above query will work perfect in phpmyadmin.
Please try this one
`<?php
$con=mysql_connect("localhost","xxx","xxx");
if(!$con)
{
die("could not connect".mysql_error());
}
mysql_select_db("DB Name",$con);
?>`
<?php
$sql="INSERT INTO patient
(patient_id,opd_id,patient_name,hospital_name,plot_from_file,entry_date)
values("1234","1233","456","temp","false","2014-08-20"); ?>