我有一些加載工作時(shí)間的代碼。我的數(shù)據(jù)庫(kù)看起來(lái)像id - int(11)day - varchar(255)starttime - (time)endtime - (time)date - (date)type - int(1)我嘗試通過(guò)以下方式獲取數(shù)據(jù)：if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} echo "Connected successfully";function get_all_records($sql){ global $conn; $result = $conn->query($sql); $result = []; while($row = $result->fetch_assoc()) $result[array_shift($row)] = $row; return $result;}$sql = "SELECT day, starttime, endtime FROM schedule WHERE type = ";$shop_hours = array_merge( get_all_records($sql . "0 ORDER BY id"), get_all_records($sql . "1 and YEARWEEK('DATE') = '201915'"));var_dump ($shop_hours);?>僅顯示內(nèi)容已成功連接
2 回答
三國(guó)紛爭(zhēng)
TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超7個(gè)贊
您正在用一個(gè)空數(shù)組覆蓋結(jié)果變量。您應(yīng)該更改此數(shù)組的名稱：
$result = [];
料青山看我應(yīng)如是
TA貢獻(xiàn)1772條經(jīng)驗(yàn) 獲得超8個(gè)贊
我在第14行發(fā)現(xiàn)了問(wèn)題
而（$行= $查詢- > FETCH_ASSOC（））$結(jié)果[array_shift（$行）] = $行;
<?php
$conn = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
function get_all_records($sql){
global $conn;
$query = $conn->query($sql);
$result = [];
while($row = $query->fetch_assoc()) $result[array_shift($row)] = $row;
return $result;
}
$sql = "SELECT day, starttime, endtime FROM schedule WHERE type = ";
$shop_hours = array_merge(
get_all_records($sql . "0 ORDER BY id"),
get_all_records($sql . "1 and YEARWEEK('DATE') = '201915'")
);
var_dump($shop_hours);
?>
- 2 回答
- 0 關(guān)注
- 187 瀏覽
添加回答
舉報(bào)
0/150
提交
取消