Pa Help naman Php+mysql convert to mysqli

[padayaw]

Sino po dito magaling.. pa convert sana sa php mysqli eto po source code.

$cnx = mysql_connect("localhost","marmar","elsa123") or die ("Cannt connect" . mysql_error() );
mysql_select_db("mardb", $cnx);
$sql = mysql_query("SELECT * FROM bukpage") or die ("Cannt connect" . mysql_error() );
while ($row = mysql_fetch_array($sql)) {
$row_array[] = $row['images'];
}
mysql_close($cnx);
$rand_images = $row_array[rand(0, count($row_array) - 1)];


Thanks po.

 

[zeegreatness]

paltan mo lang yung mga wordn na mysql na word ng mysqli sir

 

[padayaw]

yan din sabi sa akin. ayaw po sir. error po.

 

[yhatz006]

Hello TS, Check mo to link https://www.w3schools.com/php/php_mysql_select.asp baka sakaling makatulong.

 

[zeegreatness]

ano error sir

 

[thenth]

$cnx = new mysqli("localhost", "marmar", "elsa123", "mardb");
if ($mysqli->connect_errno) {
echo "Cannt connect" . $mysqli->connect_error;
}
$sql = $cnx->query("SELECT * FROM bukpage");
while ($row = mysqli_fetch_array($sql)) {
$row_array[] = $row['images'];
}
mysqli_close($cnx);
$rand_images = $row_array[rand(0, count($row_array) - 1)];