https://devcodepro.comdevcodepro

Full text search order by relevance

SELECT SQL_CALC_FOUND_ROWS *, MATCH (title,description) AGAINST ('Text') as score FROM posts WHERE MATCH (title,description) AGAINST ('Text') ORDER by score DESC;

rated 6 times (6) (0)

comments: 0 / hits: 2380 / 5 years ago, wed, dec 13, 17, 05:18:51

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

Total Code Snippets: 25

Total Comments: 2

Location: New Britain, Connecticut

Ronald snippets

Bind variables in ADODB

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

PHP

ADOdb Performance Monitor

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

PHP

Check if php mail function is enabled

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

PHP

Compare dates in smarty

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

PHP

Chrome input style

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

CSS

Get domain name without Tld

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

PHP

Validating international phone numbers

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

JavaScript

Smarty Remove BBCode

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

PHP

How to check if uploaded file is image in 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: 12106

PHP