16.) Write a program using while loop
$my_qry = mysql_query("SELECT * FROM `users` WHERE `u_id`='1'; ");
while($result = mysql_fetch_array($my_qry))
{
echo $result['First_name'.]."<br/>";
}
17.) How to create a mysql connection?
mysql_connect(servername,username,password);
18.) How to select a database?
mysql_select_db($db_name);
19.) How to execute an sql query? How to fetch its result ?
$my_qry = mysql_query("SELECT * FROM `users` WHERE `u_id`='1'; ");
$result = mysql_fetch_array($my_qry);
echo $result['First_name'];
20.) what types of loops exist in php?
for,while,do while and foreach (NB: You should learn its usage)
$my_qry = mysql_query("SELECT * FROM `users` WHERE `u_id`='1'; ");
while($result = mysql_fetch_array($my_qry))
{
echo $result['First_name'.]."<br/>";
}
17.) How to create a mysql connection?
mysql_connect(servername,username,password);
18.) How to select a database?
mysql_select_db($db_name);
19.) How to execute an sql query? How to fetch its result ?
$my_qry = mysql_query("SELECT * FROM `users` WHERE `u_id`='1'; ");
$result = mysql_fetch_array($my_qry);
echo $result['First_name'];
20.) what types of loops exist in php?
for,while,do while and foreach (NB: You should learn its usage)