webpublishing using PHP + MySQL

[Anon]

I can manage the basics in PHP and MySQL, but I'm interested in building a www site (like this one) using this tools. I'd like anybody to show mi the principles of filling the tables with articles and so on. For example, I can imagine I would write a article in a WYSIWYG HTML editor and then I'd save it in a database for further use. Problem with '"' (i don't know the English expression for " :-) occurs. I'd have to replace the escape sequences before saving to database. Actualy, I thing the article must be saved in HTML form in order to save also formatting, tables and so on.
I think, this is a quite difficult way to build a big server :-)). Can anybody tell mi the basics ? Please, respond to [e-mail] rather than here...

Thanx very much...

[Anon]

Please, respond to [e-mail] rather than here...

Please do <b>both</b>. This would be a very good discussion to have in public.

[Anon]

A site like this probably uses a template structure,
where the layout of the page is stored in a template file that is read by a php script.

The template would contain keywords that are replaced with database content by the php script.

You do not want to write complete pages and store them in a database,
because if you decide to change something in your layout, you'll have to edit all the pages inside your database.

If you use a template, you can change the layhout of your wite by editing just one file.

[Anon]

Only one question remains, what kind of template are you going to use.
- a PHP based one
- JavaScript based one

The PHP stuff is more browser compaitble, but the JavaScript version needs less server CPU power

[Anon]

I figured out how to save the HTML article to MySQL table. There'n no need to modify escape characters. I just made a form with textarea and copied the HTML content (only the body part) to MySQL using PHP. It worked and after loading the article into a table cell. The article was unchanged. So, the basic problem is solved (no security considered !) but I'd like to know how to create the database and tables for efficien use. I don't know whatever is needed for all those voting systems, hot news, headlines and so on. Simply, what structure should be chosen in order to keep it manageable....

[Anon]

The answer must be obvious🙂

• a php based one.

Because a javascript based interface doesn't work if the user disables javascript.

The extra server load for a template driven site is minimal if you do it right 🙂

I personally don't really use a template that gets parsed,
I use a skeleton php page that calls various scripts/functions wherever I need content.
That way I end up with the normal script code plus only a few extra switch and ifthen statements.