Because of its versatility, the MySQLR database server is the most popular database for partnering with PHP in web applications. MySQL can be used for small business sites as well as high-traffic websites. But how do you communicate with the MySQL server? You will use the SQL computer language and, like PHP, you can put the SQL code within the HTML code for your webpages. SQL stands for Structured Query Language and the sentences you use to talk to the database server are called SQL queries. Much like HTML, the SQL language uses English words and therefore is easy to understand and use. Let's take a look at an example query that will select the names of all the members from a membership table that live in the state of Ohio. It will then put these names in alphabetical order.
| |