https://devcodepro.comdevcodepro

ADOdb Performance Monitor

URL: https://www.phplisting.com/entry/14/17/adodb-database-class

This module provides HTML and CLI interfaces for viewing key performance indicators of your database.

//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);

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 4 times (4) (0)

comments: 0 / hits: 3093 / 7 years ago, tue, sep 6, 16, 10:18:23

Comments

There are no comments for this Snippet yet

Only authorized users can post. Please sign in first, or register a free account

Posted

Ronald

Member since Sep 6, 2016

Total Points: 242

Total Code Snippets: 25

Total Comments: 3

Location: New Britain, Connecticut

Ronald snippets

Bind variables in ADODB

7 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: 3265

PHP

Check if php mail function is enabled

7 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: 3559

PHP

Compare dates in smarty

7 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: 4320

PHP

Chrome input style

7 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: 2508

CSS

Get domain name without Tld

7 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: 3841

PHP

Validating international phone numbers

7 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: 3204

JavaScript

Smarty Remove BBCode

7 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: 3355

PHP

How to check if uploaded file is image in php

7 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: 15839

PHP

How to check CKEditor textarea not empty

7 years ago, sun, dec 25, 16, 2:44:24

<div class="ckarea" style="display:none;">Please enter Description</div> <textarea name="longdesc" id="longdesc"></textarea> <script> CKEDITOR.replace( 'longdesc' ); </script> <script> $("form").submit(function(e) { var description = CKEDITOR.instances['longdesc'].getData().replace(/<[^>]*>/gi, '').length; if (!description) { $(".ckarea").show(); return false; } }); </script>

comments: 0 / hits: 6772

JavaScript