[RESOLVED] no errors but not working

[lilRachie]

I have a DB table that shows customer account# name and what date a letter was postal mailed/faxed to them and what day it was returned to our office.

the admin fills in the dates that are then supposed to go to the DB but aren't doing so.

form

//get table info
$query = "SELECT * FROM `VORVER`";
if($result = mysql_query($query)) {
    while ($row = mysql_fetch_array ($result)) {
        //print table info
        print "<tr><td align=center height=30>". $row["account_number"] .  "</td><td align=center height=30>". $row["consumer_last_name"] . ", ".$row["consumer_first_name"] . "</td><td align=center height=30>";

	if($row["VbyMail"] == NULL) {
		print "<input type=\"hidden\" name=\"an\" value=". $row["account_number"] ."><input type=\"text\" name=\"VbyMail\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyMail"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["VbyFax"] == NULL) {
		print "<input type=\"hidden\" name=\"an\" value=". $row["account_number"] ."><input type=\"text\" name=\"VbyFax\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyFax"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["Returned"] == NULL) {
		print "<input type=\"hidden\" name=\"an\" value=". $row["account_number"] ."><input type=\"text\" name=\"Returned\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["Returned"] . "</td>";
	}

    print "</tr>";
}// end while
}// end if

form shows perfectly

insert on submit

<?
ob_start();
session_name('SESN');
session_start();

 if (isset($_POST["update"])) // if it's not set, do nothing.
{
    foreach($_POST['an'] as $AN)
    {

$VBM = mysql_real_escape_string(mb_strtolower($_POST['VbyMail']));
$VBF = mysql_real_escape_string(mb_strtolower($_POST['VbyFax']));
$RET = mysql_real_escape_string(mb_strtolower($_POST['Returned']));

$sql = "UPDATE `securedb_sbsclients`.`VORVER` SET `VbyMail`= '$VBM', `VbyFax`='$VBF', `Returned`= '$RET' WHERE `account_number`='$AN'";
mysql_query($sql) or die('mySQL Error: ' . mysql_error());

 }
}else{

}
?>

Anyone see why it's not giving me errors or updating the DB?

lilRachie 😕

[bradgrafelman]

lilRachie;10999051 wrote:

Anyone see why it's not giving me errors

Do you have error_reporting set to E_ALL (or better) and either log_errors or display_errors set to On?

lilRachie;10999051 wrote:

or updating the DB?

Where do you ever connect to MySQL in the second script? Also, don't use the "<?" short open tags - they can be disabled (and often are). Instead, always use the full "<?php" opening tag.

[lilRachie]

bradgrafelman;10999059 wrote:

Do you have error_reporting set to E_ALL (or better) and either log_errors or display_errors set to On?

Where do you ever connect to MySQL in the second script? Also, don't use the "<?" short open tags - they can be disabled (and often are). Instead, always use the full "<?php" opening tag.

i have the connect between session_start(); and if but removed it on here, sorry

I looked at the error logs on the server for the day. Nothing there at all. display_errors and log_errors are both set to On. error_reporting says 22519.

the short tags (<?) are on on this server but i will keep this in mind. Thanks

Still no idea why it's not working

lilRachie

[Bonesnap]

Do a print_r() on the $POST variable to make sure there's something in $POST['an']. In instances like this, where there's no syntax errors or errors logged, but the outcome is not what's expected, usually there's a logic error.

[lilRachie]

Getting an absolute blank page doing that, Bonesnap, unless I did it incorrectly

lilRachie

[lilRachie]

Ok variables are passing

<?
ob_start();
session_name('RRAdmin');
session_start();

print_r($_POST['an']);
print_r($_POST['VbyMail']);
print_r($_POST['VbyFax']);
print_r($_POST['Returned']);

include('cond.php');

 if (isset($_POST["update"])) // if it's not set, do nothing.
{
    foreach($_POST['an'] as $AN)
    {

//$VBM = mysql_real_escape_string(mb_strtolower($_POST['VbyMail']));
//$VBF = mysql_real_escape_string(mb_strtolower($_POST['VbyFax']));
//$RET = mysql_real_escape_string(mb_strtolower($_POST['Returned']));

//$sql = "UPDATE `securedb_sbsclients`.`VORVER` SET `VbyMail`= '$VBM', `VbyFax`='$VBF', `Returned`= '$RET' WHERE `account_number`='$AN'";
mysql_query($sql) or die('mySQL Error: ' . mysql_error());

 }
}else{

}
?>

But in the loop they don't

<?
ob_start();
session_name('RRAdmin');
session_start();

