MSQL to MYSQLI converter

Question

I'm not familiar with MySQLi

<?php
    $bestaat = mysql_query("SELECT * FROM badgesdownload LIMIT 7");  
    while($bestaat2 = mysql_fetch_array($bestaat)) {
        $bestaat3 = $bestaat2['naam'];
        $txt = mysql_query("SELECT * FROM badgesdownload WHERE naam = '".$bestaat3."'"); 
        while($txt2 = mysql_fetch_array($txt)){
            $txt3 = $txt2['txt'];   
            echo $bestaat3; 
            echo'<br>';
            echo $txt3;
            echo'<br>';
        }
    }
?>

How can I change this script to mysqli?

MaggsWeb · Answer 1 · 2015-07-08T20:49:44.543

0

Mysqli - procedural method is fairly similar. Just add your database connection as the first parameter to a query, and an 'i' in all the functions...

$bestaat = mysqli_query($db, "SELECT * FROM badgesdownload LIMIT 7");

while($bestaat2 = mysqli_fetch_array($bestaat)) {
    $bestaat3 = $bestaat2['naam'];
    $txt = mysqli_query($db, "SELECT * FROM badgesdownload WHERE naam = '$bestaat3'");
    while($txt2 = mysqli_fetch_array($txt)){              
        echo $bestaat3.'<br>'.$txt2['txt'].'<br>';
    }
}

I have also fixed some obvious errors.. ..missing close braces was the main one.

edited Jul 08 '15 at 20:49

answered Jul 08 '15 at 20:27

MaggsWeb

3,018
1
13
23

Hi, Sorry but the script is not working – Tom Lammers Jul 08 '15 at 20:41
Sorry but the code is still not working. – Tom Lammers Jul 08 '15 at 20:58
Its your code - I just converted it to mysqli_... Whats not working? – MaggsWeb Jul 08 '15 at 21:06
The mysql code works, But the mysqli code not? – Tom Lammers Jul 08 '15 at 21:07
Have you named your database handle $db..? – MaggsWeb Jul 08 '15 at 21:09
Look this is working http://prntscr.com/7qfnr3 – Tom Lammers Jul 08 '15 at 21:16
Comment your dbConnect function, and the call to it, execpt for the line starting with $link. (This is your db handle.) Change to mysqli_connect. Leave the mysqli_select_db line in as well. This also needs $link as the first parameter. Does this work now? – MaggsWeb Jul 08 '15 at 21:42
Look at the picture, Van you change it to mysqli? This script works namely – Tom Lammers Jul 09 '15 at 11:00
@TomLammers mate - we're here to help, but you have to help us to help you. "It's not working" doesn't help me help you. What error are you getting? – MaggsWeb Jul 09 '15 at 11:10
I see no error only a white page – Tom Lammers Jul 09 '15 at 11:31
So look in the error.log – MaggsWeb Jul 09 '15 at 14:05

MSQL to MYSQLI converter

1 Answers1