I started web-design a few weeks ago but I am very familiar with C/C++/Java for years. My problem is that although I understand how to link my created HTML pages (with CSS and Js) with PHP, especially when I need to submit a form, but I am still yet to get how I can link my HTML/CSS/Js with SQL despite understanding SQL on its own along with PHP. I get it that SQL is like a database for storing client information but its the relationship with other web-lnguages that I don't fully understand. Let's say I am creating a simple web-application that stores name and phone numbers of my friends this is how I understand it works in plain English.
1. Use HTML for the basic things needed for the website (HTML)
2. Use CSS to add colours and stylings to the website. (CSS)
3. Use Javascript to add a few more functionalities to the site (Js)
4. Create a submit button that when clicked will use POST attribute then send the inputed information to a specified location (PHP)

5. Where does SQL come in??
I understand that it is meant to hold all the submitted information but how is it linked to the website? Is it through the HTML document? Or is it automatically added?

I use Xamp, and I know a little on how to use phpmyadmin to create databases and tables but I can't link them with my HTML pages.

Please it is kind of urgent

php has an interface with which you can communicate with mySQL.
with your database engine in place, you will use some php functions to carry out the needed operations (like select, delete, insert, update, join and etc) on the database.

on the page the form [data] is submitted to, that is where you establish connections and communications with the database (mysql).

I hope this helps

Marsatto:
I started web-design a few weeks ago but I am very familiar with C/C++/Java for years. My problem is that although I understand how to link my created HTML pages (with CSS and Js) with PHP, especially when I need to submit a form, but I am still yet to get how I can link my HTML/CSS/Js with SQL despite understanding SQL on its own along with PHP. I get it that SQL is like a database for storing client information but its the relationship with other web-lnguages that I don't fully understand. Let's say I am creating a simple web-application that stores name and phone numbers of my friends this is how I understand it works in plain English.
1. Use HTML for the basic things needed for the website (HTML)
2. Use CSS to add colours and stylings to the website. (CSS)
3. Use Javascript to add a few more functionalities to the site (Js)
4. Create a submit button that when clicked will use POST attribute then send the inputed information to a specified location (PHP)

5. Where does SQL come in??
I understand that it is meant to hold all the submitted information but how is it linked to the website? Is it through the HTML document? Or is it automatically added?

I use Xamp, and I know a little on how to use phpmyadmin to create databases and tables but I can't link them with my HTML pages.

Please it is kind of urgent

Sql is a Lang, mysql is the database.

You would need to connect to your database, assuming you've used phpmyadmin to create a database, table..


All you need do from your script is

<? php
$con = mysqli_connect("localhost", "root", "your phpmyadmin password", "test" ) ;
// I assumed your database's name is test.
//to insert values from your firm, you use a query statement

mysqli_query($con, " INSERT INTO `users`() VALUES()";
// I assumed users is the name of your table in the database,
? >
You should consider reading the php manual sha... Other things are still involved,like validating and sanitization


I hope it helps

thank you all