Wed, July 6, 2022
https://devcodepro.comdevcodepro
Home · Latest · Trends
1

ADOdb count number of records

$recordSet = $conn->Execute('SELECT * FROM mytable where published = '.$conn->qstr('1').' or published = '.$conn->qstr('2').' order by id DESC');
$counter = $recordSet->recordCount();
echo $counter;
AD ยท www.interserver.net/r/240055 

Interserver | Standard & VPS Cloud Hosting | $2.50 /Month

Flexible VPS hosting platform to deploy your online projects. Economical and balanced between processor cores, memory and storage
rated 1 times (1) (0)
comments: 0 / hits: 1367  / 4 years ago, sun, apr 8, 18, 04:14:33
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
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: 2926
PHP
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: 2780
PHP
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: 3193
PHP
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: 3785
PHP
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: 2329
CSS
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: 3535
PHP
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: 2961
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: 3034
PHP
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: 12631
PHP