Fundamental Database System, Slides of Computer Fundamentals

Download Fundamental Database System and more Slides Computer Fundamentals in PDF only on Docsity!

CIT 203

FUNDAMENTALS

OF DATABASE

SYSTEM

Mitchie Gay A.

Sembrano

BS INFOTECH

XAMPP is a release made available by the non-profit project Apache Friends. Versions with PHP 5.5, 5.6, or 7 are available for download on the Apache Friends Step 1: Download

Step 2: Run .exe file Once the software bundle has been downloaded, you can start the installation by double clicking on the file with the ending .exe.

Step 4: Deactivate UAC

User Account Control (UAC) can interfere

with the XAMPP installation because it limits

writing access to the C: drive, so we

recommend you deactivate this too for the

duration of the installation process. To find

out how to turn off your UAC, head to the

Microsoft Windows support pages.

Step 5: Start the

setup wizard

After you’ve opened the .exe file (after deactivating your antivirus program(s) and taken note of the User Account Control, the start screen of the XAMPP setup wizard should appear automatically. Click on ‘Next’ to configure the installation settings.

Step 7: Choose the installation directory In this next step, you have the chance to choose where you’d like the XAMPP software packet to be installed. If you opt for the standard setup, then a folder with the name XAMPP will be created under C:\ for you. After you’ve chosen a location, click ‘Next’.

Step 8: Start the

installation process

Once all the aforementioned preferences have been decided, click to start the installation. The setup wizard will unpack and install the selected components and save them to the designated directory. This process can take several minutes in total. You can follow the progress of this installation by keeping an eye on the green

Step 10: Complete

installation

Once all the components are

unpacked and installed, you can close

the setup wizard by clicking on

‘Finish’. Click to tick the

corresponding check box and open

the XAMPP Control Panel once the

installation process is finished.

The XAMPP Control Panel Controls for the individual components of your test server can be reached through the XAMPP Control Panel. The clear user interface logs all actions and allows you to start or stop individual modules with a single. The XAMPP Control Panel also offers you various other buttons, including:

• Config: allows you to configure the XAMPP as well as the individual components
• Netstat: shows all running processes on the local computer
• Shell: opens a UNIX shell
• Explorer: opens the XAMPP folder in Windows Explorer
• Services: shows all services currently running in the background
• Help: offers links to user forums
• Quit: closes the XAMPP Control Panel

Setting up XAMPP A common source of error connected with Apache is blocked ports. If you’re using the standard setup, then XAMPP will assign the web server to main port 80 and the SSL port 443. The latter of these particularly is often blocked by other programs. In the example above, it’s likely that the Tomcat port is being blocked, meaning the web server can’t be started. There are three ways to solve this issue:

• Change the conflicting port: Let’s assume for the sake of example that the instant messenger program Skype is blocking SSL port 443 (this is a common problem). One way to deal with this issue is to change Skype’s port settings. To do this, open the program and navigate via ‘Actions’, ‘Options’, and ‘Advanced’, until you reach the ‘Connections’ menu. You should find a box checked to allow Skype access to ports 80 and 443. Deselect this checkbox now.

• Change the XAMPP module port settings: Click the Config button for the module in question and open the files httpd.conf and httpd-ssl.conf. Replace port number 80 in httpd.conf and port number 443 in httpd-ssl.conf with any free ports, before saving the file data. Now click on the general Config button on the right-hand side and select ‘Services and Ports Settings’. Customize the ports for the module server to reflect the changes in the conf files.
• End the conflicting program: The simplest way to avoid port conflicts in the short term is to end the conflicting program (Skype in this case). If you restart Skype after your XAMPP module servers are already running, it will select a different port and your issue will be resolved.

• You can use the Admin button of your database module to open phpMyAdmin. Here, you can manage the databases of your web projects that you’re testing on your XAMPP. Alternatively, you can reach the administration section of your MySQL database via localhost/phpmyadmin

Testing your XAMPP installation To check whether your test server is installed and configured correctly, you have the option to create a PHP test page, store them on your XAMPP’s local host, and retrieve them via the web browser.

• Open the XAMPP directory through the ‘Explorer’ button in the Control Panel and choose the folder htdocs (C:
  xampp\htdocs for standard installations). This directory will store file data collected for web pages that you test on your XAMPP server. The htdocs folder should already contain data to help configuration of the web server. But you should store your own projects in a new folder (like ‘Test Folder’ for example).
• You can create a new PHP page easily by using the following content in your editor and storing it as test.php in your ‘ test’ folder (C:\xampp\htdocs\test):