-
Popular Articles
Build Your Own Database Driven Web Site Using Php & MySQL, Part 4: Publishing MySQL Data on the Web
Derek Featherstone: Accessibility is not About Compliance
Build Your Own Database Driven Web Site Using Php & MySQL - Fourth Edition
Build Your Own Database Driven Web Site using Php & MySQL, Part 3: Introducing PHP
Build Your Own Database Driven Web Site Using Php & MySQL, Part 2: Introducing MySQL
Build Your Own Database Driven Web Site using Php & MySQL - Part 1: Installation
How To Handle File Uploads With PHP
-
Access Control: The PHP Code
Explore Article Recent Articles (Jun 30 2010)
Here it is: the most complex coding project that we tackle in this course! We’ll make heavy use of include files to keep our code organized and reusable. (Read Full Article)
-
Access Control: The Database
Explore Article Recent Articles (Jun 30 2010)
One of the most common reasons for building a database driven web site is that it allows the site owner to update the site from any web browser, anywhere! But, in a world where roaming bands of jubilant hackers will fill your site with viruses and pornography, you need to stop and think about the security of your administration pages. (Read Full Article)
-
Managing Jokes
Explore Article Recent Articles (Jun 29 2010)
Along with adding, deleting, and modifying jokes in our database, we also need to be able to assign categories and authors to our jokes. Furthermore, we’re likely to have many more jokes than authors or categories. To try to display a complete list of jokes, as we did for the authors and categories, could result in an unmanageably long list with no easy way to spot the joke we’re after. We need to create a more intelligent method of browsing our library of jokes. (Read Full Article)
-
Managing Authors
Explore Article Recent Articles (Jun 28 2010)
Let’s begin with the code that will handle adding new authors, and deleting and editing existing ones. (Read Full Article)
-
Variable Scope and Global Access
Explore Article Recent Articles (Jun 28 2010)
One big difference between custom functions and include files is the concept of variable scope. Any variable that exists in the main script will also be available, and can be changed in the include file. While this is useful sometimes, more often it’s a pain in the neck. (Read Full Article)
-
Shared Include Files
Explore Article Recent Articles (Jun 28 2010)
On many sites, you’ll want to share include files among scripts that span potentially complex directory structures. A solid candidate for a shared include file would be the database connection include. (Read Full Article)
-
Types of Includes
Explore Article Recent Articles (Jun 28 2010)
The include statement we’ve used so far is actually only one of four statements that you can use to include another PHP file in a currently running script. (Read Full Article)
-
Many-to-Many Relationships
Explore Article Recent Articles (Jun 24 2010)
The correct way to represent a many-to-many relationship is to use a lookup table. This is a table that contains no actual data, but which lists pairs of entries that are related. (Read Full Article)
-
Rule of Thumb: Keep Entities Separate
Explore Article Recent Articles (Jun 23 2010)
This is a rule of thumb that you should always keep in mind when designing a database: each type of entity (or “thing”) about which you want to be able to store information should be given its own table. (Read Full Article)
-
Deleting Data from the Database
Explore Article Recent Articles (Jun 22 2010)
In this article, we’ll make one final enhancement to our joke database site. We’ll place next to each joke on the page a button labeled Delete that, when clicked, will remove that joke from the database and display the updated joke list. (Read Full Article)
-
Inserting Data into the Database
Explore Article Recent Articles (Jun 22 2010)
In this article, I’ll demonstrate how to use the tools at your disposal to enable site visitors to add their own jokes to the database. (Read Full Article)
-
Handling Select Result Sets
Explore Article Recent Articles (Jun 21 2010)
When it processes a SELECT query, mysqli_query returns a result set, which contains a list of all the rows returned from the query. (Read Full Article)
-
Sending SQL Queries with PHP
Explore Article Recent Articles (Jun 21 2010)
Last week, we connected to the MySQL database server using the phpMyAdmin tool, which allowed us to type SQL queries (commands) and view the results of those queries immediately. In PHP, a similar mechanism exists: the mysqli_query function. (Read Full Article)
-
Controllers and Templates
Explore Article Recent Articles (Jun 17 2010)
What’s nice about using include statements to load your PHP template files is that you can have multiple include statements in a single PHP script, and have it display different templates under different circumstances! (Read Full Article)
-
PHP Loops
Explore Article Recent Articles (Jun 17 2010)
There are two kinds of loops in PHP: while loops and for loops. Loops, like conditional statements, give you control over whether or not a group of statements is executed, but in addition you get to control how many times they are executed. (Read Full Article)
-
A Reusable Form Validation Script
Explore Article Recent Articles (May 11 2010)
Before we got distracted by the bewildering glory of regular expressions, I seem to remember today being about forms. How about we try to combine the two by using regular expressions to validate forms? (Read Full Article)
-
Regular Expressions Basics
Explore Article Recent Articles (May 11 2010)
A look at some of the most commonly used regular expression special characters. (Read Full Article)
-
Dependent Form Fields
Explore Article Recent Articles (May 10 2010)
You don’t always need your users to fill in every field in a form. Sometimes, the value a user enters into one form field renders another field irrelevant. Instead of relying on the user to figure out which fields are relevant, why not use the disabled property to disable the fields that the user can safely ignore? (Read Full Article)
-
Html Dom Features for Forms
Explore Article Recent Articles (May 10 2010)
In addition to the standard DOM properties, methods, and events that we’ve already played with, form-related elements support a bunch of extra properties and methods that are defined in a separate section of the DOM standard. (Read Full Article)
-
Animated Accordion
Explore Article Recent Articles (May 6 2010)
You learned to make an accordion control in a previous article, and I’m sure you were clicking around it, collapsing and expanding the different sections, but thinking, “This isn’t quite there; it needs some more … snap!” Well, it’s now time to make it snap, move, and jiggle. (Read Full Article)
-
setTimeout and clearTimeout
Explore Article Recent Articles (May 5 2010)
We control time in JavaScript using setTimeout. Instead of allowing your program to execute each statement as quickly as it can, setTimeout setTimeout operation of tells your program to wait awhile—to take a breather. (Read Full Article)
Comment on Article Mentions: Javascript
-
Stripy Tables
Explore Article Recent Articles (Apr 29 2010)
I think you’re ready to make your first real JavaScript program, and a useful one it is too! (Read Full Article)
-
Controlling Styles with JavaScript
Explore Article Recent Articles (Apr 29 2010)
Almost every aspect of your web page is accessible via the DOM, including the way it looks. (Read Full Article)
-
Attributes in the DOM
Explore Article Recent Articles (Apr 29 2010)
Attributes are focused on reading and modifying the data related to an element. As such, the DOM only offers two methods related to attributes, and both of them can only be used once you have an element reference. (Read Full Article)
-
Navigating the DOM Tree
Explore Article Recent Articles (Apr 28 2010)
What if you want to get an element on the basis of its relationship with the nodes that surround it? For instance, if we have a list item node and want to retrieve its parent list? For each node in the tree, the DOM specifies a number of properties, and it’s these properties that allow us to move around the tree one step at a time. (Read Full Article)







Recent Comments
LambALEJANDRA » Qooxdoo 1.2 And 1.1.1 Released
It's good that we are able to take the business loans and that opens up ...
ToddRuthie » Qooxdoo 1.2 And 1.1.1 Released
If you are willing to buy a house, you would have to receive the personal ...
See all recent comments