Form

[tommyrulez]

I have a form which is called from another page. I have finally gotten it into the variables (thanks to all those that helped 🙂 ). But, now, when I click submit the form loads into a new window.

<?php
error_reporting(E_ALL);
include 'function.php';

if (isset($_POST['submit'])){

// check to see if hidden field is empty
foreach($_POST as $key => $row)

//Check to see if hiddenfield is filled
$row= trim($row);
if((!$row == "") && ($key=="thishiddenfield"))

{   //reset form if true

close($con);
header ("locate: ./Topten/topten.php");
exit();

}  //Check to see if all fields are filled
else{
if($row == ""){
echo 'Sorry, but '.$key.' is empty.';
close($con);
exit();
}
}
$sdata;

// insert the user and date.
include 'db.php';
$con;
$mydb;
$dbname;
$sql2;
$result;
$myinsert2;
exit();
}   

?>
<form action="/Topten/bin/lib/Pollform.php" method="POST" name="pollForm" id="currentsurvey">
  <table width="100%" border="1" cellspacing="5" cellpadding="3">
    <tr>
      <td width="30%"><input name="fc" type="text">
      </td>
      <td width="70%" rowspan="12" align="left" valign="top">Welcome to this month's Survey. This month you get to decide: THE GREATEST MOVIE EVER!!!!<br />
        There are fifteen fields to enter your favourites. Choose wisely, because you can enter your choices only once. </td>
    </tr>
    <tr>
      <td><input  type="text" name="sec">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="tc" >
      </td>
    </tr>
    <tr>
      <td><input type="text" name="foc" >
      </td>
    </tr>
    <tr>
      <td><input type="text" name="fic" >
      </td>
    </tr>
    <tr>
      <td><input type="text" name="sic">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="sevc">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="ec">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="nc">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="tec">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="fac">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="seac">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="tac">
      </td>
    </tr>
    <tr>
      <td><input type="text" name="foac">
      </td>
    </tr>
    <tr>
      <td ><input type="text" name="fiac">
      </td>
    </tr>
  <td height="32" width="100%" colspan="2" align="center" valign="middle" >
  <input type="hidden" name="thishiddenField" id="thishiddenField" value="" >
    <br/>
    <input name="submit" type="submit" value="Submit" >
    </td>
  </tr>
  </table>
</form>

I know it's because this.

<form action="/Topten/bin/lib/Pollform.php" method="POST" name="pollForm"

Ok, so I try:

<form action="<?php echo $_SERVER['PHP_SELF'];?>"

Which does work to some extent, but nothing gets loaded into my variables and I get multiple entries into my other db.

[bradgrafelman]

Not sure what you mean 'loaded into [your] variables', but one problem I see is this:

// insert the user and date. 
include 'db.php'; 
$con; 
$mydb; 
$dbname; 
$sql2; 
$result; 
$myinsert2; 
exit()

Other than including db.php, that code doesn't do anything. You've just got a list of variable names, but you don't assign any values to them or use their values or do anything at all to them. It's essentially the same code as this:

include 'db.php';
exit();

EDIT: Some other problems...

close($con);
header ("locate: ./Topten/topten.php"); 

AFAIK, there is no such HTTP header called "Locate" - perhaps you meant "Location:" instead? In addition, there is no such function called close().

You've also got the same issue as above here:

$sdata;

Again, that code does absolutely nothing.

[Pikachu2000]

Something here: header ("locate: ./Topten/topten.php"); doesn't look quite right . . . Should be "Location: http://www.domain.com/[path]" , no?

EDIT: Brad beat me to that one . . .

[tommyrulez]

function setdb($sdata)
{
include 'db2.php';
$con;
$db;
$mydb;
$mysql;
$myresult;
$returned_rows = mysql_num_rows ($result);
if ($returned_rows == 0){
$fc=$_POST['fc']; 
$sec= $_POST['sec']; 
$tc= $_POST['tc']; 
$foc= $_POST['foc']; 
$fic= $_POST['fic']; 
$sic= $_POST['sic']; 
$sevc= $_POST['sevc']; 
$ec= $_POST['ec'];
$nc= $_POST['nc']; 
$tec= $_POST['tec']; 
$fac= $_POST['fa']; 
$seac= $_POST['sea']; 
$tac= $_POST['ta']; 
$foac= $_POST['foa']; 
$fiac= $_POST['fia']; 
$fcount=1;
$secount=1;
$tcount=1;
$focount=1;
$ficount=1;
$sicount=1;
$sevcount=1;
$ecount=1;
$ncount=1;
$tecount=1;
$facount=1;
$seacount=1;
$tacount=1;
$foacount=1;
$fiacount=1;
$sdata= filter($sdata);
  $myinsert;
  mysql_close($con);
}
}

Here is my DB.php code. It works, it just puts multiple entries into my users table.

<?php
$con=mysql_connect('localhost', 'xxxxxx_xxxxxx', 'xxxxxx');
$dbname = 'xxxxxx_xxxxxxl';
$mydb= mysql_select_db($dbname,$con);
$sql2 = mysql_query("SELECT date,user FROM users");
$result=mysql_query($sql2);
$myinsert2=mysql_query("INSERT INTO users (date,user) VALUE (CURDATE(),'$pUser')")or die (mysql_error());
?>

I changed locate to location.

Would I be better off using:

$fc->$_POST['fc'];  ??