Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysqlserver = localhost;
- $mysqluser = sadasdssad;
- $mysqlpassword = sdasdsadas;
- $connect = mysql_connect($mysqlserver, $mysqluser, $mysqlpassword);
- if (!$connect) {
- die(' A connection could not be established to the MYSQL server: ' . mysql_error());
- }
- mysql_select_db("harlexne_admin");
- $query = mysql_query("SELECT SteamID, Name, Banner, Length, Reason FROM bans");
- $result = $query;
- $fields_num = mysql_num_fields($result);
- echo "<h1>Currently Banned: </h1>";
- echo "<table border='1'><tr>";
- // printing table headers
- for($i=0; $i<$fields_num; $i++)
- {
- $field = mysql_fetch_field($result);
- echo "<td><b>{$field->name}</b></td>";
- }
- echo "</tr>\n";
- // printing table rows
- while($row = mysql_fetch_row($result))
- {
- echo "<tr>";
- // $row is array... foreach( .. ) puts every element
- // of $row to $cell variable
- foreach($row as $cell)
- echo "<td>$cell</td>";
- echo "</tr>\n";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement