CSS Clip-PathMaker - live code

If you are looking for CSS CLIP-PATH example code for polygon, hexagon, triangle or square or custom shape for your webiste - just check here for instant size & point co-ordinates --- Clip-Path Maker

Dot Leaders in Receipt Design CSS HTML

Dot leaders btw Description and Rate in HTML CSS

CSS Code
<style type="text/css"> ul li { width: 100%; } ul.leaders { max-width: 40em; padding: 0; overflow-x: hidden; list-style: none} ul.leaders li:before { float: left; width: 0; white-space: nowrap; content: ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . " ". . . . . . . . . . . . . . . . . . . . "} ul.leaders span:first-child { padding-right: 0.33em; background: white} ul.leaders span + span { float: right; padding-left: 0.33em; background: white} </style>

HTML Cide
<ul class="leaders"> <li> <span>Base Fare</span> <span>$25.00</span> </li> <li> <span>Addl. PAX</span> <span>$20.00</span> </li> <li> <span>Child Seat</span> <span>$10.00</span> </li> <li> <span>Booster Seat</span> <span>$10.00</span> </li> <li> <span>Total Fare</span> <span>$65.00</span> </li> <li> <span>Discount (15%)</span> <span>$9.75</span> </li> <li> <span>Total Payable<br>(After Discount)</span> <span>$55.25</span> </li> </ul>

Taxi Website Designers.com

MYSQL - Group by date and Sum by Everyday

If want to calculate sum of everyday here is simple ways to do it

Sum of Everyday Descending Order in MySQL

select date(csdate) as xdate, sum(ifare) as total from rform group by date(csdate) order by date(csdate) DESC

Sum of A Day in Mysql

select csdate, ifare from rform where date(csdate) = "2015-09-21"

Removing white space non-numeric characters parenthesis spaces hyphens of Phone Number formatting in MySQL Query Statement

This is God of All Small Things.

You have phone number with too many formattting like
(444) 444-4444
(555)555-5555
800-123-4567
877 987-4563

and you want to QUERY it in MySQL like "4085439351" --- you will have to write a trigger and use it as function in your MYSQL QUERY STATEMENT

STEP#1 -- WRITE A QUERY

// phone10() is your function name DELIMITER $$ USE [database]$$ // USE A DATABASE WHERE YOU WANT TO SAVE YOUR TRIGGER DROP FUNCTION IF EXISTS `phone10`$$ CREATE DEFINER=`root`@`localhost` FUNCTION `phone10`(str VARCHAR(1000)) RETURNS VARCHAR(1000) CHARSET latin1 DETERMINISTIC BEGIN DECLARE counter INT DEFAULT 0; DECLARE strLength INT DEFAULT 0; DECLARE strChar VARCHAR(1000) DEFAULT '' ; DECLARE retVal VARCHAR(1000) DEFAULT ''; SET strLength = LENGTH(str); WHILE strLength > 0 DO SET counter = counter+1; SET strChar = SUBSTRING(str,counter,1); IF strChar REGEXP('[0-9]+') = 1 THEN SET retVal = CONCAT(retVal,strChar); END IF; SET strLength = strLength -1; SET strChar = NULL; END WHILE; RETURN retVal; END $$ DELIMITER ;

MYSQL QUERY STATEMENT

SELECT person FROM usermst WHERE phone10(phone_number) = '123456789' select phone10(phone_number) from usermst

SIMPLE - ISN'T IT???