pdo statement to return more than 1 column in php

Question

I am trying to fetch values from a mysql query using PDO...it works with one column but I need to return 2 columns from the query. Below is the piece of code I have made...

try { $conn = new PDO('mysql:host=localhost;dbname=****', 'root', '****'>setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { echo 'ERROR: ' . $e->getMessage(); } $sth = $conn->prepare("select distinct prod_url,ean from tab_nl where ean in (select ean1 from test_sku where sku='$sku') and prod_url like '%prijzen%'"); $sth->execute(); $urlsku = $sth->fetchAll(PDO::FETCH_COLUMN, 0); $urlean = $sth->fetchAll(PDO::FETCH_COLUMN, 1); echo $sku; echo $urlsku; echo $urlean;

It returns me some array values...which I really can't figure out. Can anyone please help me with this.

You should add the array result also , that would help us to solve quickly — Aniruddha Chakraborty
– Aniruddha Chakraborty, Commented Jan 27, 2016 at 18:01

Jay Blanchard · Accepted Answer · 2016-01-27 18:16:35Z

If you use fetch() with the PDO::FETCH_ASSOC style it is easy to get both columns:

while($row = $sth->fetch(PDO::FETCH_ASSOC) { echo $row['prod_url']; echo $row['ean']; }

By placing the fetch in a loop all of the rows will be returned which you can then limit as you see fit.

Nick · Accepted Answer · 2016-01-27 17:56:27Z

0

$data = $sth->fetchAll(PDO::FETCH_ASSOC); echo $data[0]['prod_url']; echo $data[0]['ean'];

answered Jan 27, 2016 at 17:56

Nick

10.2k8 gold badges65 silver badges97 bronze badges

Comments

Aniruddha Chakraborty · Accepted Answer · 2016-01-27 17:59:33Z

Add LIMIT 2 in the query , to get two sets of result :)

try { $conn = new PDO('mysql:host=localhost;dbname=****', 'root', '****'>setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { echo 'ERROR: ' . $e->getMessage(); } $sth = $conn->prepare("select distinct prod_url,ean from tab_nl where ean in (select ean1 from test_sku where sku='$sku') and prod_url like '%prijzen%' LIMIT 2"); $sth->execute(); $urlsku = $sth->fetchAll(PDO::FETCH_ASSOC, 0); $urlean = $sth->fetchAll(PDO::FETCH_ASSOC, 1); print_r($urlsku); print_r($urlean);

If you do not loop through the results the two rows will not be returned. Besides, the OP wanted "2 columns", not 2 rows according to their clarifying comments.

Collectives™ on Stack Overflow

pdo statement to return more than 1 column in php

3 Answers 3

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Related