php - 如何修复未定义的索引 $user = $_GET['user'];
问题描述
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, PATCH, PUT, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Origin, Content-Type, X-Auth-Token');
header("Content-Type: application/json; charset=UTF-8");
include("global.php");
$conn = new mysqli(server, dbuser, dbpw, db);
$user = $_GET['user'];
//$customer = $_GET['customer'];
$querystring = "";
$querystring = "SELECT email, password, firstname, lastname from user ";
$result = $conn->query($querystring);
$outp = "[";
while($rs = $result->fetch_array(MYSQLI_ASSOC)) {
if ($outp != "[") {$outp .= ",";}
$outp .= '{"email":"' . $rs["email"] . '",';
$outp .= '"password":"' . $rs["password"] . '",';
$outp .= '"firstname":"' . $rs["firstname"] . '",';
$outp .= '"lastname":"' . $rs["lastname"]. '"}';
}
$outp .="]";
$conn->close();
echo($outp);
?>
这是数据库中的PHP代码,需要使用get方法。该错误显示未定义的索引:$user = $_GET['user'];
当我运行它时显示此错误。如何解决?
解决方案
我在下面的代码中添加了 IF 条件,您可以检查它。通过添加此条件,您可以解决未定义索引问题
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, PATCH, PUT, DELETE, OPTIONS');
header('Access-Control-Allow-Headers: Origin, Content-Type, X-Auth-Token');
header("Content-Type: application/json; charset=UTF-8");
include("global.php");
$conn = new mysqli(server, dbuser, dbpw, db);
if(!isset($_GET['user']) && empty($_GET['user']))
return false;// this will send back if data or index is not found and also solve the undefine index problem
$user = $_GET['user'];
//$customer = $_GET['customer'];
$querystring = "";
$querystring = "SELECT email, password, firstname, lastname from user ";
$result = $conn->query($querystring);
$outp = "[";
while($rs = $result->fetch_array(MYSQLI_ASSOC)) {
if ($outp != "[") {$outp .= ",";}
$outp .= '{"email":"' . $rs["email"] . '",';
$outp .= '"password":"' . $rs["password"] . '",';
$outp .= '"firstname":"' . $rs["firstname"] . '",';
$outp .= '"lastname":"' . $rs["lastname"]. '"}';
}
$outp .="]";
$conn->close();
echo($outp);
?>
推荐阅读
- json - 在 Swift 的 ObjectMapper 中使用 TranfsformType 映射类对象
- regex - 如何从字符串中删除电子邮件地址?
- r - 如何使用 dplyr 根据向量中字符串的存在来变异和赋值
- kotlin - 私有顶级扩展函数和类内部私有扩展函数的区别
- php - Builder.php 第 2405 行中的 BadMethodCallException:调用未定义的方法 Illuminate\Database\Query\Builder::answers()
- sql-server - 我想在 sql server 中将 20080910173240 转换为 2008-09-10T17:32:40.000+0000
- swift - 如何在 xcode 中删除构建警告消息
- redis - 如何将 Redis DB 配置为只读?
- python - 在哪里存储 tns、用户名和密码,以便在 Unix 中与 Python 和 R 一起使用 Oracle DB 连接
- jquery - 使用 jquery DataTables 插件时向行 (tr) 标记添加值