PHP - Problem With Cookies - Value Disappears On Page Reload

The Script:

<h1>Do Add a Message to the MySQL Database</h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
    <textarea name="message"></textarea>
    <br/>
    <input type="submit" name="submit"/>
</form>

<?php
// The Connection to the Database
// Taken Out

?>

<?php
// To insert the text data into the MySQL database.
if(isset($_POST['submit'])){

$tqs = "INSERT INTO messages (`message`) VALUES ('{$_POST['message']}')";

$tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

}

?>

<?php
// To select the text data from the MySQL database.
$tqs = "SELECT * FROM messages";
$tqr = mysqli_query($dbc, $tqs);


// To print out the text data inside of table on the page.
echo "<h1>This Is Where the Messages Gets Printed on Screen</h1>";
echo "<table><tr><td>ID</td><td>The Message</td></tr>";

while($row = mysqli_fetch_assoc($tqr)){

    echo "<tr><td>" . $row['id'] . "</td><td>" . $row['message'] . "</td></tr>";

}

echo "</table>";

?>

1. When I have added text with the form to the MySQL database... 2. ... and I have clicked on "page reload" in Firefox to reload the page... 3. ... then the before submitted text gets submitted again to the MySQL database.   So basically, add text with the form to the MySQL database, reload the page in Firefox, and the before added text will get submitted to the MySQL database again.   My Question Is: What is the proper way to avoid this?
Edited by glassfish, 06 October 2014 - 10:18 AM.

For those willing to run this sample problem, reference the 2 files below. You will need to create an Excel file called blank.xls and put it in the same directory as these 2 files.

When you launch indexTest.php, it will load the formTest.html.php page. This form has 3 options on it:
1. Export Excel - will prompt you to download the Excel file you made and should clear the error message on the form
2. Test Flag - tests the functionality of clearing the error message, shows what should happen when the Export Excel option is selected
3. Reset - resets back to initial state

I really need the Export Excel option to be allow the form to reload properly.

This is a problem that I have been wresting with for awhile and need a solution. Hopefully someone can give me some insight on how to get this to work.

indexTest.php

<?php
  $frmErrorLevel=1;
  $frmErrMsg='Error Level 1 indicated';
  
  if(isset($_POST['action']) && $_POST['action']=='submitted')
  {
      if(isset($_POST['ExportCarrier']))
      {
          $download_filename = "blank.xls";
          $FileInfo = pathinfo($download_filename);
          // fix for IE catching or PHP bug issue
          
          header("Pragma: public"); 
          header("Expires: 0"); // set expiration time 
          header("Cache-Control: must-revalidate, post-check=0, pre-check=0");  

          // browser must download file from server instead of cache 
          // force download dialog 
          header("Content-Type: application/force-download"); 
          header("Content-Type: application/octet-stream");
          header("Content-type: application/x-msexcel");
          header("Content-Type: application/download"); 

          // use the Content-Disposition header to supply a recommended filename and  
          // force the browser to display the save dialog.
          header("Content-Disposition: attachment; filename=".$download_filename.";"); 
          header("Content-Transfer-Encoding: binary");
          header("Content-Length: ".filesize($download_filename)); 
          @readfile($download_filename);
        //ob_end_clean(); 
        $frmErrorLevel=0;
      }
      if(isset($_POST['Test_Flag']) && $_POST['Test_Flag']=='Test Flag'){
          $frmErrorLevel=0;
          $frmErrMsg='';
      }
  }
  include ('formTest.html.php');
  exit();
?>

formTest.html.php

<?php   
    ini_set ("display_errors", "1");
    error_reporting(-1);
    echo "<pre>";
    echo "--> Form data (POST) <-- <br>";
    print_r ($_POST);
    echo "--> Form data (GET) <-- <br>";
    print_r ($_GET);
    echo "</pre>";
?>
<!DOCTYPE html>
<html lang="en">

    <head>
        <meta charset="utf-8">
        <title>Export Trucking Data</title>
    </head>
    <body>
        <h1>Export Data</h1>
        <form action="" method="post">
        <?php   
            if($frmErrorLevel>0)
            {
                echo '<font color=#CC6600 size=+1>'.$frmErrMsg.'</font><br><br>';
            }
        ?>
        <table width="650" border="0">
            <caption>
                <font size="+3">Data Export Options</font>
            </caption>
            <tr>
                <td>
                    <?php 
                        if($frmErrorLevel==1) print '<img src= "..\..\images\rdx.gif">'; 
                        else echo "&nbsp"; 
                    ?>
                </td>
                <td width="275"><label> Carrier table data</label></td> 
                <td width="100"><input name="ExportCarrier" type="submit" value="Export Excel"></td>
                <td> <div align="center"> <td><input type="submit" name="Test Flag" value="Test Flag"></td>
                <td> <div align="center"> <td><input type="submit" name="Reload Form" value="Reset"></td>
            </tr>
 
        </table>
        <div>
            <input type="hidden" name="action" value="submitted" />
        </div>
    </form>
    </body>
