Putting It All Together

Now that you know about the common benefits and pitfalls of using PHP and SQL, you should be ready to tackle a complete example. In this example, we will use a link to create a new record, an HTML table to show the records in the SQL table, and add some links to each row of the HTML table to allow editing and deleting. For brevity, we won't be filling in all of the columns; in a real application, this may be the only interface to the data, so there should be some means of updating every column of interest.