INDIA, STD Code Finder Script in PHP, MYSQL, JQUERY

by Posted on

Here i am going to share one useful database that is STD code list of india in MYSQL and EXCEL with STD Code finder script in PHP, MYSQL, JQUERY.

If you are planning to create any telecommunication based website then it may help you, Here i have share full database with script, In STD code finder script i used jquery auto-complete feature, You can read tutorial how to create auto-complete/auto-suggest
std-finder
So lets start the tutorial

Create your html file. with some css and required javascript, don’t forget to include jquery library.

index.html

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>INDIA, STD Code Finder Script in PHP, MYSQL, JQUERY</title>
  <link rel="stylesheet" href="http://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<style>
  .ui-autocomplete-loading {
    background: white url("img/ui-anim_basic_16x16.gif") right center no-repeat;
  }
   .ui-autocomplete {
    max-height: 300px;
    overflow-y: auto;
    /* prevent horizontal scrollbar */
    overflow-x: hidden;
  }
  /* IE 6 doesn't support max-height
   * we use height instead, but this forces the menu to always be this tall
   */
  * html .ui-autocomplete {
    height: 100px;
  }
  </style>
</head>
<body>
 
 
<h3>INDIA, STD Code Finder Script in PHP, MYSQL, JQUERY</h3>
	<div class="ui-widget">
  <input type="text" id="std" name="std" placeholder="Type city name or std code" style="width:550px;"><br/>
  <span style="color:red">* Enter atleast 3 character..!! </span>
</div>
<br/><br/>
 
  <script src="http://code.jquery.com/jquery-1.10.2.js"></script>
  <script src="http://code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
  <script>
  $(function() {
   $( "#std" ).autocomplete({
      source: function( request, response ) {
        $.ajax({
          url: "request.php",
          dataType: "json",
          data: {
            q: request.term
          },
          success: function( data ) {
            response( data );
          }
        });
      },
      minLength: 3,
      select: function( event, ui ) {
      	    // do something on select event
        console.log(ui.item); // ui.item is  responded json from server
      },
      open: function() {
                 // D0 something on open event.
      },
      close: function() {
               // Do omething on close event
      }
    });
  });
  </script>
</body>
</html>




Create server file to fetch data from database and return in json format.

<?php
$hostname = "localhost";
$username = "username";
$password = "db-password";
$dbname = "database-name";
$q = $_GET['q'];
if(isset($q) || !empty($q)) {
	$con = mysqli_connect($hostname, $username, $password, $dbname);
    $query = "SELECT * FROM stdcodes WHERE CONCAT(city, ' ', stdcode) LIKE '%$q%'";
    $result = mysqli_query($con, $query);
    $res = array();
    while($resultSet = mysqli_fetch_assoc($result)) {
	 $res[$resultSet['id']] = $resultSet['city'].", STD-CODE: ".$resultSet['stdcode'];
    }
    if(!$res) {
    	$res[0] = 'Not found!';
    }
    echo json_encode($res);
}
 
?>

Use below button to see live demo and download source code with database.

DEMO DOWNLOAD

If you like this post please don’t forget to subscribe my public note book for more useful stuff

Published by admin