include('cond.php');

 if (isset($_POST["update"])) // if it's not set, do nothing.
{
    foreach($_POST['an'] as $AN)
    {

print_r($_POST['an']);
print_r($_POST['VbyMail']);
print_r($_POST['VbyFax']);
print_r($_POST['Returned']);

//$VBM = mysql_real_escape_string(mb_strtolower($_POST['VbyMail']));
//$VBF = mysql_real_escape_string(mb_strtolower($_POST['VbyFax']));
//$RET = mysql_real_escape_string(mb_strtolower($_POST['Returned']));

//$sql = "UPDATE `securedb_sbsclients`.`VORVER` SET `VbyMail`= '$VBM', `VbyFax`='$VBF', `Returned`= '$RET' WHERE `account_number`='$AN'";
mysql_query($sql) or die('mySQL Error: ' . mysql_error());

 }
}else{

}
?>

Very strange

[Derokorian]

What is in cond.php ? I notice your print_rs are before and after that include, so its possible something in that file is the problem.

[lilRachie]

that's my db connect file, nothing to do with the variables carrying or not....

lilRachie

[bradgrafelman]

Can you just do a print_r() on the entire $_POST array before the outer if() statement and show us the results?

[Derokorian]

Also try putting the print_r before AND after at the same time. Make sure the same request is producing different results in both places.

[lilRachie]

right now as it stands there are 2 test rows in the DB table and the

print_r($_POST['an']);

it shows the second records account number

[lilRachie]

when it's inside the foreach it doesn't show anything

[bradgrafelman]

Can you show us the full output of the print_r() if you do it for the entire $_POST array?

[lilRachie]

Ok variable is printing but only for account number before the if statement because i changed

<input type=\"hidden\" name=\"an\" value=". $row["account_number"] .">

to

<input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] .">

So it now prints
Array ( [0] => 13392 [1] => 13392 [2] => 13403 [3] => 13403 [4] => 13403 ) 03/14/12

03/14/12 is from the second row of input into VbyFax field

[lilRachie]

My output

Array
(
[an] => Array
(
[0] => 13392
[1] => 13392
[2] => 13403
[3] => 13403
[4] => 13403
)

[VbyFax] => Array
    (
        [0] => 
        [1] => 03/14/12
    )

[Returned] => Array
    (
        [0] => 03/13/12
        [1] => 
    )

[VbyMail] => Array
    (
        [0] => 
    )

[update_x] => 71
[update_y] => 11

)

[lilRachie]

that is what the arrays are printing

[bradgrafelman]

That output shows that $POST['VbyFax'], $POST['Returned'], and $_POST['VbyMail'] are all arrays, yet your code is treating them as if they were strings.

Furthermore, the first two contain two elements while the third (VbyMail) only contains a single element. Neither group has the same number of elements as $_POST['an'], nor do any of the three have data in the same array index (VbyFax has data in the second index, Returned has data in the first, and VbyMail has no data).

You're going to have to explain how you're trying to use all of this data, because it definitely doesn't make any sense to me.

[lilRachie]

bradgrafelman;10999158 wrote:

That output shows that $POST['VbyFax'], $POST['Returned'], and $_POST['VbyMail'] are all arrays, yet your code is treating them as if they were strings.

they weren't showing up til i made them arrays. So I changed them

<?
include('cond.php');
//get table info
$query = "SELECT * FROM `VORVER`";
if($result = mysql_query($query)) {
    while ($row = mysql_fetch_array ($result)) {
        //print table info
        print "<tr><td align=center height=30>". $row["account_number"] .  "</td><td align=center height=30>". $row["consumer_last_name"] . ", ".$row["consumer_first_name"] . "</td><td align=center height=30>";

	if($row["VbyMail"] == NULL) {
		print "<input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] ."><input type=\"text\" name=\"VbyMail[]\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyMail"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["VbyFax"] == NULL) {
		print "<input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] ."><input type=\"text\" name=\"VbyFax[]\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyFax"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["Returned"] == NULL) {
		print "<input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] ."><input type=\"text\" name=\"Returned[]\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["Returned"] . "</td>";
	}

    print "</tr>";
}// end while
}// end if
?>

bradgrafelman;10999158 wrote:

Furthermore, the first two contain two elements while the third (VbyMail) only contains a single element. Neither group has the same number of elements as $_POST['an'], nor do any of the three have data in the same array index (VbyFax has data in the second index, Returned has data in the first, and VbyMail has no data).

You're going to have to explain how you're trying to use all of this data, because it definitely doesn't make any sense to me.

