MySQL Part 3 - Punjabi

Questions posted on Forums
PHP and MySQL Tutorials - Punjabi

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 ) 

ਡਾਟਾਬੇਸ ਵਿੱਚ ਕੁੱਝ ਡਾਟਾ ਲਿਖਣਾ  ( INSERT ਅਤੇ UPDATE queries ) 
mysql_query ( TYPE_HERE_YOUR_MYSQL_QUERY )   -   ਆਪਣੇ ਡਾਟਾਬੇਸ ਉੱਤੇ ਵਿਸ਼ੇਸ਼ query ਰਨ ਕਰਨ ਲਈ ਇਸ ਫੰਕਸ਼ਨ ਦਾ ਪ੍ਰਯੋਗ ਹੁੰਦਾ ਹੈ ।  
INSERT QUERY – ਟੇਬਲਸ ਵੈਲਿਊਜ਼ ਵਿੱਚ ਸ਼ਾਮਿਲ  ਕਰਨਾ  ( att1 ,  att2  ,  att3 ,  att4  , att5 )   /  / ਟੇਬਲ ਵਿੱਚ ਡਾਟਾ ਸ਼ਾਮਿਲ ਕਰਨਾ ।  
UPDATE QUERY  -  UPDATE table_name SET att1 = xyz  /  / ਡਾਟਾਬੇਸ ਦੇ ਟੇਬਲ ਵਿੱਚ ਸਟੋਰ ਵੈਲਿਊਜ਼ ਨੂੰ ਅਪਡੇਟ ਕਰਦਾ ਹੈ ।