Can't execute a MySQL request in my PHP function

Asked Feb 12 '18 at 00:40

Active Feb 12 '18 at 01:03

Viewed 38 times

Hi I can execute my code in my main page but I want to make an include page with all of my function. When I execute this code in the main page that work. But when I try to execute a MySQL request in a function it doesn't work...

include('databaseConnexion.php'); 

function showFirstname($idUser)
{

    $users = $bdd->query("SELECT * FROM user WHERE id = '" . $idUser . "'");
    while ($user_info = $users->fetch())
    { 
      echo $user_info['firstname']; 
    }

}

edited Feb 12 '18 at 01:03

Valdeir Psr

asked Feb 12 '18 at 00:40

Matthew Touz

1

Are you including databaseConnexion.php on pages that do not work? – Valdeir Psr Feb 12 '18 at 00:43
1

Are you using PDO or MySQLi? Show "databaseConnexion.php" too. – Feb 12 '18 at 00:52
Are you including the main page in other pages too? – Feb 12 '18 at 00:54
1

http://php.net/manual/en/language.variables.scope.php – Paul Spiegel Feb 12 '18 at 01:05
1

"doesn't work" is not a good problem statement. – Paul Spiegel Feb 12 '18 at 01:08
How do you declare the `$bdd`? we must see the included file code. – Dee Feb 12 '18 at 01:24
Hi, this is my databaseConnexion.php getMessage()); } ?> – Matthew Touz Feb 12 '18 at 02:53

Can't execute a MySQL request in my PHP function

0 Answers0