Thanks for the replies.
So, if I changed all the mysql related code, for example, code like this:
mysql_real_escape_string($_GET['load']);
$sql1 = "SELECT * FROM member_profile WHERE user_id = $id";
$query1 = mysql_query($sql1) or DIE(mysql_error());
$result = mysql_fetch_array($query1);
$query = mysql_query($sql) or DIE(mysql_error());
$channel = mysql_real_escape_string($channel);
$id_sql = "SELECT channel_id FROM channels WHERE channel_name_seo = '$channel' LIMIT 1";
$id_query = @mysql_query($id_sql);
$row = mysql_fetch_array($id_query);
in the installed php script, and replaced it with the proper PDO code, and then my web host replaced the PHP5+ with PHP7, the mySQL db names or tables wouldn’t need to change? and in theory the script should work and be more secure?