How to get all unique years from a date column using Sql(Mysql)?

Get all unique years from a date column using Sql(Mysql)?

SELECT distinct year(OrderDate) FROM Orders;

SELECT distinct year(column_name) FROM table_name;

Comments

How to use inner html value or data in php from javascript(innerHTML)?

use inner html value or data in php from javascript(innerHTML)? <html> <body> <p id="demo">use inner html value in php(innerhtml)</p> <script> var jassi = document.getElementById("demo").innerHTML; //document.write(jassi); </script> <?php $jassi = '<script>document.write(jassi);</script>'; echo $jassi; ?> </body> </html>

How to check date format in PHP?

Check date format in PHP function isCorrectDateFromat($date){ if(!empty($date)){ $dateString = $date; // Replace this with your date string $format = "Y-m-d"; // Replace this with your expected date format $dateTime = DateTime::createFromFormat($format, $dateString); if ($dateTime === false) { /* echo "The date is not in the correct format."; */ } else { $errors = DateTime::getLastErrors(); if (empty($errors)) { /* echo "The date is in the correct format."; */ return true; } else { /* echo "...

How to get all table names from database in wordpress?

Get all table names from database in wordpress. global $wpdb; $mytables=$wpdb->get_results("SHOW TABLES"); foreach ($mytables as $mytable) { foreach ($mytable as $t) { echo $t . "<br>"; } }

Php Tutorials

Search This Blog