PHP Mysql echoing data in one column from multiple rows

Question

My MySQL table looks like this:

MySQL Table

and I want to retrieve the data from the column 'host' from where uid is equal to twenty.

I have some code that will connect to the database and will return the row when uid is equal to twenty

DB.php:

public function query($sql, $params = array()){
    $this->_error = false;
    if($this->_query = $this->_pdo->prepare($sql)){
        $x = 1;
        if(count($params)){
            foreach($params as $param){
                $this->_query->bindValue($x, $param);
                $x++;
            }
        }

        if($this->_query->execute()){
            $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
            $this->_count = $this->_query->rowCount();
        } else {
            $this->_error = true;
        }
    }

    return $this;
}

public function results(){
    return $this->_results;
}

server.php:

public static function get($uid){
    $_db = DB::getInstance();
    $data = $_db->get('servers', array('uid', '=', $uid));

    return $data->results();
}

cURL.php:

$a = Server::get('20');
var_dump($a);

The var_dump on the return gives the following: PHP var_dump return

array(2) { [0]=> object(stdClass)#5 (4) { ["sid"]=> string(2) "13" ["host"]=> string(12) "example.home" ["port"]=> string(4) "8081" ["uid"]=> string(2) "20" } [1]=> object(stdClass)#6 (4) { ["sid"]=> string(3) "153" ["host"]=> string(15) "stream.as.ag.ca" ["port"]=> string(5) "23434" ["uid"]=> string(2) "20" } }

Note: If this question has already been answered somewhere else, could a link be provided as I couldn't find the answer.

Actually I zoomed in so nevermind, might be useful for other users to be able to see it though. The data is there are you having issues iterating through it? Look into foreach. — chris85
– chris85, Commented May 29, 2015 at 18:15
Yes, I have issues on how to go through the data and then extract the 'host'. — meun5
– meun5, Commented May 29, 2015 at 18:16

chris85 · Accepted Answer · 2015-05-29 18:54:27Z

1

I think you should be able to pull each host with this.

foreach($a as $row) {
    echo $row->host;
}

edited May 29, 2015 at 18:54

answered May 29, 2015 at 18:36

chris85

23.9k7 gold badges36 silver badges51 bronze badges

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

3 Comments

meun5 Over a year ago

It's returning the following error: Catchable fatal error: Object of class stdClass could not be converted to string in cURL.php at the line echo $data

chris85 Over a year ago

Hmm haven't used the FETCH_OBJ before, how about this update?

meun5 Over a year ago

what are you referring to?

Collectives™ on Stack Overflow

PHP Mysql echoing data in one column from multiple rows

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related