How To Remove html tags from validation_errors() in Codeigniter Remove html tags from validation_errors() in Codeigniter Set the Opening tag and Closing Tags for …
Read MorePHP
Update Two Column Field By Splitting The VAlue from One Column in SQL.
Update Two Column Field By Splitting The Value from One Column in SQL. Here the split will be done depending on space in name. For …
Read MoreFinding Duplicates with SQL
Finding Duplicates with SQL:: SELECT `email`, COUNT(`email`) AS NumOccurrences FROM `user` GROUP BY `email` HAVING ( COUNT(`email`) > 1 )
Read MoreHow to split a single column values to multiple column values
How to split a single column values to multiple column values:: For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
Read MoreHow To Remove html tags from validation_errors() in Codeigniter
How To Remove html tags from validation_errors() in Codeigniter Remove html tags from validation_errors() in Codeigniter Set the Opening tag and Closing Tags for error …
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 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 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