I need to get the appropriate date either in me mail or fax column added to the database by account number and then at a different date I need to be able to put in the return date.

each account number starts off with 3 empty fields mail fax return.

[lilRachie]

ok changed some code around

//get table info
$query = "SELECT * FROM `VORVER`";
if($result = mysql_query($query)) {
    while ($row = mysql_fetch_array ($result)) {
        //print table info
        print "<tr><td align=center height=30><input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] .">". $row["account_number"] .  "</td><td align=center height=30>". $row["consumer_last_name"] . ", ".$row["consumer_first_name"] . "</td><td align=center height=30>";

	if($row["VbyMail"] == NULL) {
		print "<input type=\"text\" name=\"VbyMail\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyMail"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["VbyFax"] == NULL) {
		print "<input type=\"text\" name=\"VbyFax\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["VbyFax"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["Returned"] == NULL) {
		print "<input type=\"text\" name=\"Returned\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>";
	}else{
		echo $row["Returned"] . "</td>";
	}

    print "</tr>";
}// end while
}// end if

removed if(posted blah)

    foreach($_POST['an'] as $AN)
    {

$VBM = mysql_real_escape_string(mb_strtolower($_POST['VbyMail']));
$VBF = mysql_real_escape_string(mb_strtolower($_POST['VbyFax']));
$RET = mysql_real_escape_string(mb_strtolower($_POST['Returned']));

echo "UPDATE `securedb_sbsclients`.`VORVER` SET `VbyMail`= '$VBM', `VbyFax`='$VBF', `Returned`= '$RET' WHERE `account_number`='$AN'<br/>\n";


 }

and i'm getting

UPDATE securedb_sbsclients.VORVER SET VbyMail= 'na', VbyFax='03/15/12', Returned= '' WHERE account_number='13392'
UPDATE securedb_sbsclients.VORVER SET VbyMail= 'na', VbyFax='03/15/12', Returned= '' WHERE account_number='13403'

except i put 2 different dates and it's only putting the 2nd

account# name vbymail vbyfax returned
13392 mb (already in db) blank 03/13/12
13403 cx blank 03/15/12 blank

[lilRachie]

reposting

ok changed some code around

//get table info
$query = "SELECT * FROM `VORVER`";
if($result = mysql_query($query)) {
    while ($row = mysql_fetch_array ($result)) {
        //print table info
        print "<tr><td align=center height=30><input type=\"hidden\" name=\"an[]\" value=". $row["account_number"] .">". $row["account_number"] .  "</td><td align=center height=30>". $row["consumer_last_name"] . ", ".$row["consumer_first_name"] . "</td><td align=center height=30>";

	if($row["VbyMail"] == NULL) {
		print "<input type=text name=VbyMail style=font-family: serif; font-size: 12px; size=25></td>";
	}else{
		echo $row["VbyMail"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["VbyFax"] == NULL) {
		print "<input type=text name=VbyFax style=font-family: serif; font-size: 12px; size=25></td>";
	}else{
		echo $row["VbyFax"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["Returned"] == NULL) {
		print "<input type=text name=Returned style=font-family: serif; font-size: 12px; size=25></td>";
	}else{
		echo $row["Returned"] . "</td>";
	}

    print "</tr>";
}// end while
}// end if

removed if(posted blah)

    foreach($_POST['an'] as $AN)
    {

echo "<pre>" . print_r($_POST, true) . "</pre>"; 

$VBM = ($_POST['VbyMail']);
$VBF = ($_POST['VbyFax']);
$RET = ($_POST['Returned']);

echo "UPDATE `securedb_sbsclients`.`VORVER` SET `VbyMail`= '$VBM', `VbyFax`='$VBF', `Returned`= '$RET' WHERE `account_number`='$AN'<br/>\n";


 }

and i'm getting

Array
(
[an] => Array
(
[0] => 13392
[1] => 13403
)

[VbyFax] => 04/02/12
[Returned] => 
[VbyMail] => na
[update_x] => 58
[update_y] => 11

)

UPDATE securedb_sbsclients.VORVER SET VbyMail= 'na', VbyFax='04/02/12', Returned= '' WHERE account_number='13392'

Array
(
[an] => Array
(
[0] => 13392
[1] => 13403
)

[VbyFax] => 04/02/12
[Returned] => 
[VbyMail] => na
[update_x] => 58
[update_y] => 11

)

UPDATE securedb_sbsclients.VORVER SET VbyMail= 'na', VbyFax='04/02/12', Returned= '' WHERE account_number='13403'

I put in fax=na returned=a date mail=na fax=a date returned=blank

lilRachie