Why PHPMYADMIN is the ultimate leader

Posted by David Mugo on September 16th, 2008 in General, How To, PHP/MySQL 1 Comment

Somehow, open source always rules. There are many commercial and free mysql management tools that are great and really easy to use. I have used a whole line of them, from Navicat MySQL, SQLYog for MySQL and many more. MySQL front was another one that was opensource until it outgrew itself.

PHPMYADMIN, web-based mysql management tool is among the best tools i have ever used in my entire career. There may be options but 68% of web hosts use it, 75% of mysql developers do use it and there is no end to the starts. It is the ease in understanding it, the web interface that is easy to run, availability and the fact that its FREE to use. Its also quite easy to install and most of the pre-packaged apache/PHP/MySQL installations come with PHPMYADMIN pre-installed.

Lets hear you here, what is your best choice? I stand for PHPMYADMIN!

Tags: , , , , , , , ,

XAMPP: An approach to PHP on a Windows environment

Posted by David Mugo on September 16th, 2008 in General, PHP/MySQL No Comments

First, this is for the you who is thinking of your first PHP applications and you want to run and test them on a Windows environment. You need to have a web server and a database server installed. PHP runs best on Apache and the choice of a database server narrows to mysql.

Many people know from their own experience that it’s not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. I use XAMPP which is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use - just download, extract and start.

At the moment there are four XAMPP versions:

  • a version for Linux systems (tested for Ubuntu, SuSE, RedHat, Mandrake and Debian),
  • a version for Windows 98, NT, 2000, 2003, XP and Vista,
  • a beta version for Solaris SPARC (developed and tested under Solaris 8),
  • and a beta version for MacOS X.

I have developed most of my applications on XAMPP and i highly recommend it for anyone who wants an easy way to develop and run PHP applications on a Windows environment.

Tags: , , , , , ,