Download CD Content
The purpose of this chapter is to explain how a middleware program such as a PHP or ASP script can access a database located on the server, perform insertions, and request information using simple select queries. This chapter will also address common problems and demonstrate debugging techniques. The next chapter will continue with more complex examples.
This chapter will cover how you can write PHP or ASP scripts to make these connections, and how you write the code to compose SQL statements and pass them to the DBMS. You have read about SQL and practiced writing SQL statements “on paper.” You have also written them in command mode to access MySQL. You have done the equivalent of making SQL statements using the graphical user interface of Access. Now you will create SQL statements as character strings. These character strings will be arguments for PHP functions or ASP methods.