SQL Database

SQL Database


Uses MariaDB. MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License.


Your server should be running PHP 7 - ideally 7.3


Here are a few rows from a "customer" database. They are not really customers - all the names and addresses are made up, but you get the idea, I'm sure.

There are 46 customers in the database

First Name Surname Street Town Postcode
JohnTaylor34 High Grove CrescentFarehamPO98 5TY
PeterWilliams23 Shore RoadSouthamptonSO98 5TH
ArthurSmith57a Derby RoadPortsmouthPO96 G67
WilliamWatson125 Botley AvenueBournemouthBO89 5TY
KeithJones8 Garden Walk CrescentWickhamSO93 8GH
DennisHaynes24 Cutter CloseWarsashSO88 7JK
Alan Ashcroft93 The AvenueBursledonSO88 2RT
GeorgeRoberts25 Copper CrescentFarehamPO91 4FG
CyrilGascoigne127 Cranberry WayWinchesterWI88 5BN
KEITHTAYLOR34 Shore RoadSouthamptonSO319FU
NormanSeager12 Albert SquareHavantPO92 9QW
OscarMullins56 Kingston TerraceWinchesterWI89 3GG
VincentGogh12 Van Avenue Cosham by the SeaPO83 3ER
TonyKennedy467 Grange TerraceSouthamptonSO92 2DG
RupertTaylor2 Summers RoadBishops WalthamSO93 8GH
DavidJones64 Railway CuttingsWickhamSO98 2FG
KeithThompson44 Florins RoadBotleySO98 2KK
TerryToynbee45 Templecombe TerraceBotleySO98 2JJ
SamuelDimbleby2 The ParadeSouthamptonSO97 2FG
KennethSomers87 Harvest AvenueLavantCH88 6TY
Frederickvon Balmer100 Union RoadSouthseaPO76 7TB
PatPostman345 Postcode RoadWaterloovillePO56 6TY
SimonBrough89 Crescent CottagesSouthamptonSO99 4RT
RosemaryJohnson15 Blueberry HillSouthamptonSO98 6YU
RogerLeach44 Williams StreetWinchesterWI88 2DF
ChristopherCraick56 Dell ParkWinchesterWI90 6BN
JamesSibley77 Sunset StripEastleighSO95 7KL
DanielRowntree22 Ducks RoadEastleighSO95 8EW
AndrewPenyard7 Beatle DriveFarehamPO98 3DF
GiacomoPuccini"La Fenice", 34 West StreetSouthseaPO91 5GH
MichaelTaylor12 Queens RoadGosportPO96 6NM
PaulTrafford36 Peters PlaceStubbingtonPO97 2SD
GrahamWhite52 Warblers WayFarehamPO90 9CV
RayBaduch345 Western RoadCurdlingtonPO77 7CB
FrankBlueitt34 Ranvilles PlaceSouthamptonSO96 2DF
TomTittChandlers FordSO99 6GH
RupertBear234 Beddington CloseFarlingtonPO86 6RB
RandolphChurchill23 Smith StreetHeywoodOL11 3FT
SylviaBamford56a Ford StreetWarsashSO31 9TG
BillHickock346 Buffalo LaneBasingstokeBG34 5TY
MichelleMorse23 Dash RoadPortsmouthPO82 4RF
KeithTaylorWarsash
BettySwallocksPortsmouth
AllanArdvaarksArdsvilleAA12 5AA
RegDavies
RobertZiggerZA2 5PJ