ADOdb - Check if MySQL query executed successfully
<?php
$sql = $DB->Prepare('DELETE FROM mytable WHERE id = ' . $DB->qstr($id) . '');
if ($DB->Execute($sql) === false) {
print $DB->ErrorMsg();
}
if ($DB->affected_rows() !== 0) {
//true
}
?>
rated 23 times
(23)
(0)
comments: 0 / hits: 5235
/ 4 years ago, tue, may 29, 18, 04:20:25
More From
» PHP
Comments
There are no comments for this Snippet yet
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 25
Total Comments: 2
Location: New Britain, Connecticut
Ronald snippets
6 years ago, tue, sep 6, 16, 10:11:38
//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();
}
comments: 0 / hits: 2886
6 years ago, tue, sep 6, 16, 10:18:23
//MySQL
CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
);
//PHP
include ('classes/adodb/db.php');
include ('classes/adodb/adodb.inc.php');
$adoDriver = "mysqli";
$DB = ADONewConnection($adoDriver);
@$DB->Connect($server,$user,$password,$database);
$perf = NewPerfMonitor($DB);
$perf->UI($pollsecs=3);
comments: 0 / hits: 2741
6 years ago, tue, sep 6, 16, 10:42:24
<?php
$headers = 'From: [email protected]' . "\r\n" . 'Reply-To: [email protected]' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
$to = '[email protected]';
$subject = 'Email Subject';
$text = 'Test email body';
if (mail($to, $subject, $text, $headers)) {
echo "Test php mail sent successfully";
} else {
echo"Message delivery failed";
}
?>
comments: 0 / hits: 3151
6 years ago, fri, sep 16, 16, 1:10:12
{if {$date1|date_format:"%y%m%d"} lt {$date2|date_format:"%y%m%d"}}
foo
{/if}
or
{if {$date|date_format:"%y%m%d"} lt {$smarty.now|date_format:"%y%m%d"}}
foo
{/if}
comments: 0 / hits: 3719
6 years ago, fri, sep 16, 16, 1:12:32
input:-webkit-autofill{-webkit-box-shadow:0 0 0px 50px #F5F5F5 inset;opacity:0.6;}
comments: 0 / hits: 2307
6 years ago, fri, sep 16, 16, 1:27:33
$domain = 'dailymail.co.uk';
$dots = substr_count($domain, '.');
if($dots == 1){
$results = preg_split('/(?=.[^.]+$)/', $domain);
echo $results[0];
}
if($dots == 2){
$results = preg_split('/(?<=[^0-9])[.](?<![0-9])/', $domain);
echo $results[0];
}
comments: 0 / hits: 3494
6 years ago, sun, sep 25, 16, 2:52:42
<!DOCTYPE html>
<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
</head>
<body>
<input type="text" id="number" name="phonenumber" />
<script>
jQuery('#number').keyup(function () {
this.value = this.value.replace(/[^0-9.s+()]/g,'');
});
</script>
</body>
</html>
comments: 1 / hits: 2924
6 years ago, thu, nov 10, 16, 4:21:59
//libs/plugins/modifier.removebb.php
<?php
/**
* Smarty plugin
*
* @package Smarty
* @subpackage plugins
*/
/**
* smarty_modifier_removebb()
*
* @param mixed $string
* @return
*/
function smarty_modifier_removebb($string) {
$find = '|[[/!]*?[^[]]*?]|si';
$replace = '';
return preg_replace($find,$replace,$string);
}
?>
// Usage:
{$m.foo|removebb}
comments: 1 / hits: 2995
6 years ago, mon, nov 21, 16, 10:48:23
<?php
//upload.php
if(isset($_POST['query'])) {
$image_info = @getimagesize($_FILES['image']['tmp_name']);
if($image_info == false) {
die('Please upload valid image file.');
} else {
echo 'Image file is valid';
}
} else {
?>
<form action="upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="image">
<input type="submit" name="query" value="Upload" />
</form>
<?php } ?>
comments: 2 / hits: 12106