Hello, my name is Swan and today I am here to tell you about the project I worked on with 3 comrades.

Let's see the summary together.
At first I will briefly introduce the project.
In a second time, I will talk about the technical part that I had to realize to finally show you the prototyping perform and thus the final rendering of my part.

Every year, 4.9 billion kilograms of CO2 are released into the atmosphere in Europe. This figure is only increasing and is very worrying.
Our project aims to reduce this number. Indeed, we had to work on a device that will equip electric vehicles and charging stations.
This device will easily benefit from kilometric compensation.

We had to answer a problem that was: How can we encourage people to buy electric cars?

So, here we can see my part, what I had to do in the project.
I had to manage a database that had a capacity of 65000 users as well as display information on a website.

During our project we had to make a mind map. This allowed us to better see what we had to do and organize ourselves through a kind of planning called Gantt chart.

Let's move on to the technical part.
My part was to manage a database created by me beforehand and to create a website to display user data.
For that, there were some prerequisites. it must be an internet connection. At first I had to install the web server on the Raspberry PI.
In a second step, I had to perform the redirection of ports to the Raspberry PI.

Here is the redirection. It can be seen here that if a person connects to my ip address on port 22, 443 or 80, it will be redirected to the Raspberry PI.

Here is an example of the user database.
We can see that different data are stored. The one that really interested me for my part was the number of kilometers traveled and the number of refills made.

For my part I use several programming language. Php, html, css and sql.

Here is an example of the different code I had to do.
We will not dwell on it. Here is the registration form.
Here is always the registration but this part corresponds to the registration of the data of the user in the database.
And here is the code for the connection to the user interface.

Let's go to the website. You can see here the main page of the site. On this one, the project is summarized there.

And here is the user interface. As we can see, the data that was stored in the database is displayed here.