Search by number in MySQL table with PHP [closed]

Navigation
0

I have a search form where the user types a number and if it is equal to the number that is in the database it returns the data of that number. But when I click on button enviar it shows me the page teste.php with the following error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '232' at line 1) follow the code.

Database: 

CREATE TABLE 'tb_numeros' (
  'numero' int(11) NOT NULL,
  'funcionario' varchar(120) NOT NULL,
  'rca' int(4) NOT NULL,
  'regiao' varchar(14) NOT NULL,
  'nchip' int(120) NOT NULL,
  'imei' int(120) NOT NULL
) PRIMARY KEY ('numero');

Form: 

<form class="navbar-form navbar-left" method="post" action="teste.php" role="search">
    <div class="form-group">
        <input type="text" name="numerodigitado" class="form-control" placeholder="Buscar Número">
    </div>
        <button type="submit" name="enviar" class="btn btn-default"><i class="glyphicon glyphicon-search"></i></button>
</form>

test.php: 

<?php
include_once("../conn/conexao.php");//faz a conexao com o banco de dados

    if(isset($_POST['numerodigitado'])){
        $palavra = trim($_POST['numerodigitado']);
    }else{
        $palavra = trim($_GET['numerodigitado']);
    }

    if($palavra != NULL){
        // Retorna apenas os registros PARECIDOS com 'palavra', limitando à 10 registros por página
        $sql = "SELECT * FROM tb_numeros WHERE numero LIKE '%$palavra%' ";
    }else{
        // Retorna todos os registros do BD
        $sql = "SELECT * FROM tb_numeros ORDER BY numero ";
    }

    $comparar = mysqli_query($conexao, $palavra) or die (mysqli_error($conexao));
    if($comparar):
    echo "<script>
            alert('Número encontrado.');

        </script>"; 
    else:
        echo "<script>
                alert('Ocorreu um erro ao mostrar o número.');

            </script>";
    endif;

?>
    
asked by anonymous 23.11.2017 / 13:45

1 answer

1

Remembering that below I will use a connection variable, named $ conn, change by its created variable to connect to the database 

<?php

  include_once("../conn/conexao.php");//faz a conexao com o banco de dados

  if(isset($_POST['numerodigitado'])){

    $numerodigitado = $_POST['numerodigitado'];

    $result = "SELECT * FROM tb_numeros WHERE numero = '$numerodigitado' ";
    $resultado = mysqli_query($conn, $result);
    $row = mysqli_fetch_assoc($resultado);

    if($resultado -> num_rows > 0){
       echo " .$row['campo1']. ";
       echo " .$row['campo2']. ";
       echo " .$row['campo3']. ";
    } else {
       echo "<script>alert('Ocorreu um erro ao buscar o número');</script>";
    }

?>
    
23.11.2017 / 14:11
How to improve select performance Make an alias for webmail