Jump to content

Forgotten Form Data


mhoctober

Recommended Posts

All,

I have a .htm form that collects and submits data to a .php file, which connects to a backend mySQL db and inserts the user data, well - thats what its supposed to do!!

I have verified that the insert statement in the .php file is working fine (to test it I temporarily hard coded some values into it and these were inserted into the backend mySQL table OK).

For some strange reason all the data that the user is entering into the form seems to be forgotten!

Further testing results :

The key field in the mySQL database is set to auto increment, which it does every time the user completes the forms and clicks submit - but no user data is getting stored in the table.

I believe the problem lies somewhere in the form as I have tried echo $first in the .php file and nothing is output to the screen.

Any ideas?
Link to comment
Share on other sites

[!--quoteo(post=352586:date=Mar 7 2006, 02:45 PM:name=MikeHa)--][div class=\'quotetop\']QUOTE(MikeHa @ Mar 7 2006, 02:45 PM) [snapback]352586[/snapback][/div][div class=\'quotemain\'][!--quotec--]
The key field in the mySQL database is set to auto increment, which it does every time the user completes the forms and clicks submit - but no user data is getting stored in the table.

I believe the problem lies somewhere in the form as I have tried echo $first in the .php file and nothing is output to the screen.
[/quote]

Code! We need code! :)

It *sounds* like the variables are being passed into the script but you're losing them somewhere in there.. Without seeing the source it's gonna be hard to determine what you're doing. Simply put, the variables submitted wind up in 2 of 3 places. If you use a GET method on the form, the $_GET[] hash is populated with the information. If you use POST, then $_POST[] is populated. In both instances, $_REQUEST[] is populated.

So, if you submitted a form using a POST method, and you have a username and a password field, you can access the data like this :

[code]
$username = $_POST['username'];
$password = $_POST['password'];

or

$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
[/code]

And please, code responsibly. Sanitize that data. Don't let that evil skript kiddy hack you!
Link to comment
Share on other sites

Thanks! That looks like it will do the trick.

To reference the forms variable I was simply using...

$first, $last etc... and not $post['first']

Strange that this has only become a problem since we have migrated the site to a new server. Maybe the new server has an older version of php??

That being the case I wonder how many slices of code I'm going to have to hack!!!

Thanks again...

Mike

[!--quoteo(post=352588:date=Mar 7 2006, 02:52 PM:name=XenoPhage)--][div class=\'quotetop\']QUOTE(XenoPhage @ Mar 7 2006, 02:52 PM) [snapback]352588[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Code! We need code! :)

It *sounds* like the variables are being passed into the script but you're losing them somewhere in there.. Without seeing the source it's gonna be hard to determine what you're doing. Simply put, the variables submitted wind up in 2 of 3 places. If you use a GET method on the form, the $_GET[] hash is populated with the information. If you use POST, then $_POST[] is populated. In both instances, $_REQUEST[] is populated.

So, if you submitted a form using a POST method, and you have a username and a password field, you can access the data like this :

[code]
$username = $_POST['username'];
$password = $_POST['password'];

or

$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
[/code]

And please, code responsibly. Sanitize that data. Don't let that evil skript kiddy hack you!
[/quote]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.