|
Speaking SQL (part 1)
|
|
Learn the basics of creating databases and tables, and inserting data into them, with this introduction to SQL.
|
|
| The Tools |
Before we can get started, you need to get a database up and running - your SQL commands will be interpreted by this, and appropriate results generated.
Now, there are a number of database engines out there; you've probably heard of Oracle (for large, data-intensive Web applications) and Microsoft Access (for desktops and servers). Unfortunately, though both these come with powerful capabilities, neither of them is free - a fact which displeases many of those used to open-source software.
However, there is a database engine out there that is both free and effective, and will serve our purpose for this tutorial - it's called mySQL and you can download it from http://www.mysql.com/ (it's available for both UNIX and Windows platforms). Once you've downloaded and installed it (or had your network administrator do it for you), you're ready to begin your first foray into the world of SQL.
 |
How to do Everything with PHP & MySQL
How to do Everything with PHP & MySQL, the best-selling book by Melonfire, explains how to take full advantage of PHP's built-in support for MySQL and link the results of database queries to Web pages. You'll get full details on PHP programming and MySQL database development, and then you'll learn to use these two cutting-edge technologies together. Easy-to-follow sample applications include a PHP online shopping cart, a MySQL order tracking system, and a PHP/MySQL news publishing system..
Read more, or grab your copy now!
|
|
|
|
|
|
|