MySQL query is not inserting data into the table

Question

        $stmt= $mysqli->prepare("insert into book_project.personal_details(name,email,cc_num,address,city,zipcode) values (?,?,?,?,?,?)");

        var_dump($_SESSION);

        $stmt->bind_param('ssssss',$_SESSION['name'],$_SESSION['email'],$_SESSION['cc_num'],$_SESSION['address'],$_SESSION['city'],$_SESSION['zipcode']);

        $stmt->execute();

        $stmt->close();
}

I have a id column as primary key have not included it. id auto increments. I do not know to find errors. I do not understand what is happening.

Do you get any errors? Do you check for any errors later on in the code? if not, do so! php.net/manual/en/mysqli.error.php — Andresch Serj
– Andresch Serj, Commented Apr 29, 2014 at 14:07

user3577953 · Accepted Answer · 2014-04-29 14:07:36Z

2

You have 7 parameters here:

$stmt->bind_param('ssssss',$_SESSION['name'],$_SESSION['email'],$_SESSION['cc_num'],$_SESSION['address'],$_SESSION['city'],$_SESSION['zipcode']);

But there are only 6 placeholders in the SQL query:

$stmt= $mysqli->prepare("insert into book_project.personal_details(name,email,cc_num,address,city,zipcode) values (?,?,?,?,?,?)");

answered Apr 29, 2014 at 14:07

user3577953

Sign up to request clarification or add additional context in comments.

3 Comments

CodeBird Over a year ago

where are there 7 params! I see 6 everywhere!

briosheje Over a year ago

'ssssss' is the first (or seventh) which shouldn't be there.. (@CodeBird)

CodeBird Over a year ago

yeah bind_param ( string $types , mixed &$var1 [, mixed &$... ] ) the first ssssss is the types ----> jp.php.net/manual/en/mysqli-stmt.bind-param.php

Collectives™ on Stack Overflow

MySQL query is not inserting data into the table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related