Beginner PHP Tutorial – 132 – LIKE With a Search Engine Example Part 3

[ad_1]
Facebook –
GitHub –
Google+ –
LinkedIn –
reddit –
Support –
thenewboston –
Twitter –


Posted

in

by

Tags:

Comments

10 responses to “Beginner PHP Tutorial – 132 – LIKE With a Search Engine Example Part 3”

  1. Prakash Besra Avatar

    mysql_real_escape_string — Escapes special characters in a string for use in an SQL statement.

  2. Paulo Moniz Avatar

    <?php
    /Fazer procura numa base de dados/

    /Fichero que liga à base de dados./
    require 'connect.php';

    /Procura numa base de dados/
    if(isset($_POST['search_name'])){

    $search_name = strtolower($_POST['search_name']);

    if(!empty($search_name)){

    /* Acrescentar segurança, ".VARIAVEL AQUI." e depois usar mysqli_real_escape_string */
    $query = "SELECT name FROM names WHERE name LIKE '%".mysqli_real_escape_string($mysqlcon,$search_name)."%'";

    /Corre-se a Query/
    if ($query_run = mysqli_query($mysqlcon,$query)){
    //echo 'Query Sucess';

    //Only prints out info if it finds any
    if(mysqli_num_rows($query_run) == NULL){
    echo 'No results found in the database';
    }else{
    /RIP mysql_fetch_assoc/
    foreach($query_run as $query_row){
    $name = $query_row['name'];
    echo $name.'<br>';
    }
    }
    }else {
    //mysql_error() doesnt work;
    echo 'Query Fail';
    }

    }
    }
    ?>

  3. malnoor83 Avatar

    you speak fast too fast to understand !!!!

  4. xxiRaQiAtheistxx Avatar

    Add the ( names ) table to your connect.inc.php file if you having problem with mysql_num_rows.

  5. Dankest Elf Avatar

    Can't wait until AJAX (tut 171)

  6. UrpleActus Avatar

    errors every fucking time

  7. buczize Avatar

    why not use isset() function?

  8. SuperVPD Avatar

    You need too use `(apostrofies) ,which is under "Esc" not ' single quotation marks

  9. rapiboiz paguntalan Avatar

    @DesmondOO11 do you know how to create an image search engine….if you know…can you teach me….i really wanted to learn it

  10. DesmondOO11 Avatar

    for all ppl have mysql_num_rows problem change
    query = "SELECT 'bookName' FROM 'book' WHERE 'Title' LIKE '%".mysql_real_escape_string($search)."%' ";

    to

    query = "SELECT Name FROM book WHERE Title LIKE '%".mysql_real_escape_string($search)."%' ";

Leave a Reply

Your email address will not be published. Required fields are marked *