Web UI for PHP tables

The_Cowboy · February 03, 2022, 19:49

Howdy!

I was wondering if someone is interested in writing the "public display" of background PHP table which stores the Equalizer data, in the form accessible to web crowd, like so

https://www.geeksforgeeks.org/how-to-fetch-data-from-localserver-database-and-display-on-html-table-using-php/

All the relevant help shall be provided!

Absolute_Madness · February 04, 2022, 09:03

Do you have the data list ? or a database sample ?

The_Cowboy · February 04, 2022, 09:17

Good question!
Our ol' piggy has the relevant credentials of original database!!
Would you be kind enough to share it, or allow me to do so!!!

Or tonight, when I boot Linux on my system, I could share the database sample.

Piglet · February 04, 2022, 11:26

I'd rather not actually! I'll pm you

Absolute_Madness · February 04, 2022, 11:44

Quote from: Piglet on February 04, 2022, 11:26
I'd rather not actually! I'll pm you

just the database structure and few data would be enough

The_Cowboy · February 04, 2022, 12:32

Couldnt wait till night and my build farm is automated for now.
So here we go

Code Select


-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 04, 2022 at 01:27 PM
-- Server version: 10.4.20-MariaDB
-- PHP Version: 8.0.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `CowboysTestDatabase`
--

-- --------------------------------------------------------

--
-- Table structure for table `EQPlayerInformation`
--

CREATE TABLE `EQPlayerInformation` (
  `EQIdentifier` char(80) DEFAULT NULL,
  `Captures` float DEFAULT NULL,
  `Grabs` float DEFAULT NULL,
  `Covers` float DEFAULT NULL,
  `Seals` float DEFAULT NULL,
  `FlagKills` float DEFAULT NULL,
  `TeamKills` float DEFAULT NULL,
  `Points` float DEFAULT NULL,
  `TimePlayedMinutes` float DEFAULT NULL,
  `TimePlayedHours` float DEFAULT NULL,
  `Frags` float DEFAULT NULL,
  `Suicides` float DEFAULT NULL,
  `EQName` char(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `EQPlayerInformation`
--

INSERT INTO `EQPlayerInformation` (`EQIdentifier`, `Captures`, `Grabs`, `Covers`, `Seals`, `FlagKills`, `TeamKills`, `Points`, `TimePlayedMinutes`, `TimePlayedHours`, `Frags`, `Suicides`, `EQName`) VALUES
('Little_Johnny', 8, 46, 3, 0, 37, 0, 147, 145, 0, 94, 256, 'Johnny:_Sins_:Re'),
('Tamika', 0, 0, 0, 0, 7, 0, 37, 9, 0, 10, 4, 'Tamika'),
('Rae', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Rae'),
('Skakruk', 0, 7, 0, 0, 10, 0, 78, 27, 0, 17, 2, 'Skakruk'),
('Outlaw', 0, 6, 0, 0, 6, 0, 43, 11, 0, 7, 1, 'Outlaw'),
('Brock', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Brock'),
('Garrett', 0, 4, 0, 0, 2, 0, 16, 6, 0, 5, 1, 'Garrett'),
('Torch', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Torch'),
('Asp', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Asp'),
('Guardian', 0, 3, 2, 0, 0, 0, 7, 11, 0, 5, 2, 'Guardian'),
('Cyclops', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Cyclops'),
('Kane', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Kane'),
('Dominator', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Dominator'),
('Zarina', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Zarina'),
('Kraagesh', 4, 13, 0, 0, 2, 0, 78, 20, 0, 8, 2, 'Kraagesh'),
('Enigma', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Enigma'),
('Abaddon', 0, 4, 0, 0, 1, 0, 9, 11, 0, 1, 1, 'Abaddon'),
('Gaargod', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gaargod'),
('BlackJack', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'BlackJack'),
('Othello', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Othello'),
('Lauren', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Lauren'),
('Diva', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Diva'),
('Gorge', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gorge'),
('Ravage', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Ravage'),
('Aryss', 1, 4, 0, 0, 0, 0, 17, 11, 0, 4, 2, 'Aryss'),
('Mokara', 1, 5, 0, 0, 0, 0, 16, 9, 0, 1, 0, 'Mokara'),
('Satin', 0, 0, 0, 0, 4, 0, 24, 9, 0, 7, 0, 'Satin'),
('Corrosion', 1, 5, 2, 0, 0, 0, 24, 9, 0, 4, 0, 'Corrosion'),
('Baird', 0, 0, 0, 0, 1, 0, 6, 6, 0, 1, 0, 'Baird'),
('Azure', 2, 4, 1, 0, 2, 0, 55, 6, 0, 5, 0, 'Azure'),
('Harlequin', 1, 2, 2, 0, 0, 0, 23, 6, 0, 4, 0, 'Harlequin'),
('Domina', 0, 0, 0, 0, 4, 0, 25, 10, 0, 8, 0, 'Domina'),
('Selig', 0, 0, 0, 0, 6, 0, 30, 11, 0, 10, 1, 'Selig'),
('Syzygy', 1, 8, 1, 0, 0, 0, 22, 11, 0, 5, 0, 'Syzygy'),
('Divisor', 0, 0, 0, 1, 4, 0, 23, 11, 0, 8, 1, 'Divisor'),
('Matrix', 0, 7, 0, 0, 4, 0, 21, 11, 0, 4, 2, 'Matrix'),
('Gkublok', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gkublok'),
('Riker', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Riker'),
('Scarab', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Scarab'),
('Thorax', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Thorax'),
('Hyena', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Hyena'),
('Rylisa', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Rylisa'),
('Virus', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Virus'),
('Jakob', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Jakob'),
('Komek', 0, 1, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Komek'),
('Rapier', 0, 0, 0, 0, 7, 0, 50, 10, 0, 12, 1, 'Rapier'),
('Motig', 2, 6, 0, 0, 0, 0, 30, 11, 0, 0, 0, 'Motig'),
('Remus', 0, 0, 1, 0, 6, 0, 38, 11, 0, 10, 0, 'Remus');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `EQPlayerInformation`
--
ALTER TABLE `EQPlayerInformation`
  ADD UNIQUE KEY `EQIdentifier` (`EQIdentifier`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Everything above is my PC generated data from my local game sessions.

The_Cowboy · February 11, 2022, 22:36

Here comes the UI

Miasma Community

News:

Web UI for PHP tables

The_Cowboy

Absolute_Madness

The_Cowboy

Piglet

Absolute_Madness

The_Cowboy

The_Cowboy