Interested to Buy Any Domain ? << Click Here >> for more details...
How to get tabels from database in php andd display it in
the table form using codelgniter?
plz help me
- 2 Answers
- 4807 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vivek soni
//HTML coding
<html>
<head>
<title>Table</title>
</head>
<body>
<div><?php include("table.php");?></div>
</body>
</html>
//include table.php contain....
<?php
include("inc_connection.php");
$sql="select * from tablename";
$rs=mysql_query($sql);
echo "<table border=1 width='100%'> ";
echo "<tr><td colspan='2' align='center'>Student
Name</td><td >phone No</td></tr>";
while($row=mysql_fetch_assoc($rs))
{
echo "<tr><td align='right'>".$row['fname']."</td><td
align='left'>".$row['lname']."</td><td>".$row['phn']."</td></tr>";
}
echo "</table>";
?>
| Is This Answer Correct ? | 2 Yes | 0 No |
require "config.php"; //for connection with database
$query2=" SELECT * FROM tablename";
$result2=mysql_query($query2);
echo mysql_error();
$nume=mysql_num_rows($result2);
$bgcolor="#f1f1f1";
echo "<TABLE width=50% align=center cellpadding=2
cellspacing=2> <tr>";
echo "<td bgcolor='dfdfdf' > <font
face='arial,verdana,helvetica'
color='#000000'>value1</font></td>";
echo "<td bgcolor='dfdfdf' > <font
face='arial,verdana,helvetica'
color='#000000'>value2</font></td>";
echo "<td bgcolor='dfdfdf' > <font
face='arial,verdana,helvetica'
color='#000000'>value3</font></td>";
echo "<td bgcolor='dfdfdf' > <font
face='arial,verdana,helvetica'
color='#000000'>value4</font></td>";
echo "<td bgcolor='dfdfdf'> <font
face='arial,verdana,helvetica'
color='#000000'>value5</font></td></tr>";
| Is This Answer Correct ? | 4 Yes | 5 No |
What is pdo classes?
What is a persistence cookie?
at present am learning lamp course sir ..i want to know the carrer prospectus in php ...is there any companies recruiting freshers in chennai ..for freshers how much can i demand as a fresher in php ....?i finished my mca ..please sugggest me to face interview in php asking salary details and all please suggest me how much can i ask as a fresher in php ? and also tel is there any openings in chennai for recruting php freshers send their emails and company info please ? please send ur valuable suggestions to kiranpulsar2007@gmail.com i hope u wil reply to my question thank u guys bye take care see u soon all the best to everyone
How can we know the number of days between two given dates using PHP? How can we know the number of days between two given dates using MySQL?
Is php a backend?
Are parent constructors called implicitly inside a class constructor?
What is Gd PHP?
What is the substitution of submit in PHP?
What is the role of the .htaccess file in php?
How do you find the length of a string in php?
what is output of echo 1< 2 and echo 1 >2
8 Answers HCL, Navigators Software,
How can I get the only name of the current executing file?
PHP 