</html>

Hello,


It's as subject says.


Here is the code:


<? 
//Config
include_once "../../config/config.php";


//Variables
$username = $_POST["username"];
$username = mysql_real_escape_string($username);


$password = $_POST["password"];
$password = md5($password);


//Check for User
$query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$query = mysql_query($query);


//If user not found
if(mysql_num_rows($query)!="1") {
   echo "No User Found";   
}


//If User Found
else {


   while($row=mysql_fetch_array($query)) {
      $fname = $row["fname"];
      $lname = $row["lname"];
      $userid = $row["id"];
      $admin = $row["admin"];
   }
   
   setcookie("fname", "$fname");
   setcookie("lname", "$lname");
   setcookie("userid", "$userid");
   setcookie("admin", "$admin");
   
   header('Location: ../../../portal/index.php');
   
}


?>


On the page it forwards to, I write


print_r($_COOKIE);


Yet it doesn't show my newly set cookies, yet the above snipped does on the script code above.


George

Hello

I'm trying to build a plugin to get my site up to scratch for the new EU laws on cookies coming in place on the 26th

What my main goal is a notification that when the users click accept the cookies set on machine but untill a "approval" cookie is found the site shouldn't set any cookies.

Ive written this code, which allows me to set & unset a cookies via a form, using php and html, then depending on the submission either set or unset (which is a good start because im a noob!)

but: the page needs an extra refresh in order to show the set cookie? does anyone know why or how i can resolve this?

kind regards, and thank you

Code: [Select]
<?
$set = $_POST["set"];

  if($set == "on")
setcookie(EURegulations, $set, time() + (20*365*24*60*60), www.domain.net);
else
  if($set == "off")
setcookie("EURegulations", "", time()-3600);
?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>EU Cookie Plugin</title>
</head>

<body>

<?php
  if (isset($_COOKIE["EURegulations"])) 
  echo "Cookie Permission " . $_COOKIE["EURegulations"] . "!<br />";
else
  if(!isset($_COOKIE["EURegulations"]))
echo "Cookie Permission off";
else
echo "Error no cookie Set";
?>

<form name="setform" method="post" action="<?php echo $_SERVER['$PHP_SELF'];?>">
<button name="set" type="submit" value="on">On</button>
<button name="set" type="submit" value="off">Off</button>
</form>

</body>
</html>

Hi,
I've a small form, having two fields username and password. and a checkbox remember. i want to auto fill username and password field if i login by enable checkbox remember. i put following code to do that:
                    if(isset($loginform['txtrememberme']))
          {
             setcookie('txtusername', mysql_real_escape_string($loginform['txtusername']), time()+60*60*72, '/', '', 0);
            setcookie('txtpassword', mysql_real_escape_string($loginform['txtpassword']), time()+60*60*72, '/', '', 0);
         }
after login, when i logout and come back to login page, it didn't save the values.
can anyone help please?

Hello, im having a bit of a problem...im running a function which declares a session or cookie depending on if the user wants to be remembered...after they have been set, im trying to run another function which based on the session type, does something else...the thing is that when my function to declare the session type is run if it is session it executes the 2nd function just fine because $_SESSION['whatever'] is declared...when the session type is a cookie though my 2nd function indicates that no session type has been specified...if i refresh then it will say a cookie session has been started...while my 2nd function says that there is no session type specified, if i view cookies with my browser it shows them....is this something to do with the time it takes to set a cookie or why is this happening?

heres an example:
Code: [Select]
<?php

class test1{
     function funct_1(){
          //This part will  declare session type setcookie or $_SESSION[] = '';
     }
     function funct2(){
          $this->funct_1();
          if(isset($_SESSION['whatever'])){
               echo 'Session has been set'; //this one works fine if user logs in with session
               die();
          }else if($_COOKIE[''whatever]){
               echo 'Cookie has been set';//this is displayed when user logs in with cookie...but has to refresh the page in order for this message to 
                                                      //print although cookie does exist if you check the browser...
               die();               
          }else{
               echo'No session type has been specified';//this is what is printed out when user logs in with cookie at first
          }
     }
}
?>

