Posts Tagged ‘Mysql’

For any small business or freelancer, keeping track of the client invoices and payments is a job that is handled personally.

Using an online invoicing solution can help minimizing the effort spent on the task and, FusionInvoice, a free + open source invoicing app can help.

FusionInvoice is built with PHP/MySQL and has a simple-yet-nice interface.


Using the app, we can define clients, send quotes, convert quotes to invoices or create and send the invoices directly. Invoices can be set as “recurring” as well.

As a payment system, there is only support for PayPal and any other payment provider will require some custom coding.

In the dashboard, it is possible to filter records, view reports and also create guest users (like clients) which only has read permissions so that they can view their invoices and payments too.

LiteCart is a free and open source shopping cart application that is built with PHP-MySQL.

It is light, not in means of features but for the usage (less clicks, improved usability..) and for development.


All the main features of an e-store is offered as a standard and more stuff exist like: product groups, different prices per currency, automatic backups and more.

And, there is an easy-to-use control panel for setting up the store and managing everything about it.

Solo is a free project management application that is built with freelancers in mind.

It is self-hosted, created with PHP and uses MySQL for storing the data.

The application has a slick interface where a single user (limited to a user) can create any number of projects + tasks and bind them with clients.

Free Project Management Tool - Solo

Tasks can be easily searched, reordered with drag ‘n’ drops and files can be attached to them.

File uploader is also powerful, it can handle multiple files and has inline file previews.

There is a project calendar to view tasks quickly, an activity stream shows all the footprint of yours and a timer helps you keep track of the time spent for each task/project/client.

AfterLogic WebMail Pro is a self-hosted and feature-rich webmail client which has features to attract both end-users and hosters/system admins.

Info: 3 licenses of the app is being given away. Details can be found at the bottom.

WebMail Pro has a very good-looking, modern and light interface where browsing through the e-mails is easy and all the controls are positioned where you expect them to be.

WebMail Pro

It has complete support for IMAP + SMTP, can filter or forward e-mails, has built-in search and a user-friendly attachment uploader with drag ‘n’ drop support.

The app is built with PHP-MySQL, can be installed easily, integrates with all the major control panels and a single installation works with multiple domains.

Also, a user can switch between multiple accounts without logging out and logging in which is a time-saver.

WebMail Pro Calendar

There is a powerful calendar for (recurring) events and reminders where all can stay in sync with iOS devices. An address-book exists too.

And, it works very fast, thanks to a smart caching mechanism that preloads e-mails in the background and displays instantly on-click.

For integrating WebMail Pro with any other app, a full-featured API is there as well.

The giveaway

3 licenses (100 user version) of WebMail Pro is being given away and, in order to join, just comment to this post.

The winners will be selected a week later (9 September 2013) randomly with the query below:

SELECT * FROM wp_comments WHERE comment_post_id=4518 AND comment_approved=1 AND comment_type='' GROUP BY comment_author_email ORDER BY RAND() LIMIT 3

Good luck to all.

Experienced web developers usually have a ready-to-use register/login code (from older projects) that they can reuse.

For newbies or any developer without such a starting point, this login script with PHP and MySQL can be handy.

It is simplistic, object-oriented and secure (bcrypt with blowfish and using the official PHP password hashing functions).

PHP-MySQL Login Script

The files in the package are well-organized and only a single database table is used.

There are 4 versions that cover every need from simple to full-MVC-framework-like usage.

Most advanced version has all the features like login, register, forgot password, captcha support, edit account, account package, avatar and more.

Script is totally free and open source. Also, it is actively developed and well-documented.