connect_error) { die("Connection failed: " . $conn->connect_error); } /*include($_SERVER['DOCUMENT_ROOT']."/service/connection.php");*/ $keyword = $_POST['data']; $sql = "SELECT id,`name` FROM re_city_spr_1 WHERE `name` LIKE '".$keyword."%' ORDER BY `name` ASC LIMIT 15"; $result = $conn->query($sql); if($result->num_rows > 0) { echo '

'; while($row = $result->fetch_assoc()) { $str = strtolower($row['name']); $start = strpos($str,$keyword); $end = similar_text($str,$keyword); $last = substr($str,$end,strlen($str)); $first = substr($str,$start,$end); $final = strtoupper(''.$first.''.$last); echo '
• '.$final.'
'; } echo "

"; } else echo 0; ?>