dynamically populate header meta content with php/mysql

Seriously, I don't know <smiles>. I'm hoping that someone knows what is needed to accomplish this.

How do you know that you're getting the wrong page's information?

How in the database table does it tell you which information corresponds to which page?

If you put the same exact query at the top of each page, then of course it will return the same information for each page :)

If you filter the query on each page so it only brings back the correct page's info, then you'll only get the correct page's info on each page.

If you know a certain web page corresponds to a certain `id` record in the table, change the code like this:
For page id 1:

$query = "SELECT *
          FROM articles
          WHERE `id` = 1";

For page id 2:

$query = "SELECT *
          FROM articles
          WHERE `id` = 2";


Is that helpful?

Crimson117: How do you know that you're getting the wrong page's information?

When I "view source" when the page has been generated, the title and description head tags contain info entered for one of the other pages. (I've tried placing these fields within the body of the page and that works fine with each page's title and description showing appropriately.)

Crimson117: How in the database table does it tell you which information corresponds to which page?

I don't know. Doesn't all the info in one record in the table automatically relate to the one record? In this case, the title, description and body are all in one record. (The body field holds the page content.)

Crimson117: If you put the same exact query at the top of each page, then of course it will return the same information for each page :)

That makes sense <smiles> ... but there is only one index.php that generates each of the pages so I'm not sure how to proceed.

You say that the correct bosy information is appearing, but the meta information is always the same.

So it seems that the query that populates the content of the page DOES know exactly which row to choose, while the query that gets the META info DOESN'T know exactly which row to choose.  The body query is probably filtered with "AND id = $some_number"

Can you post the php that gets the body of the page?

This is from index.php:

    <p><?=nl2br($page['body'])?></p>

I added the following to the index.php and these do work to pull the content properly from the db to place it in the body:

    <h1><?=$page['title']?></h1>
    <h1><?=$page['description']?></h1>


These are the functions from common.php:

 <?
    session_start();
    include("config.php");
    $dbh=mysql_connect ($dbhost, $dbuser, $dbpassword) or die ('I
cannot connect to the database because: ' . mysql_error());
    mysql_select_db ($dbname,$dbh);
    define("DBH",$dbh);

    function getPage($field='seoname',$value=''){
        $result = mysql_query("SELECT * FROM articles WHERE
{$field}='{$value}'", DBH);
        $page = mysql_fetch_assoc($result);
        return $page;
    }
    function getPages($field='parent',$value='0'){
        $result = mysql_query("SELECT * FROM articles WHERE
{$field}='{$value}'", DBH);
        $pages = array();
        while( $row = mysql_fetch_assoc($result) ){
            $pages[$row['id']] = $row;
        }
        return $pages;
    }
    function AddPage(){
        unset($_POST['id']);
        $_POST['seoname'] = seoname($_POST['title']);
        $query = "INSERT INTO articles (".implode(", ",array_keys
($_POST)).") VALUES ('".implode("', '",array_map
("mysql_real_escape_string",$_POST))."')";
        mysql_query($query,DBH) or die( mysql_error() );
        return mysql_insert_id();
    }
    function UpdatePage($pid){
        $_POST['seoname'] = seoname($_POST['title']);
        $query = "UPDATE articles SET ";
        foreach($_POST as $field => $value) {
        $query .= "$field = '".mysql_real_escape_string
($value)."', ";
        }
        $query = substr($query, 0, strlen($query)-2)." WHERE id =
'{$pid}'";
        mysql_query($query,DBH) or die( mysql_error() );
        return mysql_affected_rows();
    }
    function DeletePage($pid){
        unset($_POST['step']);
        $query = "DELETE FROM articles WHERE id = '{$pid}'";
        mysql_query($query,DBH) or die( mysql_error() );
        return mysql_affected_rows();
    }
    function seoname($string){
        $string = ltrim($string);
        $string = preg_replace( "/ +/", " ", strtolower($string) );
        $string = str_replace(' - ', '-', $string);
        $string = str_replace(array('-
','%',';','/','?',':','@','&','=','+','$',',','#','(',')'), '',
$string);
        $search  = array(' ', 'ä', 'ö',
'ü','ë','ï','é','è','à','ç',);
        $replace = array
('','ae','oe','ue','e','i','e','e','a','c');
        $string = str_replace($search, $replace, $string);
        $string = preg_replace("/[^a-z0-9_-]/", "", $string);
        $string = strtolower($string);
        return urlencode($string);
    }
?>

You said "I added the following to the index.php and these do work to pull the content properly from the db to place it in the body:"

So can you put similar values in where you place the meta-tags?  Or does the GetPage function not get executed until later?

If I put the following in:


<?
  include("common.php");
  $mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : '';


?>
<?
$query = "SELECT *
          FROM articles
          WHERE `id` = 1";
  $result = mysql_query($query) or die(mysql_error());
while ($articles = mysql_fetch_object($result)) {
        $title = $articles->title;
$description = $articles->description;
}
?>
<html>
<head>
<meta name="title" content="<? echo "$title"; ?>">
<meta name="description" content="<? echo $description; ?>">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">

</head>


this is what appears in the head tags:

<html>
<head>
<meta name="title" content="first page title">
<meta name="description" content="first page desc">

and, of course, if I change the id = 1 to id = 2, the info then changes to the page 2 content, which is great. But it remains constant for any page.

You are correct that the page function appears lower in the code.

Do you know if there is a way to change the WHERE portion of the SELECT so that it pulls the data correctly? or am I way off base? <smiles>

Thanks for your interest in this, and for all your help.