Last active
December 7, 2016 00:54
-
-
Save aranajhonny/ba291025585558119d8791161c94757a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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