Databases| SQL| MySQL| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials:
 

Software Solutions and Services
 

 
  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet
Questions
Comments
 
Mysql PHP Select 
 

Mysql PHP is used to execute the select statement using mysql_query ( ) function.

 

Mysql PHP Select

                         

Mysql PHP is used to execute the select statement using mysql_query ( ) function. The function send a query or command to a MySQL connection.

Understand with Example

The Tutorial illustrate an example from 'Mysql PHP Select'. To understand and elaborate example we create a table 'MyTable' that has the required fieldnames and datatypes respectively.

Query for creating table named MyTable :

The Query insert into is used to add the records or rows to the table 'MyTable'. 

 

mysql> CREATE TABLE MyTable (
    ->              Empid int(10),
    ->              Empname varchar(60)
    ->              Salary int(90)
    ->            );
Query OK, 0 rows affected (0.13 sec)

Query for inserting data in table:

The Query insert into is used to add the records or rows to the table 'MyTable'.

mysql>   insert into MyTable values(01,'Girish','20000');
Query OK, 1 row affected (0.02 sec)
mysql>     insert into MyTable values(02,'A','21000');
Query OK, 1 row affected (0.01 sec)
mysql>     insert into MyTable values(03,'C','22000');
Query OK, 1 row affected (0.00 sec)
mysql>     insert into MyTable values(04,'V','23000');
Query OK, 1 row affected (0.00 sec)
mysql>     insert into MyTable values(05,'B','24000');
Query OK, 1 row affected (0.00 sec)
mysql>     insert into MyTable values(06,'E','25000');
Query OK, 1 row affected (0.00 sec)
mysql>     insert into MyTable values(07,'Q','26000');
Query OK, 1 row affected (0.01 sec)
mysql>     insert into MyTable values(08,'W','27000');
Query OK, 1 row affected (0.01 sec)
mysql>     insert into MyTable values(09,'AS','28000');
Query OK, 1 row affected (0.00 sec)`

Query to view data inserted in table:

mysql> select * from mytable;
+-------+---------+--------+
| Empid | Empname | Salary |
+-------+---------+--------+
| 1     | Girish  | 20000  |
| 2     | A       | 21000  |
| 3     | C       | 22000  |
| 4     | V       | 23000  |
| 5     | B       | 24000  |
| 6     | E       | 25000  |
| 7     | Q       | 26000  |
| 8     | W       | 27000  |
| 9     | AS      | 28000  |
+-------+---------+--------+
9 rows in set (0.01 sec)

Viewing table data using php select:

To view the table data using php,  you need to connect with database to access the records. The mysql _connect function ( ) is used to connect the database. As your connection is built, you can retrieve the records from table 'mytable' using select query. Now we make use of mysql_fetch_array ( ) function to return the first row from the recordset of an array. Each call make to mysql_fetch_array ( ) returns you the next rows in the recordset. The While loop iterate through all the records in a data. The PHP $ROW variable is used to print the value of each row from a table.

<?php
$database="girish";
$user="root";
$password="root";
$host="192.168.10.126";

$link= mysql_connect($host,$user,$password) or die("Could not connect: ".mysql_error());
mysql_select_db($database,$link) or die("Error in selecting the database:".mysql_error());
$sql="Select * from mytable";
$sql_result=mysql_query($sql,$link) or exit("Sql Error".mysql_error());
$sql_num=mysql_num_rows($sql_result);
echo "<table border=\"1\" bgcolor=\"#CCCCFF\" >";
echo "<tr><td><b>Empid</b></td><td><b>Empname</b></td><td><b>Salary</b></td>" ;
while($sql_row=mysql_fetch_array($sql_result))
{
	$Empid=$sql_row["Empid"];
	$Empname=$sql_row["Empname"];
	$Salary=$sql_row["Salary"];
	echo "<tr>";
	echo "<td>".$Empid."</td>";
	echo "<td>".$Empname."</td>";
	echo "<td>".$Salary."</td>";
	echo "</tr>";
}	
	echo "</table>";
?>

Output:-

 

                         

» View all related tutorials
Related Tags: php sql mysql c table data ui insert datatypes types type tutorial field name using ria create tab ie example

Leave your comment:

Name:

Email:

URL:

Title:

Comments:


Enter Code:

Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Website Designing Services
 
Web Designing Packages From $150!
 
Website Designing Company Web Hosting
 
Website Designing Quotation
 
Search Tutorials:

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.