PHP & MySQL Mastery Needed

I'm struggling with PHP and MySQL on my server. I have multiple PHP versions: 7.2, 7.4, 8.0 and 8.2. Everything worked fine up to PHP 7.2 or 7.4, from 2005 to PHP 5.6. I have some scripts at 7.2 but I want to get to 8.2. Now I have removed 5.6 from my Server. Then I read that 7.2 or 7.4 will be short lived. I have added 8.0 and especially 8.2 because I read Google Sheets as well as MYSQL, and the JSON Composer to read Sheets needed 8.2. Maybe I should focus on 8.2. Online searches for PHP MYSQL commands are confusing, and still result in errors. Different errors for each PHP vers. With online Searches, I am not getting clear definitions for PHP MYSQL command structure and formats for 8.2. Old scripts needing to be updated for 8.0 and preferably 8.2 have a small number of simple selection of mysql commands: mysql_connect() mysql_select_db() @mysql_select_db() $query = 'select * from movietable'; $result = mysql_query($query); mysql_fetch_row($result) mysql_query($MyQuery) $error = mysql_error() $row=mysql_fetch_array($result,MYSQL_ASSOC) $result = mysqli_query($connection,$query); $result = mysqli_query($con, $query, MYSQLI_USE_RESULT); $row=mysqli_fetch_array($result,MYSQLI_ASSOC) mysqli_query($con,$MyQuery) or die('Error: ' . mysqli_error()) mysqli_close($con); if ($con -> connect_errno) { echo "Failed to connect to MySQL: " . $mysqli -> connect_error; exit(); } I don't always do "ASSOC". I also do $MyQuery = 'INSERT INTO...' and UPDATE... Can someone put a list together for the PHP 8.2 versions of those old 5.6 and 7.x MYSQL/MYSQLI and newer commands? I will probably do the PHP editing myself, for intellectual property reasons. If you’re experienced and proficient in PHP and MySQL, you're the person I’m after. When applying, ensure your application includes details about your past relevant projects, emphasizing the expertise you've acquired through them. Your ability to diagnose underlying issues across different PHP versions would be a great advantage. Let's streamline my PHP and MySQL processes and bring some organization back into this unexpected chaos.