Description
In this course, you will learn :
- How to set up a web server
- How to create a web site
- sql injection
- prepared statements
- How to create a database in mysql
- mysql in cli
- How to create a website in linux
- How to install mysql in linux
Syllabus :
1. setting up a web server in linux
- what is html
- what is css
- javascript and its use
- client-server communications
- protocols
- apache
- buying a vps
- what are databases
- server side programming languages
- set up a web server
- connecting to web server using ssh
2. mysql databases, sql injection and prepared statements
- installing mysql server on our linux server
- creating tables in mysql cli in linux server
- inserting and selecting data into database
- updating the mysql databases in cli
- creating a form in our web site to connect to database
- installing php on our server
- enabling php in apache
- enabling mysql in php
- connecting to database in mysql php
- retrieving data from database in mysql php
- sending data to database in the web page
- sql injection
- prepared statements