Installing and configuring PHP with MySQL

Top  Previous  Next

 

You do not need to install PHP and mySQL on your PC in order to design sites that will use PHP and mySQL.  Using dbQwikSite's X-Gen technology you can design using ASP/MS Access and later scale up to mySQL and PHP when you publish.

 

You do not have to have a Linux (unix) server to run PHP and mySQL.  You can run Apache/MySQL/PHP on your windows PC.  You may wish to install these on your PC in order to design and test is a set up that is closest to your host environment.

 

Getting AppSever

 

If you do want to set up your PC to run Apache, PHP and mySQL you need to install all these software packages onto your PC.  Fortunately there is an easy way to do this.  The AppServerNetwork open source project is a project that tests compatibilities and packages all these programs into a single install package, making installing much easier than trying to download the individual components.

 

You can download AppServer from http://www.appservnetwork.com/index.php

 

When you download and install AppServer you will be installing:

Apache
MySQL
PHP
phpMyAdmin

 

Changing dbQwikSite Settings

 

When you install dbQwikSite it will default to generating ASP and using dbQwikWebServer for local testing.  If you install Apache and PHP, then you will need to adjust the default settings.

 

The local generation settings are found in Tools>Project Settings

mnu_Tools_ProjectSettings_001

 

Here you will see the local generation settings

dlg_Project_Settings_Local_001

 

When you install AppServer you will either use the default settings or select you own.  Above we show the most common settings, however you exact settings have to match you install of AppServer.

You should select the Local Setting tab, and change your port number to 80.  You also should change your script generation to PHP.

 

Trouble Shooting Hints

 

Always use the test connection button, if the test fails, you will not be able to test.
If you are using a PC that has IIS server running on it, it likely will be using port 80.  We recommend stopping the web publishing services before starting Apache.  You can stop web publishing services using service management tool shown as an option in the above menu screen capture.  Alternatively you can run Apache on a different port number, just make sure that you set the local settings to match
If you are having troubles with AppServer, you can access support from user groups at http://www.appservnetwork.com/forum/index.php
Many errors are related to your set up.  Often a search on Google or Yahoo for the error message text will locate a wealth of information to help you resolve your problem.