文章/答案/技术大牛

发布

问$key=$_REQUEST['key']不工作
EN

Stack Overflow用户

提问于 2014-01-31 03:08:26

回答 1查看 354关注 0票数 0

if (isset($_POST['cancel'])) {
    print("<script>location.href = 'task_led.php'</script>");
}
else if (isset($_POST['assign'])) {
    $atask = $_POST['task'];
    $table_task = $_POST['hid_task'];
    $key = $_REQUEST['key'];

    include 'sql.php';

    $SQL = " ALTER TABLE $table_task ADD $atask VARCHAR(255) NOT NULL";
    mysql_query($SQL);

    $SQL = "UPDATE info SET individ_task = '$atask' WHERE username = '$key'";
    mysql_query($SQL);


    $SQL = "INSERT INTO $table_task (`username`, $atask) VALUES ('$key',     'pending')";
    mysql_query($SQL);

    $SQL = "UPDATE info SET task_status_indi = 'pending' WHERE username = '$key'";
    mysql_query($SQL);

    mysql_close($db_handle);
    print("<script>location.href = 'task_led.php'</script>");
}
else{   

    $namekey = $_REQUEST['key'];
    $user = $_SESSION['username'];
    include 'sql.php';

    $SQL = "SELECT * FROM info WHERE username = '$user'";
    $result = mysql_query($SQL);
    while ($db_field = mysql_fetch_assoc($result)) {
        $grp = $db_field['groups'];//telephone_tech
        $tsk = $db_field['group_task'];//resolve_telephone
    }

    print("<div style='top:167; left:380; position:absolute; z-index:1;'>");
    print("<table border = '0' width = '370' bgcolor = 'white'>");
    print("<tr><td>$tsk</td></tr>");
    print("</table>");
    print("</div>");

    $SQL = "SELECT * FROM task_list WHERE taskname = '$tsk'";
    $result = mysql_query($SQL);
    while ($db_field = mysql_fetch_assoc($result)) {
        $dsc = $db_field['ds'];
    }

    print("<div style='top:200; left:250; position:absolute; z-index:1;'>");
    print("<font face='Broadway' size = '4'>Description:</font>");
    print("</div>");

    print("<div style='top:197; left:380; position:absolute; z-index:1;'>");
    print("<table border = '0' width = '370' bgcolor = 'white'>");
    print("<tr><td>$dsc</td></tr>");
    print("</table>");
    print("</div>");

    print("<div style='top:270; left:350; position:absolute; z-index:1;'>");
    print("<form name='add_form' method='post' action='add_task_led.php'>");
    print("<table border = '0' >");
    print("<tr><td><b>Name:</b></td>");
    print("<td><input name = 'uname' type = 'text' readonly = 'true' value = $namekey></td>");
    print("</tr>");
    print("<tr><td><b>Task:</b></td>");
    print("<td><input name = 'task' type = 'text' value = ''></td>");
    print("<input name = 'hid_task' type = 'hidden' value = $tsk>");
    print("</tr>"); 
    print("<tr>");
    print("<td align = 'right'><input name = 'reset' type = 'reset' value = 'reset'></td>");
    print("<td><input name = 'cancel' type = 'submit' value = 'cancel'>");
    print("<input name = 'assign' type = 'submit' value = 'ASSIGN'></td>");
    print("</tr>");
    print("</table>");
    print("</form>");
    print("</div>");
    mysql_close($db_handle);
}

我需要帮助这一点，它应该得到的关键字从网址，如nbproject/add_task_led.php?key=Marija，把它放在$key变量，它似乎不工作。当我将名称直接放入本例中时，Marija而不是$key会更改DB。我做错了什么吗？

mysql

request

key

php

回答 1

Stack Overflow用户

发布于 2014-01-31 13:01:48

用于测试目的

您可以使用我总结为成功的以下代码设置测试表吗？

请确保更改这些变量以适合您自己的变量，或按如下所示创建它们：

$table_task = "table_task"; // table name
$atask = "a_task"; // column name
$db_selected = mysql_select_db('db_name', $db); // db_name is your DB

HTML/PHP/SQL (表单操作设置为self)

<?php
if (!empty($_REQUEST['key'])) {
  $key = $_REQUEST['key'];
  echo "key: ". $key. "\n";

$db = mysql_connect("host","username", "password");

$db_selected = mysql_select_db('db_name', $db);
if (!$db_selected) {
    die ('Can\'t use it : ' . mysql_error());
}

$table_task = "table_task";
$atask = "a_task";

$SQL = "INSERT INTO $table_task (`username`, $atask) VALUES ('$key', 'pending')";
mysql_query($SQL,$db);

// Used for my own testing purposes that you can comment out
// $SQL = "UPDATE $table_task SET a_task = 'pending_test' WHERE username = '$key'";
// mysql_query($SQL,$db);

}
?>

<!DOCTYPE html>
<html>
<head>
<body>

<form action="" method="get">
User: <input type="text" name="key" /><br />
<input type="submit" value="Send" />
</form>

</body>
</html>

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/21465375

复制

相似问题

问$key=$_REQUEST['key']不工作
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问$key=$_REQUEST['key']不工作EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问$key=$_REQUEST['key']不工作
EN