Site
Home / Forum / General Discussion / New on the site
Home / Forum / General Discussion / New on the site
New on the site |
| Posted: 08 Jan 2021 20:21 | |||
 | Hi, I am a new user on the site. I am looking for a API to display some football infos (results, standing, live scores, stats..). I just saw your website. I didn't saw anything about the cost of your API. How much does your API cost ? Is there some example of scripts ? Thanks a lot Webfoot | ||
 | |||
| Posted: 08 Jan 2021 21:43 | |||
 Ovokx Posts: 1,769 Joined: 2020 | Welcome aboard! Here you can find the info you are requesting  https://www.thesportsdb.com/api.php Enjoy your stay and if you have any doubts, don't hesitate to ask us!  | ||
| |||
| Posted: 08 Jan 2021 21:57 | |||
| Hi, Thanks for your answer. Yes I read this page before to post on this forum. Till now I used API with a cURL script (and a foreach loop). To use of your, what we have to do ? We have to download PHP libraries ? For example if I want to display automatically the last results of a championship ? Thanks PS : Seeably I posted two times the same topic. Is it possible to delete the other please ? I tried to do it by clicking on the recycle bin but no changes were made | ||
| |||
| Posted: 08 Jan 2021 22:17 | |||
 zag  Posts: 3,515 Joined: 2020 | Yes I read this page before to post on this forum. Till now I used API with a cURL script (and a foreach loop). To use of your, what we have to do ? We have to download PHP libraries ? For example if I want to display automatically the last results of a championship ? Thanks PS : Seeably I posted two times the same topic. Is it possible to delete the other please ? I tried to do it by clicking on the recycle bin but no changes were made Hi yes just sign up on patreon for a simple JSON api with livescore data with an API key. Saying that, a lot of our site is free to use for other data and will stay that way You will need some kind of programming language such as PHP or Javasript to decode the data and display on a web page. You can use 6 or 7 lines of code to show it with standard PHP json_decode function or indeed CURL. https://www.w3schools.com/php/func_json_decode.asp If you want to use a seperate library (some people find that easier) There is a very nice PHP library coming along here from one of our users if you want something quick and simple: https://github.com/nkl-kst/the-sports-db | ||
