Home · Latest · Trends  /  PHP
9

Bind variables in ADODB

rated 9 times [  9] [ 0]  / comments: 0 / hits: 1341  / 3 years ago, tue, sep 6, 2016, 10:11:38
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();
}
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
 
Share
Snippets
This module provides HTML and CLI interfaces for viewing key performance indicators of your database.
3 years ago, tue, sep 6, 2016
How to check if mail function is enabled on your server
3 years ago, tue, sep 6, 2016
Compare dates in smarty template file
3 years ago, fri, sep 16, 2016
Change default chrome input style CSS
3 years ago, fri, sep 16, 2016
Get domain name without Tld with PHP
3 years ago, fri, sep 16, 2016
Validating international phone numbers with jquery
3 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
Sponsor
Posted
Ronald

Ronald

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