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
- 4604 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 |
How is session id stored in browser?
What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?
Write a php code which could be used to generate random numbers between 1 - 100 and display them on the screen.
What is cookie in php with example?
Swap two variables value without using third variable in php ?
Explain about a search-friendly site looks like?
How is a constant defined in a PHP script?
What is the scope of a variable defined in a function?
What are traits?
Whether php supports microsoft sql server?
what is abstrac class? why it is use?
What are the different ways we can retrive the mysql results using php ? Explain each
PHP 
