Re: Why does this SQL Insert Fail -- WEB400

Sorry. Should have said that I'd tried it both ways already.

It did not work.

I've not used MySQL much so it's probably something really obvious that I
just don't know about.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Dr. Syd Nicholson
Sent: Tuesday, November 24, 2009 10:33 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] Why does this SQL Insert Fail

I don't know PHP and don't use it -- but looking at your SQL the variables
in your VALUES section are enclosed in quotes. Would it work if you omitted
the quotes?

Syd

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Shannon ODonnell
Sent: 24 November 2009 16:25
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Why does this SQL Insert Fail

Hi,

Trying to do a simple PHP SQL to insert a row into a MySQL database and it
keeps failing.

I've tried it with hard coded values and also with variables.

The DB was created fine, and I was able to connect to it fine.

Also, the user profile has all rights to the DB.

But it keep failing.

Is there a way to get more diagnostic info maybe so that I can see WHY it
fails or barring that, can someone see any reason why this would fail (coded
incorrectly maybe?)

Thanks!

$XmittalBatchNum = $sta->transmittal->aheader->XmittalBatchNum;

$TransmittalDate = $sta->transmittal->aheader->TransmittalDate;

$Agency = $sta->transmittal->aheader->Agency;

$RB_UserID = $sta->transmittal->aheader->RB_UserID;

$CashAmountTotal = $sta->transmittal->aheader->CashAmountTotal;

$CheckAmountTotal = $sta->transmittal->aheader->CheckAmountTotal;

$CreditAmountTotal = $sta->transmittal->aheader->CreditAmountTotal;

$CitationCount = $sta->transmittal->aheader->aCount;

$cxn=mysqli_connect("localhost", "shannon" , "mypass", "sta")

or die("Error Connecting to database");

$query = "INSERT INTO TBH-Table (

XmittalBatchNum,

TransmittalDate,

Agency,

RB_UserID,

CashAmountTotal,

CheckAmountTotal,

CreditAmountTotal,

aCount

)

VALUES('$XmittalBatchNum',

'$TransmittalDate',

'$Agency',

'$RB_UserID',

'$CashAmountTotal',

'$CheckAmountTotal',

'$CreditAmountTotal',

'$aCount')";

echo "<htmL><body><center>".$query."</center></body></html>";

$result = mysqli_query($cxn, $query)

or die("Unable to insert record: \n"."Transmittal Batch Num:
".$XmittalBatchNum);

echo "<h4>Record Added to Database</h4>";

?>

Shannon O'Donnell

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.