mysgli

Discussion in 'Databases' started by qim, Nov 29, 2015.

0
  1. #1
    Could you help translate these 2 lines from deprecated mySQL to the new mysqli, please?


    $searchq = $_POST['keyword'];
    /*$searchq = preg_replace("#[^0-9a-z]#i","",$searchq);*/
    $query = mysqli_select_db("SELECT * FROM Chains WHERE Country LIKE '%$searchq%' OR City LIKE '%$searchq%'") or die ("could not search");
    $count = mysqli_result::$num_rows($query);
    if($count == FALSE)

    I tried but whatever I put in is wrong...
     
    qim, Nov 29, 2015 IP
  2. qim

    qim Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    SOLVED!
     
    qim, Nov 30, 2015 IP