Many times we want to block IP Address so particular machine is not able to access website/blog again.
People may be hackers,enemies,Invalid clickers or may be another.Below is guide to block IP address from website.
Login to Cpanel Account
Almost all Hosting providers offers you cPanel.Login to your cPanel,for my example I use BlueHost here.
- Go to Security
- Go to IP Deny Manager
Here,you wil find different options
- Single IP Address (Recommended) – You can block particular IP Address.
- Range – As network IP Address changes dynamically,you can deny particular range of IP Address.
- Implied Range – similar kind of Range option.
- CIDR Format – Classless Inter-Domain Routing (CIDR) range allows to block associated routing prefix.Here more about CIDR Wikipedia.
- Implies range will block IP address staring from 10.**
You can also unblock if you wish & list of all IP address from same.Check blow image.
Here I block an IP address.Remember denying IP address from cPanel will block through all websites that you host on your account.
In next post,I will discuss about how to find recent IP address who visit your website/blog.Keep visiting & sharing articles.
If you know any other methods to block IP Address from accessing website.Please tell me and readers by commenting below.
As a good programmer,you need to use many Date functions in SQL Server.I share here most used Date functions of SQL Server which will do different functionality according to its needs. GETDATE() You can easily retrieve current Date Time in SQL Server using GETDATE() function. Query : select GETDATE() CONVERT() Many times,We want to convert Date Format [...] Continue Reading →
A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.(Source: MSDN).To create stored procedure in SQL Server,Go to Database ->Programmability->Stored Procedures.Click right click and click on New Stored Procedure.It will create a new Query Window for you. You will get above image script in your SQL Server.In this script,you have to [...] Continue Reading →
Sometimes we need to insert – save multiple checked checkbox values in SQL Server.For that we can use Split function. Split function of SQL Server is not in-built function,We have to add it manually in our Table-valued function as you can see in below image. Split function in SQL Server Below you can find query [...] Continue Reading →
Many times,We want to covert rows of SQL table into comma separated string which works as value.You can get comma separated values in SQL Server using COALESCE function or without it. I hope you have created table,otherwise in my example check Case Statement in SQL Server for to create & insert scripts for Product Table. After creating Product [...] Continue Reading →
In this SQL tutorial,I will explain about How to update multiple rows in SQL Server with single SQL query? Before you read this article.You should have knowledge of Case statement.I wrote about How to use Case statement in my previous post. Check Case statement in SQL If you also want to make tutorial on your localhost,You [...] Continue Reading →
Case When statement in SQL server is very much similar like switch case statement in C.Below is SQL Case When statement syntax. Simple CASE statement in SQL
WHEN when_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
To understand Case expression in SQL,here is example of Case statement .First of I create table of product.It contains ProductId(Auto increment,Primary key),ProductName,Price,Availability columns. You can use below script [...] Continue Reading →
This is first SQL Tutorial from WebTechMiner.Many times you want to find duplicate records in table in SQL due to some human errors or some another issues. Now start with table creation “How to find duplicate records in SQL Server” tutorial.! I create table “user “with Id(Auto Increment,Primary key),UserId,EMail columns.You can find below script to [...] Continue Reading →
WordPress is the easiest method to create Websites.Due to large number of free & premium WordPress Themes available across internet.Thus WordPress is becoming more & more popular over years.Here,I share best Top 10 WordPress Business Themes with you.! Your business website is your business’ identity.When anyone knows about you or your business,People will definitely come to visit [...] Continue Reading →
What is Captcha Code? Captcha code is a type of challenge to users who submits form on your website or in your blog. Captcha code is usually images in awkward font family or italic.Recently lots of people using some logical equations like 5+2?. Why do we need Captcha? Captcha code is used to prevent spam comments from automated software [...] Continue Reading →