Insert value list does not match column list: 1136 Column count doesn’t match value count

by

Your database table has 35 columns

id_logged, patient_id, one, two, three, four, five, six, seven, eight, nine, ten, eleven, twelve, thirteen, fourteen, fifteen, sixteen, seventeen, eightteen, nineteen, twenty, twone, twtwo, twthree, twfour, twfive, twsix, twseven, tweight, twnine, thirty, thone, thtwo, date_now

Where as the values you are passing are 34 columns

VALUES (:id_logged, :patient_id, :one, :two, :three, :four, :five, :six, :seven, :eight, :nine, :ten, :eleven, :twelve, :thirteen,
        :fourteen, :fifteen, :sixteen, :lone, :ltwo, :lthree, :lfour, :lfive, :lsix, :lseven, :leight, :lnine, :lten, :leleven, :ltwelve, :lthirteen, :lfourteen, :lfifteen, :lsixteen)

This mismatch of columns is giving you the error.

You forgot to pass the value for date_now column. once you pass it error will be resolved

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. PDOException SQLSTATE[HY000] [2002] No such file or directory
  3. How to get numeric types from MySQL using PDO?
  4. How can I use PDO to fetch a results array in PHP?
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  7. Use bound parameter multiple times
  8. What is the difference between MySQL, MySQLi and PDO? [closed]
  9. MySQL check if a table exists without throwing an exception
  10. how safe are PDO prepared statements
  11. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  12. PHP PDO – Num Rows
  13. How to solve General error: 2006 MySQL server has gone away
  14. Replacing mysql_* functions with PDO and prepared statements
  15. PDO + MySQL and broken UTF-8 encoding
  16. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  17. php code to test pdo is available?
  18. Calling stored procedure with Out parameter using PDO
  19. When *not* to use prepared statements?
  20. PDO fetchAll group key-value pairs into assoc array
  21. What is the best way to insert multiple rows in PHP PDO MYSQL?
  22. PDO MySQL: Insert multiple rows in one query
  23. How to bind LIKE values using the PDO extension?
  24. Binding parameters for WHERE IN clause with PDO [duplicate]
  25. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  26. PHP 7 RC3: How to install missing MySQL PDO
  27. PHP Laravel: No connection could be made because the target machine actively refused it
  28. PDO bindParam into one statement?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment