Select data using PDO and a PHP function

Question

When I try to select one nome from my bd it doesn't show anything

That's the function to select a name:

public function searchName(){
    $db = new Conection();
    $query = $db->prepare("SELECT * FROM dog WHERE id = 1");
    $query->execute();
    $result = $query->fetchAll(PDO::FETCH_OBJ);
    foreach($result as $row)
    {
        return $row['name'];//return to getName

    }
}

here is the code from getName:

    require 'Conection.php';
    require 'model/Dog.php';

    $dog = new Dog;
    $res = $dog->searchName(1);

    echo $res;

The class Connection is ok.

Since it is an object you need to return $row->name; And you do not need a loop here. — Jay Blanchard
– Jay Blanchard, Commented May 8, 2015 at 13:05

Alex · Accepted Answer · 2015-05-08 13:05:49Z

2

Since you use PDO::FETCH_OBJ you should:

return $row->name;

And since you call:

$res = $dog->searchName(1);

Your function declaration must be:

public function searchName($id){
    $db = new Conection();
    $query = $db->prepare("SELECT * FROM dog WHERE id = ?");
    $query->bindParam(1,$id);
    $query->execute();

answered May 8, 2015 at 13:05

Alex

17.3k1 gold badge31 silver badges52 bronze badges

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

3 Comments

Jay Blanchard Over a year ago

I am just asking to make sure.

Alex Over a year ago

:-) just checked with php.net/manual/en/pdostatement.bindparam.php lokks ok. If any particular suggestion you are welcome

balslev Over a year ago

Maybe Jay prefer: $query = $db->prepare("SELECT * FROM dog WHERE id = :id"); $query->bindParam(':id',$id);

balslev · Accepted Answer · 2015-05-08 13:09:05Z

0

PDO::FETCH_ASSOC is $row['name']
but
PDO::FETCH_OBJ is $row->name

http://php.net/manual/en/pdostatement.fetch.php

answered May 8, 2015 at 13:09

balslev

3614 silver badges11 bronze badges

Comments

Nishant Solanki · Accepted Answer · 2015-05-08 13:15:24Z

0

there is some problem in your code, you are not using function arguments after passing it and here are just want one row to return than you should use $query->fetch not $query->fetchAll

your code should be like this

public function searchName($id){
    $db = new Conection();
    $query = $db->prepare("SELECT * FROM dog WHERE id = :id");
    $query->execute(array('id'=>$id)); // bind parameters for security
    $result = $query->fetch(PDO::FETCH_ASSOC);     // updated object with assoc... ie if obj used than return $result->name   
    return $result['name'];            
}

and than

echo $res = $dog->searchName(1);

edited May 8, 2015 at 13:15

answered May 8, 2015 at 13:08

Nishant Solanki

2,1283 gold badges19 silver badges32 bronze badges

Collectives™ on Stack Overflow

Select data using PDO and a PHP function

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related