Thu, October 21, 2021
 
https://devcodepro.comdevcodepro
X
Home · Latest · Trends
9

Bind variables in ADODB

Using bind variables with ADODB
//Update

$sql = $DB->Prepare('UPDATE mytable SET count = count + ? WHERE id = ?');
if($DB->Execute($sql,array("1",$id)) === false) {
print $DB->ErrorMsg();
}

//Insert

$sql = $DB->Prepare('INSERT INTO mytable (id, mytext) VALUES (?, ?)');
if($DB->Execute($sql,array($id,$text)) === false) {
print $DB->ErrorMsg();
}
rated 9 times (9) (0)
comments: 0 / hits: 2608  / 5 years ago, tue, sep 6, 16, 10:11:38
More From » PHP
 

Comments

There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
Login with Google
 
Share
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 25
Total Comments: 2
Location: New Britain, Connecticut
Ronald snippets
5 years ago, tue, sep 6, 16, 10:18:23
comments: 0 / hits: 2455
PHP
5 years ago, tue, sep 6, 16, 10:42:24
comments: 0 / hits: 2827
PHP
5 years ago, fri, sep 16, 16, 1:10:12
comments: 0 / hits: 3293
PHP
5 years ago, fri, sep 16, 16, 1:12:32
comments: 0 / hits: 2163
CSS
5 years ago, fri, sep 16, 16, 1:27:33
comments: 0 / hits: 3274
PHP
5 years ago, sun, sep 25, 16, 2:52:42
comments: 1 / hits: 2598
5 years ago, thu, nov 10, 16, 4:21:59
comments: 1 / hits: 2748
PHP
5 years ago, mon, nov 21, 16, 10:48:23
comments: 2 / hits: 9728
PHP
5 years ago, sun, dec 25, 16, 2:44:24
comments: 0 / hits: 5305