MySQL INSERT query works but Data is not inserted

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);
?>

try echo "INSERT INTO daily_tips (PublishingDate,Tips) VALUES ('$date','$tips')"; and show your output here — zzlalani
– zzlalani, Commented Dec 5, 2013 at 6:20
hackers heaven here!!! sanitize your posts or you are into big trouble. or try to use prepared statements. — bansi
– bansi, Commented Dec 5, 2013 at 6:21

bansi · Accepted Answer · 2013-12-05 06:19:31Z

1

try

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

edited Dec 5, 2013 at 6:19

bansi

57.3k6 gold badges44 silver badges52 bronze badges

answered Dec 5, 2013 at 6:15

simply-put

1,0981 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammed Saqib Rajput · Accepted Answer · 2013-12-05 06:20:23Z

1

Make Sure your date format is like this '2013-12-05' ($date = $year."-".$month."-".$day)

and try this code:

mysqli_query($con,"INSERT INTO daily_tips (PublishingDate,Tips) VALUES('".$date."','".$tips."')"); echo "data inserted"; exit;

answered Dec 5, 2013 at 6:20

Mohammed Saqib Rajput

1,3701 gold badge14 silver badges23 bronze badges

Comments

himanshu bhardiya · Accepted Answer · 2013-12-05 06:14:36Z

0

try this

mysqli_query($con,"INSERT INTO daily_tips (PublishingDate,Tips) VALUES ('".$date."','".$tips."')");

answered Dec 5, 2013 at 6:14

himanshu bhardiya

811 silver badge9 bronze badges

1 Comment

himanshu bhardiya Over a year ago

what is the error? or you try with mysql_query insterad of mysqli_query

uvais · Accepted Answer · 2013-12-05 06:14:50Z

0

first of all you do not need to provide else condition remove "else" block

if everything is ok above then try this:

 $sql= mysqli_query($con,"INSERT INTO daily_tips (PublishingDate,Tips) VALUES  ('".$date."','".$tips."')");

 if( $sql) {
 echo "data inserted";
 } else {
 echo "not inserted";
 }

answered Dec 5, 2013 at 6:14

uvais

4162 silver badges6 bronze badges

6 Comments

bansi Over a year ago

why are you introducing unnecessary complication in string concatenation?

uvais Over a year ago

this is not complication,,, it will parse your data in right way , wheather it is int type or string type ..

uvais Over a year ago

you have tried my code ,, is there occuring any error , please let me know

bansi Over a year ago

what is wrong with "INSERT INTO daily_tips (PublishingDate,Tips) VALUES ('$date','$tips')"? isnt it more readable and less prone to errors?

uvais Over a year ago

actully when we insert data, then we should make sure that our data is parse correctly in comparision to thier data type.

|

Muthamizhchelvan. V · Accepted Answer · 2013-12-05 06:42:53Z

0

Just use the complete code and let me know, its working fine for me and let me know what the data type you are using for PublishingDate ?

<?php
$tips = "Today tips";
$day = "12";
$month = "01";
$year = "2012";
$date = $year."-".$month."-".$day;

//echo "$date: $tips";

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

// 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);
?>

answered Dec 5, 2013 at 6:42

Muthamizhchelvan. V

1,2611 gold badge17 silver badges31 bronze badges

Collectives™ on Stack Overflow

MySQL INSERT query works but Data is not inserted

5 Answers 5

Comments

Comments

1 Comment

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related