Member Avatar for bhuvan83

is there any way through which we can generate reports in mysql.
not using any s/w but coding.
if yes plz tell me
Thanks

  • 2 Contributors
  • 3 Replies
  • 88 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jbennet
Member Avatar for jbennet

you can do it in php . Here is the code i use to show a report of all the people whose email adresses and names i have in my database

<html>
<head>
<title>Test MYSQL PHP Page</title>
</head>
<body>
<?php
include("dbinfo.inc.php");
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><u><center>Database Output</center></u></b><br>";
echo "<hr>";
$i=0;
while ($i < $num) {
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$email=mysql_result($result,$i,"email");
echo "<b>$first $last</b><br>$email<br><hr><br>";
$i++;
}
?>
<p>
<center><a href="/index.php">Return to main page</a></center>
</p>
</body>
</html>

dbinfo.inc should contain something like:

<?php
$user="root";
$password="letmein";
$database="mydatabase";
?>
Member Avatar for bhuvan83

thanks for the info bro.
any way to do it in jsp?????

Member Avatar for jbennet

yes there is but thats not my speciality, sorry

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.