dear mam/sir please tell me how to solve my errors which i asked long back because after connection of database i cant able to see the inserted values in database
connected!Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\ANUPHP\mysql\mysql.php on line 4code here<?phprequire ("connect.php");$date =("Y-M-D");$write = mysqli_query("INSERT INTO mydata VALUES(' ','anusha','merugu','$date','female')");?>
After running the code gives no output. No value stores in a table.
9210 visits
Outline:MySQL (Part 3) Writing some data into the database (INSERT and UPDATE Queries). mysql_query('TYPE_HERE_YOUR_MYSQL_QUERY') - This function is used to run specific queries on our database. INSERT QUERY - INSERT into table values ('att1', 'att2' , 'att3', 'att4' ,'att5') //Inserts Data into the table UPDATE QUERY - UPDATE table_name SET att1='xyz' //Updates the Existing values stored in the table of the database.
MySQL (Part 3) Writing some data into the database (INSERT and UPDATE Queries). mysql_query('TYPE_HERE_YOUR_MYSQL_QUERY') - This function is used to run specific queries on our database. INSERT QUERY - INSERT into table values ('att1', 'att2' , 'att3', 'att4' ,'att5') //Inserts Data into the table UPDATE QUERY - UPDATE table_name SET att1='xyz' //Updates the Existing values stored in the table of the database.
Show video info
Pre-requisite