php mysql pdo bindparam data not insert

Question

When I Call this function , it shows no error, But Data not inserted. Database Connection is checked and its OK , Connection type PDO.

public function insert(){
    $table  = "category";
    $data   = array(
        'cat_id'    => 5, 
        'cat_name_en'   => 'Science', 
        'cat_info'  => 'All about nature', 
        'cat_tags'  => 'Physics, chemistry' 
        );
    $keys       = implode(', ', array_keys($data));
    $values     = ":".implode(", :", array_keys($data));
    echo $sql   = "INSERT INTO $table($keys) VALUES($values)";
    $stmt       = $this->db->prepare($sql);
    foreach ($data as $key => $value) {
        $stmt->bindParam(':'.$key, $value);
    }
    return $stmt->execute();

}

Database connection is ok. Because it works on SELECT and DELETE query, But not working INSERT and UPDATE query. I do not want alternative but i want where is my bug. Please help me. I am trying to solve it for 2 days.

Windows 10 64bit
WampServer 3.0.8
PHP 7.1
MySQL 5.7

stackoverflow.com/questions/19221692/…

MSISHIHAB SHIHAB
– MSISHIHAB SHIHAB

2017-09-10 11:34:28 +00:00
Commented Sep 10, 2017 at 11:34 — MSISHIHAB SHIHAB
– MSISHIHAB SHIHAB, Commented Sep 10, 2017 at 11:34
Same type error but not solved.

MSISHIHAB SHIHAB
– MSISHIHAB SHIHAB

2017-09-10 11:34:57 +00:00
Commented Sep 10, 2017 at 11:34 — MSISHIHAB SHIHAB
– MSISHIHAB SHIHAB, Commented Sep 10, 2017 at 11:34

B. Desai · Accepted Answer · 2017-09-10 11:41:30Z

1

You need to bindValue() instead of bindParam(). Change you foreach loop to

foreach ($data as $key => $value) {
        $stmt->bindValue(':'.$key, $value);
    }

See the doc:

http://php.net/manual/en/pdostatement.bindvalue.php

See the difference here:What is the difference between bindParam and bindValue?

edited Sep 10, 2017 at 11:41

answered Sep 10, 2017 at 11:38

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

2 Comments

B. Desai Over a year ago

try to print error print_r($stmt->errorInfo()); after execute

MSISHIHAB SHIHAB Over a year ago

Thank you. Problem is solved. It will be bindValue().

Collectives™ on Stack Overflow

php mysql pdo bindparam data not insert

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related