php refresh page

[kproc]

hi

is there a php function that I can add to my code to refresh the page after it comes to the end of my script.

thank you

[delr2691]

no.. if you've already sent content, you can not "refresh" the page..
you can send some headers to change the location but just before sending any content..

header("Location: http://your.domain.com/bla.php"); 

But you may wanna try JavaScript to do so..

[Jick]

You could echo a refresh meta tag at the end of the script just before it exits. Like this:

<?php
# Your script here...
# Your script here...
# Your script here...

echo('<meta http-equiv="refresh" content="20">');
?>

Could that work...? I'm not exactly sure if that will work but it was just an idea that popped into my head when I read your post. I'm sorry if it doesn't work. If it does, I hope that helps.

[kproc]

no, does nothing, thank you for taking time to post

[NogDog]

First question: why do you need to refresh your page at the end of your script? (I can't think of a reason why you would, but that doesn't mean there isn't one.)

[kproc]

I have a form that deletes data from a table. The user chooses the item from the active page and presses the button. The item is deleted but they have to click a link to refresh the page.

[NogDog]

Well, it seems if you did the form processing and database update and then generated your page output, there would be no reason to refresh -- but maybe I'm missing something?

[kproc]

attached the code to give an idea what is happening. I working with the delete section

I thought that when I get the end the delete it would reload the table but no such luck

<?

include 'db.php';

$active_id = $_SESSION['user_id'];

$buddy_id = $_POST['addbuddy'];

$array = explode(",",$buddy_id);

$post_b_id = $array[0];
$first_name = $array[1];
$last_name = $array[2];


$query = mysql_query("SELECT * FROM buddylink WHERE owner_id ='$active_id'") or die ("Search Error" .mysql_error());

    $tbl .= "<form name='dBuddy' method='post' action='addbuddy.php'>";
    $tbl .='<table width="200" border="1" cellspacing="2">';
      $tbl .='<tr>';
    $tbl .='<td>Delete</td>';
    $tbl .='<td width="303">Name:</td></tr>';

while($r=mysql_fetch_assoc($query)) {

$f_name = $r['first_name'];
$l_name = $r['last_name'];
$b_id = $r['buddy_id'];

 
 $tbl .= "<tr><td align=center><input type=radio name='deletebuddy' value='$b_id'></td>";
 $tbl .="<td><a href='SearchDetails.php?owner_id=$b_id'>$f_name $l_name</a></td></tr>";
 
}

$tbl .="</table>"; 
$tbl .= "<input align=left type='submit' name='submit' value='Delete>";
$tbl .= "</form>";

if($buddy_id != ""){

// ADD TO TABLE
$sql = mysql_query("INSERT INTO buddylink (owner_id, buddy_id, first_name, last_name, added)VALUES('$active_id', '$post_b_id', '$first_name', '$last_name', now())")or die ("Link Create Error:" .mysql_error());



}

$d_buddy = $_POST['deletebuddy'];

if($d_buddy != ""){

mysql_query("DELETE FROM buddylink WHERE buddy_id = '$d_buddy'");

echo 'Buddy has been deleted';



}
echo $tbl;

?>

[delr2691]

you are creating the whole html output before deleting the entry.. the page wont show the updates not even when you add.. you can try this instead:

<?

include 'db.php';

$active_id = $_SESSION['user_id'];

$buddy_id = $_POST['addbuddy'];

$array = explode(",",$buddy_id);

$post_b_id = $array[0];
$first_name = $array[1];
$last_name = $array[2];





if($buddy_id != ""){

// ADD TO TABLE
$sql = mysql_query("INSERT INTO buddylink (owner_id, buddy_id, first_name, last_name, added)VALUES('$active_id', '$post_b_id', '$first_name', '$last_name', now())")or die ("Link Create Error:" .mysql_error());



}

$d_buddy = $_POST['deletebuddy'];

if($d_buddy != ""){

mysql_query("DELETE FROM buddylink WHERE buddy_id = '$d_buddy'");

echo 'Buddy has been deleted';



}




$query = mysql_query("SELECT * FROM buddylink WHERE owner_id ='$active_id'") or die ("Search Error" .mysql_error());

    $tbl .= "<form name='dBuddy' method='post' action='addbuddy.php'>";
    $tbl .='<table width="200" border="1" cellspacing="2">';
      $tbl .='<tr>';
    $tbl .='<td>Delete</td>';
    $tbl .='<td width="303">Name:</td></tr>';

while($r=mysql_fetch_assoc($query)) {

$f_name = $r['first_name'];
$l_name = $r['last_name'];
$b_id = $r['buddy_id'];


$tbl .= "<tr><td align=center><input type=radio name='deletebuddy' value='$b_id'></td>";
$tbl .="<td><a href='SearchDetails.php?owner_id=$b_id'>$f_name $l_name</a></td></tr>";

}

$tbl .="</table>";
$tbl .= "<input align=left type='submit' name='submit' value='Delete>";
$tbl .= "</form>";

echo $tbl;

?>

Hope that works..

[kproc]

thank you for the reply are fixing up my code. I figured I was doing somthing wrong

I have been testing if user has posted by ($variable != ""){

code .............
}

Is this a good way to do this or is there a better way.

[delr2691]

Your welcome
And I guess you should do it this way.. [well, actually is the way I'm used to ]

if (isset($_POST['input']) && !empty($_POST['input'])) {
 //add, delete or anything here..
} else {
 //just output the table
} 

[NogDog]

Just be aware that when you do a "==" or "!=" comparison or when using the empty() function; the values 0 (zero), "" (empty string) and the boolean FALSE constant are all treated as equivalent. Therefore, if zero or a boolean false is a valid entry, then you should use "===" or "!==" against an empty string when doing your comparison. Plus, I normally trim() the inputs first to get rid of leading/trailing spaces:

foreach($_POST as $key => $val)
{
   $_POST[$key] = trim($val);
}
if(isset($_POST['input']) and $_POST['input'] !== '')
{
  // good to go
}
else
{
  // missing a required entry
} 

[arcticwarrio]

header('Location: '.$_SERVER['PHP_SELF']); 

[snipe42]

header('Location: '.$_SERVER['PHP_SELF']); 

i use this,but inside a form.

<form name='myform' method='post' action='".$_SERVER['PHP_SELF']."?action=del'> 

but script for getting del action is above it.

if ($_GET['action'] == "del")
{
   // get the hidden value
   $n = $_POST['n'];

   for ($i=0; $i<=$n-1; $i++)
   {
     if (isset($_POST['NPM'.$i]))
     {
       $NPM = $_POST['NPM'.$i];
       $query = "DELETE FROM mahasiswa WHERE NPM = '$NPM'";
       mysql_query($query);
     }
   }
} 

it's didnt show you any message, but its actually refresh the page.

[AdelineZ]

Hi there!

I have a similar problem.

I want to delete from a table of mysql database. My problem is that after i delete a second record, only if i press 'Ctrl+F5' that record disapear.Meanwhile, from the database that record is deleted. What should i do? I have to complete that i'm working on apache server, on localhost, there was no problem.

Thanks !

This is the code:

<?php
            ob_start();
                    
            include "conectarebd.php";
            $idul=$_GET['id'];
            mysql_query("DELETE FROM angajator WHERE id='$idul' ") or die(mysql_error());
    
            header('location: http://domain.ro/edit_angajator_button.php'.$random);
    
?>