Date as Header Row in PHP MySQL [solved]

After long bang bang and stackflow here is what i found to :
Date as Row Header
Daily Report Table in Using MySQL & PHP

How You will love it

<?php include('config.php'); $result = mysqli_query($con, 'select * from sform where date_format(csdate,"%Y") != "1969" order by csdate ASC'); $dateSection = ""; echo '<table width="100%">'; while($row = mysqli_fetch_assoc($result)) { $dateHeader = date("d-M, Y", strtotime($row['csdate'])); if ( $dateHeader != $dateSection ) { $dateSection = $dateHeader; echo '<tr><td colspan="5" style="background:#000;color:#fff; text-align:center; padding:8px; font-weight:bold;">' . $dateHeader .'</td></tr>'; } echo '<tr>'; echo '<td>#' . $row["rno"] . '</td>'; echo '<td>' . $row["cname"] . '</td>'; echo '<td>' . date('d-M, Y @ h:i A', strtotime($row["csdate"])) . '</td>'; echo '<td>' . $row["cphone"] . '</td>'; echo '<td>' . $row["caddr"] . '</td>'; echo '<td>' . $row["csnop"] . '</td>'; echo '</tr>'; } ?>

How to Install Laravel on Mac OSX

If you're facing this issue with macOS Catalina, I recommend these steps:

[PS: do not waste your time installing apt-get or yum ]

-- Just Install Homebrew (if you haven't already done so): head over to brew.sh or simply run this command: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

-- Run brew install php@7.3


Update your $PATH variable to include the newly installed version of php:
>>> echo 'export PATH="/usr/local/opt/php@7.3/bin:$PATH"' >> ~/.zshrc
-- Also --
>>>>>> echo 'export PATH="/usr/local/opt/php@7.3/sbin:$PATH"' >> ~/.zshrc

-- Reload your shell preferences script $ source ~/.zshrc or source ~/.bashrc

Finally, install laravel: composer global require laravel/installer

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???

Video Background Header Plain CSS - SOLVED

This is Plain CSS Video Background Header optimized for Desktop & Mobile Phone working great. Enjoy!!!

<!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, height=device-height, initial-scale=1.0, minimum-scale=1.0"> <style type="text/css"> *{ margin: 0; paddding: 0; } .wrapper{ width: 100%; height: 80vh; overflow: hidden; } .wrapper .wrapper__video{ object-fit: cover; width: 100%; height: 100%; } #xoverlay { text-align: center; margin: 20px 40px; position: absolute; z-index: 214; } #logo1 { width: 90%; } </style> </head> <body> <header> <div class="wrapper"> <div id="xoverlay"> <img src="images/our-logo.png" id="logo1"> </div> <video autoplay loop muted class="wrapper__video"> <source src="images/bg-video.mp4"> </video> </div> </header> </body> </html>

Dropdown of 50 States of United States

Here is Dropdown of 50 States of United States for you

<select name="states"> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">NewHampshire</option> <option value="NJ">NewJersey</option> <option value="NM">NewMexico</option> <option value="NY">NewYork</option> <option value="NC">NorthCarolina</option> <option value="ND">NorthDakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">RhodeIsland</option> <option value="SC">SouthCarolina</option> <option value="SD">SouthDakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">WestVirginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select>

how to install ADB on MACBOOK or Mac OS - SOLVED

It is very simple. follow the steps

• 1. INSTALL HOMEBREW (if not installed) -- ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
• INSTALL ADB --- brew cask install android-platform-tools
• TEST --- adb devices

htaccess REWRITE URL with multiple Query String

.htaccess REWRITE URL with multiple Query String

RewriteEngine On Options -Multiviews Options +FollowSymLinks #LoadModule rewrite_module modules/mod_rewrite.so #AddModule mod_rewrite.c #RewriteBase / #local pages RewriteRule ^US/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/?$ city.php?st=$1&cty=$2 [NC,L]

Visit my website : Taxi Website Designers.com

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin' - SOLVED

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin'

In the PHP code above, I am telling the browser that site-a.com has permission to make cross-domain requests to my website. The second parameter of PHP’s header function has been set to FALSE so that it is not overwritten by any other Access-Control-Allow-Origin headers that we may add in the future.

Note that you may also come across examples like this on the web:

//Access-Control-Allow-Origin header with wildcard. Access-Control-Allow-Origin: http://siteA.com Access-Control-Allow-Methods: GET, POST, PUT Access-Control-Allow-Headers: Content-Type <p>In the PHP code above, we have used a wildcard character. The problem with this is that it will allow everybody to make Ajax requests to our website. This is a lazy solution that may introduce security risks.</p>

PHP MySQL multiple rows to JSON

Simple to store PHP MySQL to JSON with multiple rows result

<?php include('config.php'); $mkt = mysqli_query($con,'select * from booking order by csdate DESC'); //while //$mkt = mysqli_query($con, $sql); $result = array("booknow" => array()); //create an associative array with a property called "dashboard_content", which is an array. (json_encode will convert an associative array to a JSON object) if (check) { $rows = mysqli_fetch_assoc($mkt); if (!$rows) { echo "No results!"; } else { while ($rows = mysqli_fetch_assoc($mkt)) { $pickup = $rows['pickup']; $drop = $rows['drop']; $csdate = date('m-d-Y @ h:i A', strtotime($rows['csdate'])); $cmsgs = $rows['cmsgs']; $tstamp = $rows['tstamp']; // $rstatus = //append the current data to a new entry in the "dashboard_content" array $result["booknow"][] = array('pickup' => $cadd, 'drop' => $drop, 'csdate' => $csdate, 'cmsgs' => $cmsgs, 'tstamp' => $tstamp); } } } //now, output the whole completed result to one single, coherent, valid JSON array. echo json_encode($result); ?>

how to create Keystore apk signing in command line cmd

Find KEYSTORE.EXE from your android studio / java installation drive on windows
Set Path to folder for easy access of keystore.exe

keytool -genkey -v -keystore c:\<[your-keystore-file-name]> -keypass bgb123456 -alias <[keystore name]> -keyalg RSA -keysize 2048 -validity 10000 keytool -exportcert -list -v -alias <[keystore name]> -keystore <[your-keystore-file-name]>

HASH Algorithm in MySQL PHP Query - SOLVED

MySQL Query of HASH SHA2 Type of SHA384

select * from users where SHA2(userid,384)="839121c5bbda9f7b630137aa10104cae53085f7a8a030d7b37f8158318ba20d059276c7aa0c455bdba3937582160a0b8"

PHP CONVERSION into HASH SHA2 Type of SHA384

<?php hash( 'sha256', '789889 ); ?>

List of universal HASH types for your references and MD5 is most common used - which can be easily DECODE by hash machines in seconds.

Array ( [0] => md2 [1] => md4 [2] => md5 [3] => sha1 [4] => sha224 [5] => sha256 [6] => sha384 [7] => sha512 [8] => ripemd128 [9] => ripemd160 [10] => ripemd256 [11] => ripemd320 [12] => whirlpool [13] => tiger128,3 [14] => tiger160,3 [15] => tiger192,3 [16] => tiger128,4 [17] => tiger160,4 [18] => tiger192,4 [19] => snefru [20] => snefru256 [21] => gost [22] => gost-crypto [23] => adler32 [24] => crc32 [25] => crc32b [26] => fnv132 [27] => fnv1a32 [28] => fnv164 [29] => fnv1a64 [30] => joaat [31] => haval128,3 [32] => haval160,3 [33] => haval192,3 [34] => haval224,3 [35] => haval256,3 [36] => haval128,4 [37] => haval160,4 [38] => haval192,4 [39] => haval224,4 [40] => haval256,4 [41] => haval128,5 [42] => haval160,5 [43] => haval192,5 [44] => haval224,5 [45] => haval256,5

Cordova Screen Orientation Portrait - Solved

Cordova Screen Orientation Portrait in INDEX.JS inside "onDeviceReady: function()" onDeviceReady: function() { this.receivedEvent('deviceready'); screen.orientation.lock('portrait'); },