This is a simple trick to get the changes caused by the UPDATE query.
The trick is to get a copy of the row before and after UPDATE query and compare those rows to get the changes. If you would like to go for something complicated than this one, then you should check the MySQL TRIGGER.
This is a simple php function for hashing a plain text password so that it can be saved into the database securely.
I was very much interested in the database class of CodeIgniter, especially the Active Records.
I was quite satisfied with an old mysql wrapper that I have been using for long time. But I’ve decided to start using MySQLi for all my future projects so started to write my own database wrapper for php.
php.net official recommend the usage of mysqli over mysql if we are using MySQL database version 4.1.3 or more.
The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer. The mysqli extension is included with PHP versions 5 and later.
The class has been made available online for free and is available at https://bitbucket.org/getvivekv/php-mysqli-class
For a complete documentation, refer https://bitbucket.org/getvivekv/php-mysqli-class/wiki/Home
The code was heavily inspired from CodeIgniter free library. The code is freely available for anyone to download. If you find any error or have any feature to add, please report me. You can also post new issue if you find any bug.
I am glad to release a free and open source ticket management system – “Fuse”.
Fuse is a simple ticket system which requires nearly zero configuration. It is built using CodeIgniter and Twitter Bootstrap frameworks. Fuse does not boast any special features. It is designed for small size organization with a couple of staffs managing the tickets.
Fuse Ticket Management System is still in development and is available for downloading at Fuse Website
Fuse offers basic functions of a ticket system. This was developed using CodeIgniter framework in less than 8 days. The development is still going on. I am not a CodeIgniter guru, this was my simply try to refresh my memory about CodeIgntier PHP Framework. If you find any bugs in the application, please do report.
Well, I did. I was writing some ajax calls to post some data to an php file and show the output received. One solution came to my mind was the jQuery Apprise plugin. I used this plugin in some of my projects. It’s pretty good.
However, the current project was heavily using the Twitter Bootstrap framework so to match with the current theme, bootstrap modal is what I preferred.
This simple jQuery function will inject a bootstrap modal window to the page and show the message that we want the user to see. The script was developed in hurry for a project so just the basic functionality is included. I plan to extend this code snippet soon when I get free time.
View Demo of BootAlert
Download the source code at BitBucket
View project at BitBucket