How to Get Week Number from Date in PHP MySQL?

Feb 10, 2022 . Admin

Hello Friends,

I am going to explain you example of how to get week number from date in PHP? , you will learn get week number from date in PHP. you will learn find week number from date in PHP. I would like to share with you calculate week number from date PHP query.

We will use get search how to use get week from date PHP. You can understand a concept of get week number in PHP. So, we can how to get week no from date in PHP. I explained simply about how to get week wise data in PHP.

You can see both example of get week from date PHP.

Table: user_payments


So, let's see bellow solution:

index.php
<?php>
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_php";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT 
            id, 
            charge, 
            WEEK(payment_date) 
        FROM `user_payments`";

$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    echo <pre>';
    print_r($row);
}

?>
Output:

Array
(
    [id] => 1
    [charge] => 50
    [WEEK(payment_date)] => 31
)
Array
(
    [id] => 2
    [charge] => 45
    [WEEK(payment_date)] => 36
)
Array
(
    [id] => 3
    [charge] => 10
    [WEEK(payment_date)] => 5
)
Array
(
    [id] => 4
    [charge] => 10
    [WEEK(payment_date)] => 1
)
Array
(
    [id] => 5
    [charge] => 66
    [WEEK(payment_date)] => 1
)
It will help you...
#PHP