marmeladenkoch
New Member
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...\[code\]$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); \[/code\]UPDATE:I would do something like this with sprinf\[code\]$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 />";\[/code\]