Saving HTML page to MySQL Database and then inserting code into that HTML and seeving it up again

Question

I'm trying to build something similar to the "Try on your site" on http://www.mywebpresenters.com/

I want to let users enter in their URL, then I need to save the HTML of that URL/Page to a MySQL database using PHP. I then need to insert a div containing more code and then serve up the whole lot to the user again.

I have done this using an IFrame but I'd like to do it better.

Can anyone shed light on this? Also, This will be used on a WordPress site if that adds in anyway.

Thanks in advance,

Barry

using an iframe... what do you mean? currently you are adding an <iframe> but would prefer to us a <div>? — Shad
– Shad, Commented Mar 13, 2012 at 4:11

Code Breaker · Accepted Answer · 2012-03-13 04:52:28Z

1

If you want to save the whole html page in the database use the smarty. It simply fetch a html file in a variable like

$myvar  = smarty->fetch('htmlfile');

now you can simply save the $myvar into the sql.

answered Mar 13, 2012 at 4:52

Code Breaker

4991 gold badge4 silver badges19 bronze badges

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

Comments

javram · Accepted Answer · 2012-03-13 04:12:07Z

0

Unless you are prepared to parse the HTML and remove the head/body tags of the scraped page, than an iFrame is the way to go. You could probably use a find/replace algorithm when you retrieve the stored HTML from the server to insert the containing code that you need into the correct location.

answered Mar 13, 2012 at 4:12

javram

2,6451 gold badge15 silver badges18 bronze badges

Comments

VinceOmega · Accepted Answer · 2012-03-13 04:13:11Z

0

The only way I could personally think of doing this is having them upload the page to your site and then doing a mysql query using PHP to store it into database. Then using the PHP 5 DomDocument model to take that same code and save it as a dynamic page.

Well actually, you can do it two ways. You can use PHP cURL library to get the url of the page and simply parse and save the HTML code to the database as well.

To present it in a div you want to use javascript and get the div a target _top attribute so window.open can load the content in that page.

You don't even need WordPress for this to be honest. This can be done by scratch.

answered Mar 13, 2012 at 4:13

VinceOmega

1051 silver badge11 bronze badges

Collectives™ on Stack Overflow

Saving HTML page to MySQL Database and then inserting code into that HTML and seeving it up again

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related