Search behavior

After MySQLi update the search behavior no longer works (page is blank with no error message).

I suspect the search behavior did not update. In the panel it says "DataAssist Search (Unknown)". When I click the behavior to update, it lets me choose the recordset but then throws an error and does nothing.

File in PM.

The search code on lines 31 to71 is still mySQL not MySQLi. You may want to delete it and re-apply the mySQLi search code.

You also have a mySQL recordset on lines 166-186 that would need to be updated.

I have deleted and re-added the search behavior. The page is still blank without a hint what's wrong. The way the page is set up, there is a little search box at the top of every page, that redirects to search.php.

The other recordset does not show up in the behavior panel. I tried deleting the spaces, but it still didn't show up. In the attached file the spaces are not deleted.

Since that recordset code was completely hand coded, it won't be able to be opened and updated through Dreamweaver. You would have to delete it and re-create it from scratch. You can copy the SQL statement and paste it into a new recordset SQL pane using the Advanced Recordset dialog.

I should have thought of that. It's done, but the page is still blank.

This code:

<?php

$rsCountryDetection = new WA_MySQLi_RS("rsCountryDetection",$connSegufixNew,1);

$rsCountryDetection->setQuery("SELECT                  c.hide_button, c.country              FROM                  ip2nationCountries c,                 ip2nation i              WHERE                  i.ip < INET_ATON("' . $_SERVER['REMOTE_ADDR'] . '")                  AND                  c.code = i.country              ORDER BY                  i.ip DESC              LIMIT 0,1'");

$rsCountryDetection->execute();

?>

should be:

<?php

$rsCountryDetection = new WA_MySQLi_RS("rsCountryDetection",$connSegufixNew,1);

$rsCountryDetection->setQuery("SELECT c.hide_button, c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < INET_ATON(?) AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1'");

$rsCountryDetection->bindParam("s", "".($_SERVER['REMOTE_ADDR'])  ."", "-1"); //varRemoteAddr

$rsCountryDetection->execute();

?>

<?php

$hide_button = $rsCountryDetection->getColumnVal("hide_button");

$countryName = $rsCountryDetection->getColumnVal("country");

?>

This post has been deleted.

I have updated the search behavior. All is looking good except for one issue.

The search returns all recordsets instead of a meaningful result. If I search for an item no., it returns all items. The behavior looks like this:

<?php
$searchRecordset1_1 = new WA_MySQLi_Search("Recordset1","");
if ((((isset($_POST["WADbSearch1"]))?$_POST["WADbSearch1"]:"") != "")) {
$searchRecordset1_1->clearSearch();
$searchRecordset1_1->setSearch(array("type"=>"Key", "comparison"=>"=", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("item_no_short", "item_no_short_2", "item_no_short_3", "item_no_short_4", "item_no_short_5", "name", "application", "application2", "application3", "application4", "application5", "application6", "info1", "info2", "info3", "info4", "info5", "info6", "contents", "contents2", "contents3", "contents4", "contents5", "contents6"), "s", "");
}
?>

Line 34 you have:

$searchRecordset1_1->setSearch(array("type"=>"Key", "comparison"=>"=", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("item_no_short", "item_no_short_2", "item_no_short_3", "item_no_short_4", "item_no_short_5", "name", "application", "application2", "application3", "application4", "application5", "application6", "info1", "info2", "info3", "info4", "info5", "info6", "contents", "contents2", "contents3", "contents4", "contents5", "contents6"), "s", "");

You should have:

$searchRecordset1_1->setSearch(array("type"=>"Key", "comparison"=>"=", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("item_no_short", "item_no_short_2", "item_no_short_3", "item_no_short_4", "item_no_short_5", "name", "application", "application2", "application3", "application4", "application5", "application6", "info1", "info2", "info3", "info4", "info5", "info6", "contents", "contents2", "contents3", "contents4", "contents5", "contents6"), "s", "".($_POST["search"])  ."");