MySQL

February 22, 2013 MySQL , PHP no responses # , , ,

Koken – An Impressive Free CMS For Creative Websites

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.

Requirements: PHP 5.2+, MYSQL 5+

Website: http://koken.me/
Download: http://help.koken.me/customer/portal/articles/632102…

February 19, 2013 Development , MySQL , PHP , Project Management no responses # , , , ,

BugKick – Open Source Bug Tracking App

BugKick is an open source bug tracking and task management application (source is hosted on GitHub) that is “light” in means of features (which i sometimes nice).

It is built with PHP-MySQL and allows teams to define projects, add tasks to them (which can be tagged with anything like “bug” or “feature request”) and assign to teammates.

BugKick

Discussions under each task is possible, status updates about each of them are delivered via e-mail and closed ones are not deleted but kept.

There is an API for integrating it into our own apps and a JavaScript snippet + a contact form helps users to submit bugs too.

Requirements: PHP, MySQLWebsite: https://bugkick.com/
Download: https://github.com/aaronmusopen/bugkick

December 3, 2012 MySQL , PHP no responses # , ,

Textpattern – Open Source & Full-Featured CMS

Textpattern is an open source content management system, built with PHP/MySQL, that offers a flexible usage for designers, publishers/bloggers and end-users. The application uses built-in tags for retrieving and displaying dynamic content which gives you a complete control over the content and presentation.

Textpattern has the capability to build any type of website with sections, categories and different page layouts with a mini​malist admin interface that can be used by an unlimited number of admin users (with custom privileges)

Continue reading

December 3, 2012 MySQL , PHP , Project Management no responses # , , , ,

Kimai – Open Source Time Tracking Web App

Those days nearly all project management applications can calculate the time that is being worked on projects to use them in various reports. If you are not using such a project management system and looking for a simpler solution just to track time, Kimai can be a good alternative.

It is a PHP-powered, open source web application that enables us to define projects/tasks and record the time we work on each item.

Kimai - PHP Time Tracker

Although it is web-based, the timer keeps working even if the browser is closed unless it is stopped. After collecting the data, it can generate a report of your activities on demand (yearly, monthly, daily, by customer/project/action).

The application stores the data in a MySQL database and it has a multilingual interface.

Website: http://www.kimai.org/en/

August 21, 2012 MySQL no responses # ,

Copy one field to another in MySQL

Rule is simple:

udpate table_name set  destination_column=source_column

If you want to update multiple tables and you can join on that table you can use the join syntax also in the UPDATE:

Continue reading

June 2, 2011 MySQL , Wordpress no responses # ,

Moving WordPress site to new domain

When You decide to reorganize the blog link URL to make it tidier or to reflect new focus or theme of the blog. If you decide to change the URL or link location of your WordPress blog due to changing of domain name (such as from http://www.old-domain.com/ to http://www.new-domain.com/) or the blog to another directory location (such as from http://www.domain.com/ to http://www.domain.com/blog/), there are some steps that should be done to ensure the proper migration and no breaking links.

The tricky part when moving WordPress blog to another location is that WordPress is using absolute path in URL link instead of relative path in URL link location when stores some parameters in database. Within blog posts’ contents itself, users may also use the old URLs when creating reference backlinks. All these values in the database will need to be changed when WordPress is moved. The following guide will show you which database fields that has references or values related to blog’s URLs that you want to modify. Note that this guide is not about how to move WordPress blog from one server or host to another new hosting service.
Continue reading

Pin It on Pinterest