Tag Archives: mysql

MySQL Singleton Class to allow easy and clean access to common mysql commands

The MySQL Database class is implemented using the singleton design pattern. This design pattern allows for only one single instance of the object. This one instance can then be obtained through a static method. This provides a convenience in that … Continue reading

Posted in MYSQL, php development | Tagged , , , | 3 Comments

Database PHP Session Handling

Database PHP Session Handling As you should be aware the HTTP protocol, as used for serving web pages, is completely stateless. This means that after the server has received a request, processed it and sent a response, the process which … Continue reading

Posted in MYSQL, php development, Uncategorized | Tagged , , , | Leave a comment

Allowing SuperAdmin access to Joomla for Demos

So you want to allow SuperAdmin access to joomla for demos, but you don’t want anybody to be able to do anything? Well, if thats what you want to do, then you will have to perform the following.

Posted in Content Management Systems, Joomla Development | Tagged , , , , , | 1 Comment

Restoring MySQL Dump with PHP

As web developers, we are usually tasked with deploying a project to a production server that we don&squo;t always have access to. And in most cases the projects require a database. The usual plan of action consists of running a … Continue reading

Posted in php development, Web Development | Tagged , , , , | 1 Comment

Using Mysql From Shell Scripts

Using Mysql From Shell Scripts Running mysql from a shell is not really a bash specific concern, but what we will be getting into for starters is running mysql from a shell script using the bash scripting syntax. For starters … Continue reading

Posted in Web Development | Tagged , , , | 1 Comment

Batch Image Resizing

[Download Photo Resizer] I would like to introduce our readers to installment [Download Photo Resizer]

Posted in Bash Scripting, Server Development | Tagged , , , | Leave a comment