Get Free PHP and MySQL Hosting with InfinityFree

For those who are seeking free web hosting to test their PHP / MySQL application can look into InfinityFree.net service which has interesting offers:

  • 99% uptime
  • No advertisement
  • PHP 7.0
  • MySQL 5.6
  • Includes FTP account access (rare !!)
  • Up to 10 Email Account
  • Apache 2.4 with .htaccess
  • 400 MySQL database
  • User can add their own domain
  • Free DNS service (including custom CNAME and MX record)
  • Unlimited Disk space and Bandwidth
  • Support Cloudflare CDN
  • Support SSL Certificate

The main advantages which entice me to InfinityFree are their support for SSL Certificate, 99% uptime guarantees and support for adding own domain name with their own free DNS.

The support for SSL certificate means that you can host Telegram Bot, Google Map web application and web app which utilizes OAuth API!

A rare sight for a completely free web hosting provider.

The only downside for InfinityFree is the free hosting only support up to 50,000 hits on the web server, which is fair by me as the free hosting could provide a good playground for Students and Web App Enthusiast to experiment with their code.

 

 

How to export SQLite3 database to *.sql file

Here’s a quick way to export SQLite3 database to *.sql text file.

sqlite3 this.db .dump > this-db.sql

The command is useful for exporting SQLite database to standard ANSI .sql which can be imported into other database management system such as Oracle, MariaDB/MySQL, etc

How to analyze 404 HTTP code from weblogs

The dreaded 404 HTTP code means page not found. However multiple 403 and 404 on weblogs also can also mean there are attempts to crack the website.

The awk script down here can be useful tool to analyze weblogs and identify multiple attempts at cracking the web application.

 

awk '($9 ~ /404/)' access.log | awk '{print $7}' | sort | uniq -c | sort -n

The script can also be tweaked for other HTTP status code too.

Get Free cronjob from Cron-Job.org!

Cronjob or CRON is an important tool to perform automated / schedule task for web application.

Some shared hosting company may limit (or completely disable) the cron service functionality leading to some web application unable to perform periodic / automated task.

Luckily there’s website such as Cron-Job.org which offers free cron-job to those who aren’t able to obtain one.

The best thing about Cron-Job.org service, is they allow minute-by-minute cronjob execution for free!

 

Bonus: The folks at Cron-Job also releases  the source code behind the service at GitHub!

Tips: Get Free PHP / MySQL Hosting with 000webhost.com

000Webhost.com is offering free PHP and MySQL Hosting to those in need those who are looking to simply to test out their PHP projects to the public (hint: Great for students !)

Advantages:

  • Offers free PHP 7.1 hosting, with
    • cURL
    • PDO
    • bcmath
    • PDO
    • SOAP
    • GD
  • Free MySQL Database hosting (2 database)
  • Built-in WordPress application (optional)
  • Easy to use File uploader
  • 1GB Diskspace
  • 10 GB bandwidth
  • Supports Cronjob
  • Cpanel
  • phpMyAdmin

However the free hosting does come with 1 hour downtime per day as an incentive for the users to upgrade.  Nevertheless it is still useful for students and hobbyist to test their website on the internet for free!