PEAR DB prepare/bind values

Question

Just can't seem to print the binded values without executing the query. Looking to debug the query before execution. Any tips? I know I'm overlooking something simple, ugh...

$field1 = 'one';
$field2 = 'two';
$field3 = 'three';

$fields  = 'SET ';
$fields .= 'field1 = ?, ';
$fields .= 'field2 = ?, ';
$fields .= 'field3 = ? ';

$vals[] = $field1;
$vals[] = $field2;
$vals[] = $field3;

$sql = 'UPDATE table_name '.$fields.' WHERE id = 123';
$dbh = $db->prepare($sql);

// this binds and executes the query but I would like to print the query with the bind values before executing
$results = $db->execute($dbh, $vals);

UPDATE:

I would do something like this with sprinf

$field1 = 'one';
$field2 = 'two';
$field3 = 'three';

$fields  = 'SET ';
$fields .= 'field1 = %s, ';
$fields .= 'field2 = %s, ';
$fields .= 'field3 = %s ';

$vals[] = $field1;
$vals[] = $field2;
$vals[] = $field3;

$sql = 'UPDATE table_name '.$fields.' WHERE id = 123';

$query = sprintf($sql, $field1, $field2, $field3);
echo "Query before execution: ".$query."<br />";

there is no $db->field(), could you explain? – Phill Pafford Sep 30 '10 at 18:41 — Phill Pafford, Sep 30 '10 at 18:41
The naming of `$feilds` _is_ consistant, albeit confusing. – Wrikken Sep 30 '10 at 18:46 — Wrikken, Sep 30 '10 at 18:46
crap, typo, ugh!!! sry quick copy/paste – Phill Pafford Sep 30 '10 at 18:51 — Phill Pafford, Sep 30 '10 at 18:51

score 1 · Accepted Answer · edited May 23 '17 at 10:33

1

You can't get the values inside the query like that. The way the server handles prepared queries is different.

The best you could do is:

echo $sql;
print_r($vals);

Retrieve (or simulate) full query from PDO prepared statement

edited May 23 '17 at 10:33

Community

1
1

answered Sep 30 '10 at 18:38

Galen

29,976
9
71
89

no I understand I can print them in separate lines, I want to print the query as it would be executed, before I execute – Phill Pafford Sep 30 '10 at 18:40
that's why i stated that you cant do that – Galen Sep 30 '10 at 18:51
can I mix PDO and Pear? something like $dbh->bindValue(':field1', $field1, PDO::PARAM_STR); – Phill Pafford Sep 30 '10 at 18:59
Looks like there is a bug, ugh. no real solution to do what I wanted – Phill Pafford Oct 01 '10 at 15:54

PEAR DB prepare/bind values

1 Answers1