Nothing inserted into birthdate column, rest does get inserted

QuincyDK

Hey, I've got this part of a script. The problem: The date (user_birthdate) doesnt get inserted in my database yet: when I echo it back, it is correctly displayed. If I insert it manually using my MySQL client, it also inserts correctly.. Any help?
This is the prepare statement after the vars are filled in
$stmt->bind_param('ssssssss', Quincy, de Koster, 2014-01-22, VDS11, 355X XT, , 0612345678, )

		if(isset($_POST['verzend'])){
			$voornaam = $_POST['voornaam'];
			$achternaam = $_POST['achternaam'];
			$ts = strtotime($_POST['geboortedatum']);
			print $ts.'<br />';
			$geboortedatum = date('Y-m-d', $ts);
			echo '2 '.$geboortedatum;
			$adres = $_POST['adres'];
			$postcode = $_POST['postcode'];
			$stad = $_POST['stad'];
			$telefoon = $_POST['telefoonnummer'];
			$uname = $_SESSION['username'];
			echo "dit is een $geboortedatum";
			$stmt = $connectres->prepare("UPDATE users SET user_first_name= ?, user_last_name= ?, user_birthdate= ?, user_adress= ?, user_zipcode= ?, user_city= ?,user_phone= ? where user_name = ?");
			$stmt->bind_param('ssssssss', $voornaam, $achternaam, $geboortedatum, $adres, $postcode, $stad, $telefoon, $uname);
			$stmt->execute();
			$stmt->close();
		}

MOD EDIT: [noparse]

..

[/noparse] bbcode tags added.

traq

What type is the [FONT=monospace]user_birthdate[/FONT] column?
mysql date/time types

As for being echoed back correctly, I can only assume the value is being passed in some other way, and you're not actually retrieving it from the DB.

QuincyDK

The column user_birthdate is datatype DATE.

QuincyDK

Sorry for the double post, but Im mobile at the moment and cannot seem to find an edit button. I retrieve the value from POST, and it has to be inserted into the column.

traq

QuincyDK;11037609 wrote:
The column user_birthdate is datatype DATE.

The format you posted ("YYYY-MM-DD") should be inserted correctly. Have you checked [font=monospace]$stmt->error_list[/font]?

dalecosp

Do you have PDO::ERRMODE_SILENT set, by any chance?

QuincyDK

traq;11037615 wrote:
The format you posted ("YYYY-MM-DD") should be inserted correctly. Have you checked [font=monospace]$stmt->error_list[/font]?

$stmt->error_list gives 'Array ( )' so I'm guessing no errors ... Well, this isn't the first unexplainable error, and my teacher couldn't help me with this one either...

traq

dalecosp;11037621 wrote:
Do you have PDO::ERRMODE_SILENT set, by any chance?

I would assume (though I didn't clarify) that the OP is using MySQLi, because the posted code uses the [font=monospace]bind_param[/font] method.

@, I cannot reproduce this based on the info you provided. Can you create a reduced test case (including the table schema) that demonstrates this problem?

Also, what versions of php / mysqlnd / mysql are you using?

bradgrafelman

Just to cover all bases, can you do a [man]var_dump/man on $geboortedatum before the bind_param() and show us the output?

Also, have you checked to see if anyone told your MySQL server "Please don't change data that you think is invalid into something else and pretend as if there wasn't a problem and that you did what I told you to do." ? The MySQL devs decided to abbreviate that to STRICT_ALL_TABLES and made it an option for the server mode. (Wouldn't it be nice if the world worked like MySQL did? Where sanity was optional at all times? 🙂)

traq

bradgrafelman;11037633 wrote:
Where sanity was optional at all times? 🙂)

In fairness, that's why MySQL is such a perfect partner for PHP.

johanafm

Your update statement, after filling in the blanks, is

UPDATE stuff
WHERE user_name = NULL

traq

johanafm;11037637 wrote:
Your update statement, after filling in the blanks, is
UPDATE stuff
WHERE user_name = NULL

hmm… @, the way I read your original post, it seemed that you meant the other parameters were being updated, and only the date was not. Is this the case? or is the entire statement ineffective? What value does [font=monospace]$stmt->affected_rows[/font] contain after you execute the statement?

Derokorian

the last parameter should only be null if $_SESSION['username'] is null / undefined.

QuincyDK

traq;11037639 wrote:
hmm… @, the way I read your original post, it seemed that you meant the other parameters were being updated, and only the date was not. Is this the case? or is the entire statement ineffective? What value does [font=monospace]$stmt->affected_rows[/font] contain after you execute the statement?

This is indeed the case, everything gets updated/inserted.

To every one else: I'm low on time right now, I will answer everything tomorow 🙂