query from web site

[qupe]

hi

i have a small db form series i watch, and i red about ability to query from web sites like imdb or myanimelist and i may get poster link or series episode number , i am not big programmer,

So what do you have thoughts about this thing

 

[isladogs]

From your comments, I think you will find that quite challenging.

I recommend that you search the interweb to find example code that does what you want.
I'm sure you will find many examples using Google

 

[HiTechCoach]

This may be what you want:


http://imdbapi.poromenos.org/

IMDB API
by Stavros Korokithakis

Well hello. I see you want to access IMDB programatically. Well, this is your chance. This service is updated every day from the IMDB data files and you can access it with the ?name= URL parameter. For example, this is the episode list (in JSON) for How I Met Your Mother.

This service only supports shows, it does not have any movies.

or

http://omdbapi.com/

OMDb API

The Open Movie Database

The OMDb API is a RESTful web service to obtain movie information, all content and images on the site are contributed and maintained by our users.

 

[qupe]

This may be what you want:


http://imdbapi.poromenos.org/




or

http://omdbapi.com/

thank you very much.
this is a code found on internet but it is not working probably for
1. i am using the main IMDB not what did you recommend
2. some debugs.

Private Sub Form_Load()

Dim IE As New InternetExplorer
IE.Visible = True
IE.Navigate "http://www.imdb.com/find?ref_=nv_sr_fn&q=" & Me.seriesname.Value
Do
DoEvents
Loop Until IE.ReadyState = READYSTATE_COMPLETE
Dim doc As HTMLDocument
Set doc = IE.Document
Dim div As String
div = Trim(doc.getElementsByTagName("div")(5).innerText)
MsgBox div



End Sub

i appreciate if could help me .
i need the series poster link

 

[jdraw]

qupe,

You may get some ideas and concepts from some of the WiseOwl tutorials

here are a few

https://www.youtube.com/watch?v=dShR33CdlY8 47 Browsing to websites
https://www.youtube.com/watch?v=sGw6r5GVA5g 48 Web scraping multi page
https://www.youtube.com/watch?v=JPezrWwvsJM 49 Downloading files from websites

These deal with Excel and vba, but the vba is the same as Access vba. There are some changes to use Access rather than Excel, but it's the concepts and approach in the tutorials that I am highlighting.

I realize you are not a "big" programmer, but there are several free youtube videos for Access and vba that can help when you get to the programming part. Watch the videos to get an appreciation of the concepts involved.

Good luck.

 

[ashleedawg]

Since your collection of shows is small, there isn't much benefit to "automatically" getting the posters from the website. (In the time it will take to automate that for multiple sites, you could download hundreds of posters yourself!)

But you can still organize your collection (and links to the posters) in a database. That would be a good starter project for learning to program.

In fact, many others before you have used exactly that as a first project!

Here is a YouTube video called "How to build movie collection database using MS ACCESS 101 Part 1" : https://youtu.be/9wnag6_sD7I

 

[qupe]

Since your collection of shows is small, there isn't much benefit to "automatically" getting the posters from the website. (In the time it will take to automate that for multiple sites, you could download hundreds of posters yourself!)

But you can still organize your collection (and links to the posters) in a database. That would be a good starter project for learning to program.

In fact, many others before you have used exactly that as a first project!

Here is a YouTube video called "How to build movie collection database using MS ACCESS 101 Part 1" : https://youtu.be/9wnag6_sD7I

thank you,
in the beginning, i were using poster link and it was fine, but recently they change some thing with their sever, so the old link was not valid any more
, and i have 70 shows, it is not easy task, then i found about the scraping , so i looked for it.