Total members 11889 |It is currently Thu Mar 28, 2024 12:34 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





Listing all rows and fields in a table
Code:
<html>
<head>
<title>Listing all rows and fields in a table</title>
</head>
<body>
<?php
$user 
"user";
$pass "password";
$db "userdb";
$link =  mysql_connect"server"$user$pass );

if ( ! 
$link ){
    die( 
"Couldn't connect to MySQL" );
}

mysql_select_db$db$link ) or die ( "Couldn't open $db: ".mysql_error() );
$result mysql_query"SELECT * FROM Employee" );

$num_rows mysql_num_rows$result );
print 
"There are currently $num_rows rows in the table<P>";
print 
"<table border=1>\n";

while ( 
$a_row mysql_fetch_row$result ) ){
    print 
"<tr>\n";
    foreach ( 
$a_row as $field )
        print 
"\t<td>$field</td>\n";
    print 
"</tr>\n";
}

print 
"</table>\n";
mysql_close$link );
?>
</body>
</html>





_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : Listing All Rows and Fields in a Table
 Select odd rows from table     -  
 Multi colored table rows     -  
 different colors for table Even- Odd rows and Cells     -  
 How to save a search fields...in Struts2.0     -  
 listing tag usage     -  
 Clear specific form fields using JQuery     -  
 Listing the Contents of a Directory     -  
 Disable submit button until all form's fields are filled     -  
 Listing elements using list components in J2me     -  
 three rows frameset .     -  



Topic Tags

PHP Database
cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com