How to remove sAntivirus | Segurazo Virus?

I have made this video "How to remove sAntivirus" only because I have troubled with this unwanted software and thought that if same type of problem arises for others then they can get help with this video as well as my blog. SAntivirus software or threat comes automatically in my laptop or it may come from other software installation from website or it may come any browser when installing extra browser plugins or browser extensions. There may be any reasons to come this virus as I was not aware of this..

Read More.. Share

How to backup databases in SQL server | cloud backup

To back up the database regularly is the most important part of any business or company. Not only the IT person, common employee should know the process of backup of SQL Server. This is very simple and easy to understand. I have made this video 'How to backup databases in SQL server' through Microsoft Visual Studio for those people who doesn't know how to do this. In information technology, a backup, or data backup is a copy of computer data taken and stored elsewhere so that it may be used to restore the original after a data loss event.

Read More.. Share

How to create a google account - what is gmail?

I have made this video "How to create a google account" for the youtube viewers and for those who does not know how to create a new google account. This is very basic introduction for the beginners. First open google chrome and search for as 'create google account' and then open the first link https://account.google.com then you will ask for your details to input like your first name, your last name, gmail id, password and confirm password and your phone number. So, input all the information correctly then click next and accept the agreement..

Read More.. Share

How to use google drive

I have made this video "How to use google drive" completely for beginners not for them those who is already known this. So, what is google drive? It is app of the Google. It is an online google drive where you can store your important and secure files and folders and other important tools. You can upload/download your important data into google drive from your computer / pc / laptop / mobile even from other devices also. You can make google documents, google sheets, google slides and even more than that. After that you can share those created files and folders to your friends and colleges by separately or you can share in groups.

Read More.. Share

Date Format in PHP MySql MSSQL JQuery

Date format sometimes is a problem for the developers. When you pickup the date as dd/mm/yyyy format from web page and want to store in the Microsoft SQL server that has a field datatype date or datetime or datetime2 then it takes the date value as yyyy-mm-dd format. In this case I faced a problem means an error message showing [see the screenshot]. Then I have used CONVERT function, Cast function even DATE_FORMAT function but the date inserted into the database like 1970-01-01 every time. Front-end is PHP-JQuery and Back-end is MS SQL Server 2014.

Read More.. Share

how to create a basic cms system

This is very basic blogging system with cms admin panel. Mainly html5, php and mysql is used. Here you can get a very basic idea of a CMS admin panel, front website and also get an idea how to post a blog or comment online. Please not that this version is very old and was created in the year 2003/2004 and design was purely based on html and css with core php. Here no bootsmap framework had been used. Now a days a lot of advanced versions have come out.

Read More.. Share

how to remove Index.php from iis windows server urls

For the sample application, the relevant mod_rewrite rules in the .htaccess file are:

RewriteCond %{HTTP_HOST} ^example\.com$ [NC]

RewriteRule ^(.*)$ http://www.example.com/$1 [L,R=301]

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]

Read More.. Share

Best Municipal Software in West Bengal of India | Free Demo & Pricing - Asenwebmedia.biz

Best Municipal Software for Local Government or Government Agencies

Finding the best Municipal Software for your organization is now faster and easier! Compare reviews, features, and get free demo and consultation to find the perfect and Best Municipal Software for Local Government.


How can a Municipal Software help in Keeping a Track of the Things

Local government organizations use municipal software to perform a variety of services regarding financial, administrative and other responsibilities for the local public.

Read More.. Share

Selecting/casting output as integer in MySQL

Say, you have created a table asen_role_master with the field role_cd. The field role_cd takes only integer value. Now you want to get the maximum number with the MySql statement. So, for this you need to use cast as unsigned in your select statement. And will work perfectly.

Read More.. Share

how to remove unique key in mysql

If you need to remove an unique key from my mysql table. How can you remove that using mysql query? There are two methods to remove index in mysql.  One is MySql Query and another is GUI. Second Method to remove using MySql GUI (phpMyAdmin): In this method you have to open GUI interface of MYSQL and then go to that database and then go to that particular table in which you want to remove index. After that click on the structure option, Then you can see table structure and below you can see table indexes. You can remove indexes by clicking on drop option.


Read More.. Share

how to add unique key in mysql

If you need to add a unique key from mysql table. How can you add that using mysql query? There are two methods to add index in mysql.  One is MySql Query and another is GUI.  First Method to add using MySql Query: To add a unique key use : alter table your_table add UNIQUE(target_column_name); To add multiple column for a unique key use: ALTER TABLE ADD UNIQUE( column_name1, column_name2, column_name3); 

In this method you have to open GUI interface of MYSQL and then go to that database and then go to that particular table in which you want to add index.First you need to select one column or you can select multiple columns as required and then click on index option (here unique). That's all.

Read More.. Share

List of Categories

  • 5 Internet Basics
  • 14 PHP & MySql
  • 7 PHP & MSSQL SERVER
  • 2 How to trade in stock market