MySQLi Handler Class

Last year I have created a mysqli class to wrap’s it’s most basic methods and encapsulate the whole database layer providing a little bit more of security. I have always felt that were some items on that class that could be re-written and improved, so I have re-created the MySQLi Handler class.

It’s a wrapper for the mysqli methods and query constructor with pagination. It make simplier to work with the daily sql statements in a fast wizard way.

It’s not a Zend Framework Database Manager, but hey, if you cant use Zend Framewor or Pearl DbManager, it might help you.

As a note, for the next version it might have some AJAX methods attached for the pagination process.

Anyway the class is under GNU General Public License and you can download it here

Vcard

I have build a very simple class that parses a Vcard file type. The class will read a file with a Vcard, parse all information in it and output an array with the information. Once you get the array you can easily access it and uses it’s information for another class such as user or contacts.

The class is bellow and you can use it, modify it, just make a reference where you got it from (thanks): Vcard.zip


# The class is very simple, it will build an array with all the information of the Vcard
# This is an example of the return of the parser

Array
(
[name] => Array
(
[lastname] => Robot
[firstname] => Tired
[middlename] =>
)
[fullname] => Tired Robot
[business] => Tired Robot Blog
[title] => Blog Picture
[note] => Any notes associated with this contact
[phone] => 5615615561
[home] => 5615615562
[cell] => 5615615563
[fax] => 5615615564
[address] => Array
(
[0] => 1234 NW Street with no Name St
[1] => Deerfield Beach
[2] => FL
[3] => 33442
[4] => United States
)

[url] => mcloide.wordpress.com
[email] => info@mcloide.wordpress.com
)
*/