Can I redirect before inserting data?

[Code.Warrior]

At the moment I'm adding a record to mysql and using header() to redirect the user.

Would it be better if I put the header() command before the insert statement or won't that make any difference? i.e. can the user be redirected without having to wait for the insert to complete?

[spikeZ]

One way or another, the insert has to be done so personally I would do the insert and then redirect.

JMHO

Spike

[clamcrusher]

generally, if some part of my script needs to be executed, i do it first before i tell the browser to go elsewhere.

if you really need to make sure part of your script is executed, you can also look at ignore_user_abort()

[Code.Warrior]

Thanks for the replies. It's actually more important that the user get's redirected than the database is updated on this occasion.

Just wondered if it actually made a difference if one statement was before the other.

[Code.Warrior]

Anyone know if it makes a difference to the order?

[skeeterbug]

Anyone know if it makes a difference to the order?

unless your insert is MASSIVE, the difference will be negligible. as in imperceptible. try it and see if it is ok.

you could redirect to another page and then process the insert, but it will require sessions and increase the complexity of your code.

[trib4lmaniac]

Sending the header does not stop the script from finishing it's execution. A header is a browser instruction. You can put them either way.

Edit:

But whether or not the browser requests the new page before your script has finished, is another matter.