Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <input name="name" type="text" placeholder="Buscar...">
- <input value="Buscar" type="submit">
- </form>
- <?php
- include("global.php");
- require_once("zebra.php");
- if (empty($_GET['name'])) { $name="";} else { $name=$_GET['name'];}
- $query = "SELECT * , MATCH (nom, des) AGAINST ('$name') AS puntuacion FROM webs WHERE MATCH (nom, des) AGAINST ('$name') ORDER BY puntuacion DESC LIMIT 50 " or die(mysqli_error());
- $res = $con->query($query);
- $num_registros = mysqli_num_rows($res);
- $resul_x_pagina = 5;
- $paginacion = new Zebra_Pagination();
- $paginacion->records($num_registros);
- $paginacion->records_per_page($resul_x_pagina);
- $consulta = "SELECT * , MATCH (nom, des) AGAINST ('$name') AS puntuacion FROM webs WHERE MATCH (nom, des) AGAINST ('$name') ORDER BY puntuacion DESC LIMIT 50 " die(mysqli_error());
- .(($paginacion->get_page() - 1) * $resul_x_pagina). "," .$resul_x_pagina;
- $result = $con->query($consulta);
- while($row = mysqli_fetch_array($result)){
- echo "<a href="$row[nom]" target="_blank">$row[nom]</a><br>";
- echo $row['des']."<br><br>";
- }
- $paginacion->render();
- mysqli_close($con);
- ?>
- He busado por todos lados y creo que la consulta
- Es correcta, pero solo funciona si le añado die(mysqli_error());
- Si en vez de consultas con match las hago con like no tengo problemas.
- Alguna idea? Muchas gracias
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement