Why my basic insertion won't work?

[kyme]

I was just playing insertion using PDO statement.

I just referred this tutorial and test it my code.

http://php.net/manual/en/pdo.prepared-statements.php

So I did but didn't work.  

 

Is there anything I miss? 

 

This is my Insertion: 

https://paste.ofcode.org/dxgTWNKJqcRdPZqvjjrxHf

 

My localhost db is connected and running in localhost. Anyway here is also my config.

https://paste.ofcode.org/32LafCUrBbJSiLDAfrQjaWM

 

I wonder why it won't insert in my local db. Did I missed something in my insertion code? 

[requinix]

Do you have the database set up correctly? Are you looking for error messages?

[kyme]

Do you have the database set up correctly? Are you looking for error messages?

 

Yeah. My db is also connected. 

 

I'm not sure about the error. But my codes is correct right?

[NigelRel3]

You are trying to insert into 3 values for your insert statement and bind only 1.

[requinix]

Use PDO::errorInfo to get information about the last problem that occurred. In your case that's just after the ->prepare... probably, or else after the ->execute.

[kyme]

You are trying to insert into 3 values for your insert statement and bind only 1.

 

Oh I didn't notice this. Thanks. It works now. 

[Jacques1]

Not really.

 

Your connection code is fudged up. You need to get rid of this stupid try-catch stuff, because it exposes internal information and is just irritating. Error messages are meant for you, the developer, not your users. What on earth are your users supposed to do with a PDO error message? They'll just think that your application has a lot of problems.

 

Then you need to enable exceptions, so that messed up queries are immediately reported. Learn how PDO works.