Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Autocomplete JQuery and special characters


Andromeda100

Recommended Posts

Posted

Hi,

 

I installed the contrib "Autocomplete JQuery. I like the contrib, but it does't work for products with special characters like Ö, Ü, Ä and so on. I tried to customize but I havn't found any solution.

 

Could anyone help me, please?

 

This is my autocomplete.php

 

<?php
require('includes/application_top.php');

$return_arr = array();
$fetch = tep_db_query("select * from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id WHERE p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pd.products_name LIKE '%" . $_GET['term'] . "%'");


while ($row = mysql_fetch_assoc($fetch)) {
$test=$row['products_name'];
		   array_push($return_arr, $test);
}  
print json_encode($return_arr);
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...