In php and mysql, insert an error directly in mysql... when written to php, the following error occurs: & nbsp; mysqli_query () & nbsp; expects & nbsp; at & nbsp; least & nbsp; 2 & nbsp; parameters, & nbsp; 1 & nbsp; given & nbsp; in & nbsp; D: xampphtdocsca php, mysql insert error
Insert this statement directly in mysql... when written to php, the following error occurs: Warning: mysqli_query () expects at least 2 parameters, 1 given in D: \ xampp \ htdocs \ ca \ connect. php on line 12
Line 12 in the error indicates $ res = mysqli_query ($ SQL) in the php code. this line
$ Mysql = mysqli_connect ("localhost", "root", "", "leo ");
$ SQL = "insert into doc (name, size, loc) values ('name1', 'size1 ', 'loc1 ')";
$ Res = mysqli_query ($ SQL );
If ($ res = TRUE)
{
Echo 'insert ';
}
Else echo 'insertion failed ';
Mysqli_close ($ mysql );
?>
------ Solution --------------------
Function prototype
Mixed mysqli_query (mysqli link, string query [, int resultmode])
Link cannot be default
Writing
$ Res = mysqli_query ($ mysql, $ SQL );
------ Solution --------------------
Mysqli_query ($ mysql, $ SQL); // Two parameters are required
Learn to query manual