Force download a file automatically and keeping statistics with PHP

Many times when we go to download software we click the vendor’s download link on their site and are immediately taken to a download page where it says “the download will start immediately, if not please click this link.” So how do we actually go about doing this?
Read more

Using MySQL date functions to save time in PHP

Ever since I started using PHP, if I ever needed to store a timestamp I always stored it as an INT. Only until recently have I switched over to using the DATETIME and TIMESTAMP data types in MySQL exclusively for any dates I needed. These fields are in the format of YYYY-MM-DD HH:MM:SS. When I first start using these field types, I didn’t know how to convert back and forth to a UNIX timestamp for use in PHP so I made a bunch of functions in PHP to convert between the two. That was until I found out about the MySQL date and time functions.

Read more