Home / mySQL (page 3)

mySQL

Secure Login page using PHP and MYSQL based on user role

Hi Guys, Here I explain how to develope secure login page based on user role like different types of user using PHP. First you create the registration form. After register your name into database then we can develope login page with PHP and MYSQL. You have created your registration.php page …

Read More »

Nested or Sub-queries Practice Questions with Answers

Hi Guys, Today we discuss mysql sub-queries questions with answers. Sql queries are useful and used in web application development connected with database tables. We can fetch the data from database, insert the data to database, update the existing data in a database table and also delete the data or …

Read More »

How to access database like MySQL using PHP

In this article shows PHP functions are available to connect to a MySQL database PHP Data Object (PDO) and odbc_connect function. PHP has a rich collection of built in functions for manipulating MySQL databases. The mysqli_connect function is used to connect to a MySQL database server. [crayon-614457e56d92f406966431/] OR [crayon-614457e56d935344071645/] Code …

Read More »

Difference Between Left Join and Inner Join

Hi all, What’s is the bifference betweeen left join and inner join. In this tutorial I will explain inner join and left join.First we discuss why we use join or what are the purpose of join in MYSQL. Why we use Join ? The main purpose of SQL joins are, …

Read More »

WordPress Database Backup Manually

Hi all, The wordpress database backup manually without using wordpress plugin is very simple, easy to undestand and useful to web developers. Do you want know how to develope or making this operation? . Knowing the manual method allows you to quickly create a database backup whenever you need it. …

Read More »

Difference Between mysql and mysqli

Hi all, Yesterday I attend the telephonic interview to web development post. The interviewer ask somany questions related to PHP, MYSQL, WordPress, JavaScript, jQuery etc. Almost every questions I answerd. But the interviewer ask one important question What is the Difference Between mysql and mysqli. I can’t give the correct …

Read More »

Multiple WordPress Installation Using a Single Database

Hi all, Here I explain how to install multiple wordpress in a single database. If you want multiple sites, multiple theme in one database. You must install WordPress manually in order for this to work. Most one click programs like Fantastic would not let you choose the prefix. Multiple Blogs …

Read More »

An Introduction to SQL Data Types – PostgreSQL

Hi Friends, Everybody know that SQL is a structured Query Language is a computer language. It is used for storing, manipulating and retrieving data stored in relational databases. This article give you a basic idea about data types in PostgreSQL. SQL support standard language for relational database system. The all …

Read More »

How to copy one table data into another table using Mysql Query?

Hi friends, Today I’m going to tell you “how to copy table values from one database table values to another database table using MYSQL.” We can easly copy the one table values to another table in same database. This is easy and this purpose is used in allproject. But in …

Read More »