The Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQL by Alan Forbes

Author:Alan Forbes [Forbes, Alan]
Language: eng
Format: epub, pdf
Tags: PHP, computer programming
Publisher: Plum Island Publishing LLC
Published: 2012-10-10T22:00:00+00:00

Let's start out with a simple SELECT statement. In phpMyAdmin, click on the cars icon on the left side and then click on the SQL tab at the top of the page. Type in the following command and press Go.

SELECT * FROM inventory;

In general, the asterisk character (*) in computer lingo is called a wildcard and basically means "everything", so the result of the command above should return all rows and columns of the inventory table, and look similar to:

If you typed out this statement correctly, you should see the entire contents of your table 'inventory'. To select only certain columns of a table, type out all of the columns you want to see in that table separated by a comma. Type in the following command and press Go.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.