selecting all rows of a table using sql command
selecting-all-rows-of-a-table-using-sql-command.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>selecting all rows of a table using sql command</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Md Iqbal Hosan">
<meta name="title" content="selecting all rows of a table using sql command">
<meta name="keywords" content="php, example, code, table, sql command, sql, select all rows of a table">
<meta name="description" content="selecting all rows of a table using sql command">
<style>
h2, h4{background:#ddd; color:#000083;}
h2{ padding:3px; margin:3px; font-size:21px;}
h4{ padding:2px; margin:2px; font-size:18px;}
p{padding:2px; margin:2px; color:#0099Fd;}
body{ background:#FFFFFb;}
</style>
</head>
<body>
<h2>selecting all rows of a table using sql command</h2>
<pre>
<?php
/*
---------------------------------------------------------------------
WE WANT TO SELECT ALL ROWS OF TABLE departments BY USING SQL COMMAND
---------------------------------------------------------------------
*/
$sql = "SELECT * FROM departments";
/*
------------------------------------------------
YOU CAN SELECT DISTINCT ROWS USING SQL COMMAND
------------------------------------------------
*/
$sql = "SELECT DISTINCT * FROM departments";
/*
----------------------------------------------------
USING PHP YOU CAN DO THIS.
GET CONNECTION TO DATABASE BY USING : mysql_connect()
SELECT DATABASE BY USING : mysql_select_db()
THEN RUN THE QUERY
----------------------------------------------------
*/
mysql_connect('localhost', 'root', 'root');
mysql_select_db('hr');
mysql_query($sql);
/*
-----------------------------------------------------------------------------
TO RUN THE PHP CODE PROVIDE REAL DATA TO mysql_connect AND mysql_select_db()
-----------------------------------------------------------------------------
*/
?>
</pre>
</body>
</html>
selecting all rows of a table using sql command - output in the client
Dear Bhaia,
ReplyDeleteThanks for your such MySQL examples. My belief is that your codes/examples are so friendly/easy for all.
Bhaia, on this line....$sql = "SELECT DISTINCT * FROM departments"; I feel little problem. Here based on which I select DISTINCT?
It will be more helpful for me if you kindly answer this for me?
Thanks.
thnQ and follow http://php-example-code.blogspot.com/2010/06/mysql-distinct-example-select-distinct.html which is another example of distinct.
ReplyDelete