[RESOLVED] need to add page names to globals.php file

unitedintruth

I am adding an editor on a website so it can be more easily updated without html.

All working fine until this small issue.

When I add the page_content to the database table for a page, I then have to open globals.php and edit the file adding that page name to this line of code that reads:

// 1. Define an array of allowed $_GET values:
	$pass = array('home','amra_history','about_amra','about_amra','registration','pedigree','standard','links','breeders1','puppies','breedingbetterdogs');

is there a way to have that array list the page names dynamically so the person editing does not have to open globals.php at all?

Maybe like this:

$query="SELECT page_name FROM _content WHERE page_name='". * ."'";;

or something to that effect.

Thanks,
Donnie

Kudose

I store the file names and ID's in the database with a select field to choose which file to edit.

To display them, I check the requested page against the database and display it if appropriate.

The only way to store the pages without editing a file would be to store them in the database.

unitedintruth

I can't put my globals.php in the database. The connection to the db is in that file.

I have the page_names and page_content in the database already, what I want is the page_name field to populate my get array values . (The field I am wanting it to populate from the database is commented as #1.)

Maybe I can make more sense if I include my globals.php code and leave the comments in it.

function getPage()
	{
  $localhost="myhost";
  $username="myname";
	$password="mypassword";
	$database="mydatabase";

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

// 1. Define an array of allowed $_GET values:
	$pass = array('home','amra_history','about_amra','about_amra','registration','pedigree','standard','links','breeders1','puppies','breedingbetterdogs');


// 2. If there is no $_GET['id'] defined, then serve the homepage:
	if (!isset($_GET['id'])) {
	 $id="home";
	}

// 3. If the page is allowed, include database retreival
	elseif (in_array($_GET['id'], $pass)) {
	$id = $_GET['id'];
	}

// 4. If the page is not allowed, send them to an error page:
	else {
	 $id="error";
	}

$query="SELECT page_content FROM _content WHERE page_name='". $id ."'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
	$content=mysql_result($result,$i,"page_content");
	echo $content;
	$i++;
	}
}

The values I need to populate in globals.php is the same value as the page_name field in the database.

Isn't there a select and echo or post query that could serve that purpose?

Thanks,
Donnie

Kudose

I see what you mean now.

$sql = mysql_query("SELECT DISTINCT page_name FROM _content ORDER BY page_name ASC");
$pass = array();
while(($data = mysql_fetch_array($sql, MYSQL_ASSOC)) !== FALSE)
  $pass[] = $data;

unitedintruth

Where would I put that in my code?

I tried to replace the array in #1 with your code, but got empty pages instead of my page_content from the database.

Thanks,
Donnie

Kudose

Do you receive any errors?

When you print_r $pass, do you get any values?

unitedintruth

No I didn't receive any errors. you know how that array in globals.php had the line that reads:

$pass = array('home','amra_history','about_amra','about_amra','registration','pedigree','standard','links','breeders1','puppies','breedingbetterdogs');

those values are my current page names. when I then aim my browser to a url like "http://www.mydomain.com?id=home" it will retrieve the contents of the "home" table in the sql and post it on the page where I define the value

<?php getPage(); ?>

in my index.php page. of course if the value home is not in the array then I actually get no error, just no content shows for the value "home" and my page only contains header, navigation, footer, copyright but no content.

When I replace that array in the globals.php file with the code you gave me it simply doesn't give me page content for that value home as if it was not defined in globals.php.

I hope that makes sense, I am still learning the lingo to be able to call stuff the right thing.

Thanks again for all your time. I look forward to the day that, because of all the help I get from you all, I too will have the ability to contribute and help those that are in the newbie stage that I am in now.

Thanks,
Donnie