Changing PHP scripts to use mysqli instead of mysql?

Don't know what you are talking about, I remember, yes so so many years ago when I made the switch (haha), there weren't any problems, or so minor that I don't remember them.

Don't over think it, disable mysql extension, enable mysqli, go through the errors one by one. If some of the errors can be easily fixed by a project wide search and replace of the API, then do that.

Many modern editors let you do a project wide search and replace, using the free Atom editor for example, open the folder your PHP project is in, do a Find > Find in Project

The problem you have is one of the reasons why some people prefer to use an access layer, and not use the DB API directly

An over smplified example,

function q($sql) {

mysql_query($sql);

}

So that you don't have to write mysql_query($sql); in your program, only q($sql); So when you update to mysqli, you just change what's in your q() function

Asking the question like this is not helpful; you need to show us what code you've tried and how it failed.

The basic idea is something like:

function my_query($query) {

$db = new mysqli($server, $username, $password, $database);

$db->set_charset("utf8");

$result = $db->query($query);

if ($result->num_rows > 0) {

while ($row = $result->fetch_assoc()) $rows[] = $row;

return $rows;

}

return null;

}