unity php mysql_unity与php关于mysql登录的实例解析

客户端代码:

using UnityEngine;

using UnityEngine.UI;

using System.Collections;

public class login : MonoBehaviour

{

public InputField userIdField;

public InputField passwordField;

public Text statusText;

public Button loginBtn;

private string userId = "";

private string password = "";

private string url = "https://dasp.top/WE/login.php";

private void Awake()

{

loginBtn.onClick.AddListener(OnLogin);

}

public void OnLogin()

{

userId = userIdField.text;

password = passwordField.text;

if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(password))

{

print("账户和密码不能为空");

return;

}

StartCoroutine(logining());

}

private IEnumerator logining()

{

WWWForm form = new WWWForm();

form.AddField("userId", userId);

form.AddField("password", password);

WWW www = new WWW(url, form);

yield return www;

if (www.error != null)

{

print("error is login:" + www.error);

statusText.text = www.error + "...";

}

else

{

print(www.text);

statusText.text = www.text;

}

}

}

在MySQL建一个测试的数据表:

DROP TABLE IF EXISTS `tb1`;

CREATE TABLE `tb1` (

`userid` varchar(30) NOT NULL,

`password` varchar(50) NOT NULL,

PRIMARY KEY (`userid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------

-- Records of tb1

-- ----------------------------

INSERT INTO `tb1` VALUES ('100001', '123456');

INSERT INTO `tb1` VALUES ('100002', '123456');

INSERT INTO `tb1` VALUES ('100003', '123456');

INSERT INTO `tb1` VALUES ('100004', '123456');

PHP端代码:

dbconfig.php

mysqli = mysqli_connect($this->host, $this->user, $this->pwd))

{

die("Cant connect into database");

}

else

{

//echo "连接数据库成功...

";

}

$this->select_db($this->db_name);

}

//析构函数

function __destruct()

{

mysqli_close($this->mysqli);

}

/*

* 说明:

*/

public function get_mysql_handle()

{

return $this->mysqli;

}

/*

* 说明:

*/

public function select_db($_db)

{

if($this->mysqli != null)

{

if(mysqli_select_db($this->mysqli, $_db))

{

//echo "连接数据库成功...

";

}

else

{

die("Cant connect into database");

}

}

}

/*

* 说明: 执行一个sql无返回值

*/

public function execute($_sql)

{

if(empty($_sql))

{

echo "参数不能为空";

return;

}

if(!mysqli_query($this->mysqli, $_sql))

{

echo "执行失败...

";

}

}

/*

* 说明: 执行一个查询语句，并执行回调函数

*/

public function do_query($_sql, $query_callback = "")

{

if(empty($_sql))

{

echo "参数不能为空";

return;

}

if($result = mysqli_query($this->mysqli, $_sql))

{

$num_rows = $result->num_rows;

if($num_rows > 0)

{

while($row = $result->fetch_assoc())

{

if(!empty($query_callback))

{

call_user_func( $query_callback , $row );

}

}

return $num_rows;

}

else

{

return 0;

}

mysqli_free_result($result);

}

else

{

echo "执行失败...

";

}

}

//成员变量

private $host = "localhost"; //数据库地址

private $user = "root";//用户名

private $pwd = ""; //用户密码

private $db_name = "test"; //数据库

private $mysqli = null;

}

?>

login.php

do_query($sql, "login_callback") > 0)

{

if($password_db == $password)

{

//echo "登录成功...".$_POST["userId"].",".$_POST["password"].",".$password_db;

echo 1;

}

else

{

//echo "登录失败1...".$_POST["userId"].",".$_POST["password"].",".$password_db;

echo 2;

}

}

else

{

//echo "登录失败2...".$_POST["userId"].",".$_POST["password"].",".$password_db;

echo "登录失败2...";

}

}

function login_callback($row)

{

global $password_db;

$password_db = $row["v"];

}

?>