我正在尝试从sqli表中检索一些数据并将数据保存在变量下(这里称为total_one)下,以便稍后可以使用它来创建图形。
数据库不是问题,我已经在站点的其他部分使用它,没有问题,并且连接已经创建并且可以正常工作。
我曾尝试寻找其他人在本网站和其他网站上问过类似问题,但似乎无法解决此问题<?php
require "header.php";
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
//this is where the data perviously entered is put into graphs
$username = $_SESSION['userUsername'];
$one = date("Y-m-d", strtotime("previous monday"));
$two = date("Y-m-d", strtotime("previous tuesday"));
$three = date("Y-m-d", strtotime("previous wednesday"));
$four = date("Y-m-d", strtotime("previous thursday"));
$five = date("Y-m-d", strtotime("previous friday"));
$six = date("Y-m-d", strtotime("previous saturday"));
$seven = date("Y-m-d", strtotime("previous sunday"));
$sql = "SELECT * FROM $username WHERE day='$one'";
if($result = mysqli_query($conn, $sql)){
if(mysqli_num_rows($result) > 0){
$overall_one = $row['overall'];
}
else{
$overall_one = "5"; //this is the default number if they have not entered any data on that day
}
}
else{
$overall_one = "5"; //this is the default number if they have not entered any data on that day
}
这是代码的开头,错误在行上:$ overall_one = $ row ['overall'];我从sql表$ username中选择数据,其中日期与存储在变量“ day”中的日期匹配。
我正在尝试从sqli表中检索一些数据并将数据保存在变量下(这里称为total_one)下,以便稍后可以使用它来创建图形。数据库不是...