Convert mysql code to mysqli

[Catchamouse]

I have a code in two files and I want to convert it from mysql to mysqli.

func.php:

<?php
$con = mysql_connect('*','*','*');
mysql_select_db("*",$con);

function search_results($keywords){
    $returned_results = array(); 
    $where = "";

    $keywords = preg_split('/[\s]+/',$keywords);
    $total_keywords = count($keywords);

    foreach ($keywords as $key => $keyword) {
            $keyword = strtolower($keyword);
            $where .= "LOWER(`keywords`) LIKE '%$keyword%'";
            if ($key != ($total_keywords -1)) {
            $where .= " AND ";
    }
}
    $results = "SELECT name, image_url, game_url, alt FROM search_games WHERE $where";
    $results_num = ($results = mysql_query($results))? mysql_num_rows($results):0;
    if($results_num === 0){
        return false;
    }
    else{
        while ($results_row = mysql_fetch_assoc($results)) {
    $returned_results[] = array(
        'name' => $results_row['name'],
        'image_url' => $results_row['image_url'],
        'game_url' => $results_row['game_url'],
        'alt' => $results_row['alt']
    );
}
        return $returned_results;
    }
}
?>

search_site.php:

<?php
include('func.php');

echo '<div class="number-of-items">';

if(isset($_POST['keywords'])){
    $suffix = "";
    $keywords = mysql_real_escape_string(htmlentities(trim($_POST['keywords'])));
    $errors = array();
        $results = search_results($keywords);
        if ($results === false) {
        echo '<h1>We didn\'t find anything for &quot;'.$keywords.'&quot;</h1>';
    }
    else {
        $results_num = count($results);
        $suffix = ($results_num!=1)?'s':'';
        echo '<h1 class="number_of_results">'.$results_num.' item'.$suffix.' For &quot;'.$keywords.'&quot;</h1>';

echo '</div>';

echo '<div class="results">';

        foreach($results as $result){
            echo '

<span class="overimage">

<a href="',$result['game_url'],'" target="_blank">

<span class="hoverimage">
<span class="hovertext1line-home">'.$result['name'].'</span><img class="onlinegameimage-home" src="'.$result['image_url'].'" alt='.$result['alt'].'>
</span>

</a>

</span>

';

}
echo '</div>';

}}

?>

[rubberman]

RTFM? The differences between them are minor, but significant. There is no "magic" way to convert mysql to mysqli. It has to be done manually, and painstakenly. Not hard, but patience and attention to detail is important.

[rproffitt]

I think you could have left the code off this post. That is, there are priors at https://www.google.com/search?q=how+do+I+convert+from+mysql+to+mysqli and maybe, just maybe a tool to do the conversion in simpler systems.

I know folk want instant conversions with no work on their part. But free beer is usually not tasty.