Tag Archives: mysql

WampServer vs XAMPP

Posted on September 11, 2011 by Lex

This is not an Earth shattering post. Moreover, it’s not an objective one, that is, it is based on my experience and my experience only. WAMP is a bundle of Apache, MySql, and PHP (though often also Perl and/or Python) … Continue reading →

Posted in Tools, Web Development, Windows | Tagged , , , , , , , , | 8 Comments

Exploring Database Tables with jQuery

Posted on May 1, 2011 by Lex

I woke up this morning tired of phpMyAdmin, and decided to take a stand. phpMyAdmin is a web-based tool that most big hosting companies use for their shared hosting plans. It’s powerful in terms of the set of features it … Continue reading →

Posted in Misc, Tools, Web Development | Tagged , , , | Leave a comment

Commas in a PHP For Loop

Posted on April 24, 2011 by Lex

When generating a string that lists items (e.g. for a MySQL query) with a for-loop in PHP, you often need to add commas after every element except the last one. It may be trivial advice, but instead of having an … Continue reading →

Posted in Programming, Web Development | Tagged , , | Leave a comment

CRUD: Create, Read, Update, and Delete

Posted on February 15, 2011 by Lex

CRUD are the four basic operations commonly performed on a relational database. In MySQL for example, the four operation are implemented by INSERT, SELECT, UPDATE, and DELETE, respectively. The reason for this post is that I’ve had to program these … Continue reading →

Posted in Web Development | Tagged , , , , , | Leave a comment