| |||
| Posted: 08 Jan 2021 22:23 | |||
zag Posts: 3,515 Joined: 2020 | If you want to test our API its very easy to in a browser. Just copy and paste an API url into a web browser and it should show lots of data right away. If you want to see the data in a structured way then install the json_view extension for google chrome. https://chrome.google.com/webstore/detail/json-viewer/gbmdgpbipfallnflgajpaliibnhdgobh | ||
| |||
| Posted: 08 Jan 2021 22:36 | |||
| Yes i saw the php library (on this topic https://www.thesportsdb.com/forum_topic.php?t=5198) , i dowloaded it before to post on this forum. I just try to learn how to display the datas (i am a beginner). Till now i just used an API with a cURL (the script was given by the owner of the API and i just had the foreach loop to create, i didn't had any libraries to manage) | ||
| |||
| Posted: 08 Jan 2021 22:44 | |||
zag Posts: 3,515 Joined: 2020 | I just try to learn how to display the datas (i am a beginner). Till now i just used an API with a cURL (the script was given by the owner of the API and i just had the foreach loop to create, i didn't had any libraries to manage) If you are a beginner then I would just do it the way you always have done, cURL should work fine and then just loop over the array. I suggest you look into some tutorials because with PHP it should be very easy: 1) Load the JSON URL into a file object 2) Decode JSON into an array 3) Var_dump the array to test your data 4) Once you understand the structure the loop over the data and print the results | ||
| |||
| Posted: 08 Jan 2021 22:49 | |||
| For example till now i used of this kind of script (provided by the creator of the api) And after in the body, i made my foreach loops | ||
| |||
| Posted: 09 Jan 2021 10:44 | |||
zag Posts: 3,515 Joined: 2020 | https://zupimages.net/up/21/01/b2x3.png And after in the body, i made my foreach loops Yes thats pretty much perfect and how I do things when I need to send API keys in headers! | ||
| |||
| Posted: 09 Jan 2021 12:13 | |||
| So for example to get the last results of the French Ligue 1 for example (as I am for France), what URL i need to put in the curlopt url ? It seem it works also without to put the headers | ||
| |||
| Posted: 09 Jan 2021 13:28 | |||
zag Posts: 3,515 Joined: 2020 | It seem it works also without to put the headers https://www.thesportsdb.com/api/v1/json/1/eventspastleague.php?id=4334 All this info is on the API instruction page | ||
| |||
| Posted: 09 Jan 2021 14:03 | |||
| Thanks it seems ok When i type the url in the curlopt_url i have this page  | ||
| |||
| Posted: 09 Jan 2021 16:11 | |||
| I made my foreach loop, it seems working great ... On the results, there is not the logo of each team in "detail" ? For example i would like to do something like :  For the next events, is it possible to change the number of events ? (for example 10 instead of 15) zag | ||
| |||
| Posted: 09 Jan 2021 18:44 | |||
zag Posts: 3,515 Joined: 2020 | So to lookup the team badges you would have to use the lookupteam API https://www.thesportsdb.com/api/v1/json/1/lookupteam.php?id=133604 as a 2nd call using the Home and Away Team ID you have in the event details. For the 10 events limit you could put a counter in the code and then break from the loop when it reaches 10 All should be quite simple with PHP. | ||
| |||
| Posted: 09 Jan 2021 19:40 | |||
| I tried to insert a for loop and in this for loop my foreach loop and i get 10 times the 15 matches (so 150 matches  ).I also tried with a while loop, it loops at the infinite on the 15 matches againIt would be great to have an option to choose the number of matches (for example i want 10 matchs cause it is the number of matches for each round in the french championship). | ||
| |||
| Posted: 10 Jan 2021 11:05 | |||
| Humm maybe I am wrong in my way to process I use of this kind of script to display the datas I define a $json on a files_get_contents and after I use a json_decode Is it a good process ? is there a better one ? (i am still on my problem to display logos and number of matches) Thanks | ||
| |||
| Posted: 10 Jan 2021 13:38 | |||
| I finally succeeded to display 10 matches instead of 15... but i have another question. It is possible to define automatically the last round ? I used of these datas : https://www.thesportsdb.com/api/v1/json/1/eventsround.php?id=4334&r=19&s=2020-2021 the round is typed manually. Is there an option to define automatically the last one ? Thanks | ||
| |||
| Posted: 10 Jan 2021 18:06 | |||
| So to lookup the team badges you would have to use the lookupteam API https://www.thesportsdb.com/api/v1/json/1/lookupteam.php?id=133604 as a 2nd call using the Home and Away Team ID you have in the event details. So each time we want to display a badge we need to use of the complete script for the json decode ? | ||
| |||
| Posted: 10 Jan 2021 20:40 | |||
zag Posts: 3,515 Joined: 2020 | So to lookup the team badges you would have to use the lookupteam API https://www.thesportsdb.com/api/v1/json/1/lookupteam.php?id=133604 as a 2nd call using the Home and Away Team ID you have in the event details. So each time we want to display a badge we need to use of the complete script for the json decode ? Yes you would lookup each team individually and pull as a single variable the team badge. There are many ways to improve this such as caching the badge locally and renaming it to the ID number. | ||
| |||
| Posted: 10 Jan 2021 23:19 | |||
| So to lookup the team badges you would have to use the lookupteam API https://www.thesportsdb.com/api/v1/json/1/lookupteam.php?id=133604 as a 2nd call using the Home and Away Team ID you have in the event details. So each time we want to display a badge we need to use of the complete script for the json decode ? Yes you would lookup each team individually and pull as a single variable the team badge. There are many ways to improve this such as caching the badge locally and renaming it to the ID number. Seems difficult to realize ... it would be more simple to put each bagde on the page than the 2 badges on the same pic ... It is possible to define automatically the last round ? I used of these datas : https://www.thesportsdb.com/api/v1/json/1/eventsround.php?id=4334&r=19&s=2020-2021 the round is typed manually. Is there an option to define automatically the last one ? | ||
| |||
| Posted: 12 Jan 2021 21:39 | |||
zag Posts: 3,515 Joined: 2020 | No option for last round sorry. For the badges you could do a very quick hack and download all the team badges, rename them to the idTeam number and put them on your web server. then just use PHP to display the badge like this | ||
| |||
| Posted: 12 Jan 2021 22:30 | |||
| For the last round i found another solution. I gave to the visitor a possibilty to choose the round he wants to see. For the badges I'll see ... | ||
| |||
| Posted: 13 Jan 2021 11:39 | |||
| For the badges you could do a very quick hack and download all the team badges, rename them to the idTeam number and put them on your web server. then just use PHP to display the badge like this echo "img src='$team->idTeam'.png" I don't know how can I use a $team->idTeam'.png if the pics are on my server. if i do a switch case condition on an external file and call it with an include on my page, I could work ? In fact my problem for the badges is that the id of the team is specified in the url | ||
| |||
| Posted: 14 Jan 2021 23:28 | |||
| Hi, I renamed the teams I want to use their french name. For that i made a simple php page with a switch case called in my code by an include For the last events, no problems all teams are correctly displayed but for the next events, for the strAwayTeam, i have a "1" written beside the name of the team. This "1" is not in my code (I checked several times) I looked at the code generated in my console and I have a bis_skin_checked="1" . I think it is coded in your API. How can I "uncheck" it ? Thanks | ||
|
Who is Online? In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm | About Us Discussion forum for TheSportsDB.com site and related topics | Rules - Be Polite - Respect other users - Always post log files with issues - Try to be helpful - No Piracy discussion |