MySQL INSERT查询有效，但未插入数据

Question

I just want to insert into database, but following code is not showing any error nor showing my inserted data in database. Can anybody help me in debugging this code.

<?php
$tips = $_POST["tips"];
$day = $_POST["day"];
$month = $_POST["month"];
$year = $_POST["year"];
$date = $year."-".$month."-".$day;

//echo "$date: $tips";

//========================
//  DataBase Connectivity
//========================
$con=mysqli_connect("localhost","root","","mydb");

// Check connection
if (mysqli_connect_errno($con))
  {
    echo "Failed to connect to Database";
    exit;
  }

else{
// Perform INSERT query
    mysqli_query($con,"INSERT INTO daily_tips (PublishingDate,Tips) VALUES ('$date','$tips')");
    echo "data inserted"
    exit;
}
mysqli_close($con);
?>

Answer 1

try

if( mysqli_query($con,"INSERT INTO daily_tips (PublishingDate,Tips) VALUES ('$date','$tips')"))
{
    echo 'success';
}else{
    echo 'failed';
}