Values will not _POST

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I have been struggling with this for days. The correct values are displayed in the form. I am passing them with hidden fields.

Even though I don't think I need to.

But I can't get either one of these to write to the database. I need help.

I'll link a txt file.

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Sat Dec 16, 2006 10:32 pm

Change this line
$result = $db->sql_query ("INSERT INTO " . $prefix . "_eto_tracking (log_id, ateam_id, dteam_id, tid, move_dt, action)". "VALUES ('NULL','$ateam_id','$dteam_id','$tid',CURRENT_TIMESTAMP(),'$action')");

To
$sql = "INSERT INTO " . $prefix . "_eto_tracking (log_id, ateam_id, dteam_id, tid, move_dt, action) VALUES (NULL,'$ateam_id','$dteam_id','$tid',CURRENT_TIMESTAMP(),'$action')";
echo '$sql = '.$sql;
die();
$result = $db->sql_query ($sql);

See what $sql looks like and if it seems ok then run the $sql directly in phpmyadmin.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Here is what came back.

$sql = INSERT INTO nuke_eto_tracking (log_id, ateam_id, dteam_id, tid, move_dt, action) VALUES (NULL,'','','',CURRENT_TIMESTAMP(),'Attack')

Raven · Posted: Sat Dec 16, 2006 11:03 pm

I just noticed something? Where is your closing </form> statement Wink

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

&^%#!

That still didn't help, but good catch.

Raven · Posted: Sat Dec 16, 2006 11:20 pm

Have you verified that those variables that you want to write have values? It could be the SQL statement is correct but the $_POST values are empty. We need to isolate where it's happening before resolving what is happening.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I know the SQL is correct because the page displays the correct values.

I don't think I need to pass the hidden values because they are not really hidden. I was trying to anyway.

Code:

echo"<input type=\"hidden\" name=\"ateam_id\" value=\"$ateam_id\">"
."<input type=\"hidden\" name=\"dteam_id\" value=\"$dteam_id\">"
."<input type=\"hidden\" name=\"tid\" value=\"$tid\">"

And Iv'e always written this way. I don't know how else to do it.

Code:

if ($op == "ConfirmAttack") {
   $ateam_id = $_POST['team_id'];
   $dteam_id = $_POST['dteam_id'];
   $tid = $_POST['tid'];

Raven · Posted: Sat Dec 16, 2006 11:57 pm

But, are there values here:

if ($op == "ConfirmAttack") {
$ateam_id = $_POST['team_id'];
$dteam_id = $_POST['dteam_id'];
$tid = $_POST['tid'];

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

No. I've tried this and get nothing.

Code:

if ($op == "ConfirmAttack") {
   $ateam_id = $_POST['team_id'];
   $dteam_id = $_POST['dteam_id'];
   $tid = $_POST['tid'];
   $action = 'Attack';

   echo $ateam_id;
   echo $dteam_id;
   echo $tid;
   die();

Raven · Posted: Sun Dec 17, 2006 12:14 am

So, we know that the problem is that the values aren't getting passed, not in the writing to the database. Please post your latest code in the TXT file, with the closing </form> statement.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Done

Raven · Posted: Sun Dec 17, 2006 12:26 am

Right before this statement
echo"<input type=\"hidden\" name=\"ateam_id\" value=\"$ateam_id\">"

Check all the values. I believe you will find they are either empty or are equal to the LAST record you read, which is not what I think you are after.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Outside the loop like this?

Closetable();
}

echo $ateam_id;
echo $dteam_id;
echo $tid;

echo"<input type=\"hidden\" name=\"ateam_id\" value=\"$ateam_id\">"
."<input type=\"hidden\" name=\"dteam_id\" value=\"$dteam_id\">"
."<input type=\"hidden\" name=\"tid\" value=\"$tid\">"
."<input type=\"hidden\" name=\"div_id\" value=\"$div_id\">"
."<input type=\"hidden\" name=\"op\" value=\"ConfirmAttack\">"
."</form>";
@include_once("footer.php");

Raven · Posted: Sun Dec 17, 2006 12:35 am

Yep

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

It returns 14512748

145 is the id of $ateam_id

127 is the id of the last row in the query for $dteam_id and belong to the 2nd Armored Division

48 is the tid of the territory I'm on called Lincolnshire

Raven · Posted: Sun Dec 17, 2006 12:51 am

Are those the values you want to pass?

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

The first and third one are, but the middle one being the dteam_id should depend on which one I click on. Look at the graphic about 9 posts up.

Raven · Posted: Sun Dec 17, 2006 1:05 am

Just try $_GET['op'] in place of $op to humor me Smile

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Nope. $action and CURRENT_TIMESTAMP() still get posted along with the $log_id but none of the other values.

Raven · Posted: Sun Dec 17, 2006 1:16 am

Just as an fyi, remove the quotes from around NULL. I've got to goto bed. It's something simple - I'm just too tired to look at it anymore. The print is all running together. I'll check back in the morning.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Hitting the pillow myself. Thanks for your help.

Raven · Posted: Sun Dec 17, 2006 1:20 am

When you look at the source code for the page when you call it up, are the hidden values populated correctly?

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

The are populated.

It looks right except for the dteam_id that's contained in the last dteam_id in the query

<input type="hidden" name="ateam_id" value="145">
<input type="hidden" name="dteam_id" value="127">
<input type="hidden" name="tid" value="48">
<input type="hidden" name="div_id" value="2">
<input type="hidden" name="op" value="ConfirmAttack">
</form>

Raven · Posted: Sun Dec 17, 2006 4:06 am

Please zip up and send me the page source. Thanks.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

You mean the db tables?