Articles from Kevin Yank

1-25 of 37 // 1 2 »
  1. 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)

    Comment on Article

  2. 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)

    Comment on Article

  3. 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)

    Comment on Article

  4. 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)

    Comment on Article

  5. 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)

    Comment on Article

  6. 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)

    Comment on Article

  7. 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)

    Comment on Article

  8. 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)

    Comment on Article

  9. 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)

    Comment on Article

  10. 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)

    Comment on Article

  11. 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)

    Comment on Article

  12. 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)

    Comment on Article

  13. 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)

    Comment on Article

  14. 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)

    Comment on Article

  15. 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)

    Comment on Article

  16. 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)

    Comment on Article

  17. 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)

    Comment on Article

  18. 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)

    Comment on Article

  19. 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)

    Comment on Article

  20. 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)

    Comment on Article

  21. 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

  22. 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)

    Comment on Article

  23. 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)

    Comment on Article

  24. 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)

    Comment on Article

  25. 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)

    Comment on Article

1-25 of 37 // 1 2 »