Forum PHP.pl

[PHP] pobierz, plaintext 
    $druki_query = mysqli_query($con, "SELECT * FROM prace WHERE  user_id ='{$_SESSION["current_user"]}' ");
    while($druki=mysqli_fetch_array($druki_query)) {
             $date = substr($druki['data_'], 0, 7); 
             $miesiac = substr($druki['data_'], 5, 2); 
             $rok = substr($druki['data_'], 0, 4); 
 
 
             echo '<a href="a4.php?date_start='.$rok.'-'.$miesiac.'-01&date_end='.$rok.'-'.$miesiac.'-'.iledni($rok, $miesiac).'" target="_blank">'.$rok.'-'.$miesiac.'</a><br>';
 
    }
 
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT DISTINCT  `data_` FROM `prace` WHERE  `user_id` = '{$_SESSION["current_user"]}'
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT DISTINCT DATE_FORMAT(data_,'%Y-%m') AS DATA
FROM `prace`
WHERE  `user_id` = '{$_SESSION["current_user"]}'
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$data = explode('-', $druki['data_']);
echo sprintf("%d-%d",  $data[0], $data[1]);
[PHP] pobierz, plaintext 

Cytat(Tomplus @ 5.01.2024, 18:43:47 )

[PHP] pobierz, plaintext 
$data = explode('-', $druki['data_']);
echo sprintf("%d-%d",  $data[0], $data[1]);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$date = DateTimeImmutable::createFromFormat('Y-m-d', $druki['data_']) ?: null;
echo $date?->format('Y-m') ?? '';
[PHP] pobierz, plaintext