Archive: web development

If you are feeling lazy, or would like to build in some future proofness into your system, you can use the MySQL Desc query to get table column information and then use this information to create dynamic SQL insertion strings.
For example:
PLAIN TEXT
PHP:

$cols_query = db_query("desc table");

while($cq = mysql_fetch_assoc($cols_query)){

    $cols[]=$cq;

}

foreach($cols as $c){

    if(!empty($_POST[$c['Field']])){

      [...]

I have been looking for this for ages - A URL pattern matching cache controller to disable caching on local / dev sites whilst maintaining normal caching operations on the rest of the web.
The solution is a Firefox addon called Johnny Cache (boom boom)!
More Reading:no matching posts found..

Sometime in MySQL you want to copy an entire table from one database to a separate database. One example of when you would want to do this is if you are making a backup of a table before you apply some kind of processing to that table. There is nothing worse than ruining a database [...]

My favourite platform for web development has to be Ubuntu Linux. As a desktop system to work on (rather than play) I think it is unsurpassed. However there are some times that you really need to use windows. For example my laptop seems to refuse to install Ubuntu which means that I am forced to [...]

osCommerce is an awesome ecommerce package. It has many critics and this is mainly due to the fact that unlike many modern open source packages it is not really ready to run "out of the box". That is a drawback, however it is not really so much of a drawback when you take into account [...]

Ubuntu Linux is undoubtedly the most successful desktop version of linux available today. It has managed to tempt across many dedicated windows users with its easy installation procedure, comprehensive bundle of applications including open office and firefox, its greater security and reduced vulnerability to internet viruses and malware. And of course the fact that it [...]

The web developer toolbar is an excellent addition to the great firefox web browser. It allows you ultimate control over the behaviour of your web browser and helps you to fine tune layouts. The toolbar has a real time html and css editor built in which is great for tweaking things. For those of you [...]