PDO array result as php variable

Question

Is it possible to set a PDO result as a PHP $variable and use it outside the PDO query? Here is what I am trying to do:

SQL database contains:

names:
John
Peter
Allen

My code looks like this:

$conn = new PDO("mysql:host=$host;dbname=$db_name",$username,$password);
$conn->query('SET NAMES UTF8');
$sql = "SELECT * FROM $tbl_name";
$q = $conn->prepare($sql);
$q->execute(array($title));
$q->setFetchMode(PDO::FETCH_BOTH);

while($data = $q->fetch()){
$phpvar = "$data[names], ";
}

echo $phpvar;

The result I want from "echo $phpvar;" is:

John, Peter, Allen

Table and Column names cannot be replaced by parameters in PDO. — Saty
– Saty, Commented Nov 28, 2015 at 9:37

roullie · Accepted Answer · 2015-11-28 09:32:27Z

1

declare $phpvar before the loop and concat the values to it.

$phpvar = '';
while($data = $q->fetch()){
    $phpvar .= "$data[names], ";
}
echo $phpvar;

answered Nov 28, 2015 at 9:32

roullie

2,82019 silver badges26 bronze badges

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

1 Comment

CitronAutobot Over a year ago

AAAAAND we have a winner! This worked like a charm! :D Thanks a million!

Prafulla Kumar Sahu · Accepted Answer · 2015-11-28 09:36:47Z

0

just declare a empty array and use it like below.

 $phpvar = array();

    while($data = $q->fetch()){
        array_push($phpvar, $data[names]);
    }

answered Nov 28, 2015 at 9:36

Prafulla Kumar Sahu

9,75911 gold badges78 silver badges116 bronze badges

3 Comments

CitronAutobot Over a year ago

I just get "array" as a result when i try to "echo $phpvar;"

Prafulla Kumar Sahu Over a year ago

@CitronAutobot use var_dump( $phpvar );

Prafulla Kumar Sahu Over a year ago

@CitronAutobot if you want it as a string use implode() and for a json object you can use json_encode() .

Professor Abronsius · Accepted Answer · 2015-11-28 09:47:52Z

0

A variation on a theme but as already mentioned, declare the variable that you wish to use later and populate in the loop

$phpvar=array();
while( $rs=$q->fetch() ) $phpvar[]=$rs->names;

print_r( $phpvar );

answered Nov 28, 2015 at 9:47

Professor Abronsius

33.9k5 gold badges36 silver badges49 bronze badges

Comments

Aniruddha Chakraborty · Accepted Answer · 2015-11-28 10:14:22Z

0

PDO is throwing an object . So you have to do this on while loop after giving a null value in $phpvar , then you have to use rtrim()

$conn = new PDO("mysql:host=$host;dbname=$db_name",$username,$password);
$conn->query('SET NAMES UTF8');
$sql = "SELECT * FROM $tbl_name";
$q = $conn->prepare($sql);
$q->execute(array($title));
$q->setFetchMode(PDO::FETCH_BOTH);
$phpvar = '';

while($data = $q->fetchAll()){
$phpvar .= $data->names;
$phpvar .= ',';
}

echo rtrim($phpvar, ",");

edited Nov 28, 2015 at 10:14

answered Nov 28, 2015 at 9:44

Aniruddha Chakraborty

1,8621 gold badge22 silver badges33 bronze badges

2 Comments

CitronAutobot Over a year ago

Thanks, but this doesn't give any results at all. Just a blank screen. What could I be doing wrong?

Aniruddha Chakraborty Over a year ago

just Edited the answer .. if you still didn't get the deserved answer . I think your should check the error reporting is turned on or not :-/

AbraCadaver · Accepted Answer · 2015-12-03 16:56:57Z

0

Aside from the fact that your query will fail and that you are setting PDO::FETCH_BOTH which is the default and will give you duplicate results in your string, just use implode(). It's also easier to just use fetchAll():

$data = $q->fetchAll(PDO::FETCH_ASSOC);
$phpvar = implode(', ', $data);

answered Dec 3, 2015 at 16:56

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Collectives™ on Stack Overflow

PDO array result as php variable

5 Answers 5

1 Comment

3 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

3 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related