php pdo bindvalue array
Solutions on MaxInterview for php pdo bindvalue array by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "php pdo bindvalue array"
Neele
16 Nov 2017
1<?php
2$ids = array(1, 2, 3, 7, 8, 9);
3$inQuery = implode(',', array_fill(0, count($ids), '?'));
4
5$db = new PDO(...);
6$stmt = $db->prepare(
7 'SELECT *
8 FROM table
9 WHERE id IN(' . $inQuery . ')'
10);
11
12// bindvalue is 1-indexed, so $k+1
13foreach ($ids as $k => $id)
14 $stmt->bindValue(($k+1), $id);
15
16$stmt->execute();
17?>
18similar questions
php pdo error 500php pdo transactionphp pdo connectionfetching columns using pdo 28php data object 29php parameter hinting arraypdo php search tablehow to fetch data using pdo in phpphp forech pdophp pdo howto columns from tablepdo turn on errorsphp pdo has resultphp pdo fetch from dbbind method in pdo in phpphp pdo error handlingbind in pdopdo fetchpdo connection phpphp transform associative array to arrayphp pdophp query pdophp pdo examplephp pdo check if update query successful your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful