not being redirected to the required page

Question

<?php 
    if(isset($_POST['sub']))
    {
    $mname=$_POST['sub'];
    }
    if(isset($_POST['pos']))
    {
    $pos=$_POST['pos'];
    }
    if(isset($_POST['rad1']))
    {
    $vis=$_POST['rad1'];
    }
 ?>

<?php 
 global $mname, $pos, $vis;

        if(isset($mname) && isset($pos) && isset($vis))
        {
        $q= "INSERT INTO subjects (menu_name, position, visible) VALUES ('$mname', $pos, $vis) ";
        $qs=mysql_query($q, $connection);
        if($qs)
        {       echo "hi";
                header("Location: content.php");
        }
        else{
            echo mysql_error();
        }

    }

?>

There is a form which is posting 'sub', 'pos' 'rad1'
its getting stuck at http://localhost/widget_corp/create_subject.php?sub=whatever&pos=4&rad1=1
Its adding nothing to the database, but the id is getting auto incremented.

Why isn't it redirecting to content.php?

I have no idea what you are asking here. The information provided by you is incomplete and it has nothing to do with `phpmyadmin` — Mr. Alien, Jan 24 '15 at 08:07
Also I don't see any `function` used so not sure why you are using keyword `global` and even if you use functions there is no need to use global variables, consider passing the variables as function params instead — Mr. Alien, Jan 24 '15 at 08:12
Try to add `ob_start();` at the first line of your code immidiately after ` — Aadil Keshwani, Jan 24 '15 at 08:15
I'm new to php. i didn't understand 'How to fix “Headers already sent” error in PHP' Please help — Ashwin Kannan, Jan 24 '15 at 08:17

score -2 · Answer 1 · answered Jan 24 '15 at 08:12

Try this.

 <?php 
if(isset($_POST['sub']))
{
$mname=$_POST['sub'];
}
if(isset($_POST['pos']))
{
$pos=$_POST['pos'];
}
if(isset($_POST['rad1']))
{
$vis=$_POST['rad1'];
}

if(isset($mname) && isset($pos) && isset($vis))
    {
    $q= "INSERT INTO `subjects` (`menu_name`, `position`, `visible`) VALUES ('$mname', '$pos', '$vis') ";
    $qs=mysql_query($q, $connection);
    if($qs)
    {     
            header("Location: content.php");
    }
    else{
        echo mysql_error();
    }

}

?>

not being redirected to the required page

1 Answers1