please help with sessions?

DKY

I have been all over the web and found all sorts of confusing things about sessions. I can't pick them apart and get them to make sense. I have this page that displays information in a mysql table at the top and has a text box and submit button at the bottom. When you enter text and hit submit, it then displays what you just submitted up at the top of the page. Simple so far but here's where I get lost. Everytime I refresh the page, it creates a new row and re-submits what I just submitted. How do I get around that?

ArmyNation_Net

Start A Session:

session_start();
session_register("variable");

Query A Session:

session_start();;

Its What I Use.

DKY

Now, where in the script do I use them? That's the other quesiton I have with this.

ArmyNation_Net

I Use Mine At The Very Top.

<?php
session_start();
session_register("email");

...

All Other Pages:

<?php
session_start();;

echo "$email Is Now On Every Page";
?>

DKY

so, I'm getting mixed up then. Maybe I don't need sessions, sessions are for multiple pages. This page I have uses itself for the action of the form.

ArmyNation_Net

You Only Need Sessions If You Want To Transfer A Inputted Variable Across Multiple Pages.

If You Want The Variable To Stay On The Page It Was Submitted To Just Use:

<?php
if($action == "")
{
echo "<form action='page.php?action=next' method='POST'>";
echo "<b>Variable:</b> <input type='text' name='var'><br>";
echo "<input type='submit' value='   Go   '></form>";
}
if($action == "next")
{
echo "$var Is Now On This Action (or Page)";
}
?>

DKY

I'm not sure exactly what I want other than, I just want my page to stop creating new rows in mysql everytime I refresh after I submit a new row. Once I create a row then hit submit it displays said row, but then if I refresh everytime after that it re-creates the row again. Check it out for yourself.
http://dky.sytes.net/kq/

ArmyNation_Net

Thats Becuase Your Refreshing The Page That Inserts The Row.

You Should Have It Say:

<?php
$var = mysql_query("SELECT * FROM `table` WHERE `row`='$inputbox'");
$count = mysql_num_rows($var);

if($count >= 1)
{
echo "";
}
ELSE
{
mysql_query("INSERT INTO `table` (`row`) VALUES ('$inputbox')");
}
?>

Basically, If The News Item Already Exists, Do Nothing, But, If It Doesnt Exist, Then Insert It.

This Will Protect Your Refresh Problem

Although, Its Double Entering, Because Your Refreshing The INSERT Query.

DKY

okay, kinda makes sense. I'll have to play around with this tommorrow, but before I rush off I wanted to ask one thing about how the code you just posted works. With the code you just posted, if I were to submit something, it would increase the count to 1, right? would it then prevent me from submitting anything again unless I reset the count?

ArmyNation_Net

No, Unless You Posted The Same EXACT THING PERFECTLY THE SAME Again, Thats Only Counting The Number Of Entrys That Is EXACTLY To What You Entered.

So The First Post:

Hello, Im Bob. (Count = 0)

Hello, Im Sam. (Count = 0)

Hello, Im Bob. (Count = 1, Do Nothing)

Weedpacket

ArmyNation.net is leading you somewhat astray. For the most part it's correct, but
[man]session_register[/man] has been superseded by the $_SESSION array since PHP4.1 back in December 2001. [man]session_register[/man] (as noted on that page) can't be relied upon to work.

<?php
session_start();
...
$_SESSION['email'] = 'foo@example.com';
....
?>

Subsequent pages:

<?php
session_start();
....
echo $_SESSION['email']." is available on this page.";
?>