我正在开发简单的登录注册页在统一使用后台作为php在MySQL上。我已经做到了,但它是工作在同一个网络。我的意思是我可以在同一个wi-fi上使用它。我怎样才能使它在任何地方都能使用呢?
我使用Xampp来启动Apache和MySQL。
这是我的php代码
<?php
$con = mysqli_connect('localhost', 'anyname','anypassword', 'unityaccess');
//check connection
if(mysqli_connect_errno())
{
echo "1: Connection failed!"; //connection failed
exit();
}
$username=$_POST["name"];
$password=$_POST["password"];
$namecheckquery = "SELECT username, salt, hash, score FROM players WHERE username='" . $username . "';";
$namecheck= mysqli_query($con, $namecheckquery) or die("2: Name Check Query failed!"); //namecheckquery failed
if(mysqli_num_rows($namecheck)!=1)
{
echo "5: Either no user with name or more than one";
exit();
}
//get login info from uery
$existinglogininfo = mysqli_fetch_assoc($namecheck);
$salt=$existinglogininfo["salt"];
$hash=$existinglogininfo["hash"];
$loginhash=crypt($password, $salt);
if($hash != $loginhash)
{
echo "6: Incorrect password";
exit();
}
echo "0\t" . $existinglogininfo["score"];
?>
这是我的c代码
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;
using UnityEngine.SceneManagement;
public class Login : MonoBehaviour
{
public Button login;
public InputField nameinput;
public InputField passinput;
public void CallLogin()
{
StartCoroutine(LoginPlayer());
}
public IEnumerator LoginPlayer()
{
WWWForm form = new WWWForm();
form.AddField("name", nameinput.text);
form.AddField("password", passinput.text);
WWW www = new WWW("http://localhost/sqlconnect/login.php", form);
yield return www;
}
}