Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost"; /* Host name */
- $user = "root"; /* User */
- $password = ""; /* Password */
- $dbname = "ubigeo"; /* Database name */
- $conexion = mysqli_connect($host, $user, $password,$dbname);
- // Check connection
- if (!$conexion) {
- die("Connection failed: " . mysqli_connect_error());
- }
- $search = $_POST['service'];
- $qss = mysqli_query("SELECT * FROM provincias WHERE provincia like '" . $search . "%' AND status=1 ORDER BY title DESC", $conexion);
- while ($row = mysqli_fetch_array($qss)) {
- echo '<div class="suggest-element"><a data="'.$row['provincia'].'" id="service'.$row['idProvincia'].'">'.utf8_encode($row['idDepartamento']).'</a></div>';
- }
- ?>
Add Comment
Please, Sign In to add comment