echo '[' . implode(',', $json) . ']'; die(); // filthy exit, but does fine for our example. } else { user_error("Failed to select the database"); } }
?>
i have try to edit those code to this but not working..
Quote:
if (@$_REQUEST['ajax']) {
global $xoopsDB;
$results=$xoopsDB->query('select * from x620_xdir_select_chain where category="' . strtolower(mysql_real_escape_string(strip_tags($_REQUEST['category']))) . '"');
$json = array(); while (is_resource($results) && $row = $xoopsDB->fetch_object($results)) {
Greeting to all , i want to use a jquery ajax plugin: "auto populating select boxes" for a submit form of the mxdirectory modules.
i have upload the sql file and test it on the server out of xoops, it works correctly!
then i try to make this works on xoops,
1. i have place those html code to the modules html file,
2. upload the sql file that the plugin provided to xoops modules prefix.
3. in the templates theme.html, i have include the jquery.js and the select-chain.js file in the header
4.the select-chain.php file i have place it to root, theme templates, modules root , modules templates directory.. (because i don't know the script "url:select-chain.php" means where)
i have edited the php file but not working...
here r the orignal php code, like this: Quote:
if (@$_REQUEST['ajax']) {
// connect to local database 'test' on localhost
$link = mysql_connect('localhost', 'root', '');
if ($link == false) trigger_error('Connect failed - ' . mysql_error(), E_USER_ERROR); $connected = mysql_select_db('test', $link); if ($connected) { $results = mysql_query('select * from test.select_chain where category="' . strtolower(mysql_real_escape_string(strip_tags($_REQUEST['category']))) . '"');
$results=$xoopsDB->query('select * from x620_xdir_select_chain where category="' . strtolower(mysql_real_escape_string(strip_tags($_REQUEST['category']))) . '"');
$json = array(); while (is_resource($results) && $row = $xoopsDB->fetch_object($results)) {
Include this site, when u after login and the jgrowl pop up, the top of the search input box no respond... u need refesh the page, the problem will gone...
i m using php5.3, chrome, ie , firefox, opera, safr..... also the same....
when the jgrowl pop up, the background area that cover by the jgrowl pop up box, have no respond of hover and click...
even on this site too, when after login, that welcome message pop up and fade out, behind the pop up area if there are some links or else that can hover or click,
on this site, the top of the search box will no respond of hover and click after u login , because of the jgrowl message box , but when u refresh the brower it will be fine......
i use the latest ie, chrome, firefox, opera and safari tested....
where is the file of jgrowl? that i can move it to a space area.... till to a fix come out..