Jump to content
Sign in to follow this  
kyme

Why my basic insertion won't work?

Recommended Posts

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? 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.