Jacob Garby Jacob Garby - 18 days ago 6
HTML Question

Simple idea behind a database for a single website

I have a website. I'm using MySQL Workbench 6.3. I have MySQL installed.

How hard can it be to send and receive data from this database, from the website? I don't know yet, but I can learn it if that's necessary.

What I want is simply to, for example, have a form on a website which sends it's information to the database. I understand about the columns in the database, and I've created a database table thing on the MySQL workbench, but I don't know how to host this database, or how to access it from my website.

Even just some good links would be helpful, as I haven't found any.

Answer

You actually can Google but you can go try to learn at the links below:

  1. w3schools.com
  2. php.net

And you need to learn too. For , this links can help you:

  1. w3schools.com
  2. tutorialspoint.com

Hope this links will make your job easier. And a quick tutorial by me:

mysql_* commands are no longer available. Use mysqli or PDO.

Connecting To Your Database:


Using mysqli

<?php

$conn = new mysqli($servername, $username, $password);

?>

Using PDO:

<?php

$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);

?>

Hope everything will work fine, happy coding!

Comments