Category: Uncategorized

find /home/ -type f -size +10M -and -regex ‘(.tar|.gzip|.zip|.tgz|.*sql)’

Stored at SSH-for-Backups.txt

cannot connect to X server (SOLVED)

on Centos 7

sudo yum install Xvfb (note the Capital X)

xvfb-run /usr/bin/wkhtmltopdf http://www.google.com google.pdf

//for removing duplicate entries from table
ALTER IGNORE TABLE email_base ADD UNIQUE INDEX email_unique (email);

$price = 849;  // enter price here

$vat_rate = 20;
$vat = ($price * $vat_rate)/(100+$vat_rate);
echo "\n Price Inc.Vat - > ".$price;
echo "\n VAT - > ".$vat;
$price_ex_vat = $price-$vat;
echo "\n Price Ex. Vat - > ".$price_ex_vat;

Run the above code here:

http://writecodeonline.com/php/

location

This is used in GUR admin’s location management

Download the location zip…

1. Print a report can be found latest in: ??http://englishtestuk.com/admin/order/index?page=view
2. Captcha change code is added first in the project:?http://englishtestuk.com/register
3. Grouping of records based on a field and multiple checkbox update is done in exluk?View
4. Image max size fix has bee done in this shopping cart View
5. Image merge on the Fly while upload with other image – ?we have done in doyouwork View
6. Social media sharing buttons?http://kurtnoble.com/labs/rrssb/index.html
7. List of unicode characters?https://en.wikipedia.org/wiki/List_of_Unicode_characters

// for datetime field like 2001-12-03
select * from user where month(date_of_birth) = 2  

 // for datetime field like 978363171

select * from user WHERE MONTH(FROM_UNIXTIME(date_of_birth)) = MONTH(CURDATE()) AND DAY(FROM_UNIXTIME(date_of_birth)) = DAY(CURDATE()) AND date_of_birth !=0