Skip to content

Instantly share code, notes, and snippets.

@aranajhonny
Last active December 7, 2016 00:54
Show Gist options
  • Save aranajhonny/ba291025585558119d8791161c94757a to your computer and use it in GitHub Desktop.
Save aranajhonny/ba291025585558119d8791161c94757a to your computer and use it in GitHub Desktop.
asegura de tener jquery ui instalado y la version 2 o superior de jquery
/*codigo html*/
<input id="codigo" name="codigo-entrada">
/*codigo javascript*/
$(function() {
$("#codigo").autocomplete({
source: '?controller=compras&action=autoProv' // url
});
});
/*codigo php */
/*Controlador*/
public function autoProv(){
$searchTerm = $_GET['term'];
$p = new proveedor();
$p->auto_prov($searchTerm);
}
/*modelo*/
public function auto_prov($searchTerm)
{
$return_arr = array();
$query = $this->dbh->prepare('SELECT rif FROM proveedores WHERE rif LIKE :term'); // like :term hace que cada vez que metas algo busque automaticamente
$query->bindValue("term", "%$searchTerm%");
$query->execute();
while ($row = $query->fetch()) {
$return_arr[] = $row['rif'];
}
echo json_encode($return_arr); // Ajax tiene que ir asi json_encode($queryloquesea)
$this->dbh = null;
}
// eso es todo 100% Ajax en menos de 40 lineas
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment