MySQL PHP sample web services with JSON output
 Tutorials, Get all kinds of tutorials for Web, desktop, Windows, Apple, mobile, Android, iOS, webOS
Source codes

Delphi
Objective C
HTML5
WebOS

Designs

Delphi forms
Objective C iOS designs
HTML5 designs templates

Open source projects

Delphi code analyser
Objective C iOS SlamApp
JavaScript Alerts

Introduction

MySQL PHP JSON!

MySQL sample PHP web service spitting out JSON result!, You can use this sample PHP web services to test JSON.

Get Team! JSON

Get the list of team details as JSON array! using the link Team details

This link should connect to the database and get the team details and spit out the JSON for you! like this.

[{"TeamsID":"1","0":"1","TeamName":"Arsenal","1":"Arsenal","TeamStadium":"1","2":"1","TeamManager":"1","3":"1"},{"TeamsID":"2","0":"2","TeamName":"LiverPool","1":"LiverPool","TeamStadium":"2","2":"2","TeamManager":"2","3":"2"},{"TeamsID":"3","0":"3","TeamName":"Everton","1":"Everton","TeamStadium":"3","2":"3","TeamManager":"3","3":"3"},{"TeamsID":"4","0":"4","TeamName":"Newcastle United","1":"Newcastle United","TeamStadium":"4","2":"4","TeamManager":"4","3":"4"},{"TeamsID":"5","0":"5","TeamName":"Aston Villa","1":"Aston Villa","TeamStadium":"5","2":"5","TeamManager":"5","3":"5"},{"TeamsID":"7","0":"7","TeamName":"Southampton United","1":"Southampton United","TeamStadium":"7","2":"7","TeamManager":"7","3":"7"}]
			

Get Team Managers! JSON

Get the list of team managers as JSON array! Team manager

This link should connect to the database and get the managers details and spit out the JSON for you! like this.

[{"ManagerID":"1","0":"1","ManagerName":"Arsene Wenger","1":"Arsene Wenger","ManagerTitlesWon":"10","2":"10"},{"ManagerID":"2","0":"2","ManagerName":"Brandon Rodgers","1":"Brandon Rodgers","ManagerTitlesWon":"1","2":"1"},{"ManagerID":"3","0":"3","ManagerName":"Allen Pardew","1":"Allen Pardew","ManagerTitlesWon":"0","2":"0"},{"ManagerID":"4","0":"4","ManagerName":"Roberto Martinex","1":"Roberto Martinex","ManagerTitlesWon":"1","2":"1"},{"ManagerID":"5","0":"5","ManagerName":"Paul Lambert","1":"Paul Lambert","ManagerTitlesWon":"5","2":"5"}]
			

Get Team Stadium! JSON

Get the list of team stadium as JSON array! Team stadium

[{"StadiumID":"1","0":"1","StadiumName":"Emirates","1":"Emirates","StadiumLocation":"London","2":"London"},{"StadiumID":"2","0":"2","StadiumName":"Anfield","1":"Anfield","StadiumLocation":"Liverpool","2":"Liverpool"},{"StadiumID":"3","0":"3","StadiumName":"Goodison Park","1":"Goodison Park","StadiumLocation":"LiverPool","2":"LiverPool"},{"StadiumID":"4","0":"4","StadiumName":"Saint James Park","1":"Saint James Park","StadiumLocation":"New castle","2":"New castle"},{"StadiumID":"5","0":"5","StadiumName":"Villa Park","1":"Villa Park","StadiumLocation":"Aston","2":"Aston"},{"StadiumID":"6","0":"6","StadiumName":"Saints","1":"Saints","StadiumLocation":"Southampton","2":"Southampton"}]
			

Download the code

Download the web service code from GitHb

 Tutorials, Get all kinds of tutorials for Web, desktop, Windows, Apple, mobile, Android, iOS, webOS