Arrays to store DateTime from Database

Question

I'm trying to store the date from DateTime from PhpMyAdmin into an array in my code. For some reason, It only applies the last date to the position [0] from my array. Please help.

This is what I tried:

$id = $_SESSION['userId']; 
      $dBname = "infosensor";
      $conn = mysqli_connect($servername, $dBUsername, $dBPassword, $dBname);

      $sql = "SELECT dias FROM `$id`;";
      $result = mysqli_query($conn, $sql);
      $resultCheck = mysqli_num_rows($result);

      if ($resultCheck > 0)
      {
        while ($row = mysqli_fetch_assoc($result))
        {

          $horario = $horario .'"'.(date('H:i:s', strtotime(str_replace('.', '-', $row['dias'])))). '",';    

          $arr = array($horario);
        }
      }


      echo $arr[0];

The result that I get from the code I tried is:

"16:29:47","16:30:07","16:33:55","16:34:25",...

All of the at position [0]

I would need to when going into the array -> arr[0] = "16:29:47" when I want the position 1 I just use arr[1] = "16:30:07"...

Do you have a separate table for each user? – Dharman Nov 04 '19 at 12:38 — Dharman, Nov 04 '19 at 12:38
You keep overwriting `$arr`. – mickmackusa Nov 04 '19 at 13:04 — mickmackusa, Nov 04 '19 at 13:04
@mickmackusa How can I not overwrite it? – Matheus Nov 04 '19 at 13:10 — Matheus, Nov 04 '19 at 13:10

score -1 · Accepted Answer · edited Nov 04 '19 at 13:25

-1

Try changing this line like this:

$horario = (date('H:i:s', strtotime(str_replace('.', '-', $row['dias']))));

$arr[] = explode(',', $horario);

edited Nov 04 '19 at 13:25

Matheus

83
6

answered Nov 04 '19 at 12:39

Moshe Gross

1,206
1
7
14

I'm getting the answer as 'Array' :( – Matheus Nov 04 '19 at 13:02
I almost work, I don't want to print the whole array, just the position that I type – Matheus Nov 04 '19 at 13:09
What does `echo $arr[0];` output now? – Moshe Gross Nov 04 '19 at 13:11
I get this Ola Array ( [0] => "16:29:47" [1], but when I need to get only position 1, It prints position 0 with it, I don't need pos 0 when I print pos 1 – Matheus Nov 04 '19 at 13:16
Change this `$horario = $horario .'"'.(date('H:i:s', str.....` to `$horario = (date('H:i:s', str....` – Moshe Gross Nov 04 '19 at 13:18
As you keep on adding old value (position 0) to beginning of new value (position 1) – Moshe Gross Nov 04 '19 at 13:19
Just A quick question, I'm getting the right output, but it is printing like this Array ( [0] => 16:34:41 ), do you know how could I only get the date? – Matheus Nov 04 '19 at 13:26
Try adding [0] afterwards e.g. `echo $arr[0][0];` and `echo $arr[1][0];` – Moshe Gross Nov 04 '19 at 13:29

Mohit Gupta · Answer 2 · 2019-11-04T13:10:28.647

-1

First you need to initialise $arr = [] Then you can achieve this by explode.

$id = $_SESSION['userId']; 
$dBname = "infosensor";
$conn = mysqli_connect($servername, $dBUsername, $dBPassword, $dBname);

$sql = "SELECT dias FROM `$id`;";
$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);

$arr = [];
if ($resultCheck > 0)
{
    while ($row = mysqli_fetch_assoc($result))
    {

        $horario = $horario .'"'.(date('H:i:s', strtotime(str_replace('.', '-', $row['dias'])))). '",';
    }

    if(!empty($horario)){
        $arr = explode(',', $horario);
    }
}
print_r($arr);

edited Nov 04 '19 at 13:10

answered Nov 04 '19 at 12:43

Mohit Gupta

7
3

This worked but How can I access the Array? Is it like $arr[0]? And why is echo not working? – Matheus Nov 04 '19 at 13:04
here you can directly access $arr; for try echo $arr[0]; // output: 16:29:47 – Mohit Gupta Nov 04 '19 at 13:11
answer is updated now @Matheus – Mohit Gupta Nov 04 '19 at 13:14

Bhargav Chudasama · Answer 3 · 2019-11-04T13:23:49.187

-1

$arr = []; // define array here
while ($row = mysqli_fetch_assoc($result))
{

      $horario = $horario .'"'.(date('H:i:s', strtotime(str_replace('.', '-', $row['dias'])))). '",';    

      $arr[] = $horario; // add [] here and remove array()
}
//    print_r($arr);
echo $arr[0];

Output

Like this

arr[0] = "16:29:47" , arr[1] = "16:30:07"

edited Nov 04 '19 at 13:23

answered Nov 04 '19 at 13:03

Bhargav Chudasama

6,928
5
21
39

Yes, But I want to get only the arr[1] for example, why does it show me the other ones – Matheus Nov 04 '19 at 13:05
because you print the whole array that's why – Bhargav Chudasama Nov 04 '19 at 13:06
MR. DV please say reason for it? – Bhargav Chudasama Nov 04 '19 at 13:07
But I want just the position that I type, how can i get that? – Matheus Nov 04 '19 at 13:08
i did not understand what you get from array if you want only `$arr[0]` than use it, whats the problem? – Bhargav Chudasama Nov 04 '19 at 13:10
No, I have a bunch of dates, each of them is going to be displayed at different positions, that's why I don't want to print the whole array, just the position that I need – Matheus Nov 04 '19 at 13:11
which position bro? – Bhargav Chudasama Nov 04 '19 at 13:12
All of them, It will go into a loop further on, but your code prints this:```arr[0] = "16:29:47" , arr[1] = "16:30:07" ``` I need this: ``` arr[1] = "16:30:07"``` – Matheus Nov 04 '19 at 13:13
so you use `[]` inside `while loop` `$arr[]=` and its working – Bhargav Chudasama Nov 04 '19 at 13:15
If I want the position 1, for some reason the position 0 comes with it... If I want position 2 the position 1 and 0 come with it, that the problem – Matheus Nov 04 '19 at 13:18
and where you use this share exact code – Bhargav Chudasama Nov 04 '19 at 13:20
I will use this code inside a chart, The code from moshe gross worked, I will paste so you can have a look, It was because of the way I was getting the values into the variable – Matheus Nov 04 '19 at 13:22
and remove `array()` from code – Bhargav Chudasama Nov 04 '19 at 13:23

Arrays to store DateTime from Database

3 Answers3