KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to bind parametres for SQL query inside a loop: $db = new PDO('mysql:dbname=test;host=localhost', 'test', ''); $stmt = $db->prepare('INSERT INTO entries VALUES (NULL, ?, ?, ?, NULL)'); $title = 'some titile'; $post = 'some text'; $date = '2010-whatever'; $reindex = array(1 => $title, $post, $date); // indexed with 1 for bindParam foreach ($reindex as $key => $value) { $stmt->bindParam($key, $value); echo "$key</br>$value</br>"; //will output: 1</br>some titile</br>2</br>some text</br>3</br>2010-whatever</br> } The code above inserts in database in all 3 fields 2010-whatever . This one works fine: $stmt->bindParam(1, $title); $stmt->bindParam(2, $post); $stmt->bindParam(3, $date); So, my question is why the code in the foreach-loop fails and inserts wrong data in the fields?
Tags (comma-separated)
Save Edits
Cancel