unity3D外网读数据库怎么都连不上，本地没问题 - 纳金网

<?
// 连接数据库
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$host = "111.229.239.249"; //主机名
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$user = "sp_wsk"; //用户名
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$password = "123456"; //密码
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$dbname = "sp_wsk94"; //数据库名称
mysql_connect($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$host, $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$user, $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$password) or die("Cant connect into database");//连接失败输出错误提示
mysql_select_db($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$dbname)or die("Cant connect into database");
// =============================================================================
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$unityHash =$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$_POST["hash"];//接收unity3d发送给程序的哈希值
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$phpHash = "hashcode"; //另外，要说的是hash值在此其实相当于二重保险，避免sql注入
//所以为了简化程序我这里也去了，只要保证unity3d和php内的哈希值相等即可
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$nick = $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$_POST["name"]; //接收unity3d发送给程序的用户名
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$pass = $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$_POST["password"];//接收unity3d发送给程序的密码
//先判断发送值是否为空
if(!$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$nick || !$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$pass)
{
echo "昵称或密码不能为空!";//昵称或密码不能为空。
} else
{
if ($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$unityHash != $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$phpHash)
{
echo "HASH code is diferent from your game, you infidel.";//判断哈希值是否相等
} else
{
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$SQL = "SELECT * FROM `scores` WHERE `scores`.name = '" . $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$nick . "' and `scores`.password = '".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$pass."'";//查看用
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$result = mysql_query($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$SQL) or die("DATABASE ERROR!");
if(mysql_num_rows($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$result)==0)//php函数
{
echo "昵称或密码错误!"; //输出昵称或密码错误
}else
{
echo "Welcome to unity3D !\n";//成功提示，“\n”只是为了能在unity中实现换行
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$sql = "SELECT * FROM `scores` WHERE `scores`.name = '" . $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$nick . "' and `scores`.password = '".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$pass."'";
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$result = mysql_query($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$sql);
while($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$row = mysql_fetch_array($$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$result))//输出用户表信息
{
echo "ID:".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$row['id']."\n";
echo "NAME:".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$row['name']."\n " ;
echo "PASSWORD:".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$row['password']."\n ";
echo "INFO:".$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$row['info']."\n ";
}
}
}
}
// Close mySQL Connection
mysql_close();
?>

复制代码

#pragma strict
private var formName = "";//创建私有变量formName，记录文本框内输出的用户名变量
private var formPassword = "";//创建私有变量 formPassword记录文本框内输出的密码变量
var formText = "";//创建变量formText显示php发送给web端的信息
var URL = "http://111.229.239.249/wsk94/wwwroot/check.php";//提交表单的网址
var hash = "hashcode";//与php中相同的哈希值
private var textrect = Rect (10, 150, 500, 100); //建立GUI的文本输入框
function OnGUI()
{
GUI.Label( Rect (10, 10, 80, 20), "姓名:"); //用户名
GUI.Label ( Rect (10, 30, 80, 20), "密码:" );//密码
formName = GUI.TextField ( Rect (90, 10, 100, 20), formName ); //这里，你可将你输入的用户名赋值给formName变量
formPassword = GUI.PasswordField ( Rect (90, 30, 100, 20), formPassword ,"*"[0], 25);
//同理，这里是给formPassword 赋值
if ( GUI.Button ( Rect (10, 60, 100, 20) , "登录" ) )
{ //如果单击登录按钮会执行Login()函数
Login();
}
GUI.TextArea( textrect, formText );//显示文本信息
}
function Login()
{
var form = new WWWForm();//建立新表单变量
//print(hash);//print的内容会在console选项卡中输出
//print(formName);//我在这里添加三个输出语句是为了检验用户名和密码是否复制正确，以便之后调试php文件
//print(formPassword);
form.AddField("hash",hash);//创建表单各项
form.AddField("name",formName);
form.AddField("password",formPassword);
var w = WWW(URL,form);//建立名为“w”的变量，并且将表单提交的URL和表单内容同步
yield w;//我们等待表单响应php程序的返回，让程序把控制权交给其他应用
if(w.error != null)//如果返回信息为错误信息，在console中输出错误信息
{
print(w.error);
}
else
{
print("OK!");//在console中输出ok
formText = w.text;//将返回的web短信息赋值给formText ，在执行GUI.TextArea( textrect, formText );时输出
}
formName = "";//点击查询完用户信息后清空用户名及密码
formPassword = "";
}

复制代码