MySQL Select Using PHP

MySQL Select Query Using PHP

The SELECT statement is used to display data from a table. To display all data from a table using select(*) statement and to display particular field's data use select filed1,filed2 at the place of (*).

Syntax

The SELECT statement is used to select data from one or more tables:

SELECT column_name(s) FROM table_name

Or we can use the * character to select ALL columns from a table:

SELECT * FROM table_name

MySQL functions used in select query:

• mysql_num_rows(mysql_result $result): returns number of rows.
• mysql_fetch_assoc(mysql_result $result): returns row as an associative array. Each key of the array represents the column name of the table. It returns NULL if there are no more rows.

PHP MySQL Select Query Example

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysql_connect($host,$user,$pass) or die(mysql_error());  
	if(!$conn){  
	  die("Could not connect:".mysql_connect_error());  
	}
	// select database 
	mysql_select_db($dbname,$conn);  
	$sql = "SELECT * FROM users";  
	$retval=mysql_query($sql);  
	  
	if(mysql_num_rows($retval) > 0){  
	 while($row = mysql_fetch_assoc($retval)){  
	    echo "EMP ID :$row['id']<br> ".  
	         "EMP NAME :$row['name']<br> ".  
	         "EMP SALARY : $row['salary']  <br> ".  
	         "--------------------------------<br>";  
	 } //end of while
	}else{  
		echo "0 results";  
	}  
	mysqli_close($conn);  
?>  

Output:

Connected successfully
User ID :1 
User Name: name1
User Salary: 90000 
--------------------------------
User ID :2
User Name: name2
User Salary: 50000 
--------------------------------
User ID :3 
User Name: name3
User Salary: 900000

Display the Records inside Table:

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysql_connect($host,$user,$pass) or die(mysql_error());  
	if(!$conn){  
	  die("Could not connect:".mysql_connect_error());  
	}
	// select database 
	mysql_select_db($dbname,$conn);  
	$sql = "SELECT * FROM users";  
	$retval=mysql_query($sql);  
	  
	if(mysql_num_rows($retval) > 0){  
		echo "<table border='1'>";
		echo "<tr><th>ID</th><th>Name</th><th>Salary</th></tr>";
		while($row= mysql_fetch_array($val))
		{
			echo "<tr>";	
			echo "<td>".$row['id']."</td>";
			echo "<td>".$row['name']."</td>";
			echo "<td>".$row['salary']."</td>";
			echo "</tr>";
		}		
		echo "</table>";
	}else{  
		echo "0 results";  
	}  
	mysql_close();  
?> 

Output:

Display Data with table: Users