SQLize Online / PHPize Online  /  SQLtest Online

<?php require_once 'IpRequest.php'; $requestModel = new Request(); $ip = $requestModel->getIpAddress(); $isValidIpAddress = $requestModel->isValidIpAddress($ip); if (! isset($_SESSION)) { session_start();} $MemberId= $_POST["MemberId"]; $Password= $_POST["LoginPassword"]; $token= $_POST["Token"]; if ($_SERVER["REQUEST_METHOD"] == "POST") { if (isset($_POST["MemberId"]) && trim($_POST["MemberId"]) != "" && isset($_POST["LoginPassword"]) && trim($_POST["LoginPassword"]) != "" && isset($_POST["Token"]) && trim($_POST["Token"]) != "" && isset($_POST["CaptchaCode"]) && trim($_POST["CaptchaCode"]) != "") { require_once ('Config.php'); $conn = new mysqli($servername,$db_username,$db_password,$db_name); $MemberId = $conn -> real_escape_string($_POST["MemberId"]); $Password = $conn -> real_escape_string($_POST["LoginPassword"]); $toke = $conn -> real_escape_string($_POST["Token"]); $captcha = $conn -> real_escape_string($_POST["CaptchaCode"]); $conn -> close(); function session_logo() /// session_logot { session_unset(); session_destroy(); } function isValidMd5($md5 ='') /// md5 valide chake { return preg_match('/^[a-f0-9]{32}$/', $md5); } if(isValidMd5($token) != "" && isValidMd5($token) == "1"){ if($_SESSION["token"] == $toke){ if($_SESSION["CaptchaCode"] == $captcha){ try { $_SESSION["login_time_stamp"]=time(); $conn = new PDO("mysql:host=$servername;dbname=$db_name; charset=utf8", $db_username, $db_password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql4 ="select * from master_user where MemberId= '".$MemberId."' and Password= '".$Password."' and IsDelete='0' and Role='Retailer' "; $q4 = $conn->prepare($sql4); $q4->execute(); $q4->setFetchMode(); $r = $q4->fetchAll(PDO::FETCH_ASSOC); $json = json_encode( $r ); echo $json ; $sql4 = null; $conn=null; } catch(PDOException $e) { session_logo(); echo "Connection failed: " . $e->getMessage(); } } else { if ($isValidIpAddress == "") { session_logo(); echo json_encode(array("msg"=>"Invalid IP address $ip")); } else { // $geoLocationData = $requestModel->getLocation($ip); session_logo(); echo json_encode(array("msg"=>"$ip The Validation code does not match!")); } } } else { if ($isValidIpAddress == "") { session_logo(); echo json_encode(array("msg"=>"Invalid IP address $ip")); } else { // $geoLocationData = $requestModel->getLocation($ip); session_logo(); echo json_encode(array("msg"=>"$ip Something Went Wrong")); } } } else { if ($isValidIpAddress == "") { session_logo(); echo json_encode(array("msg"=>"Invalid IP address $ip")); } else { // $geoLocationData = $requestModel->getLocation($ip); session_logo(); echo json_encode(array("msg"=>"$ip Something Went Wrong3")); } } } else { if ($isValidIpAddress == "") { session_logo(); echo json_encode(array("msg"=>"Invalid IP address $ip")); } else { // $geoLocationData = $requestModel->getLocation($ip); session_logo(); echo json_encode(array("msg"=>"$ip Something Went Wrong2")); } } } else { if ($isValidIpAddress == "") { session_logo(); echo json_encode(array("msg"=>"Invalid IP address $ip")); } else { // $geoLocationData = $requestModel->getLocation($ip); session_logo(); echo json_encode(array("msg"=>"$ip Something Went Wrong1")); } } ?>