Ponk Room Database

Using MariaDB and SQL to make and display a simple table

Here's a basic example of a customer or membership database. None of the data is real - it is all made-up. This page was made using MariaDB 10, PHP 7.4 and Apache 2.2 . phpMyAdmin was used to set up the empty database.

You can click on the blue column headings to change the sort order for that column

I stumbled a little when doing this. I could not get the database connection to work. phpinfo() showed that PDO and mySQLi were not part of the PHP installation. After a day of faffing around I found the answer - you can edit php.ini, like this:

*Open Web Station
*Click on PHP settings
*Click on the version of PHP you are using - the Edit tab at the top of the page becoms active
*Click the Edit tab
*You are shown the "Default Server Settings". This includes PFO / mySQLi
*Clicking "Core" shows you just about everything else you will need to change,

A number of people on the forum seem to be having this problem, and there are some complicated solutions proffered. If only Synology could put just a little hint in the Manual it would make all the difference.

One other thing - you must declare the port number as 3307 when connecting to MariaDB. If you are using local host then you'll have to define something like
DB_HOST = localhost:3307

Title Surname First Name Street Town County Post Code
MrTaylorJohn34 High Grove CrescentFarehamHantsPO98 5TY
MrWilliamsPeter23 Shore RoadSouthamptonHantsSO98 5TH
MrSmithArthur57a Derby RoadPortsmouthHantsPO96 G67
MrWatsonWilliam125 Botley AvenueBournemouthDorsetBO89 5TY
MrJonesKeith8 Garden Walk CrescentWickhamHantsSO93 8GH
MrHaynesDennis24 Cutter CloseWarsashHantsSO88 7JK
MrAshcroftAlan93 The AvenueBursledonHantsSO88 2RT
MrRobertsGeorge25 Copper CrescentFarehamHantsPO91 4FG
MrGascoigneCyril127 Cranberry WayWinchesterHantsWI88 5BN
MrStuartVictor7 Ford RoadChichesterSussexCH88 4FG
MrSeagerNorman12 Albert SquareHavantHantsPO92 9QW
MrMullinsOscar56 Kingston TerraceWinchesterHantsWI89 3GG
MrBlairMaxton58 Wadhams WayFarehamHantsPO90 4BN
MrKennedyTony467 Grange TerraceSouthamptonHantsSO92 2DG
MrTaylorRupert2 Summers RoadBishops WalthamHantsSO93 8GH
MrJonesDavid64 Railway CuttingsWickhamHantsSO98 2FG
MrThompsonKeith44 Florins RoadBotleyHantsSO98 2KK
MrToynbeeTerry45 Templecombe TerraceBotleyHantsSO98 2JJ
MrDimblebySamuel2 The ParadeSouthamptonHantsSO97 2FG
MrSomersKenneth87 Harvest AvenueLavantSussexCH88 6TY
MrMcIntyreGreg45 Tampion TerracePortsmouthHantsPO80 3ER
MrsBamfordSylvia567 Long AvenuePortsmouthHantsPO99 3ER
MrBroughSimon89 Crescent CottagesSouthamptonHantsSO99 4RT
MrJohnsonWayne15 Blueberry HillSouthamptonHantsSO98 6YU
MrLeachRoger44 Williams StreetWinchesterHantsWI88 2DF
MrCraickChristopher56 Dell ParkWinchesterHantsWI90 6BN
MrSibleyJames77 Sunset StripEastleighHantsSO95 7KL
MrRowntreeDaniel22 Ducks RoadEastleighHantsSO95 8EW
MrPenyardAndrew7 Beatle DriveFarehamHantsPO98 3DF
MrFullerArchie8 Mayflower ParkLee on the SolentHantsPO90 8TG
MrTaylorMichael12 Queens RoadGosportHantsPO96 6NM
MrTraffordPaul36 Peters PlaceStubbingtonHantsPO97 2SD
MrWhiteGraham52 Warblers WayFarehamHantsPO90 9CV
MrFarrierErnest90 Amberfield AvenueFarehamHantsPO90 9NB
MrBlueittFrank34 Ranvilles PlaceSouthamptonHantsSO96 2DF
MrTittTomChandlers FordHantsSO99 6GH