Issue Redirecting in php

Question

I have a form that works (input data is transferred to Mysql database and redirects back to index.php) in my XAMP local sever but when I copy the files and code to my online hosting my data is uploaded to the database but the program is failing to redirect. Please have a look at my redirect code and let me know of any possible solutions.

// Insert
public function insert($query) {
    $insert_row = $this->link->query($query) or die($this->link->error.__LINE__);
    //Validate Insert
    if($insert_row) {
        header("Location: index.php?msg=".urlencode('Record Added'));
        exit();
    } else {
        die ('Error : ('.$this->link->error.') '.$this->link->error);
    }
}

* This is just my insert function, with a redirect if insert is successful.

Like I said this functions works great in XAMP. I am new to this. — nj167252, Jun 14 '17 at 21:47
The database query works in XAMP, but you don't know if it works online? — Jay Blanchard, Jun 14 '17 at 21:49
I am running the exact same code online as in XAMP and getting different results. I think this is route cause because the rest of it is working as intended... uploading inputted data to the database the last step is to be redirected back to index.php — nj167252, Jun 14 '17 at 21:51
Then there is something different online. You need to check your error logs. — Jay Blanchard, Jun 14 '17 at 21:52
After my input query I run this... $insert_row = $db->insert($query); which I guess refers to the function I'm struggling with. — nj167252, Jun 14 '17 at 21:54
You could echo out a javascript redirect https://stackoverflow.com/questions/4744751/how-do-i-redirect-with-javascript - does that work? — Usman Shahid, Jun 14 '17 at 22:04
Thanks Usman Shahid. That work wonderfully!! Do you know why my php redirect failed though? — nj167252, Jun 14 '17 at 22:14
can you turn off error reporting `error_reporting(0);` and try again, i think there is something echoing before this redirect statement. — Dileep Kumar, Jun 15 '17 at 06:33

score 0 · Answer 1 · answered Jun 14 '17 at 23:02

0

header("Location: index.php?msg=".urlencode('Record Added'));.

Make sure that you are not echoing out any HTML, or any other sort of text at all, before that statement is reached. Otherwise, your redirect will fail.

answered Jun 14 '17 at 23:02

Tim

810
9
20

Issue Redirecting in php

1 Answers1