How to use SQL database on my page?

Question

Hello. I am sorry, because this will be probably duplicate question, but I couldn't find answer via search box. Anyway, I need to know, how can I use SQL database to store some data. I need it for quite complex project, so I won't describe what is it for in details. Let's just say I need a program, that saves text submitted via HTML form into database table. I went through HTML, CSS, JS, PHP and SQL courses, but I couldn't find how to acceess SQL. Can somebody make a code that would do that? If it's not posible to make in Sololearn because of blocking file-creation, send the code as raw text here please. And if it's to complex to describe just in a comment, send a link to a webpage that describes it. Thanks.

Answer 1

first you need to create database . download xammpp➡run your local apache server ➡ open phpmyadmin➡ create new database, run 👇on server (index.php)

<?php
$servername = "localhost";
$database = "testdb";
$username = "root";
$password = "";

$name="test";
$pass="testing";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection

if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO test_db (username,password) VALUES ('$name','$pass')";
if (mysqli_query($conn, $sql)) {
echo "<br><fieldset>New record created successfully,/fieldset>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
mysqli_close($conn);
}
?>

you cannot get enough answer on sololearn coz it's a complex method so visit different sites

Answer 2

Hello there
It means if sql runs properly then this condition will be true
Suppose you have mentioned some column to be not null and it will go to else part then throwing error.
To check just change the table or column name it will go to else part.

Answer 3

W3schools and tutorial are the website to Learn the code and modify you can do it on your local for practical examples.

Answer 4

Thank you very much. I will write here if I need help.

Answer 5

Hello again. After several weeks of studying php I finally understand this a bit. Can you just explain me what does line "if (mysqli_query($conn, $sql))..." exactly do?

Answer 6

Ok, thanks for explanation. BTW do you know any good webpage/video/pdf document where I can learn to modify databases with php?