简单身份认证之php脚本

loginJun.php:::

<?php
$USERNAME = 'root';   //database username
$PASSWORD = '123';    //database password
$DATABASE = 'asterisk';   //database name
$URL = 'localhost';        //database location
//echo "Test Login<br>";
//if(isset($_GET['getTutorials']))
//{
    mysql_connect($URL, $USERNAME, $PASSWORD);
    mysql_select_db($DATABASE) or
    die('Cannot connect to database.');
    echo "bbbb";
$js($_GET['jsonSendData']);
$js("//","",$jsonString);
$data=json_decode($jsonString,true);
    echo "aaaa";

//foreach($data as $tutorialEntry){
    // check the login info
     $username=$data[0];
        $pwd=$data[1];
  //echo $username;
 echo $pwd;
  //if(!isset($tutorialEntry['deleted']))
  //{
   $query="SELECT * FROM auth_user WHERE user_id='$username' AND user_password='$pwd'";
  //}
  $result=mysql_query($query);
  echo $result;
  if(!mysql_num_rows($result)==1)
  {
   mysql_close();
   echo "login failed";
  }else{
  mysql_close();
  echo "login succeed";
  }
//}
    //$returnArray = array();
    
    //$query = 'SELECT * FROM asterisk';
    //$result = mysql_query($query);
//}
//else  echo "Exception occured";
?>

crossdomain.xml::这个文件是为了解决json发送异常的
<?xml version="1.0"?>
<!DOCTYPE cross-domain-policy SYSTEM " http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd ">
<cross-domain-policy><allow-access-from domain="127.0.0.1" secure="false" />
</cross-domain-policy>