MySQL Part 3 - Gujarati

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

Questions posted on Forums
PHP and MySQL Tutorials - Gujarati

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 (પાર્ટ 3)

 અમુક ડેટા ડેટાબેઝમાં લખવું (ક્વેરિ સુધારિત અને ઉમેરવી ).
mysql_query('TYPE_HERE_YOUR_MYSQL_QUERY') - આ ફંક્શન આપણા ડેટાબેઝમાં વિશિષ્ઠ ક્વેરી વાપરવા માટે વપરાય છે.
INSERT QUERY - ટેબલ વેલ્યુમાં સમાવિષ્ઠ કરવું ('att1', 'att2' , 'att3', 'att4' ,'att5') //ટેબલમાં ડેટા દાખલ કરવા.
UPDATE QUERY - UPDATE table_name SET att1='xyz' // ડેટાબેઝના ટેબલમાં  રહેલ હાલની વેલ્યુ અપડેટ કરવી.