PHP table with date start and end?

TrucksLOGByTrucksLOG

Hello. I'm looking for a solution, but unfortunately I'm stuck at the moment.

I have a vacation database with many employees from which I get a start date of the vacation (e.g. 2025-01-01) and an end date (e.g. 2025-01-07).

Now I have a table with the name and I want to color the columns according to the days. To do this, I use the query

 $insert = $this->pdo->prepare("SELECT * FROM Urlaub WHERE ma_id = :ma AND date_start > :datum AND date_end < :datum"); $insert->execute([ 'ma' => $maid, 'datum' => $datum ]);

Then I get the number of days with days_diff and can then color the columns via colspan.
This works well as long as an employee only has one vacation day in a month. However, as soon as two vacation days are entered (e.g., on January 3, 2025, and January 20, 2025), it creates two rows for me, because the day is always queried during the run, and then one vacation day is queried for each employee. Does anyone have any idea how I can get two vacation days in a row?

In this table you can see that "min" (the same employee (Armin from Table 1)) has vacation on the 17th and the 24th, for example, but this is shown in two rows. I would like to have this in one

(1 votes)
Loading...

Similar Posts

Node Red?

ByHerkulesGamer

Hey, I am currently doing a two-day trial internship and have been given a task with Node-Red. However, I am unable to access information from a website. I'm supposed to get electricity market data from SMARD using an inject and a function node, but I just can't get any further. I would be very grateful…

How do I pass data with input?

BydieTrolle

The use of input is actually quite clear. However, the question posed is intended to point out my problem, because I'm having trouble in the case presented. if ($sichern == true){ for($i=1; $i<4; $i++){ echo "<input type='hidden' name='vonMod[$i]' value='$vonMod[$i]'>"; echo "<input type='hidden' name='bisMod[$i]' value='$bisMod[$i]'>"; } echo "<p align='center'><br><input class='backa' type='button' value='nein, zur&uuml;ck' onclick='history.back()'>&nbsp;&nbsp;"; echo "<input…

Subscribe
Notify of
6 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Mirko Marek
Mirko Marek
2 months ago

Hi,

by the Aggregate function GROUP_CONCAT() in MySQL or more skillful PHP processing using to keep several vacations per employee in one line, you can solve the problem. Here I have an adapted example for you from the net:

$insert = $this->pdo->prepare("
    SELECT date_start, date_end FROM Urlaub
    WHERE ma_id = :ma AND date_start >= :start AND date_end <= :end
    ORDER BY date_start
");
$insert->execute([
    'ma' => $maid,
    'start' => '2025-01-01',
    'end' => '2025-01-31'
]);

$urlaube = $insert->fetchAll(PDO::FETCH_ASSOC);
0
tilfuerst
tilfuerst
2 months ago

Moin.

I’m not sure I got your problem right.

My proposal is:

Instead of trying to summarize with Colspan every holiday day in the table, just every day an employee has a vacation to color as a single cell. And if Thomas takes four days in a row, then four days are black and already it looks like a bar in the table.

Would be my proposal now. There are certainly many possibilities.

Much success,

T.

0
Neeuugiieerriig
Neeuugiieerriig
2 months ago
$insert = $this->pdo->prepare("
    SELECT * FROM Urlaub 
    WHERE ma_id = :ma 
    AND :datum BETWEEN date_start AND date_end
");
$insert->execute([
    'ma' => $maid,
    'datum' => $datum
]);
0
Neeuugiieerriig
Neeuugiieerriig
2 months ago
Reply to  Neeuugiieerriig

Unfortunately, I can’t post the php part anymore…

0
TrucksLOG
Author
TrucksLOG
2 months ago
Reply to  Neeuugiieerriig

It doesn’t work so much. I’m working on it, I think something’s wrong with the date. He’s giving me the nausea wild…

0
TrucksLOG
Author
TrucksLOG
2 months ago

I got it. Maybe my solution is not quite elegant, but works.
First, I read out all the employees who have vacations in that Mnat.
I then let them pass through in a foreach loop and then ask again with a for loop the day of 1-31. If the day coincides with the month, SQL gives me an array. Then I will check if the query contains data and then output it.
You could possibly solve this more elegantly, but it works first. The query with the Between unfortunately always brought multiple records.
Thank you.

0