SQL array var_dump shows nothing

Question

I have some code for load business-hours. My databas looks like

id - int(11)
day - varchar(255)
starttime - (time)
endtime - (time)
date - (date)
type - int(1)

I try to get the data with:

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);
?>

Only what is displayed is Connected successfully

I can't see the issue :(

I see no error handling or debugging attempted here

John Conde
– John Conde

2019-04-13 16:40:05 +00:00
Commented Apr 13, 2019 at 16:40 — John Conde
– John Conde, Commented Apr 13, 2019 at 16:40

Steve T · Accepted Answer · 2019-04-13 16:41:34Z

1

You are overwriting the result variable with an empty array. You should change the name of this array:

$result = [];

answered Apr 13, 2019 at 16:41

Steve T

5724 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joppieb · Accepted Answer · 2019-04-13 17:12:56Z

I found the issue on line 14

while($row = $query->fetch_assoc()) $result[array_shift($row)] = $row;

    <?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);
?>

Collectives™ on Stack Overflow

SQL array var_dump shows nothing

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related