I have created a login form. I am sending values through Ajax for form validation. However, I am having problem with the code that I am unable to store values in Sessions & Cookies.   I have added a "Remember me" checkbox into login form. I want to validate Boolean value using Javascript Checked property and send the data to PHP for validation.    If user clicks on remember me checkbox then the data should be stored in either Sessions & Cookies. If it is not checked then data should be stored only in Sessions. I am posting here my login form code, Ajax code & PHP code.   Could you guys help me to point out my mistake what I am doing wrong in this code?   Login Form:

<input type="checkbox" id="cb" name="cb">
<label for="cb">Remember me</label>

Ajax Code:

function login(){var e = _("email").value;
var pass = _("password").value;
var cb = _("cb").value;
if(e == "" || pass == ""){
_("status").innerHTML = "Please fill out the form";
} else {
_("loginbtn").style.display = "none";
_("status").innerHTML = 'please wait ...';
var ajax = ajaxObj("POST", "handlers/login_handler.php");
        ajax.onreadystatechange = function() {
       if(ajaxReturn(ajax) == true) {
           if(ajax.responseText == "login_failed"){
_("status").innerHTML = "Login failed, please try again.";
_("loginbtn").style.display = "block";
} else {
window.location = "message.php?msg=Hello "+ajax.responseText;
}
  }
    } 
        ajax.send("e="+e+"&pass="+pass+"&cb="+cb);
}
} 

PHP Code:

$cb = cleanstr($_POST['cb']);
if(isset($cb) && ($cb == true)) {
// IF USER CLICKED ON REMEMBER ME CHECKBOX CREATE THEIR SESSIONS AND COOKIES
$_SESSION['userid'] = $db_id;
$_SESSION['username'] = $db_username;
$_SESSION['password'] = $db_pass;
setcookie("id", $db_id, strtotime( '+30 days' ), "/", "", "", TRUE);
setcookie("user", $db_username, strtotime( '+30 days' ), "/", "", "", TRUE);
     setcookie("pass", $db_pass, strtotime( '+30 days' ), "/", "", "", TRUE); 
// UPDATE THEIR "IP" AND "LASTLOGIN" FIELDS
$sql = "UPDATE users SET ip='$ip', lastlogin=now() WHERE id='$db_id' LIMIT 1";
            $query = mysqli_query($con, $sql);
echo $db_username;
   exit();
} else {
// IF USER HAS NOT CLICKED ON REMEMBER ME CHECKBOX CREATE THEIR SESSIONS ONLY
$_SESSION['userid'] = $db_id;
$_SESSION['username'] = $db_username;
$_SESSION['password'] = $db_pass;
// UPDATE THEIR "IP" AND "LASTLOGIN" FIELDS
$sql = "UPDATE users SET ip='$ip', lastlogin=now() WHERE id='$db_id' LIMIT 1";
            $query = mysqli_query($con, $sql);
echo $db_username;
   exit();
}

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

I'm using this php web script and would like to know what happens upon log-in. I see "will auto hide when logged in". Does this mean the log-in box disappears after log-in? Does it get replaced with something? Can you read the code below and tell me? If so, what replaces it? Thanks.

Code: [Select]
<!-- start of login box - will auto hide when logged in-->
  <div id="IndexLoginGoldBox_1">
    <!--[onload_300;block=div;when [var.show_login_box]=1;comm]-->
    <div id="IndexLoginGoldBox_2">
      <div id="IndexLoginGoldBox_content">
        <div id="RelatedVideosTitle">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="font5_14">Login and start Uploading!</span></div>
        <ul class="IndexLoginGoldBox_list">
          <form name="login" action="login.php" method="POST" class="FormIndexLogin">
            <li>Username&nbsp;&nbsp;&nbsp;&nbsp;
              <input type="text" name="user_name_login" size="20" />
            </li>
            <li>Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              <input type="password" name="password_login" size="20" />
            </li>
            <li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              <input type="hidden" name="submitted" value="yes" />
              <input type="submit" value="Login Now" name="logi_n" />
            </li>
          </form>
        </ul>
      </div>
    </div>
  </div>
  <!-- end of login box -->

Hi! I'm working on a simple e-commerce script.  I have some $_SESSION variables that is defined and works fine while surfing on the site. But when I close the browser and reenter the site, all the session-variables are not defined (unset?), until i click on a link on the site. Weird behavior... please help!

/I

