Php : How To Insert Data Into MySQL Database Using Php MySQLI [ with source code ]

THANK YOU SO MUCH 🙏🙏

Lots of Thanks, sir.

THANK YOU for not including awful deafening rave/electronic music. No, really. Thank you!!

error : Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean

its great Thanks but U had not explained how to remove warning which is associated with
mysqli_free_result(). Please explain.

It was really helpful, thanks you so much

Plz how did u create "test_db"

Thanks a looooooooooooooooooooooooooooooottttttttttttttttttttttttttttttttttttt

me salvaste el culo gracias y saludos cordiales.

dude you referencing a file PHP_insert_data_mysql_database.php and you dont mention where it is ???? Dont like that! Be straight up!

when I click submit the data inthe fields are just deleted and nothing goes to database

error 404 when pressing submit

$result = mysqli_query($query,$connect);

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\index.php on line 169

data not inserted
showing

Thanks a lot. Its working, uff after working on this a whole day. Finally....

error showing "no databasr selected"

THANKS A LOT BRO

my page also does nothing when I press submit

sir can i know how to retrieve data using php code by a single click

im sorry but i follow all the process seems still cant insert data to my database when i tried to click submit its do nothing
Thanks

<?php
$con=mysqli_connect('127.0.0.1','root','');
if(!$con)
{
echo 'not connected server';
}

if(!mysqli_select_db($con,'al'))

{
echo 'database not connected';
}

$id=$_POST['id'];
$name=$_POST['name'];
$email=$_POST['email'];
$gender=$_POST['gender'];
$birth_date=$_POST['birth_date'];
$address=$_POST['address'];
$mobileno=$_POST['mobileno'];

$sql="INSERT INTO `al`(`id`, `name`, `email`, `gender`, `birth_date`, `address`, `mobileno`) VALUES ([$id],[$name],[$email],[$gender],[$birth_date],[$address],[$mobileno])";

if(!mysqli_query($con,$sql))
{
echo 'not inserted';
}
else
{
echo 'inserted';
}
?>


can u solv it?