Web Services from Awave, Inc.
Communications systems and services from Awave, Inc.
Computer & Network Systems and Services from Awave, Inc.
Video and Multimedia Systems and Services from Awave, Inc.
Consulting Services from Awave, Inc.
Contact Awave, Inc.
 

BF_logo_04_IS
PHP.net
MySQL Site

 

 

Logo for NothingButSoftware.com  

 

Unlimited Local & Long Distance - $19.95/mo.  

Top Rated Anti-Spyware Software – Free Download  

 

Get Firefox! 

Heidi SQL GUI for MySQL
WebSite Pros

Tutorial:
Using PHP and MySQL with Fusion

© 2000-2009
Awave, Inc.

Tutorial - Get Fusion 10
dynamic web sites using PHP and MySQL

Contact the author

Awave Web Server Platforms:

Fedora 10, Apache 2.2.10, PHP 5.2.6, MySQL 5.0.67


Development Platform: Fusion 11, Windows Vista Ultimate, HeidiSQL- 3.0

Author: Chuck Joslin

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.

These tutorials do NOT address the use of the Fusion 7.5 DB Component or the built-in DB component in Fusion 8 or 9.0 thru 11. 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.

If you further need assistance with using Fusion 7 or above, visit the BeyondFusion website. This is the official Awave web site for Fusion help and has lots of great tips and tutorials online.

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 the Fedora successor to Red Hat Linux. Probably due to my history as a Unix system admin.

The tools: The server software tools we use are "free".

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 3.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.

My tutorials are being moved soon to www.BeyondFusion.com

Until then, click here to see what's available now.
 

Last Updated: 03/18/09

Domain transfers and registrations

allwebmenus - Cross platform DHTML!