Posted By

conspirator on 10/10/08

Tagged

php
textmate

Versions (?)

Last Edited at 10/10/08 07:45am

Statistics

Viewed 1046 times

Favorited by 0 user(s)

Related snippets

Get DB data using PHP

/ Published in: Other

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
// Establish database connection
$db_host = 'localhost';
$db_name = 'DB NAME';
$db_user = 'YOUR USER NAME';
$db_pass = 'YOUR PASSWORD';
$db_table = 'DB TABLE';
 
// Connect to database
$link = mysql_connect($db_host, $db_user, $db_pass);
$db = mysql_select_db($db_name);
 
// Generate SELECT query
$sql = "SELECT date_saved, atm, access, loan, checking, online, advantage, contact_name, contact_email, contact_zip FROM quiz_responses ORDER BY date_saved DESC";
 
$result = mysql_query($sql, $link);
 
// Loop through the results/rows
if ($result) {
 
	echo "<table id='quiz_responses' cellspacing='0' cellpadding='3' border='0'>n"; // Open a table
		echo "<thead>n<tr>n";
		echo "<th>Date Saved</th>";
		echo "<th>Contact Name</th>";
		echo "<th>Contact Email</th>";
		echo "<th>Contact Zip</th>";
 
		echo "<th>ATM Response</th>";
		echo "<th>Access Response</th>";
		echo "<th>Loan Response</th>";
		echo "<th>Checking Response</th>";
		echo "<th>Online Response</th>";
		echo "<th>Advantage Response</th>";
		echo "</tr>n</thead>n<tbody>";
 
	while($row = mysql_fetch_array($result)) { // Pull each row from the table
		echo "<tr>n";
		echo "<td>" . $row['date_saved'] . "</td>";
		echo "<td>" . $row['contact_name'] . "</td>";
		echo "<td>" . $row['contact_email'] . "</td>";
		echo "<td>" . $row['contact_zip'] . "</td>";
		echo "<td>" . $row['atm'] . "</td>";
 
		echo "<td>" . $row['atm'] . "</td>";
		echo "<td>" . $row['access'] . "</td>";
		echo "<td>" . $row['loan'] . "</td>";
		echo "<td>" . $row['checking'] . "</td>";
		echo "<td>" . $row['online'] . "</td>";
		echo "<td>" . $row['advantage'] . "</td>";
 
		echo "</tr>n";
	}
 
	echo "</tbody>n</table>"; // Close the table
 
 
} else {
 
	echo "No records were found. Perhaps the database is empty?";
 
}
 
?>