Need help with converting a file to accept templates from a DB

WizyWyg

I have to modify a pre-written file that is now, using static html files as templates and change it so that it uses templates from a DB instead. I have no idea how to change the class functions that is presented in the files, so I would like some help on how to go about doing this; and maybe teach me along the way on more on PHP

(please bare with me since Im not a programmer, but an artist, the best php i Know is just basic stuff ie how to retrieve date, time and print/echo out some results coming from the D😎

Attached are some files that Im working with; includes the sql file if you need it and you would need to modify the common file with your database information. Also included is the original static .html template file, which is being used by the original php files.

If anyone would be so kind as to help me walk through this conversion, it will be greatly appreciated.

WizyWyg

Addendum:

Basically, this is the bit of code from a function that I have to modify:

function load_file($filename, $sName)
  {
    $nName = "";
    $template_path = $this->templates_root . "/" . $filename;
    if (file_exists($template_path))
    {
      $this->DBlocks[$sName] = join('',file($template_path));
      $nName = $this->NextDBlockName($sName);
      while($nName != "")
      {
        $this->SetBlock($sName, $nName);
        $nName = $this->NextDBlockName($sName);
      }
    }
  }

As was suggested by another forum but answers there come in spurts of 64 hours periods;

The php page calls for:
```
 $template_filename = "series.html";   
```

which is the current static html template file, which will be used by series.php to "layout" the page.

in the DB, i made a new table called templates with the rows of template_id, name, template
name = the original name of the template file ( so in the db its called series.html)
template - a copy and paste of the entire template that was in the static.html file

So my questions are:

Where do I inject a SQL query to pull the information from the DB instead of calling for the static html file ? I wana keep the edits as minimal as possible, using hte same variable names if possible.

these three lines would need to be changed so instead of looking for a static file, it looks at the DB

$template_path = $this->templates_root . "/" . $filename;
    if (file_exists($template_path))
    {
      $this->DBlocks[$sName] = join('',file($template_path));

Any tips on how to go about doing this, for those who dont want to download the files in the first posting.