Split value from one field to two using Mysql For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq asd j. …
Read MoreFinding Duplicates with SQL
#Finding Duplicates with SQL:: SELECT `email`, COUNT(`email`) AS NumOccurrences FROM `user` GROUP BY `email` HAVING ( COUNT(`email`) > 1 ) For Single Occurance Use:: SELECT …
Read MoreHow to prevent duplicate usernames when people register? PHP/MySQL
$connect = mysql_connect(‘whatever’,’whatever’,’whatever’); $database = mysql_select_db(‘your dbname’); $username = $_POST[‘username’]; if(isset($username)){ $mysql_get_users = mysql_query(“SELECT * FROM table_name where username=’$username'”); $get_rows = mysql_affected_rows($connect); if($get_rows >=1){ echo …
Read MoreSet auto height and width in CSS/HTML for different screen sizes
#Set auto height and width in CSS/HTML for different screen sizes Larger Device, Medium Devices & Small Devices media queries. (Work in my Scenarios.) Below …
Read MoreHow to auto adjust the div size for all mobile / tablet display formats?
This is called Responsive Web Development(RWD). To make page responsive to all device we need to use some basic fundamental such as:- 1. Set the …
Read MorePageSpeed: Leverage browser caching
PageSpeed: Leverage browser caching Find your .htaccess file in the root of your domain. This file is a hidden file but should show up in …
Read MoreMeta tags for social share links or images
Facebook Meta Tags <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ > <title></title> <meta name=”viewport” content=”width=device-width, initial-scale=1″> <meta name=”keywords” content=”” > <meta name=”description” content=””> <!–FACEBOOK–> <meta property=”og:title” content=”” > …
Read MoreFacebook share link with more than one image
Facebook share link with more than one image <meta property=”og:image” content=”https://images-na.ssl-images-amazon.com/images/I/41LH4pXAe6L.jkhjk000_.jpg” /> <meta property=”og:image” content=”https://images-na.ssl-images-amazon.com/images/I/41LH4pXAe6L.jkhjk000_.jpg” /> <meta property=”og:image” content=”https://images-na.ssl-images-amazon.com/images/I/41LH4pXAe6L.jkhjk000_.jpg” />
Read MorePhp- Star rating
<?php for ($rcnt=0; $rcnt<$product_rating; $rcnt++) { ?> <i class=”fa fa-star has-star” aria-hidden=”true”></i> <?php } for($star_blank=0; $star_blank < (5-$product_rating); $star_blank++){ ?> <i class=”fa fa-star-o” aria-hidden=”true”></i> <?php …
Read MoreHow can I show dots (“…”) in a span with hidden overflow?
How can I show dots (“…”) in a div with hidden overflow? ._shr_name{ display:inline-block; width:180px; white-space: nowrap; overflow:hidden …
Read More