This is a project of the school, which is recorded here for review. The main use of XAMPP through the phpMyAdmin connection MySQL database, to achieve a simple query function.
Outline
- Setup of XAMPP
- Implementation of MySQL database in "PhpMyAdmin"
- Create PHP Page
- User Interface and test cases
1. Setup of XAMPP
1) I downloaded the XAMPP from this link (http://www.apachefriends.org/en/xampp.html). Since I already has IIS taking port, I need to modify the ' httpd.conf ' file by clicking on ' Config ' on ' Apache '. Then find "Listen" to change it to-as the port for Apache (see line-in-figure 1 below).
Figure 1
2) Also I have installed MySQL before. So the port 3306 was taken. I need to setup another port for the MySQL in XAMPP. Edit ' My.ini ' by clicking ' Config ' on ' MySQL ' then find ' port ' and ' change ' it from 3306 to 3307 Ure 2 below).
Figure 2
This is the reference. (Http://stackoverflow.com/questions/18177148/xampp-mysql-does-not-start)
3) After these, the XAMPP was finally set up (Figure 3).
Figure 3
4) Type in "localhost:85", it'll show correctly (Figure 4).
Figure 4
5) When I am trying to click on "PhpMyAdmin", it gave me the error message (Figure 5)
After I do some, I found most of the suggestions were talking on password and username settings in the "Confi g.inc.php "file under the directory of" \xamp\phpmyadmin ". But it's not the case for me. What I did was to change "$cfg [' Servers '] [$i] [' host ']" to "127.0.0.1:3307" instead of original "127.0.0.1" D Line 7).
Figure 6
Figure 7
Also Notice that at line @ the file of "config.inc.php" (Figure 7), it states that the extension is "mysqli". I was not aware of this at this stage, but it gave me a lot of trouble later in the implementation of search function of PHP in this assignment because "MySQL" extension is used as the default method.
Also Many suggest that it's not a good practice to use the "root" as the account for the database. I should avoid that in the future.
Here is the references. They is not the quite my case, but the they helped me a lot figuring how to fix my case.
A) http://stackoverflow.com/questions/7180893/mysql-said-cannot-connect-invalid-settings-xampp
b) http://stackoverflow.com/questions/1276538/phpmyadmin-cant-connect-invalid-setings-ever-since-i-added-a-root-passwor).
6) After all of these modifications, "PhpMyAdmin" finally worked (Figure 8)
Figure 8
Bookstore project using XAMPP detailed configuration Part 1