Get value from table... PHP/MySQL

Question

I have the following that returns data from my table...

    $query = dbConnect()->prepare("SELECT * FROM users a INNER JOIN actions b ON a.id = b.user_id WHERE a.id=:user_id");
    $query->bindParam(':user_id', $_SESSION['user_id']);
    $query->execute();


    if($row = $query->fetchAll()){
        $row['id'] = $_SESSION['user_id'];
    }

I want to print out every value in my 'check_id' column for the currently logged in user...

I've tried...

 if($row = $query->fetchAll()){
        $row['id'] = $_SESSION['user_id'];
        $checkValue = $row['check_id'];
    }

Only i receive...

Notice: Undefined index: check_id in /home/index.php on line 24

Printing the array shows my check_id value...

enter image description here

fetchAll() returns a multidimensional array, so try -> $checkValue = $row[0]['check_id'];. Or you could change to if($row = $query->fetch()){ — Sean
– Sean, Commented Oct 3, 2014 at 16:20

ʰᵈˑ · Accepted Answer · 2014-10-03 16:05:50Z

2

You need to;

Fetch all the results
Iterate through your result set

$arrResults = $query->fetchAll();
foreach($arrResults as $result) {
   echo $result['user_id'] . PHP_EOL;
}

answered Oct 3, 2014 at 16:05

ʰᵈˑ

11.4k3 gold badges31 silver badges50 bronze badges

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

Comments

Johan Snowgoose · Accepted Answer · 2014-10-03 16:04:21Z

0

To debug use print_r

if($row = $query->fetchAll()){
    print_r($row);
}

answered Oct 3, 2014 at 16:04

Johan Snowgoose

3943 silver badges6 bronze badges

1 Comment

Liam Over a year ago

I've updated my question with the reply @JohanSnowgoose

Collectives™ on Stack Overflow

Get value from table... PHP/MySQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related