GetArray with $inputarr

[rotezecke]

I'm using GetArray method with an input array

Code: Select all

SELECT * FROM quotes_booked qb WHERE qb.qb_webquote_id = ? ORDER BY qb.qb_id ASC

and my array looks like this:

Code: Select all

Array
(
    [0] => 10285
    [1] => 10286
)

I know there is a result for 10285, and I know there is NO result for 10286.

Code: Select all

$bookingsArray = $db->GetArray($bookings_sql,$bookings);

the return array is entirely empty though. What am I doing wrong?

[rotezecke]

I have since modified my sql to build a string of IDs instead of the $inputarr.

Code: Select all

SELECT * FROM quotes_booked qb WHERE qb.qb_webquote_id IN ($bookingsStr) ORDER BY qb.qb_id ASC

This works as expected. Still wonder how to use the $inputarr correctly though.

[Jo Morg]

Apart from the fact that you didn't offer any clue of what the table structure is, including its name and prefix, if any, along with the columns names, which doesn't allow me to exclude any possible SQL syntax error, there is a misinterpretation of what $db->GetArray() actually does:

• the GetArray method returns an array of values which represent a result or set of results for the query (the 1st argument the method takes);
• Assuming that your SQL query is correct, the ? represents a placeholder, binding to a value, which has to be set on the second argument of the method, in the form of an array: the relationship has to be one to one i.e. one value in the array for each placeholder ? in the query string and in the same order as they occur in the said string;

For your code to work you'd have to go with:

Code: Select all

$bookingsArray = $db->GetArray($bookings_sql,array($webquote_id));

Or using the alternate PHP syntax:

Code: Select all

$bookingsArray = $db->GetArray($bookings_sql,[$webquote_id]);

Again assuming that your sql query is correct, you are requesting any existing booking with a qb_webquote_id === $webquote_id which all being as expected should be no more than one.

HTH

[rotezecke]

Thanks, so each element in my argument array stands for a ? in the SQL? So there will only ever be one result set. That is different to what I assumed it to be. Thanks for clearing this up.

[Jo Morg]

Yes to your 1st question, no to the 2nd. The query determines the result set in terms of rows and columns to be returned in the array.