我试图传递一个字符串(全名)作为参数,但是我经常被重定向回用户配置文件(换句话说,它无法提供任何特定名称的数据)。
我尝试使用警报消息来查看参数是否已成功发送
而且消息是空白的,所以我想可以肯定的是,参数甚至没有通过页面。
几个小时来我一直在想这个问题,但我放弃了,有人能告诉我方向吗?
代码如下:
这是形式:
<form method="post" action="search"><input type="text" name="name" required placeholder="Firstname_Lastname"/><input type="submit" value="Search"/></form>
有另一种方法可以访问search.php,它是通过get从用户列表中获取的,但也不起作用。当我尝试使用用户列表时,它只是没有加载页面。也没有MySQL语法错误。以下是搜索页面:
<?php
$title = "Public Profile";
include 'header.php';
include 'profiletabs.php';
checkForLogin();
if(isset($_GET['uid']) && !is_numeric($_GET['uid']))
{
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=publicprofile">';
}
if(isset($_GET['uid']))
{
$query = $_GET['uid'];
$query = mysql_real_escape_string($query);
$resultSearch = $con->query("SELECT * FROM `playerinfo` WHERE `SQLID` = $query LIMIT 1;");
}
else
{
$query = $_POST['name'];
echo "<script type='text/javascript'>alert('$nameri');</script>";
echo "<script type='text/javascript'>alert(". $_POST['name'].");</script>";
$query = mysql_real_escape_string($query);
$resultSearch = $con->query("SELECT * FROM `playerinfo` WHERE `PlayerName` = '$query' LIMIT 1;");
$nameri = $query;
$message = "wrong answer";
echo "<script type='text/javascript'>alert('$nameri');</script>";
echo "<script type='text/javascript'>alert($nameri);</script>";
}
if($resultSearch->rowCount() > 0)
{
// Code goes here
}
else echo '<META HTTP-EQUIV="Refresh" Content="0; URL=publicprofile">';
我很感谢你的帮助,谢谢!
最佳答案
你的语法有问题,我有更新,希望这将有帮助。
没有名为-->$nameri的变量
<?php
$title = "Public Profile";
include 'header.php';
include 'profiletabs.php';
checkForLogin();
if(isset($_GET['uid']) && !is_numeric($_GET['uid']))
{
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=publicprofile">';
}
if(isset($_GET['uid']))
{
$query = $_GET['uid'];
$query = mysql_real_escape_string($query);
$resultSearch = $con->query("SELECT * FROM `playerinfo` WHERE `SQLID` = $query LIMIT 1;");
}
else
{
$query = $_POST['name'];
echo "<script type='text/javascript'>alert('". $_POST['name']."');</script>";
$query = mysql_real_escape_string($query);
$resultSearch = $con->query("SELECT * FROM `playerinfo` WHERE `PlayerName` = '$query' LIMIT 1;");
$nameri = $query;
$message = "wrong answer";
echo "<script type='text/javascript'>alert('$message');</script>";
}
if($resultSearch->rowCount() > 0)
{
// Code goes here
}
else echo '<META HTTP-EQUIV="Refresh" Content="0; URL=publicprofile">';