CREATE DEFINER="..."  PROCEDURE `ip_city`(IN ip_in varchar(100),OUT city varchar(100))
BEGIN
select city_name into city from ip2loc.ip2location_db3 where ip_from<inet_aton(ip_in) and ip_to>inet_aton(ip_in);

END

<?php


include('db_config.php');

$ip=$_SERVER['REMOTE_ADDR'];
$stmt = mysqli_prepare($conn, "CALL ip_city('$ip',@city)");
mysqli_stmt_execute($stmt);

$stmtout= mysqli_prepare($conn, "select @city");

mysqli_stmt_bind_result($stmtout, $output_data);
mysqli_stmt_execute($stmtout);
mysqli_stmt_fetch($stmtout);

 echo "
".$ip.":".$output_data."<br /<"
?>