Web Technology Experts Notes

Saturday, 14 December 2019

How to add number of days to a date in PHP?

Program Example

$Date = "2020-09-19";
echo date('Y-m-d', strtotime($Date. ' + 1 days'));
echo date('Y-m-d', strtotime($Date. ' + 2 days'));

Output

2020-09-18
2020-09-19

Question: How to add number of days to a current date?

echo date('Y-m-d', strtotime("+10 days"));

It would add 10 days to the current date.

Question: How to subtract number of days to a current date?

echo date('Y-m-d', strtotime("-10 days"));

It would subtract 10 days to the current date.

Question: How to add number of days to a on given date?

$date = new DateTime('2016-12-14');
echo date('Y-m-d', ($date->getTimestamp()+ (3600*24*10) )); //3600 = 1 hour

It would add 10 days to the current date.

Question: How to subtract number of days to a given date?

$date = new DateTime('2016-12-14');
echo date('Y-m-d', ($date->getTimestamp()- (3600*24*10) )); //3600 = 1 hour

It would subtract 10 days to the current date.

Thursday, 12 December 2019

How to get the sizes of the tables in mysql database?

Question: How to get the sizes of the tables in mysql database?

SELECT table_name "Table Name",SUM( data_length + index_length ) / 1024 / 1024 "Table Size (MB)",SUM( data_free )/ 1024 / 1024 "Free Space(MB)" FROM information_schema.TABLES WHERE table_schema='mydb' GROUP BY table_name ORDER BY SUM(TABLE_ROWS) DESC

(Replace mydb with Your Database Name)

Output

Question: Get record counts for all tables along with size in MySQL database?

SELECT table_name "Table Name",SUM( data_length + index_length ) / 1024 / 1024 "Table Size (MB)",SUM( data_free )/ 1024 / 1024 "Free Space(MB)", SUM(TABLE_ROWS) AS "Total Record(S)" FROM information_schema.TABLES WHERE table_schema='mydb' GROUP BY table_name ORDER BY SUM(TABLE_ROWS) DESC

(Replace mydb with Your Database Name)

Output