Not sure how to store files and how to display them.

[Perry|]

Hello.

 

I am not sure how to store files for my site and then display them. I have installed Smarty on my server for templates. My site is guide based and I want to keep the URL's short and identify them with ?id= (http://www.myurl.com/guide.php?id=1)

 

Those not familiar with Smarty, you create a template (.tpl file) and add areas in the template that you edit in your main file (index.php or whatever)

 

This is what I have in my index.php file currently

 

<?php
require 'smartyconfig/libs/Smarty.class.php';

$smarty = new Smarty;

$smarty->assign('title','Home');
$smarty->assign('main','THIS IS WHERE MAIN CONTENT WILL GO');
$smarty->display('index.tpl');
?>

 

So basically anything in 'main' needs to be dynamic.

 

So any ideas on how to achieve this please post them, if you are unsure about anything please ask me!

 

I have subscribed to this topic so I will get back to you within ~20 minutes.

 

Many thanks,

 

Perry

 

[JonnoTheDev]

The page content is stored in a database table - correct?

You would select the record from your URL id, then pass it to Smarty so:

 

$query = mysql_query("SELECT field FROM table WHERE id='".$_GET['id']."' LIMIT 1");
$result = mysql_fetch_array($query);

$smarty->assign('main', $result['field']);

[Perry|]

The page content is stored in a database table - correct?

You would select the record from your URL id, then pass it to Smarty so:

 

$query = mysql_query("SELECT field FROM table WHERE id='".$_GET['id']."' LIMIT 1");
$result = mysql_fetch_array($query);

$smarty->assign('main', $result['field']);

No it's not that's what I'm asking, where should I store the content? In mySQl? In files?

 

Also the Title needs to be dynamic with the content too.

[JonnoTheDev]

Store it wherever you like. In text files is more difficult if the title needs to be extracted as a separate piece of data.

In mysql you could have a page content table with fields pageId, title, content

 

Then your page title is sent to the template:

$smarty->assign('title', $row['title']);

[Perry|]

I need to learn about MySQL. Just to clear it up, what would I do with the tables? Create a table then add data for each page of content? Or will I need a table for each page of content?

[JonnoTheDev]

No. 1 table.

When you stated:

want to keep the URL's short and identify them with ?id= (http://www.myurl.com/guide.php?id=1)

 

What was the id supposed to reference in ?id=x

In most cases this is the primary key value for the database table you are querying

[Perry|]

The id is referencing the specific guide.

 

Say I have one guide category then the id is pointing to a specific part of the category (On a new page).

[JonnoTheDev]

OK. You need to learn a relational database if you want dynamic capabilities in your website.

[Perry|]

Where should I start? I don't really like W3Schools, what is an alternative?