Understanding PHP Data Types
Variables can store data of different types, and different types of data can do different things. For example, you can add variables whose values are numbers [more…]
Building SQL Queries
SQL is almost English; it's made up largely of English words, put together into strings of words that sound similar to English sentences. In general (fortunately), you don't need to understand any arcane [more…]
Troubleshooting a PHP Script
You just can't write scripts without making certain mistakes. The trick is to train yourself to recognize them, roll your eyes, say, "Not again," and just fix them. One error message that you'll see many [more…]
Setting Up Your Computer for PHP and MySQL Web Site Development
To use your local computer to develop your Web site, you must install a Web server, PHP, and MySQL. PHP and MySQL are free to download and use. [more…]
Considering the Various Uses for the PHP Scripting Language
PHP is a general-purpose language that can be used to write general-purpose scripts. Scripts are computer files containing instructions in the PHP language that tell the computer to do things, such as [more…]
Keeping Up with PHP and MySQL Changes
PHP and MySQL are open source software. If you've used only software from major software publishers — such as Microsoft, Corel, or Adobe — you'll find that open source software is an entirely different [more…]
Use PHP Statements to Create Programs
PHP programs are a series of PHP statements, executed one at a time. Here’s a list of the PHP statements (with syntax) that you use when writing PHP programs: [more…]
Communicate with a Database through PHP MySQL Functions
PHP communicates with MySQL databases by using a set of functions developed specifically for this purpose. This list shows the syntax of these frequently used functions. [more…]
Access and Adapt a Database with MySQL Queries
PHP communicates with MySQL databases by sending SQL queries. Here’s a list of SQL queries, with their syntax, that you can use to access, view, and alter the database: [more…]
Knowing the MySQL WHERE Clause Format
The WHERE clause is used to modify a DELETE, SELECT, or UPDATE SQLquery. This list shows the format you can use when writing a WHERE clause: [more…]
Make MySQL Database Changes with the ALTER Query
The ALTER query is used to change the structure of a MySQL database. This list shows the syntax for the changes you are most likely to want to make: [more…]
Special Characters to Use in PHP Expression Test Patterns
Regular PHP expressions use patterns to test whether the input users submit when using online forms are in the correct format. This table shows characters you can use in patterns. [more…]
PHP & MySQL For Dummies Cheat Sheet
When writing PHP programs to create your Web database application and communicate with a MySQL database, you have many things to remember. You must spell code correctly and use perfect syntax. This Cheat [more…]
WHERE Clause Format for PHP and MySQL Web Development
You’re developing Web pages using PHP & MySQL, and because you’re developing Web pages and/or databases, you need to write WHERE clauses so that you can sort through data. The following list shows the [more…]
Changes for the ALTER Query in PHP and MySQL Web Development
Using PHP and MySQL in developing your Web site and/or database means you often get do things the easy way, and the following list shows you just how easily you can change things [more…]
PHP and MySQL Functions
Doing Web development with PHP and MySQL, you need to use MySQL functions to run your subroutines, whether you’re writing a connect routine or a query. The following list shows the format for these functions [more…]
PHP Statements to Use for Web Development with PHP and MySQL
You'll use PHP statements when developing Web sites and databases with PHP and MySQL. The following list lays out the key PHP statements and the necessary format: [more…]
Special Characters Used in Patterns in PHP and MySQL Web Development
To search for patterns in Web sites and databases developed using PHP & MySQL, you use a list of special characters. You don’t have to channel Daffy Duck [more…]
PHP & MySQL Web Development AIO For Dummies Cheat Sheet
Using PHP and MySQL to develop your Web site and/or database gives you lots of tools and lots of options, but you have to become familiar with how each program operates so that you can properly format [more…]
Components of a WordPress Template Tag
A WordPress theme is a collection of WordPress templates made up of WordPress template tags. As the core component of WordPress templates and plugin functions, you need to understand what makes up a template [more…]
How to Program a Basic WordPress PHP File
To make sure you understand the basics of PHP, including how to start and stop PHP within a file, try your hand at a little sample of PHP code. Follow these steps to create a simple HTML web page with [more…]
MySQL Database Structure in WordPress
A lot of new WordPress users are pretty intimidated by the MySQL database, perhaps because it seems to be way above their technical skills or abilities. Truth be told, regular WordPress users — those who [more…]
How to View the Template Files in a WordPress Theme
A WordPress theme, is actually a group of templates that makes up the theme. A WordPress template, is only one of the theme’s template files that contains WordPress template tags. WordPress [more…]
