I need some help. I want to make a search engine using Ajax, so i came across XAjax. And also tried AdoDB, for the pager.
So, here it is:
[PHP]<?php
require_once("xajax/xajax_core/xajax.inc.php");
require_once("adodb/adodb.inc.php");
require_once("adodb/adodb-pager.inc.php");
$xajax = new xajax();
$xajax->registerFunction("buscar");
function buscar($ca, $cr, $tx, $nm){
if(empty($_POST['st']) && $ca == "" && $tx !== "" && $cr !== ""){
$r = "SELECT * FROM material WHERE `$cr` LIKE '%$tx%'";
}else{
if($tx == "" && $cr == "" && $ca == ""){
$r = "SELECT * FROM material";
}elseif($tx == "" && $cr == "" && $ca !== ""){
$rt = "SELECT * FROM material WHERE `tipo`='$ca'";
}elseif($ca == "" && $tx !== "" && $cr !== ""){
$r = "SELECT * FROM material WHERE `$cr`='$tx'";
}
}
$db = NewADOConnection('mysql');
$db->Connect('localhost', 'root-user', 'heregoesthepass', 'oblig');
$pager = new ADODB_Pager($db, $r);
$pager->Render($nm);
$objResponse = new xajaxResponse();
$objResponse->addAssign("SomeElementId","innerHTML", $newContent);
return $objResponse;
}
$xajax->processRequests();
$xajax->printJavascript();
?>[/PHP]
The sql queries are OK, but i am almost sure that the Xajax part isn't.
p.s: It is possible to use both AdoDB and XAjax at the same tiem like i did right ??