If you're getting any error messages that would be helpful. If you remove
the "or die(...)" you might get specific information on what is going on.
I'd also like to see what your query looks like when you print it out.
|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"'Web Enabling the AS400 / iSeries'" <web400@xxxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|11/24/2009 11:42 AM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: [WEB400] Why does this SQL Insert Fail |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
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 is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/web400..
Scanned by IFB SafeMail
http://www.ifb.net for spam/UCE and virus content.
IFB Spam-Score: (0.202)
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/web400..
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/web400..
midrange.com
