PHP: mysqli::prepare – Manual
Unfortunately, the use “/* bind result variables */ $stmt->bind_result($district);” is obsolete and condemned. Also, instead of ‘$stmt->bind_param(“s”, $city);’, use “$stmt->bind_param($types, …$parameters);” with array. Here the advantage of using an array…