Home / 2015 / December

Monthly Archives: December 2015

WordPress Redirect Https To Http With Htaccess

Hi all, Nobody know how to redirect a https: request to http:// using .htaccess in wordpress, today I share some information related to this problem. You can redirect all website pages from https to http. It will be redirect only when you open the page with https. First write your …

Read More »

Fetch MYSQL table data – PHP

Welcome to all, Here we discuss one useful topic related to MYSQL,fetch the data from data base in MySQL using PHP. From the MYSQL database the data can be fetched by executing SQL SELECT statement through PHP function mysql_query. The mysqli_fetch_array() or mysql_fetch_array() function is most frequently option. This function …

Read More »

mysql_connect() and mysql_pconnect()

Hi all, Nobody knows what are the main differnce between MYSQL_CONNECT() and MYSQL_PCONNECT(). MYSQL_CONNECT() and MYSQL_PCONNECT() are working for database connection. But these two have some little diffrence. In mysql_pconnect(), ā€˜pā€™ stands for persistance connection. The mysqli_connect() function opens a new connection to the MySQL server. Every time it is …

Read More »

SQL LIKE Operator

Good morning to all, Welcome to SQL commnands, queries, operators etc. Now we are discuss the SQL LIKE operator. The LIKE operators used to fetch the data from database foor specific pattern. The LIKE operator is used to search for a specified pattern in a column used in WHERE clause. …

Read More »

Save the particular div in PDF format onclick – Jquery

Here I’m going to discuss about how to save or download the particular div as in the PDF format onclick using jsPDF jquery file. This is very simple and most interesting useful tutorial I already showed you one tutorial to Save the HTML or PHP webpage as PDF using JAVASCRIPT …

Read More »

Retype password Validation – Javascript

Hi Guys, Here I explain, how to check Password and Confirm Password validation for Password TextBox using pur javascript method with demo. The Password and Confirm password are in textboxes. And these are compared using JavaScript and if the values do not match an error message will occur like password …

Read More »

Reset Auto-Increment – MySQL

Good morning to all, Here I going to demonstrate how to reset auto-increment value in MySql. Assign to auto-increment attributes to a column of a table, to generate unique identity for the new row. If new row is inserted it incrementsthe value one. Whenever you insert a new row into …

Read More »

SQL JOINS

Hi all, The SQL joins are used for combine rows from two or more table based on a common field between them.We are discuss this topic today. It fetch data from two or more tables and which is joined to appear as single set of data. Join Keyword is used …

Read More »

Truncate, Drop and Rename a Table- SQL

Hi all, Here I share some useful information in sql queries like truncate command, drop command alter command. These is more helpful in MYSQL operations. For delete complete data from an existing table using TRUNCATE command. And also delete the data inside the table. For delete a table using DROP …

Read More »
Social Media Auto Publish Powered By : XYZScripts.com