|
Scope: Using the tools we use on the platform we use. We're not going to teach you system administration or how to install Linux or Apache or PHP or MySQL before you get started.
We're not going to cover Microsoft IIS or SQL Server or ASP or any other web technologies. Much of what we cover applies on other platforms (for example; PHP and MySQL are available for Windows), but you're on your own in applying what you learn here.
For testing locally on your PC, we recommend WampServer. It includes the Apache web server, PHP and MySQL.
These tutorials do NOT address the use of the Fusion 7.5 DB Component or the built-in DB component in Fusion 8 thru 12. However, learning these techniques will make those components easier to understand.
Assumptions: This article assumes that you are already familiar with how to use Fusion to create web sites and are ready to move on to creating dynamic web pages using a server-side scripting language and a relational database.
We further assume that your web server (or the host where you put your web sites) is equipped with the tools we use or at the least, compatible versions of those tools.
About us: We're a company that designs and hosts web sites (among other things). Many of these sites are owned by us and others are those of clients. Our web server OS of choice is Fedora. Probably due to my history as a Unix system admin.
The tools: The server software tools we use are "open source".
PHP is the server-side scripting language we use in conjunction with the widely used Apache web server.
Our chosen database is MySQL. All of our production servers use the current release.
The tool we use to administer our MySQL databases is the free HeidiSQL. Version 6.0. Your hosting company, however, may require the use of a web-based administration tool (such as phpMyAdmin) instead for security reasons. Check with them to see if this applies.
|
