Return array pulled from MySQL using PHP

Question

I am trying to pull all badges associated to a particular user that is logged into my site. On my index.php page I have,

<?php
     include_once 'includes/db_connect.php';
     include_once 'includes/functions.php';
     print_r(get_badges($_SESSION['user_id'], $mysqli));
?>

My db_connect.php:

$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);

and on my functions.php I have,

<?php
function get_badges($u, $mysqli){
     $badges[] = array();

     if ($mysqli->connect_errno) {
        printf("Connect failed: %s\n", $mysqli->connect_error);
        exit();
    }

    $query = "SELECT * FROM memBadges WHERE ownerId = $u";

    if ($result = $mysqli->query($query)) {

        while ($row = $result->fetch_assoc()) {
            $badges[] = $row["badgeId"]);
        }
    }

$mysqli->close();

return $badges;
}
?>

The problem is that the piece in the functions.php page makes my page go blank. When I remove it, the page looks normal. What am I doing wrong?

maybe there is a syntax error somewhere, but the message is suppressed by the server? — user2291398
– user2291398, Commented Jan 21, 2015 at 3:45
How do you use $mysqli inside the function get_badges() if it is not defined as global ? — Oleg Dubas
– Oleg Dubas, Commented Jan 21, 2015 at 3:46
This is up on a hosted server and I added " ini_set('display_errors',1); error_reporting(E_ALL); " and I'm not seeing any error reporting, even in the error_log. — Prock
– Prock, Commented Jan 21, 2015 at 4:00
@Prokzy, try debuggung. Add echo 123; exit; as the first line of the script. Run. See 123? Now move it a line below. Continue until you know what causes the script to die. Tell us. — Oleg Dubas
– Oleg Dubas, Commented Jan 21, 2015 at 4:13

Kanishka Panamaldeniya · Accepted Answer · 2015-01-21 04:13:32Z

1

You have syntax error in your code . change

$badges[] = $row["badgeId"]);

to

$badges[] = $row["badgeId"];

and also change

$badges[] = array(); to $badges = array();

answered Jan 21, 2015 at 4:13

Kanishka Panamaldeniya

17.6k31 gold badges128 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prock Over a year ago

Wow, I missed that. Thank you.

Oleg Dubas Over a year ago

@Prokzy, Sure! Good luck coding

Collectives™ on Stack Overflow

Return array pulled from MySQL using PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related