India's No. #1 Programmer's Forum

How to connect MySQL Database with PHP?

Asked by Chandraket On 05 Jun, 2020 09:11:26pm

PHP MySQL

100

Hello Connection,

I want to connect MySQL Database in PHP, when I inserting my data in the database I am facing a problem

Here is My PHP Code

$host = "localhost";

$username = "root";

$password = "";

$db = "test";

if(isset($_POST['insert']))

{

$sql = "insert into student";

if($sql)

{

echo "data insert success";

}else{

echo "some problem";

}

Re: How to connect MySQL Database with PHP?

06 Jun, 2020 10:12:48pm

Answer by yuvamind

Hello Connection you can use this code, i hop your problem will be solved



$host = "localhost";
$username = "root";
$password = "";
$db = "test";
$con = mysqli_connect($host,$username,$password ,$db);
if(isset($_POST['insert']))
{

$sql = "insert into student set column_name='value'";
$query = mysqli_query($con,$sql);
if($query)
{
echo "data insert success";
}else{
echo "some problem";
}

}