User's way to include new pages in a site without programming

Well, let's see if this is what you want ...

You will have a DB like this (+ -):

    //tabela paginas:
    //(id, nome, conteudo);

when it inserts a new page:

    //(1, galeria, conteudo1);

In the index you can do this:

    <?php 

    $get_page = $_GET['page'];

    if(isset($get_page)){


    $selecionaPagina = mysql_query("SELECT * FROM paginas WHERE nome = '$get_page'");
    while($paginaConteudo = mysql_fetch_array($selecionaPagina)){

    }


    ?>

    // ai você faz o loop

    <div><?php echo $paginaConteudo['conteudo']; ?></div>

    <?php } ?>

Already in the menu, you would have to do the same thing, but selecting only pages with content

    <?php

    $selecionaPagina = mysql_query("SELECT * FROM paginas WHERE NOT conteudo = ''");
    while($paginaConteudo = mysql_fetch_array($selecionaPagina)){

    // ai você faz o loop

    <ul>

    <li><?php echo $paginaConteudo['nome']; ?></li>

    </ul>

for static pages, or you change instead of index.php? page = contact for contact.php or you create arrays of them and do an initial check in the index. Type, if the $ _GET ['page'] exists and it is = the contact: include ("contact.php");

I hope to have helped

You should work well on your database structure to have a legal result, easy implementation and maintenance. Here I am illustrating a simple but powerful modeling.

Just study the modeling well, and perform the queries correctly. To display the content you must have a page that always searches for the "page" you want and display the content of the page with echo .

Bank modeling

Menu table ( navs )

• id (unique, auto_increment)
• name (NOT NULL)
• description
• slug (single NOT NULL)
• active (1 - Active, 0 - Inactive, Default 0)
• menu_id (foreign key).

Records

(1, 'Home', 'Página inicial', 'home', 1, 1)
(2, 'Contato', 'Página de contatos', 'contato', 1, 1)
(3, 'Site map', 'Mapa do site (menu do rodapé do site)', 'site-map', 1, 2)
(4, 'Contato', 'Página de contatos (menu do rodapé do site)', 'contato', 1, 2)

OBS: The field slug is what you will pass in the links for page search, so it should always be unique as a primary key, and it is recommended to index it.

Menu group table ( menus )

• id (unique, auto_increment)
• description

Records

(1, 'Menu Principal')
(2, 'Menu Rodapé')

Page table ( pages )

• id (unique, auto_increment)
• title (NOT NULL)
• content (NOT NULL)
• description
• keywords

Records

(1, 'Home', '<p>Conteúdo da página</p>','Essa é a página inicial do site','página, inicio, home, site, foo, bar')
(2, 'Contato', '<p>Página de contato</p>','Essa é a página de contato do site','página, contato, contact, site, foo, bar')
(3, 'Site Map', '<p>Mapa do site</p>','Essa é a página com o mapa do site','página, map, site map, mapa do site, mapa, site, foo, bar')

Table of relationships between menus and pages (one page can have multiple menus, but one menu only once) ( navs_pages )

• id_nav
• id_page

Records

(1,1) // Menu principal -> Página Inicial
(2,2) // Menu principal -> Página Contato
(3,3) // Menu rodapé -> Site Map
(4,2) // Menu rodapé -> Página Contato

Search for menus

$sql = "SELECT n.* FROM navs n WHERE n.id_menu = 1 AND n.ativo = 1;"; // Menu Princial
$sql = "SELECT n.* FROM navs n WHERE n.id_menu = 2; AND n.ativo = 1"; // Menu Rodapé

// Aqui você tem a lista dos menus é só trabalhar neles para montar o HTML

Search for pages

$page = (isset($_GET['page']) ? $_GET['page'] : 'home');

$sql = "SELECT p.* 
        FROM navs n
           INNER JOIN navs_pages np ON (np.id_nav = n.id)
              INNER JOIN pages p ON (p.id = np.id_page)
        WHERE n.slug = '{$page}'"

// Executa essa consulta SQL e da um echo do conteúdo no local desejado

Let me see if I get it, you want to make a web application that creates and manages content, a CMS in this case.

Look, if it is, there are some materials that can help you. Quick search on Google found this, also in PHP:

CMS with CakePhp

The interesting thing about this article is that in addition to using PHP, it uses a framework to work with MVC, which would make it easier to encode.

What you're trying to do basically consists of storing the HTML that the user types or his editor generates in the database, and in a PHP script, via $_GET['paginaexemplo'] , you load this information from the database and put it in some part of the merged PHP code with HTML, which would generate your code below, eg: index.php?page=home, index.php?page=empresa e index.php?page=sobre index.php?page=contato? (these pages exist).

The advantage of using a PHP framework such as CakePhp is that it offers a number of features you would not have to do.