[insert_php]
echo “hi”;
error_reporting(0);
@session_start();
function getDBConnection( $dbIPAddr, $dbUser, $dbPassword, $dbName )
{
$db_connnection = mysql_connect( $dbIPAddr, $dbUser, $dbPassword );
if ( !$db_connnection )
{
echo (“Failed to connect to data base:: ” . mysql_error());
return false ;
}
$select_db = mysql_select_db( $dbName, $db_connnection );
if ( !$select_db )
{
echo (“Failed to select edvantedge data base:: ” . mysql_error());
return false ;
}
$_SESSION[‘db_connection’] = $db_connnection ;
return true ;
}
$dbUser = “onlineag_user”;
$dbPassword = “2-6JJ[UmE){c”;
if ($_SERVER[‘SERVER_ADDR’] == “::1”)
{
$dbIPAddr = “localhost”;
}
$dbName = ‘onlineag_db1’;
date_default_timezone_set(‘Asia/Kolkata’);
$format = ‘%Y-%m-%d %H:%M:%S’;
getDBConnection( $dbIPAddr, $dbUser, $dbPassword, $dbName );
$con = $_SESSION[‘db_connection’];
$sql = ‘SELECT DISTINCT BANK FROM ifsc’;
$queryUserExists = mysql_query($sql, $con);
[/insert_php]
function data(){ $('#stat').show(); var name = document.getElementById("name").value; $data= name; $.ajax({ url: "ifsc_ajax.php?bank="+$data, success: function(receivedData){ var res = receivedData; $('#state').html(res); $('#stat').hide(); } });
} function ndistrict(){ var name = document.getElementById("state").value; // alert(name); $data= name; $('#dist').show(); $.ajax({ url: "ifsc_ajax.php?state="+$data, success: function(receivedData){ var res = receivedData; $('#district').html(res); $('#dist').hide(); } });
} function ncity(){ var name = document.getElementById("district").value; // alert(name); $data= name; $('#cit').show(); $.ajax({ url: "ifsc_ajax.php?city="+$data, success: function(receivedData){ var res = receivedData; $('#city').html(res); $('#cit').hide(); } });
} function mbranch(){ var name = document.getElementById("city").value; // alert(name); $data= name; $('#branchlo').show(); $.ajax({ url: "ifsc_ajax.php?branch="+$data, success: function(receivedData){ var res = receivedData; $('#branch').html(res); $('#branchlo').hide(); } });
} function naddress(){ var name = document.getElementById("branch").value; // alert(name); $data= name; $('#add').show(); $.ajax({ url: "ifsc_ajax.php?address="+$data, success: function(receivedData){ var res = receivedData; $('#address').html(res); $('#add').hide(); } });
} function nifsc(){ var name = document.getElementById("address").value; // alert(name); $data= name; $.ajax({ url: "ifsc_ajax.php?ifsc="+$data, success: function(receivedData){ var res = receivedData; res=res.split("@"); $('#ifsc').html(res[0]); $('#micr').html(res[1]); } });
}