Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <form action="" method="GET" >
- <input type="text" autocomplete="on" name="q" placeholder="Digite a sua pesquisa" />
- <input type="submit" value="Tecle Enter" />
- </form>
- <?php
- $host = 'localhost';
- $user = 'devel';
- $password = '********';
- $database = 'Cadastro';
- $connect = mysqli_connect($host, $user, $password, $database) or die("conexao die");
- $query = $_GET['q'];
- if(isset($query)){
- $consult = mysqli_query("SELECT nome FROM 'usuarios' WHERE 'nome' LIKE %q%", $connect);
- $result = mysqli_fetch_assoc( $consult );
- print_r($result);
- }
- else {
- echo 'nao foi encontrado nada';
- }
- ?>
- </body>
- </html>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <form action="" method="GET" >
- <input type="text" autocomplete="on" name="q" placeholder="Digite a sua pesquisa" />
- <input type="submit" value="Tecle Enter" />
- </form>
- <?php
- $host = 'localhost';
- $user = 'devel';
- $password = '********';
- $database = 'Cadastro';
- $connect = mysqli_connect($host, $user, $password, $database) or die("conexao die");
- $query = $_GET['q'];
- if(isset($query)){
- $consult = mysqli_query("SELECT nome FROM 'usuarios' WHERE 'nome' LIKE '%".$query."%'", $connect);
- $result = mysqli_fetch_assoc( $consult );
- print_r($result);
- }
- else {
- echo 'nao foi encontrado nada';
- }
- ?>
- </body>
- </html>
- <?php
- $host = 'localhost';
- $user = 'devel';
- $password = '********';
- $database = 'Cadastro';
- $connect = mysqli_connect($host, $user, $password, $database) or die("conexao die");
- if(isset($_GET['q'])){
- $consult = mysqli_query('SELECT nome FROM usuarios WHERE nome LIKE "%' .$_GET['q']. '%"', $connect);
- $result = mysqli_fetch_assoc( $consult );
- print_r($result);
- }
- else {
- echo 'nao foi encontrado nada';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement