Urgent Request for Help

zooropa

Dear All,

I've defined a variable $mnt which has the value of what i enter into a textbox named fdd_lot on Form 1

i.e. $mnt=$_POST['fdd_lot'];

I also have a second form on the same page as Form 1, namely Form 2 that contains a hidden input "submitted". So say I enter "xyz" into the text box then $mnt is assigned the value xyz and this is successfully shown on the page using the echo statement below.

However, when i try to insert $mnt into the database using the INSERT query it just inserts as a blank - the insert happens in as much as a new record is created but xyz doesn't appear in the "test" field. It's as if $mnt loses its value as soon as the submit button is clicked and Form 2 posted.

If I insert the statement $mnt='xyz'; just after the echo statement, then xyz is inserted into the test field in the database.

Does anyone have any idea why xyz is not showing in the test field?

 
<?php
echo ('the value is ').$mnt;

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


$q1="INSERT INTO tbl_test (test) VALUES('$mnt')";
$r = mysqli_query($dbc,$q1); 

}
?>

dalecosp

First off, there's a post in my .sig called "getting help at all". Read Weekpacket's advice regarding titling your post. "Urgent request for help" is spelled properly, but means little.

To get the actual ball rolling, are you testing the value of $r?

dalecosp

And, after re-reading your post, I'd think that the problem is that the value of $mnt isn't in the form you're submitting? More details, perhaps, would help. Are these two forms on the same page, or is the execution path more like:

form1 > submit > form2 > submit > handler

zooropa

OK, point taken : )

Yes, the two forms are on the same page.
The reason I'm trying to POST the data via Form 2 (which contains a Submit button and hidden form input) is that Form 1 (which contains the text box) also contains 3 cascading dropdowns which rely on a call to a javascript function that causes the form to reload. However, this creates duplicate records as the text box data is posted each time Form 1 is reloaded.

Hope this makes sense but if not i can put up the complete code

Thanks

dalecosp

Well, since the echo() works at the top of the handler, I'm kind of in your boat ... at a loss to explain what's up with a blank field in the DB after a query.

I'd say we just need to go into DEBUG mode, echo() or print_r() everything, at every stage of the handler. Echo() out the SQL statement and try it from console? What about the value of $r?

What about $r?

zooropa

Thanks for your help. I've decided to bite the bullet and learn Ajax which seems better suited to my application. That should be less frustrating in the end for both me and the people on this forum.

dalecosp

Lol, who's frustrated? 🙂