<html>
<head>
</head>
<body>
<table border="1">
<tr>
<th>Emails</th>
<th>Password</th>
</tr>
<?php
// Mysql settings
$dbserver = "localhost";
$user = "root";
$password = "password";
$database = "emails";
// connect to Mysql
mysql_connect($dbserver, $user, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
// query table & grab 10 random rows
$query = "SELECT * FROM accounts ORDER BY RAND() LIMIT 10";
$result = mysql_query($query) or die(mysql_error());
// loop through array
while($row = mysql_fetch_array($result)){
// start new row of table
echo "<tr>";
// start new column of current row
echo "<td>".$row['email']."</td>";
echo "<td>".$row['pass']."</td>";
// end row
echo "</tr>";
}
// close Mysql
mysql_close();
?>
</table>
<body>
</html><html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#submit").click(function() {
var dataString = '';
$.ajax({
type: "POST",
cache: false,
url: "sqltotable.php",
data: dataString,
success: function(data){
$("#table").html(data);
}
});
return false;
});
});
</script>
</head>
<body>
<form action="" method="post" onsubmit="">
<input id="submit" type="submit" value="Submit" />
</form>
<p></p>
<div id="table"></div>
</body>
</html><table border="1">
<tr>
<th>Emails</th>
<th>Password</th>
</tr>
<?php
// Mysql settings
$dbserver = "localhost";
$user = "root";
$password = "password";
$database = "emails";
// connect to Mysql
mysql_connect($dbserver, $user, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
// query table & grab 10 random rows
$query = "SELECT * FROM accounts ORDER BY RAND() LIMIT 10";
$result = mysql_query($query) or die(mysql_error());
// loop through array
while($row = mysql_fetch_array($result)){
// start new row of table
echo "<tr>";
// start new column of current row
echo "<td>".$row['email']."</td>";
echo "<td>".$row['pass']."</td>";
// end row
echo "</tr>";
}
// close Mysql
mysql_close();
?>
</table>