For the TShirtShop web site, it will store all data regarding the products, departments,
users, shopping carts, and so on.
Many RDBMSs are available for you to use with PHP, including MySQL, PostgreSQL, Oracle,
and so on. However, both formal surveys and real-world practice show MySQL is truly the leading
database choice for PHP-driven projects.
MySQL is the world??™s most popular open source database, and it??™s a free (for noncommercial
use), fast, and reliable database. Another important advantage is that many web hosting
providers offer access to aMySQL database, which makes your life easier when going live with
your newly created e-commerce web site. We??™ll use MySQL as the back-end database when
developing the TShirtShop e-commerce web site.
The language used to communicate with a relational database is SQL (SQL Query Language,
or, according to older specifications, Structured Query Language). However, each database engine
recognizes a particular dialect of this language. If you decide to use a different RDBMS than
MySQL, you??™ll probably need to update some of the SQL queries.
Getting in Touch with MySQL
You talk with the database server by formulating an SQL query, sending it to the database engine,
and retrieving the results. The SQL query can say anything related to the web site data, or its
data structures, such as ???give me the list of departments,??? ???remove product number 223,???
???create a data table,??? or ???search the catalog for yellow t-shirts.
Pages:
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85