I was working on my old project it was using old mysql extension function for PHP, but Server have latest PHP version 7. So I am getting below Errors….
Fatal error: Call to undefined function mysql_query() – PHP
Fatal Error: Uncaught error: Call to undefined function mysql_connect()
Here is quick & dirty fix for old mysql functions using new mysqli php extension
<?php error_reporting(E_ALL); $con = mysqli_connect("localhost","root","","radioDB"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit(); } function mysql_query($sql) { global $con; // global $con variable return mysqli_query($con, $sql); } function mysql_fetch_assoc($result) { return mysqli_fetch_assoc($result); } function mysql_fetch_object($result) { return mysqli_fetch_object($result); } function mysql_num_rows($result) { return mysqli_num_rows($result); } $result = mysql_query("SELECT station_href_name FROM `radio_station` WHERE is_active = 'Y' "); $rps = mysql_fetch_assoc($result); echo mysql_num_rows($result); //print_r($rps); while($rp = mysql_fetch_object($result)) { print_r($rp); } // Free result set mysqli_free_result($result); mysqli_close($con); ?>