Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In cPanel, go to the Databases section and select phpMyAdmin to access the backend of the site.
  2. Open up the target database and there you can access all tables and stored procedures created for the system.
  3. Table information, database relationships, and stored procedures can be seen below.
  4. Any changes on this server will be permanent in nature and affect the entire site. Be careful when modifying tables and check with a supervisor before dropping anything. Deleting certain fields may cause other tables to break.
  5. Use the web interface created by the MIS team for any routine changes.

 


Installing Apache Web Server -with WAMP server

Since PHP is a server-side language, you need a web server that can interpret PHP in order to use the PHP functionality of your file. The GoDaddy service (cPanel) has a server that supports PHP. So deploying files to the server with PHP embedded will work. The issue is that you do not wish to use the online server to preview your ongoing developing. In order to preview your PHP files you must install a PHP enabled server on your workstation. 


We installed a package called WAMP Server to our Windows workstations(laptops).  WAMP stands for Windows, Apache, MySQL, PHP. WAMP allows us to install Apache web server, MySQL, and PHP on our WINDOWS workstations(laptops). This package only works on WINDOWS computers and will not work on other operating systems such as linux or macosx. 


  1. To install WAMP server you must go to the following link: http://www.wampserver.com/ (Links to an external site.)
  2. Once on the site you want to select the appropriate download option
    1. Note: There will be different download options available and you should select the appropriate download taking into consideration your version of Windows and the version of PHP that your host server is using to ensure full compatibility.
  3. Once the package is downloaded click on the package and follow the prompts for installation.
    1. Note: The default values in the prompts should suffice for installing to your workstation. It is not necessary to change the default values.
  4. Once WAMP server is installed you will have an icon on your taskbar that will change colors to indicate whether the services (Apache and MySQL) are running or not.
  5. To start/stop the services left click on the icon and select start/stop all services.
  6. If you wish to preview your PHP enabled files you must ensure that all services have been started and the file you wish to preview is in the ‘WWW’ folder in the WAMP directory on your machine
    1. the WAMP directory is in the location specified during the installation process .The default location is the C: drive.
  7. You can then preview that file by using the preview functionality of your IDE or manually by opening a browser and typing http://localhost/ (Links to an external site.) (file in WWW folder)
    1. Example for manually viewing your file in a browser: http://localhost/index.php (Links to an external site.)
  8. In order to successfully view the files you must ensure that services are running. If services are not running expect the functionality of the file to be limited

...