Everything Else

How To: Execute a Basic SQL Query Using dbForge Studio GUI for MySQL

If you need to build a SQL query, you can choose one of two alternatives. The first and a rather old way is using a console. But if you build your queries in MySQL console, you have to remember all the commands and keys. This is not a convenient way, because query execution is a time-consuming process. Another way is to use some graphical interfaces for MySQL. It can fulfill many developers' requirements, including query execution.

How To: Use a singleton pattern in PHP programming

This PHP newbie video with teach you what a Singleton Pattern is and how to use it in your PHP programming. PHP OOP Singleton is great for a database connection when you only want one consistent connection in your application. So, to prevent wasting space accidentally by calling it twice in different areas, this is good way to protect it. Singleton is very popular and used often in Database Connections.

How To: Protect Your PHP Website from SQL Injection Hacks

As a web developer, I often read articles about hackers (from the lowly to the knowledgeable) infiltrating websites via the dreaded 'SQL Injection' method and completely taking control, changing, gaining access, or destroying the owner's data. As a fellow web developer, I'm sure you want to know how to protect against it. Well, here it is! In this article, you will find out what SQL Injection is, what you can do to protect against it, and additional recommendations that are easy to do and onl...

How To: Program faster with some PHP speed tips

If you're looking to shave a few milliseconds off the Zend Engine's work load, check out this tutorial for some PHP programming speed tips. This efficency will pay off when you have tons of traffic to your site and save you valuable server resources.

How To: Chain methods in your PHP object programming

Chaining methods in PHP can be simple and straightforward if you follow along with this informative video tutorial on PHP OOP methods from JREAMdesign. The key action is to return the object after running the function so that you can run another function to the object directly afterwards.

How To: Use type hinting in your PHP design patterns

Type hinting in PHP appears frequently in design patterns but can be distinctively confusing unless you are totally familiar with it. This walkthrough from JREAMdesign raises your exposure levels to using type hinting in your parameter functions with objects and arrays.

How To: Use the Facade design pattern in your PHP programming

This tutorial from JREAMdesign reviews the Facade design pattern and how it specifically relates to PHP programming. In the facade pattern, a complex subsystem and calling class are hidden from each other through the use of a Facade class. This video guide walks through the construction of a Facade and demonstrates its use.

How To: Utilize the MVC Pattern in PHP programming

The "Model View Controller" pattern, or MVC, is a paradigm of programmatically organizing an application into three parts: the Model, the View and the Controller. This video tutorial from JREAMdesign summarizes the purposes of the various components and how they interrelate with the program within this pattern. Several options for working with MVC are also highlighted.

How To: Create PDO's (PHP Database Objects) in PHP

Learn to work with PDO in PHP with this informative video tutorial from JREAMdesign. The PDO extension is a consistent interface for accessing several types of databases in PHP and it has a ton of options. This knowledge is also required for Zend Certification.

How To: Use SimpleXML to load XML into PHP

Learn to utilize SimpleXML in this PHP tutorial to load and access XML from within PHP. This video shows how to load an XML file into a PHP array variable and get values from within that array. This informative video from JREAMdesign shows you step by step.

How To: Choose the right PHP framework and CMS

In this video tutorial, JREAMdesign looks at the task of choosing a PHP framework and a CMS. He helps simplify the act of choosing between the major framework contenders (Zend Framework, Symfony, Yii, Code Igniter, CakePHP) and content management systems (Drupal, WordPress, Joomla, Wolf CMS, Mod X) by summarizing what normally is expected from these systems and some of their typical features.

How To: Use composition instead of inheritance in PHP

While inheritance is very useful within PHP and OOP, it is notably better to favor composition over inheritance. In this video walkthrough, JREAMdesign demonstrates the composition concept with interrelated functions, and also shows a way of logically organizing the resultant files.

How To: Save your server resources with PHP caching

Sometimes server space can be an issue, especially when you're talking about costly actions such as iteration, file scanning, and numerous queries. In those instances it's often best to cache! This tutorial gives you a simple example which can help your site load faster and take less abuse.

How To: Use PHP array programming to make a user agent sniff script

OK, so visitors are coming to your website and they're even leaving comments! Now, with some simple PHP array programming you can find out what browser and OS they're using. This tutorial shows you how to create a simple and efficient user agent sniff script to get the information you want. Sniff, sniff. Is that Chrome running on OS X I smell?

How To: Update a table with a trigger when using SQLite 3

In this clip, we learn how to update a table with a trigger when using SQLite 3. Whether you're entirely new to the SQLite embedded relational database management system or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more information, take a look!

Prev Page