PHP CRUD Operations with MySQL Database | Create , Read , Update , Delete

You can find the project files in description

guys what is wrong with this code?

<?php
include("connect.php");
if (isset($_POST["create"])){
$title = mysqli_real_escape_string($conn, $_POST['title']);
$author = mysqli_real_escape_string($conn, $_POST['author']);
$type = mysqli_real_escape_string($conn, $_POST['type']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$sql = "INSERT INTO books (tile, author, type, description) VALUES ('$title','$author','$type','$description')";
if(mysql_query($conn, $sql))
{
echo "data is inserted";
}else{
die("something went wrong");
}
}
?>

thats a fantastic tutorial i really get whats going on now.

amazing video
please produce more vid like this

Can you pls add "all fields are required"

Can you add "All fields are required" error?
I hope you can help me

Here is the code for the PhpMyAdmin (insert into SQL tab):


CREATE TABLE `books` (
`id` int(11) NOT NULL,
`title` varchar(250) NOT NULL,
`author` varchar(25) NOT NULL,
`type` varchar(50) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hi. how can i add search field?

Thank you ❤️

I hope you will come up with more PHP lessons

Awesome

bro i have error
after i click submit it says
Parse error: syntax error, unexpected token "}" in C:\xampp\htdocs\prob\process.php on line 28

make a video on Multilevel dynamic menus kind of tree structure

thank you so much!!!
needed the tutorial for few errors i had in my code, very helpful :)

Thank you