Answer 1

Please edit your post to add more details regarding your question. For example, you didn't mention whether you use mysqli or PDO, you didn't mention either where the values to insert came from, it could be from HTML form submission or JSON/XML data. With more information given people feel more assured of how to assist.

* I will remove this note soon as I see you updated your post. Thanks for understanding, and hope you get better chance for an answer by improving the post.