Display HTML file in uiwebview from SQLite database?

Question

I have a project that I am working on that requires me to be able to display an HTML file stored in a SQLite database in a uiwebview. I know how to display a local file stored in the main bundle, but I just can't figure out how to get these files stored in the SQLite database to display in the uiwebview. If anyone can help me it would be greatly appreciated. Sample project or tutorial is great! Thanks in advance!

ADDED INFO I thought I would attach this link to help in understanding what I'm trying to do. http://www.google.com/url?sa=t&source=web&cd=1&ved=0CCYQFjAA&url=http%3A%2F%2Fdblog.com.au%2Fiphone-development-tutorials%2Fiphone-sdk-tutorial-reading-data-from-a-sqlite-database%2F&rct=j&q=sqlite%20animals%20tutorial%20iphone&ei=41eIT-79L9H-2QW50tXaCQ&usg=AFQjCNGqongc81oHHa3WGFTctkBIiduCvA in the linked tutorial I have dropped the image view since I don't need it for my purposes, and I have replaced the data in the database to be the contents of an html file. In the tutorial it displays the text in a textview and I want to change it to display in a uiwebview. I want this to keep formatting and a few other reasons. Thanks to those who have posted. If anyone can help me get this it would be great!! Thanks in advance!

I add more info to my question to make easier to answer. Thanks to all. — infobug
– infobug, Commented Apr 13, 2012 at 17:11

borrrden · Accepted Answer · 2012-04-13 07:01:54Z

2

webView loadHTMLString:baseURL: (I assume it is just stored as a string....if you have any images, you will need to set your base directory accordingly)

answered Apr 13, 2012 at 7:01

borrrden

33.4k8 gold badges76 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prabhjot Singh Gogana · Accepted Answer · 2012-04-13 07:25:31Z

1

  [WebView loadRequest:[NSURLRequest requestWithURL:[NSURL fileURLWithPath:[[NSBundle mainBundle] pathForResource:@"test" ofType:@"html"]isDirectory:NO]]];

this code displays "test.html" which is located in the project folder

answered Apr 13, 2012 at 7:25

Prabhjot Singh Gogana

1,4081 gold badge14 silver badges39 bronze badges

3 Comments

infobug Over a year ago

I know how to do that. I'm trying to display a file stored in a SQLite database.

Prabhjot Singh Gogana Over a year ago

so u want to know how to access a file from SQLite

infobug Over a year ago

Yes. I'm trying to access the file and then display it in a uiwebview. It is an HTML file.

carbonr · Accepted Answer · 2012-04-13 23:13:59Z

1

Got it by using

NSString *html = [animal description];
[self.animalView.animalDesciption loadHTMLString:html baseURL:[NSURL fileURLWithPath:[[NSBundle mainBundle] bundlePath]]];

when the ViewController that contains the webview is pushed into the display.

edited Apr 13, 2012 at 23:13

carbonr

6,0975 gold badges49 silver badges74 bronze badges

answered Apr 13, 2012 at 19:39

infobug

3135 silver badges17 bronze badges

3 Comments

borrrden Over a year ago

How does this answer involve SQLite at all?

infobug Over a year ago

check out the link to the tutorial and you will see what how it is changed by the above code.

borrrden Over a year ago

No thanks...no one wants to read a tutorial to get an answer to a question

Collectives™ on Stack Overflow

Display HTML file in uiwebview from SQLite database?

3 Answers 3

Comments

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related