用PHP连接到我的数据库

Question

I want to connect my HTML page to my database but I”m not getting it not sure why. What’s wrong with the code?

<?php
$con = mysqli_connect("localhost","root","","sibd02");

$query = sprintf("SELECT*FROM fornecedor ",
$result = mysql_query($query);

if (mysqli_connect_errno()) {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 mysqli_close($con);


?>

Answer 1

Mixing MySQL and MySQLi won't work. You can simply do this:

<?php

/* ESTABLISH CONNECTION */

$con=mysqli_connect("localhost","root","","sibd02");

if(mysqli_connect_errno()){

echo "Error".mysqli_connect_error();

}

$query = "SELECT * FROM fornecedor";
$result = mysqli_query($con,$query); /* EXECUTE QUERY */

/* IF YOU WANT TO PRINT THE RESULTS, HERE IS AN EXAMPLE: */

while($row=mysqli_fetch_array($result)){

echo $row['column']." ".$row['column2']." ".$row['column3']; /* JUST REPLACE THE NECESSARY COLUMN NAME */

} /* END OF WHILE LOOP */

mysqli_close($con);

?>