У меня есть таблица в BD для входа.
Есть JS скрипт который отправляет запрос в PHP файл и обрабатывает, потом посылает в Unity.
В самом редакторе Unity3D у меня все нормально работает(Запрос отправляет и принимает), но когда скомпилировал WebPlayer, запустил ввел логин и пароль не чего не происходит, Я думаю что запрос не отправляется.
Скрипт :
Синтаксис:
Используется javascript
var window = 0;
var pass: String = "";
var user : String = "";
var passN: String = "";
var userN : String = "";
var urlN = "i.ru/reg.php";
var url = "i.ru/checklogin.php";
private var textrect = Rect (10, 100, 100, 100); //just make a GUI object rectangle
var formText = ""; //this field is where the messages sent by PHP script will be in
function OnGUI () {
if (window == 0) { // теперь главное меню активировано при window = 0
if (GUI.Button (Rect (Screen.width/2 - 90,Screen.height/2 + 70,180,20), "Регистрация")) {
window = 1; // активируем окно "настройки"
}
GUI.Box (Rect (Screen.width/2 - 100,Screen.height/2 - 110,200,220), "Вход");
user = GUI.TextField (Rect (Screen.width/2-90, Screen.height/2-60, 160, 30), user, 25);
pass = GUI.PasswordField (Rect (Screen.width/2-90, Screen.height/2-10, 160, 30), pass, "*" [0], 25);
if (GUI.Button(Rect(Screen.width/2 - 90,Screen.height/2+30,100,30),"Вход"))
{
HandleLogin(user, pass);
}
}
if (window == 1) { // наши настройки
GUI.Box (Rect (Screen.width/2 - 100,Screen.height/2 - 100,200,200), "Регистрация");
userN = GUI.TextField (Rect (Screen.width/2-90, Screen.height/2-60, 160, 30), userN, 25);
passN = GUI.PasswordField (Rect (Screen.width/2-90, Screen.height/2-10, 160, 30), passN, "*" [0], 25);
if (GUI.Button(Rect(Screen.width/2 - 90,Screen.height/2+30,180,25),"Зарегестрироваться")) {
HandleLoginN(userN, passN);
}
if (GUI.Button (Rect (Screen.width/2 - 90,Screen.height/2 + 60,180,20), "Назад")) {
window = 0;
}
}
GUI.TextArea( textrect, formText );
// Debug.Log("Logged In");
}
function HandleLogin(username: String, password: String) {
var form = new WWWForm();
form.AddField("myusername", username);
form.AddField("mypassword", password);
var login = new WWW(url, form);
yield login;
// React to login, check for errors, etc.
a = login.text; //get echo from php
print(a);
formText = a;
if (a=="Ok")
Application.LoadLevel(1);
}
function HandleLoginN(usernameN: String, passwordN: String) {
var formN = new WWWForm();
formN.AddField("myusernameN", usernameN);
formN.AddField("mypasswordN", passwordN);
var loginN = new WWW(urlN, formN);
yield loginN;
// React to login, check for errors, etc.
q = loginN.text; //get echo from php
print(q);
formText = q;
if (q=="Ok")
Application.LoadLevel(0);
}
var pass: String = "";
var user : String = "";
var passN: String = "";
var userN : String = "";
var urlN = "i.ru/reg.php";
var url = "i.ru/checklogin.php";
private var textrect = Rect (10, 100, 100, 100); //just make a GUI object rectangle
var formText = ""; //this field is where the messages sent by PHP script will be in
function OnGUI () {
if (window == 0) { // теперь главное меню активировано при window = 0
if (GUI.Button (Rect (Screen.width/2 - 90,Screen.height/2 + 70,180,20), "Регистрация")) {
window = 1; // активируем окно "настройки"
}
GUI.Box (Rect (Screen.width/2 - 100,Screen.height/2 - 110,200,220), "Вход");
user = GUI.TextField (Rect (Screen.width/2-90, Screen.height/2-60, 160, 30), user, 25);
pass = GUI.PasswordField (Rect (Screen.width/2-90, Screen.height/2-10, 160, 30), pass, "*" [0], 25);
if (GUI.Button(Rect(Screen.width/2 - 90,Screen.height/2+30,100,30),"Вход"))
{
HandleLogin(user, pass);
}
}
if (window == 1) { // наши настройки
GUI.Box (Rect (Screen.width/2 - 100,Screen.height/2 - 100,200,200), "Регистрация");
userN = GUI.TextField (Rect (Screen.width/2-90, Screen.height/2-60, 160, 30), userN, 25);
passN = GUI.PasswordField (Rect (Screen.width/2-90, Screen.height/2-10, 160, 30), passN, "*" [0], 25);
if (GUI.Button(Rect(Screen.width/2 - 90,Screen.height/2+30,180,25),"Зарегестрироваться")) {
HandleLoginN(userN, passN);
}
if (GUI.Button (Rect (Screen.width/2 - 90,Screen.height/2 + 60,180,20), "Назад")) {
window = 0;
}
}
GUI.TextArea( textrect, formText );
// Debug.Log("Logged In");
}
function HandleLogin(username: String, password: String) {
var form = new WWWForm();
form.AddField("myusername", username);
form.AddField("mypassword", password);
var login = new WWW(url, form);
yield login;
// React to login, check for errors, etc.
a = login.text; //get echo from php
print(a);
formText = a;
if (a=="Ok")
Application.LoadLevel(1);
}
function HandleLoginN(usernameN: String, passwordN: String) {
var formN = new WWWForm();
formN.AddField("myusernameN", usernameN);
formN.AddField("mypasswordN", passwordN);
var loginN = new WWW(urlN, formN);
yield loginN;
// React to login, check for errors, etc.
q = loginN.text; //get echo from php
print(q);
formText = q;
if (q=="Ok")
Application.LoadLevel(0);
}
И PHP
Синтаксис:
Используется javascript
<?php
$host="127.0.0.1"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
echo "Ok";
// Register $myusername, $mypassword and redirect to file "login_success.php"
//session_register("myusername");
//session_register("mypassword");
//header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
$host="127.0.0.1"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
echo "Ok";
// Register $myusername, $mypassword and redirect to file "login_success.php"
//session_register("myusername");
//session_register("mypassword");
//header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>