MySQL Part 3 - English

This is a sample video. To access the full content,
please Login

Questions posted on Forums
PHP and MySQL Tutorials - English

Questions posted on ST Forums:

mysql database connection
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
03-04M 30-40S SHARINI2000

Answer last updated on: Jan. 17, 2022, 5:02 p.m.
database connected but while executing the query getting some warning message plz check and give replay sir
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')");?>
03-04M 20-30S anushamerugu

Answer last updated on: Jan. 17, 2022, 4:40 p.m.
Giving no output
After running the code gives no output. No value stores in a table.
03-04M 50-60S 181040107034@gperi.ac.in

Answer last updated on: Feb. 24, 2020, 3:28 p.m.

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.