The magic journey into sql storage of posts - Part 3.
All the old stuff has now been moved into the sql database!
Things diden't go as smooth as i had expected but the errors i ran into would have to be fixed sooner or later... Having to add stuff in phpMyAdmin after creating it elsewhere first seems a tad silly.
At least i now also have templates for other post and project types.
The magic journey is complete!
The magic journey into sql storage of posts - Part 2.
The basic sql/php has now been set up!
All parts of the "Projects" page and most of the front page is now generated from tables in the database. Minor additions like working tags, permalinks and link to the main project from each post will be added soon.
Only major thing left to do now is adding all the old content into the database.
The magic journey into sql storage of posts - Part 1.
As you may or may not have noticed,the front page has recently consisted of some weird gibberish rambling about posts and some sql database.
To your liking... Or disliking this will be the future of the site...
Not the useless text but the way it is stored and fetched to the user.
I have lately been setting up a sql database for storing and categorization of posts. Until now the whole website has been hardcoded which has led to far more work than needed and general unwillingness to add stuff to the site.
This is about to change.
Tables have been created and php functions written. The only thing left to do now is add old content to the system and make sql become html in some magic way.