PHP MYSQL insert doesn't work and receive no error

Question

I have this PHP code , and i would insert a data in a table. I don't know why , it doesn't work. I receive no error from the query. If i print the $update_miner nothing is showed. This is the code:

<?php


session_start();
include("header.php");
$building['rock_miner'] =3;
$current_time = time();
$update_miner = mysqli_query($connection,"INSERT INTO `updates_queue` (`user_id`,`content`, `start_at`,`end_at`,`finished`,`old_level`) VALUES ('".$_SESSION['uid']."', 'rock_update', '".$current_time."','".$current_time."',0 ,'".$building['rock_miner']."'");




include("footer.php");

?>

This is the table:

Try adding ini_set('display_errors', 1); error_reporting(-1); to the top of the page. Also try adding if($update_miner === FALSE){ die(mysqli_error($connection)); }. If an INSERT fails, there's got to be a reason (and an error message). — gen_Eric
– gen_Eric, Commented Oct 16, 2015 at 15:04
he said me : syntax error at line 1. What? is the error in <?php ??? — Vito
– Vito, Commented Oct 16, 2015 at 15:06
What did the entire message say? Perhaps the error is in the included header.php? — gen_Eric
– gen_Eric, Commented Oct 16, 2015 at 15:07
it says anlo what i wrote :/ No the error is not in the header. I tried to remove it and nothing changed — Vito
– Vito, Commented Oct 16, 2015 at 15:10
Is that syntax error from PHP or MySQL? Can you copy and paste the entire message (and edit it into the question)? — gen_Eric
– gen_Eric, Commented Oct 16, 2015 at 15:13

Niranjan N Raju · Accepted Answer · 2015-10-16 15:14:52Z

4

you are missing one parenthesis at last

INSERT INTO `updates_queue` (`user_id`,`content`, `start_at`,`end_at`,`finished`,`old_level`)
VALUES ('".$_SESSION['uid']."', 'rock_update', '".$current_time."',
'".$current_time."',0 ,'".$building['rock_miner']."')")
                                                    ^

answered Oct 16, 2015 at 15:14

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

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

Comments

Richard Housham · Accepted Answer · 2015-10-16 15:07:36Z

0

Not too sure but wouldn't use int to store a time. Int only goes up to a certain value and then will fail-or just store the highest value it can. I think that might depend on your mysql version though.

The comment before is a good start and make sure you have connected to the database as well.

So your $connection isn't false.

answered Oct 16, 2015 at 15:07

Richard Housham

1,6782 gold badges16 silver badges33 bronze badges

4 Comments

Vito Over a year ago

my db is connected. I tried the query in the phpmyadmin and everything works. The problem is the query passed by PHP. I also removed the header and footer include. Nothing changed

Richard Housham Over a year ago

Have you tried the previous comment ini_set('display_errors', 1); error_reporting(-1); Will show errors - generally. if($update_miner === FALSE){ die(mysqli_error($connection)); } Will show any errors. Also might be worth a sanity check - are you connected to the right database, I generally have 2. 1 development,1 live. Check both (if you have them)

david Over a year ago

I wouldn't use INT to store time either, but both PHP and MySQL have functions that allow one to convert to/from a "Unix timestamp" value. Note that you can't use INT(9), however, as that would have overflowed in 2001. Using INT will fail in 2038, and using INT UNSIGNED will fail in 2106.

Richard Housham Over a year ago

Yeah I like the unix_timestamp options, but I would store my time as a datetime

Collectives™ on Stack Overflow

PHP MYSQL insert doesn't work and receive no error

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related