$con = mysql_connect("localhost", "root", "");
$db = mysql_select_db("dbname", $con);
$q = "select*from tablename";
$qry = mysql_query($q);
can you please help me to convert this mysql query to mysqli
Asked
Active
Viewed 44 times
-4
-
There are so many solutions available on net – Ashu Feb 19 '19 at 11:00
-
@Ashu - What's wrong to have a solution on SO? Do you have a duplicate reference? – Paul Spiegel Feb 19 '19 at 11:12
-
@PaulSpiegel this question posted without any research. – Ashu Feb 19 '19 at 11:14
-
@Ashu - The same is true for almost all popular questions. https://stackoverflow.com/questions/tagged/php?sort=votes&pageSize=50 – Paul Spiegel Feb 19 '19 at 11:20
1 Answers
0
Use like
// mysqli_connect(host,username,password,dbname,port,socket);
$con = mysqli_connect("localhost", "root", "", "your_db");
// mysqli_select_db(connection, dbname);
$db = mysqli_select_db($con, "dbname");
$q = "select*from tablename";
// mysqli_query(connection,query,resultmode);
$qry = mysqli_query($con, $q);
Refer below docs
vishuB
- 4,173
- 5
- 31
- 49