Values will not _POST

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.

http://www.eto-league.com/Attack.txt

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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.

Posted: Sat Dec 16, 2006 10:53 pm

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')

Posted: Sat Dec 16, 2006 11:03 pm

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

Posted: Sat Dec 16, 2006 11:12 pm

&^%#!

That still didn't help, but good catch.

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.

Posted: Sat Dec 16, 2006 11:31 pm

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'];

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'];

Posted: Sun Dec 17, 2006 12:09 am

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();

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.

Posted: Sun Dec 17, 2006 12:25 am

Done

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.

Posted: Sun Dec 17, 2006 12:33 am

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");

Posted: Sun Dec 17, 2006 12:35 am

Yep

Posted: Sun Dec 17, 2006 12:41 am

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

Posted: Sun Dec 17, 2006 12:51 am

Are those the values you want to pass?

Posted: Sun Dec 17, 2006 12:59 am

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.

Posted: Sun Dec 17, 2006 1:05 am

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

Posted: Sun Dec 17, 2006 1:12 am

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

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.

Posted: Sun Dec 17, 2006 1:19 am

Hitting the pillow myself. Thanks for your help.

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?

Posted: Sun Dec 17, 2006 1:30 am

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>

Posted: Sun Dec 17, 2006 4:06 am

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

Posted: Sun Dec 17, 2006 11:24 am

You mean the db tables?