???
No matter what the SQL query says, we need a way to send it to MySQL. MySQL ships with
a simple, text-based interface (named mysql) that permits executing SQL queries and gets back
the results. If you find it difficult to use, don??™t worry; there are alternatives to the command-line
interface. Several free, third-party database administration tools allow you to manipulate data
structures and execute SQL queries via an easy-to-use graphical interface. Many web-hosting
companies offer database access through phpMyAdmin (which is the most widely used MySQL
web client interface), which is another good reason for you to get familiar with this tool. However,
you can use the visual client of your choice. A popular desktop tool for interacting with MySQL
databases is Toad for MySQL (http://www.quest.com/toad-for-mysql/).
Apart from needing to interact with MySQL via a direct interface to its engine, you also
need to learn how to access MySQL programmatically from PHP code. This requirement is
obvious, because the e-commerce web site will need to query the database to retrieve catalog
information (departments, categories, products, and so on) when building pages for the visitors.
As for querying MySQL databases through PHP code, the tool you??™ll rely on here is the PHP
Data Objects (PDO) extension.
Implementing Database Integration Using PDO
PDO (PHP Data Objects) is a native data-access abstraction library that ships with PHP starting
from version 5.
Pages:
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86