Problema base de datos

Code: Select all

$dblink = mysql_connect('192.168.x.x', 'opencart', 'opencart') or die( mysql_error() );
mysql_select_db('opencart');
 
$rs = mysql_query('select descripcion from transporte where descripcion like "'. mysql_real_escape_string($_REQUEST['term']) .'%" order by descripcion asc', $dblink);
// loop
$data = array();
if ( $rs && mysql_num_rows($rs) )
{
   while( $row = mysql_fetch_array($rs, MYSQL_ASSOC) )
   {
      $data[] = array('value' => $row['descripcion']);
   }
}
 
// jQuery wants JSON data
echo json_encode($data);
flush();

Code: Select all

$query = $this->db->query("SELECT descripcion from transporte where descripcion like '". mysql_real_escape_string($_REQUEST['term']) ."%' order by descripcion asc");
$products = array();
if ($query->num_rows > 0) {
    foreach ($query->rows as $result) {
        $products[] = array('value' => $result['descripcion']);
    }
}

// jQuery wants JSON data
echo json_encode($products);
flush();

Code: Select all

$dblink = mysql_connect('192.168.x.x', 'opencart', 'opencart') or die( mysql_error() );
mysql_select_db('opencart');
 
$rs = mysql_query('select descripcion from transporte where descripcion like "'. mysql_real_escape_string($_REQUEST['term']) .'%" order by descripcion asc', $dblink);

Code: Select all

$rs = $this->db->query("SELECT descripcion from transporte where descripcion like '". mysql_real_escape_string($_REQUEST['term']) ."%' order by descripcion asc");

Code: Select all

<script type="text/javascript" src="catalog/view/javascript/transporte.js"></script>
Transporte:
<input id="id_transporte" type="text" name="id_transporte" value="<?php include('catalog/model/checkout/transporte_defecto.php'); ?>"><br> 

Code: Select all

jQuery(document).ready(function(){
            $('#id_transporte').autocomplete({
            source:'catalog/model/shipping/transporte.php', minLength:1});
        });

Code: Select all

<?php
$dblink = mysql_connect('192.168.0.8', 'opencart', 'opencart') or die( mysql_error() );
mysql_select_db('opencart'); 
$term = trim(strip_tags($_GET['term']));
$resultado = mysql_query("SELECT * from transporte where descripcion LIKE '%".$term."%'");
		
$data = array();
if ( $resultado && count($resultado) )
{
	while( $row = mysql_fetch_array($resultado, MYSQL_ASSOC) )
	{
		$data[] = array('label' => $row['descripcion']);
	}
}
echo json_encode($data);
flush();
?>

Code: Select all

$dblink = mysql_connect('192.168.0.8', 'opencart', 'opencart') or die( mysql_error() );
mysql_select_db('opencart'); 

Code: Select all

require_once('../../../config.php');
require_once(DIR_SYSTEM . 'startup.php');

$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

Code: Select all

<?php 
				include('catalog/model/shipping/transporte.php'); 
				if (in_array($this->db->escape($data['id_transporte']), $data)) { ?>
				<div id="payment"><?php echo $payment; ?></div>
				<?php } else { ?>
				<span style=";font-family:sans-serif;font-size:16px;color:red;" >
				Atencion, el transporte <?php echo $this->db->escape($data['id_transporte']); ?> no es correcto, revise su pedido, gracias!
				</span>
				<?php } ?>