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
bhuvan83 0 Light Poster
jbennet 1,618 Most Valuable Poster Team Colleague Featured Poster
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";
?> bhuvan83 0 Light Poster
thanks for the info bro.
any way to do it in jsp?????
jbennet 1,618 Most Valuable Poster Team Colleague Featured Poster
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.