PHP 5/MySQL Programming- P69:computer programming has often been seen as a difficult and arcane skill. Programming languages are difficult and complicated, out of the typical person’s reach. However, the advent of the World Wide Web has changed that to some extent. It’s reasonably easy to build and post a Web page for the entire world to see. The language of the Web is reasonably simple, and numerous applications are available to assist in the preparation of static pages | 318 PHP 5 MySQL Programming for the Absolute Beginner Check this site out sometime when you re bored http lkseitz comics herogen . Special thanks to Lee Seitz and his hysterical Super-Hero generator. Editing Table Data You can use phpMyAdmin to browse your table in a format much like a spreadsheet. Figure illustrates this capability. figure Use the Browse tab to view table data. Follow these steps to edit a table in phpMyAdmin 1. Select the table from the table list on the left side of the SQL screen. The table appears in a spreadsheet-like format in the main part of the screen. You can edit the contents of the table in this window. 2. Edit or delete a record by clicking the appropriate icon displayed near the record. 3. Add a row by clicking the corresponding link near the bottom of the table. 4. Leave the cell you edited or press the Enter key. Any changes you make on the table data are automatically converted into the appropriate SQL code. 319 Exporting a Table Some of phpMyAdmin s most interesting features involve exporting table information. You can generate a number of data formats. The Export tab looks like the page in Figure . figure The Export Result Set dialog box allows you to save table data in a number of formats. Chapter 9 Using MySQL to Create Databases You might prefer to have your results saved in some sort of delimited format such as those discussed in chapter 6 Working with Files. You can easily generate such a format by choosing the Comma-Separated Value CSV option and selecting your delimiters. This is a good choice in these situations You want your data to be readable by a spreadsheet. You are writing a program that can handle such a format but cannot directly access databases. The Excel CSV format configures the data so an Excel spreadsheet can read it easily. The ordinary CSV format allows you to modify your output with a number of options. Figure illustrates the CSV version of the hero data set. Once