The option chosen in my form disappears -- both the initial default and the
option chosen are no longer visible after the value is chosen.  I use an ajax
call to refresh the page, if that's any clue.  Perhaps there's a way I can save
the value and write to the drop-down field or something?

Mark

I've added this code (below) to a file called uploader.php (attached).   When I simply open the corresponding html page, I see "Invalid upload file" in the top left corner of the page. When I remove this code from uploader.php the "Invalid upload file" disappears. Any ideas on how to resolve this will be appreciated.

$allowedExts = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $_FILES["file"]["name"]);
$extension = strtolower( end($temp) ); // in case user named file ".JPG" etc.!!!

if (  $_FILES["file"]["size"] < 200000 
      && in_array($extension, $allowedExts) )
{
    if ($_FILES["file"]["error"] > 0) 
    {
        echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
    } else {
        $length = 20;
        $randomString = substr(str_shuffle(md5(time())),0,$length);
        $newfilename = $randomString . "." . $extension;
        move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $newfilename);
      
       $file_location = '<a href="http://www.-----.com/upload/' . $newfilename . '">' . $newfilename . '</a>';
    }
} else {
  echo "Invalid upload file";
}
$description = $description . " \n " . $newfilename;

Hey--New to the forum, and php.

I have a drop-down list populated by a MySQL database.  Submitting that selection retrieves php scripts which I run using eval().  One of them is a form.  The scripts evaluate fine, but when I submit the second form, it disappears and I get a resource id where the "result" script was.  The resource ids change between 3 and 4 when I refresh the page.

Any hints on what I'm doing wrong?  Here is the main script:

<?php

$host="localhost";
$username="root";
$password="root";
$con = mysql_connect($host,$username,$password);

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("calculators", $con);

$result = mysql_query("SELECT * FROM calculator");

while($row = mysql_fetch_array($result))
  {
echo "<option type='text' " . "value='" . $row['Title'] . "'>" . $row['Title'] . "</option>";
  }

echo "</select>";
echo "<br>";
echo "<input type='submit' name='submit1'>";
echo "</form>";

$title = mysql_real_escape_string($_GET['Title']);

$result = mysql_query('SELECT * FROM calculator WHERE Title = "' . $title . '"');

while($row = mysql_fetch_array($result))
  {
$header = $row['Header'];
$calculator = $row['Calculator'];
$result = $row['Result'];
$formula = $row['Formula'];
$reference = $row['Reference'];
  }

eval('?>' . $header . '<?php ');
echo "<h2>Calculator</h2>";
eval('?>' . $calculator . '<?php ');
echo "<h2>Result</h2>";
eval('?>' . $result . '<?php ');
echo "<h2>Formula</h2>";
eval('?>' . $formula . '<?php ');
echo "<h2>Reference</h2>";
eval('?>' . $reference . '<?php ');

mysql_close($con);

?>

Thanks,

Davis

Hi
is there any way we can prevent suppose <textarea></textarea> when page reload it refresh and set default text
i wanted to know is there any way to prevent certain things not to get refreshed  is there any method in php which prevent to reload  this !


<?php
echo  "<textarea > Enter your favorite quote!</textarea> \n" ;
Code: [Select]
if (isset($_GET['edit']) && $_GET['edit'] == 'textupdate'){
}
<a href= \"{$_SERVER['PHP_SELF']}?page=1&edit=textupdate \" >Click</a>?>

Hi

I have this script i wrote which show four random business from my database inline.  Now I want this script to show the four results for 5 seconds and then show another 4 businesses for 5 seconds and so on.  Can someone please point me in the right direction as to what I need to be looking up to do this as I dont know where to begin.  here is the code by the way


  <?php $qGetUsers = "SELECT * FROM business ORDER BY rand() LIMIT 4";
$rGetUsers = mysql_query($qGetUsers) or die(mysql_error());
while($allUsers = mysql_fetch_array($rGetUsers)) { 


?>
                                
                               <table id="top4tbl" width="150px" height="141px" border="0" cellpadding="0" cellspacing="5">
   <tr>
     <td width="150" ><div align="center"><img src="<?php echo $allUsers['image_location'];?>" />&nbsp;</div></td>
     </tr>
   <tr>
     <td width="150" ><div align="center"><strong><?php echo $allUsers['Business_name'];?> </strong></div></td>
     </tr>
   <tr>

     </tr>
   <tr>
     <td width="150" height="20"><div align="center"><a href="businessinformation.php?businessid=<?php echo $allUsers['businessid'];?>">More Info</a></div></td>
     </tr>
</table>
<?php } ?>