[Tool/Web/Other] PHP/CSS/SQL/: Server Logging Display Table - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Tools and Files (https://sampforum.blast.hk/forumdisplay.php?fid=82)
+---- Thread: [Tool/Web/Other] PHP/CSS/SQL/: Server Logging Display Table (/showthread.php?tid=642590)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Tools and Files (https://sampforum.blast.hk/forumdisplay.php?fid=82)
+---- Thread: [Tool/Web/Other] PHP/CSS/SQL/: Server Logging Display Table (/showthread.php?tid=642590)
PHP/CSS/SQL: Server Logging Display Table - vHero - 02.10.2017
Hello, I'm here to introduce a simple PHP/CSS/SQL script that will allow you to display your Servers MYSQL tables on your website. This script can display any SQL table information, whether it's your Servers Command Logs, or just anything that uses MYSQL Tables. You may use this on your website as a .php file, or a custom forum page. I manually edited this table with CSS.
- Note: Your Gamemode would need to run on MYSQL database for this to work on it.
Example of how the code can be modified:
Optional: You can remove the border-width:1px; and the border-color:grey or change the colors to suit your needs.
I'll try my best to provide support here when possible.
Optional: You can remove the border-width:1px; and the border-color:grey or change the colors to suit your needs.
PHP Code:
<?php
//Step1
$db = mysqli_connect('DATABASE_HOST','DATABASE_USER','DATABASE_PASSWORD','DATABASE_NAME')
or die('Error connecting to MySQL server.');
?>
<?php
//Step2
$query = "SELECT * FROM `TABLE_NAME` ORDER BY `COLUMN_NAME`.`COLUMN_NAME` DESC";
mysqli_query($db, $query) or die('Error querying database.');
//Step3
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
//Step4
echo "<center><style type=\"text/css\">";
echo ".tg {border-collapse:collapse;border-spacing:0;border-color:#fff;}";
echo ".tg td{font-family:Arial, sans-serif;font-size:14px;padding:17px 10px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:grey;color:#fff;background-color:black;}";
echo ".tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:grey;color:#fff;background-color:black;}";
echo ".tg .tg-baqh{text-align:center;vertical-align:top}";
echo "</center></style>
<table class=\"tg\">";
//Step5 - opening table tag
echo '<th class=\"tg-baqh\"><center>Column_Name1</center></th><th class=\"tg-baqh\"><center>Column_Name2</center></th></th><th class=\"tg-baqh\"><center>Column_Name3</center></th><th class=\"tg-baqh\"><center>Column_Name4</center></th>';
//table headers
while ($row = mysqli_fetch_array($result)) {
// we are running a while loop to print all the rows in a table
echo'<tr>'; // printing table row
//Step6
echo '<td><center>' . $row['Column_Name1'] . '</center></td><td><center>' . $row['Column_Name2'] . '</center></td><td><center>' . $row['Column_Name3'] . '</center></td><td><center>' . $row['Column_Name4'] .'</center></td>';
// we are looping all data to be printed till last row in the table
echo'</tr>'; // closing table row
}
echo '</table>'; //closing table tag
?>
Re: PHP/CSS/SQL/: Server Logging Display Table - whadez - 02.10.2017
I dont mean to be rude but this is the most useless thing I've ever encountered on this forum.
Hopefully your server wont contain such useless stuffs!
Re: PHP/CSS/SQL/: Server Logging Display Table - vHero - 03.10.2017
Quote:
|
Originally Posted by whadez
 I dont mean to be rude but this is the most useless thing I've ever encountered on this forum.
Hopefully your server wont contain such useless stuffs! |
It's a topic that some people could find of use, but thank you for your disturbing criticism.
Re: PHP/CSS/SQL/: Server Logging Display Table - SchurmanCQC - 03.10.2017
Quote:
|
Originally Posted by whadez
I dont mean to be rude but this is the most useless thing I've ever encountered on this forum.
Hopefully your server wont contain such useless stuffs! |
This is really useful. Get off your high horse.
Re: PHP/CSS/SQL/: Server Logging Display Table - vHero - 03.10.2017
Quote:
|
Originally Posted by SchurmanCQC
Seriously?
This is really useful. Get off your high horse. |