converting blog to php / any advice?

porco

I'm about to convert a static blog
http://www.blog.lindenlangdon.com
into a php / mysql site. I figure to put the conten into a mysql database and it should be easy enough. The idea is once I have recreated the current articles I can start worrying about adding functionality like comments etc.

If you look at the site there are often images in the blog entries. How would you suggest I store these? I know as BLOBS, I mean how would I relate the images and display the text in the same way.

Each blog article consists of paragraphs inside a container div. EG.
<div>
<p>something</p>
<p>something else</p>
<img src="something"/>
<p>something more again</p>
</div>

I am just a bit blank as to how to go about delivering the specific paragraphs and images (which vary) as one unit from the database.

Any ideas or suggestions on this would be greatly appreciated.

Steven Clark
www.nortypig.com
www.blog.nortypig.com

Weedpacket

The usual method for storing binaries is to store them as files in the server's own filesystem, and store their filenames in the database. Storing them as blobs in the database directly tends to offer significant increases in complexity, while also showing some performance degradation.

As for storing the content, a single record containing plain text ought to be sufficient for each entry - if, say, a double newline represented the end of one paragraph and the start of the next (as I've done in this post), then it wouldn't be too difficult to wrap the text in appropriate <p> tags. For images, a tag like those offered on these forums could be used - if, say {{{image:my_local_foo.jpg}}} was used somewhere in the text, PHP could substitute <img src="http://www.example.com/blog/images/my_local_foo.jpg"> when preparing the text for output. That's one idea.

porco

i suppose that would be the same for the <a> tags for links too. I will give it a bit more thought. thanx.

OH if only mysql could take raw code and spit it back out lol. Anyway it'll happen just not tonight.