Font Awesome Icons not displaying

<FilesMatch "\.(ttf|otf|eot|woff)$">
  <IfModule mod_headers.c>
    Header set Access-Control-Allow-Origin "*"
  </IfModule>
</FilesMatch>

1

2

3

4

5

Header set Access-Control-Allow-Origin "*"

</IfModule>

</FilesMatch>

Posted in Php No comments June 3, 2017

Add Login Security

Functions

<?php
define("TIME_PERIOD", "30");
define("ATTEMPTS_NUMBER", "3");

function confirmIPAddress($value) {
// database connction
        $con = DBconnect();
  $query = "SELECT Attempts, (CASE when LastLogin is not NULL and DATE_ADD(LastLogin, INTERVAL ".TIME_PERIOD.
  " MINUTE)>NOW() then 1 else 0 end) as Denied FROM ".TABLE_LOGINATTEMPTS...

Posted in Php No comments May 16, 2017

Add Multiple Text Box with Ajax Autocomplete

HTML

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min...

Posted in Jquery, Php No comments May 8, 2017

Dropdown with search using jquery

Download

Posted in Jquery No comments May 5, 2017

How to run .htaccess file in wamp server

Click on Wamp icon and open Apache/httpd.conf and search “#LoadModule rewrite_module modules/mod_rewrite.so”. Remove # as below and save it

LoadModule rewrite_module modules/mod_rewrite.so

1	LoadModule rewrite_module modules/mod_rewrite.so

and restart all service.

Posted in Php No comments May 4, 2017

Change css base on attribute

$('span[attName=attData]').css('border','1px solid #d95c5c');

1	$('span[attName=attData]').css('border','1px solid #d95c5c');

Posted in CSS, Jquery No comments April 25, 2017

Detect some html modification

$("body").on('DOMSubtreeModified', "#selector", function() {
}

1 2	$("body").on('DOMSubtreeModified', "#selector", function() { }

Posted in Jquery No comments April 25, 2017

Get mysql data using lat long with some radius

SELECT
    *,
    ( 6371 * acos( cos( radians({$lat}) ) * cos( radians( `lat` ) ) * cos( radians( `lng` ) - radians({$lng}) ) + sin( radians({$lat}) ) * sin( radians( `lat` ) ) ) ) AS distance
FROM `positions`
HAVING distance <= {$radius}
ORDER BY distance ASC

1

2

3

4

5

6

SELECT

*,

( 6371 * acos( cos( radians({$lat}) ) * cos( radians( `lat` ) ) * cos( radians( `lng` ) - radians({$lng}) ) + sin( radians({$lat}) ) * sin( radians( `lat` ) ) ) ) AS distance

FROM `positions`

HAVING distance <= {$radius}

ORDER BY distance ASC

Posted in Php, Sql No comments April 21, 2017

phpmyadmin change uploading file size and execution time

Now you can go \wamp\alias\phpmyadmin.conf and edit this file.
it should look like this although your version of phpMyAdmin will probably be different

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"

# to give access to phpmyadmin from outside 
# replace the lines
#
# Require local
#
# by
#
# Require all granted
#

<Directory "c:/wamp/apps/phpmyadmin4.1.14/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
	  Deny from all
	  Allow from localhost ::1 127.0.0...

Posted in Php No comments February 14, 2017

WordPress Database Switcher

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

1

2

3

4

5

6

7

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(

Posted in Wordpress No comments November 16, 2016

Recent Posts

Functions

HTML