A 3rd year's lab work (project) of the Professional Course of Technician of Programming and Management of Computer Systems made in High School of Monte de Caparica, in the subject of Programming of Computer Systems. This project was built using HTML, PHP (Hypertext Preprocessor), MySQL, WampServer and Notepad++ (Notepad Plus Plus). The scenario of the project was the development of a simple Website/Platform of online auctions for products, allowing the users to view the currently registered products and users, as also, see all categories of products and the current bids made for some products. The system also allow to the user to make specific queries to the system.
To install and run this application, you will need:
The Git feature and/or a third-party Git Client based GUI, like:
To install this application, you will only need to download or clone this repository and run the application locally:
You can do it downloading the .zip file in download section of this repository.
Or instead, by cloning this repository by a Git Client based GUI, using HTTPS or SSH, by one of the following link:
https://github.com/rubenandrebarreiro/simple-online-auction-demo.git
- SSH:
git@github.com:rubenandrebarreiro/simple-online-auction-demo.git
Or even, by running one of the following commands in a Git Bash Console:
git clone https://github.com/rubenandrebarreiro/simple-online-auction-demo.git
- SSH:
git clone git@github.com:rubenandrebarreiro/simple-online-auction-demo.git
1) Install WampServer;
2) After install WampServer, do the following steps:
a) Go to the Notification Icons Area in your personal taskbar, click on the WampServer icon and then, click on Start All Services;
b) Go to the Notification Icons Area in your personal taskbar, click on the WampServer icon, navigate to MySQL menu and then, click on MySQL Console;
c) Use the following command, to run the MySQL scripts, by the following order:
mysql> source the/path/to/your/scripts/criacao_bds_tabelas.sql;
mysql> source the/path/to/your/scripts/insercao_registos.sql;
mysql> source the/path/to/your/scripts/actualizacao.sql;
i) Per example, for me, the command was the following:
mysql> source C:/wamp64/scripts/online-auction/criacao_bds_tabelas.sql;
mysql> source C:/wamp64/scripts/online-auction/insercao_registos.sql;
mysql> source C:/wamp64/scripts/online-auction/actualizacao.sql;
ii) The outputs was the following:
Query OK, 1 row affected (0.01 sec)
Database changed
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Database changed
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 5 rows affected (0.02 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| id_util | int(10) | NO | PRI | NULL | auto_increment |
| nome_util | varchar(50) | YES | | NULL | |
| email | varchar(70) | YES | | NULL | |
+-----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
+---------+-----------------+----------------------------+
| id_util | nome_util | email |
+---------+-----------------+----------------------------+
| 1 | Paulo S. Pedro | paulospedro@hotmail.com |
| 2 | Victor Hugo | victorhugo@hotmail.com |
| 3 | Rúben Barreiro | rubenbarreiro@hotmail.com |
| 4 | Tiburcio Ramos | tiburcioramos@hotmail.com |
| 5 | Matumbina Sousa | matumbinaramos@hotmail.com |
+---------+-----------------+----------------------------+
5 rows in set (0.00 sec)
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
d) Go to the Notification Icons Area in your personal taskbar, click on the WampServer icon and then, click on www directory to open the folder of the projects/directories contained in the localhost;
e) Copy the folder esmc-shop contained in the folder application/www to the folder opened in d);
f) Go to your Web Browser, type the 'http://localhost/esmc-shop/' in the URL address bar and enjoy it;
Paulo São Pedro
Victor Hugo Cabral
- ruben.barreiro.92@gmail.com
- r.barreiro@campus.fct.unl.pt
- up201808917@fe.up.pt
- up201808917@g.uporto.pt
- https://github.com/rubenandrebarreiro/
- https://gitlab.com/rubenandrebarreiro/
- https://bitbucket.org/rubenandrebarreiro/
- https://dev.azure.com/rubenandrebarreiro/
- 16 of 20