Fri, April 10, 2020, 09:45:36
 
Home · Latest · Trends  /  PHP
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: 1688  / 4 years ago, tue, sep 6, 2016, 10:11:38
More From » PHP
 

Comments

There are no comments for this Snippet yet
Username
 
Your Comment
 
Share
Sponsor
Sponsor
Snippets
This module provides HTML and CLI interfaces for viewing key performance indicators of your database.
4 years ago, tue, sep 6, 2016
How to check if mail function is enabled on your server
4 years ago, tue, sep 6, 2016
Compare dates in smarty template file
4 years ago, fri, sep 16, 2016
Change default chrome input style CSS
4 years ago, fri, sep 16, 2016
Get domain name without Tld with PHP
4 years ago, fri, sep 16, 2016
Validating international phone numbers with jquery
4 years ago, sun, sep 25, 2016
Smarty Remove BBCode From String
3 years ago, thu, nov 10, 2016
How to detect if uploaded file is image or not with php
3 years ago, mon, nov 21, 2016
How to check CKEditor 4 textarea not empty
3 years ago, sun, dec 25, 2016
Posted
Ronald

Ronald

Member since Sep 6, 2016
Total Code Snippets: 20
Total Comments: 1
Location: n/a
Following
User not following anyone yet.