[RESOLVED] PHP & refreshing

[phprocks2009]

Hi all,

I have created a template using PHP, the template is used throught my website, However, when I add a new menu item into mysql database the menu on the template pages does not get updated until I make an update on that particular page. Is there a way that I can get round this?

[djjjozsi]

yes, its called:

header("Location: somewhere_you_like_to_go.php");

[phprocks2009]

i've already tried that but it didn't seam to do the trick. Below is the code which I currently have.

<?php
include '/home/jon1984/public_html/central_methodist_church/includes/database.php';
include '/home/jon1984/public_html/central_methodist_church/includes/header.php';
include '/home/jon1984/public_html/central_methodist_church/includes/menu.php';
include '/home/jon1984/public_html/central_methodist_church/includes/footer.php';

echo $header;
echo $dynamic_menu;
echo $menu;

if(isset($POST["filename"]))
{
$filename = $POST["filename"];
$extension = ".php";
$file = $filename.$extension;
$content = $POST["content"];
$submenu_id = $POST["content_category"];
$content_heading = $POST["content_heading"];
$content_subheading = $POST["content_subheading"];
$content_status = $POST["content_status"];
$SESSION['page_name'] = $file;
$heading = <<<HEADING
<h1>$content_heading</h1>
HEADING;

$subheading = <<<SUBHEADING
<h2>$content_subheading</h2>
SUBHEADING;

$content_structure = <<<STRUCTURE
<p>$content</p>
STRUCTURE;

$file_location = "/home/jon1984/public_html/central_methodist_church/cms/$file";
$new_location = "/home/jon1984/public_html/central_methodist_church/$file";

if(file_exists($filename))
{
echo $filename . " already exists";
}
else
{
$sql = "INSERT INTO my_menu (menu_name,submenu_id) VALUES('$content_subheading','$submenu_id')";
$result = mysql_query($sql);

$sql2 = "INSERT INTO my_content (filename,content,content_status,content_heading,content_subheading,date_added) VALUES('$file','$content','$content_status','$content_heading','$content_subheading',now())";
$result2 = mysql_query($sql2);

$fp = fopen($file, "w") or die ("Couldn't open $file");
fwrite($fp,$header . $dynamic_menu . $menu . $heading . $subheading . $content_structure . $footer);
fclose($fp);

echo "The following page has been created " . $file;
echo "<br />";

copy($file_location, $new_location);
echo "The page has been moved to the following location : " . $new_location;
echo "<br />";

unlink($file);
echo "The page has been deleted from the temporary location";
}
}
else
{
$form = <<<FORM
<form name="add_content" action="add_content.php" method="post" />
<label for="filename">filename</label>
<input type="text" name="filename" /><br />
<label for="content_category">content category</label>
<select name="content_category">
FORM;

$sql = "SELECT * FROM my_menu WHERE submenu_id = 0";
$result = mysql_query($sql);

while($row=mysql_fetch_assoc($result))
{
$menu_name = $row['menu_name'];
$menu_id = $row['menu_id'];
$form .= <<<FORM
<option value=$menu_id>$menu_name</option>
FORM;
}

$form .= <<<FORM
</select><br />
<label for="content_heading">content heading</label>
<input type="text" name="content_heading" /><br />
<label for="content_subheading">content subheading</label>
<input type="text" name="content_subheading" /><br />
<label for="content_status">content status</label>
<select name="content_status">
<option value="draft">draft</option>
<option value="live" selected="selected">live </option>
</select><br />
<label for="content">content</label>
<textarea name="content" cols="50" rows="5"></textarea><br />
<input type="submit" value="add content" />
</form>
FORM;
echo $form;
}
echo $footer;
?>

[djjjozsi]

And where is the header() in your code?

phprocks2009;10935084 wrote:

i've already tried that but it didn't seam to do the trick. Below is the code which I currently have.

Example:

<?php
session_start();
function mres( $string )
{
    if ( get_magic_quotes_gpc() ) {
        $string = stripslashes( $string );
    } 
    return mysql_real_escape_string( $string );
} 

if ( isset( $_SESSION["message"] ) ) {
    echo $_SESSION["message"];
    unset( $_SESSION["message"] );
} 

if ( !empty( $_POST["submit"] ) ) {
    if ( empty( $_POST["f_a"] ) )
        $error[] = "A is a required field."; // Check if A is empty.
    if ( empty( $_POST["f_b"] ) )
        $error[] = "B is a required field."; // Check if B is empty.
    if ( empty( $error ) ) {
        $f_a = mres( $_POST["f_a"] );
        $f_b = mres( $_POST["f_b"] );

    $sql = "INSERT INTO test (`a`,`b`) VALUES ('$f_a','$f_b') ";

    mysql_query( $sql ) or die( mysql_error() );
    $_SESSION["message"] = "Inserted succesfully";
    header( "Location: " . $_SERVER["PHP_SELF"] );
} else
    print $error;
} //if submit has pressed!
/* FORM COMES HERE */

?>

[phprocks2009]

it is in the header include file:-

HEADER('Location: $_SESSION[page_name]');

[djjjozsi]

on the top of your page before nothing had happened ? see the previous example code

[phprocks2009]

in the header include file i have
1.<?php
2.session_start();
3.Header('Location: $_SESSION[page_name]');

[djjjozsi]

if i cannot explain it, lets read the manual: header()

header("Location: previous.php"); // you then goes to the previous file!
event1
event2
event3
event4 - event4 sets the $_SESSION['page_name'] ....
here you need to send the header to go to the created file

How you get in the car? you accelerate before you would get in ?