CODEWITHSUNDEEP
phpajax
headache
headache

Reputation: 133

Ajax message display issue

I think I've worked out that the issue relates to binding params for PDO instead of including the values in the select statement.

Now googling how to bind array values where there will be a variable number of them per query type. For example there may be one, two or three category (col) values sought.

My primary script submits an ajax request to a secondary script.

Two params are sent and are being received in most scenarios. eg department:mens-fashion, category:coats-and-jackets

In all but a few scenarios, the ajax query is successful and returns as expected. However, for some pairings of params, nothing is displayed in the page or in console.

Having returned from the query script immediately after building the query, I know the query is always working OK. (Copying and pasting into phpMyAmdin brings me the correct resultset.)

So it seems the key part of the script is the fetch routine. How can I catch an error message from PDO in the next line?...

$filtered_results = $filtered_statement->fetchAll(PDO::FETCH_ASSOC);

$debugInfo = array('debug' => vsprintf(str_replace("?", "%s", $filtered_statement->queryString), $opts ));

[edit]

if ( is_array($filtered_results) ) {
$filtered_results = array_merge($debugInfo, $filtered_results);
} else {
$filtered_results = $debugInfo;
}

[/edit]
debug info still only being returned if the query was a success.

$filtered_results_json = json_encode($filtered_results);

echo( $filtered_results_json );

Please would anyone point me to a solution where, the failed query will display in the calling script. The data required is in the db so I am still really stuck on trying to display failure messages.

Upvotes: 0

Views: 43

Answers (1)

rf1234
rf1234

Reputation: 1605

You need to check whether an array is returned or not. If nothing was found no array is being returned - and you can't use array_merge.

$filtered_results = $filtered_statement->fetchAll(PDO::FETCH_ASSOC);

$debugInfo = array('debug' => vsprintf(str_replace("?", "%s", $filtered_statement->queryString), $opts )); 

if ( is_array($filtered_results) ) {
    $filtered_results = array_merge($debugInfo, $filtered_results);
} else {
    $filtered_results = $debugInfo;
}

$filtered_results_json = json_encode($filtered_results);

echo( $filtered_results_json );

See this as well: Value return when no rows in PDO

Upvotes: 1

Related Questions