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 returns row as an associative array, a numeric array, or both. This function returns FALSE if there are no more rows.

The basic syntax of the SELECT query can be given with:

SELECT column_name(s) FROM table_name

Basic Content

• mysql_connect() : Used to open connection in MySQL
• mysql_error() : this returns the text of the error message from previous MySQL operation and empty string if no error occurred.
• mysql_select_db() : Sets the current active database on the server which is associated with specified link identifier returned by mysql_connect().






• mysqli_query() : This sends a query to current active database on the server. It takes SQL query as parameter.
• mysqli_fetch_array():The mysqli_fetch_array() function fetches a result row as an associative array, a numeric array, or both.

Below is a simple example to fetch records from Employee_table table.

There are three steps in here. First create Employee_table in fetch_demo database. Second, insert the data to the Employee_table and last fetch the data from Employee_table.

Create Employee_table

CREATE TABLE Employee_table
(Employee_ID INTEGER PRIMARY KEY,
Employee_First_Name CHAR(200),
Employee_Last_Name CHAR(200),
Employee_Email_ID CHAR(100)
);

Insert the data to Employee_table

INSERT INTO Employee_table(Employee_ID,Employee_First_Name,Employee_Last_Name,Employee_Email_ID) VALUES (01, ‘Priya’, ‘Mary’,’priyamary@gmail.com’);
INSERT INTO Employee_table(Employee_ID,Employee_First_Name,Employee_Last_Name,Employee_Email_ID) VALUES (02, ‘Princy’, ‘Mary’,’princymary@gmail.com’);
INSERT INTO Employee_table(Employee_ID,Employee_First_Name,Employee_Last_Name,Employee_Email_ID) VALUES (03, ‘Preethi’, ‘Sunny’,’preethi_sunny@gmail.com’);
INSERT INTO Employee_table(Employee_ID,Employee_First_Name,Employee_Last_Name,Employee_Email_ID) VALUES (04, ‘Pritty’, ‘Mary’,’prittyamaryvarghese@gmail.com’);

Fetch the data from Employee_table

       0)
			{
				echo "";
				echo "";
                echo "";
                echo "";
                echo "";
                echo "";
				echo "";
				while($row = mysqli_fetch_array($result))
				{
					echo "";
					echo "";
					echo "";
					echo "";
					echo "";
					echo "";
				}
				echo "
Employee_ID
Employee_First_Name
Employee_Last_Name
Employee_Email_ID
" . $row['Employee_Id'] . "
" . $row['Employee_First_Name'] . "
" . $row['Employee_Last_Name'] . "
" . $row['Employee_Email_ID'] . "
";
			} 
			else
			{
				echo "No records matching your query were found.";
			}
		} 
		else
		{
			echo "ERROR: Could not able to execute $sql. " . mysqli_error($con);
		}
		mysqli_close($con);
     ?>

Fetch all the data from Employee_table. And display in table. Fetch the data out of the fetch_demo database.
There are several mathods are available in fetching data from MYSQL database. In above example mysql_fetch_array() function is used.

The Output like:

All the datas are fetched from table Employee_table. There are four fields are available, they are:Employee_ID,Employee_First_Name,Employee_Last_Name,Employee_Email_ID.
Fetched datas are displayed in table.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

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. There are two wildcards used in conjunction with the LIKE operator:

• The percent sign (%)- represents zero, one or more than one character.
• The underscore (_)-represents only one character

SQL LIKE SYNTAX

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

The Basic Syntax of % and _ is as follows:

SELECT FROM table_name
WHERE column LIKE ‘YYYY%’

or

SELECT FROM table_name
WHERE column LIKE ‘%YYYY’

or

SELECT FROM table_name
WHERE column LIKE ‘%YYYY%’

or

SELECT FROM table_name
WHERE column LIKE ‘YYYY_’

or

SELECT FROM table_name
WHERE column LIKE ‘_YYYY’

or

SELECT FROM table_name
WHERE column LIKE ‘_YYYY_’

You can combine N number of conditions using AND or OR operators. Here, YYYY could be any numeric or string value.

Here are number of examples showing WHERE part having different LIKE clause with ‘%’ and ‘_’ operators

Example of LIKE clause

Consider Employee table

Example 1: SELECT * from Employee where Name like ‘A%’;

The above query will return all records where Name starts with character ‘A’ from Employee table.

Example2: SELECT * from Employee where Name like ‘_d%’;

The above query will return all records from Employee table where Name contain ‘d’ as second character.

Example 3: SELECT * from Employee where Name like ‘%x’;

The above query will return all records from Employee table where Name contain ‘x’ as last character.

Example4: SELECT * from Employee where Name like ‘%d%’;

The above query will return all records from Employee table where Name contain ‘d’ as second character.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.