SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2008
    0 Post(s)
    0 Thread(s)

    HELP? Connect PHP to Mysql and Editor

    I've been building small php websites for years, and wish to store the data in mysql dbase. Two tables, one for html templates and one for content/articles , and wish to use fckeditor or similar in order to create new entries in either table.
    I looked a joomla and smarty, but those are an overkill for what I need. Any recommendations? Anyone know of just a simple php/mysql front page controller script with editor?

    Here's an interesting tutorial:
    Database driven template engine

    Last edited by calfellows; Apr 8, 2008 at 20:33.

  2. #2
    SitePoint Addict
    Join Date
    Sep 2005
    0 Post(s)
    0 Thread(s)
    You might just want to spin one yourself. Building a page to edit a field from a database isn't hard. If you are trying to merge the two (template and content) you'll also need to come up with your own template system.

    Here are some things to build
    Admin section
    Admin back end that displays the template tables and the content tables.
    Click on a record from either table and the data field is loaded into fckeditor.

    Template section
    In your templates, put special markers for the content (title, author, content, etc.). The special tags/markers might look like %%TITLE%% or something like that.
    Then, when you are ready to display the template, just do a search/replace on all of your tags with the data from the database.

    I spent countless hours looking for a similar system about a year ago. Most systems were either too bulky for what I wanted to do or were just garbage. I eventually wrote my own template system. Additional benefits are that I can slowly add more features as I need it.
    PHP Shopping Cart Software Easy Ecommerce Shopping Cart Script.
    PHP Super Cart is 100% template driven.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts