refresh a page after inserting data

prinzcy

hi! i need to ask how refresh a page after inserting a data. i use :

print"<a href=\"update_budg.php?ras_num=$ras_num&update=1\" onClick=\"javascript: return confirm('Are you sure you want to do this?'); return;\">Update?</a>";

this link to update in other page. value is automatically insert and from "update_budg.php" , i will return to the previous page. the problem is the link is still exist although data already being insert into the database. it will dissappear after i click on the refresh button.

is there is other way for me to refresh it itself as soon as the data has been insert.

thank you

Hiccup

Use Javascript as follows:

function redirect($ras_num) { 
echo"<script>window.location.href=\"update_budg.php?ras_num=$ras_num&update=1\"</script>";
}

// call it anywhere you want in the script with:

redirect($ras_num);

broc7

If "update_budg.php" opens in a new window (with a target=\"update\" in the a tag), you can use javascript to close "update" and refresh the window that opened it:

After update does its sql update, print this javascript to it:

if(window.opener){
window.opener.location.reload();
window.close()
}

I use this a lot for updating, deleting, and adding to a db.

prinzcy

thanks for the reply for both of you

broc7,

can i ask more of this pls. i've tried the code but i don't really know how to. i place it in the new window - "update_budg.php" but it doesn't work. perhaps i missplaced it or i don't specify the location it will return.

broc7

It should work. Put a print statement in the javascript to see if the script is being run. The script doesn't need to know the opener's name or location. window.opener is enough to identify the window that opened update.

Is update opening in a new window?

prinzcy

yes it is. mmm...still doesn't work. i do use javascript

broc7

The way I do it is, in the new window, print out standard html from the opening html tag through the opening body tag, start a php script which includes the update sql statement, and print an opening javascript tag, the javascript I posted earlier, and a closing script tag.

All the client sees is javascript after the body tag telling it to reload the window that opened it and to close itself. If it's not working look at the new window's source and see if there's anything wrong with the javascript.

prinzcy

:o i'm so sorry. i have minsunderstood your question and post a worng reply (indeed...) so sorry.

actually it doesn't open in a new window. it open in the same window but different page.

i'm getting blank...

broc7

If you want someone to click on a link and have the page refreshed to show the data changes, the best way to do it is to have the link set for the same page. Programming would determine whether anything should change in the db on each page load- whether it was loaded after a change or for the first time with no change request.

if($_GET["whatever"]) {
run some update query
}

run a select query // will get any info updated above

display results

prinzcy

ummm.....

let me understand this well. what i need to do is use $_GETS to retrieve variable. how do i send the variable using the link then?

broc7

You already did that with:

print"<a href=\"update_budg.php?ras_num=$ras_num&update=1\"

So you retrieve ras_num and update through $_GET[""]'s, right?

Instead of figuring out how to reload the first page so that it shows the updated information, set the link to the same page. The user will do the reloading for you by clicking on the link. When the page is processed by the server the second time, it would run the update query and then the select query so that the updated info is sent to the client.

prinzcy

geez~ i can't try this yet. my server's down. as i understand, post the variable with the link to the same page. use $_GET to retrieve the variable and then update the variable, finally display. can i use the same page to display or should i display at another page?