Connect With WRD
feed via e-mail
feed via e-mail

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.

FusionInvoice

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.

LiteCart

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.

CaseBox is an open source and PHP/MySQL-powered web application for storing + managing records, tasks and files.

It has a desktop-like interface where we can create an unlimited-level of directories and store stuff in the structure preferred.

Tasks with deadlines can be created, assigned to users and the progress can be tracked easily.

CaseBox

We can store the information of clients and any number of files there as well. The contents of the files are indexed so that locating a PDF/Word.. file with its contents is pretty quick.

The application is multi-user where each user can have custom permissions. And, it can be extended with plugins.

When it comes to blogging, WordPress and Drupal are the apps that everyone think of at the 1st place.

Besides their popularity, they can easily empower any level of complicated websites with the features offered.

Anchor CMS is again an open source CMS/blogging app (PHP-MySQL) but focuses on blogging, less features and simplicity.

Anchor CMS

It is easily themable and extensible, installed quickly and small in size.

The app accepts both Markdown and HTML when it comes to writing posts. Custom JS or CSS can be used per-post by simply drag ‘n’ dropping the files.

Anchor CMS is also very well-documented and multilingual (many language files exist already).

Today, many designers/developers and web agencies choose WordPress as the platform to create any type of client or personal websites.

As the number of WordPress sites owned/managed grow within time, it gets complicated to control all of them: their updates, backups, lots of login information, etc.

InfiniteWP is a free and self-hosted application (PHP-MySQL) that allows managing any number of WordPress installations from a single interface.

InfiniteWP

Under a single login, you can add all your WordPress sites  and perform plugin/version updates, backup/restores and manage themes for a single site or for all of them.

Besides these standard functions, new features can be added with premium add-ons like post or comment management, scheduling backups, generating client reports, Google Analytics integration, uptime monitoring and much more.

InfiniteWP Dashboard

For easier management, sites can also be categorized into groups (actions can be triggered on the group level too).

The application has a modern and easy-to-use interface which makes the usage a joy.

Huge discount for WordPress’ 10th birthday

InfiniteWP, for a limited time, is offering a heavily discounted “lifetime subscription” to its all premium addons + support to celebrate the 10th birthday of WordPress.

Any current and future add-ons + support for the lifetime is offered for $699 (which is normally valued for $5000+). If you plan to integrate InfiniteWP into your business, that’s  good deal.

The giveaway

Also, they are giving away “a preferred premium add-on” to 5 WRD readers.

In order to join, just comment to this post. Winners will be selected with the query below 1 week later (3 June 2013) and announced inside this post.

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

Good luck to all.

The winners

  • mr (comment #1266057)
  • dotcompals (comment #1266034)
  • Tim (comment #1266015)
  • Robert (comment #1265984)
  • Bruno França (comment #1265980)

Congratulations and thanks very much for joining.

When it comes to the word “social network”, Facebook and Twitter are probably the first ones that come to the mind. And, creating a new one can sounds like “creating an alternative to them (which is kinda crazy)”.

However, there are lots of niche social networks out there which are used by millions of people. And, creating a new one is not something crazy, actually, something not that hard.

Dolphin - Social Network Builder

Dolphin, a professional PHP web application, is the most popular self-hosted solution for building such communities.

The application has all the core features (and more) that can be expected from social networks like connecting with friends, status updates, messaging, chats, image/video sharing, groups or events.

Members can discuss on forums, have personal pages or blogs and there are even e-commerce features where the site owner and/or members can create stores and sell stuff.

Visitors can register with their e-mails or sign-up with Facebook Connect to see which other Facebook friends are there (also invite them).

Dolphin Demo

Considering audio/video is shared too much on social networks and handling audio/video streaming +processing can be expensive, Dolphin has a custom media server that takes care of this.
Read the rest of this entry »

Koken is a free and self-hosted CMS (PHP-MySQL) that is focused on building websites where portfolio/gallery is in the core (like designer or photographer sites).

The application has a powerful media manager for the images and videos. It allows organizing items as categories, date captured, license and more.

It has a simple and flexible content editor that allows editing with live previews. Also, inserting media, slideshows or social content (like tweets, Flickr, Instagram and Vimeo) is possible.

Koken

Koken has a templating engine for building new themes. And, it is currently in beta but will soon have plugins for extending further.

Also, for Adobe Lightroom users, there is a free “publish services” plugin for easily updating, editing and replacing content.

Uptime Robot
feed-holder
FeedBurner
PSD2HTML.com