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.
If you are looking to operate a web site from your Mac, MAMP- a package of free web software programs- is an elegant solution. This video will show you how to configure MAMP on your computer, so you can get on your way running your sites.
This video how-to is a good intro for beginners, helping them understand the creation of an object oriented validator class. This can all sound confusing, so follow the example and learn how to add it to your coding quiver.
This tutorial for PHP beginners introduces the viewer to the concept of class inheritance. As your coding career takes off, you'll need to know as many ways to work efficently and code with speed to save time and money. Check it!
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.
This tutorial teaches you how to create an RSS feed with PHP using DomDocument. You can generate the items with a database loop, and this example uses a very simple array. Take a few minutes and add some more knowledge to your PHP world.
In this tutorial you'll learn about a simple PHP login script that serves to check your MySQL database against a user/password. The code in this video is a quick and dirty procedural code, but it's enough to get you going so you can try it out yourself.
In this PHP how-to tutorial you'll learn how to get started using Smarty Template Engine for PHP. This is a basic intro for PHP coding newbies, so if you're a pro, move on. If you're not a pro, watch the vid and get a little closer.
Technology: The Less You Know the Better?
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...
This tutorial provides some more useful information for PHP beginners. You'll get a quick overview about post, get and request superglobal variables. From this you'll learn how to handle a URL and a form. Don't be shy, jump in and see if PHP is right for you.
This quick little video teaches you about the switch statement and ternary operator for use with your PHP programming. It's quick so you may want to take notes to ensure it's all sticking in your gray matter hard drive. Go!
This tutorial provides a quick and clear example of how string manipulation works. A string is a line of text, and once you're up to your elbows in zeros and ones, you'll want to do lots of manipulation. Let's get digital, digital.
If you're programming with PHP and you generate a list of music files, you'll want to find a way to play them. This video shows how to use the Yahoo Media Player to play the list of mp3s you've created, with your PHP coding.
In this video, you'll use Scope and create a simple calculator while learning a little about private, public and protected properties in OOP programming. If you're looking to bone up your PHP coding skills you'll want to check this video out.
In this tutorial, learn to setup private properties(variables) and private methods(functions) with your PHP OOP programming. This tutorial will have the file logger run through some private methods. Check it out and open the door to the world of PHP programming.
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.
Abstract classes can not be created and should be thought of as template classes. If you're programming in PHP OOP, check out this tutorial to get and idea of what abstract classes are and how to use them. Good luck!
When coding with PHP OOP you may encounter the need for static methods or static classes. This tutorial will give you an overview of how to use these functions and when you should use them at all. Get coding people!
If you're doing some OOP programming you can use Magic Methods to help you out. This tutorial will show you three of the methods and they all have good uses if you need them. Magic methods alwasys start with two underscores!
When you're doing PHP programming, you'll likely want to have some regions that are strictly off limits to the user and should be accessible only to the programmer. This is when you'll want to use encapsulation to create an area within your coding that's for your eyes only.
This video presents a basic introduction to SPL (Standard PHP Library) in PHP programming. You'll be dealing with itertators, which will allow you to loop through operations. This is a basic intro, but gives you a good idea of what you'll be dealing with.
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.
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.
Learn to create and use the Decorator pattern in PHP by following along with this instructional video from JREAMdesign. The Decorator pattern is very handy when it is time to "decorate" an object by "adding", for example, frosting, nuts and sprinkles to a cake by sending it to various "decorating stations."
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.
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.
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.
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.
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.
Learn how to properly use and implement getters and setters in your PHP programming by following along with this informative video. By constructing a very simple program on his computer, JREAMdesign demonstrates how getters and setters work within PHP programming.
Learn to serialize your data and convert multidimensional arrays into a single string by following along with this informative video from JREAMdesign. Serializing your data essentially compacts it from an expanded array into a string series of values, a very handy PHP feature indeed.
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.
One of the things you'll need for a successful future in programming is a great re-usable library of code. In order to achieve that you'll need to practice strict organization and consistency with your coding. This tutorial shows you how to do both, and help up your PHP proramming potential.
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.
In the world of coding you want to be clean and efficient. A great way to do this is with an IDE, such as Netbeans IDE. If you're ever working with a team, knowledge of a great IDE is a must. Check out this PHP coding tutorial and up your knowledge base.
When you're working with PHP OOD (Object Oriented Design)you want to create objets that are singular and serve a specific role. This tutorial shows you how to easily couple and decouple things when designing - and when you should and should do it too.
This tutorial shows you how to set up an interactive chat box on your website, so you can allow members to communicate with each other in real time. It can be a bit tricky to master, but will definitely be worth it for your site in the long run.
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?
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!