Re: Anybody here know anything about doing SQL Prepared Statements from PHP?

On Sep 27, 2016, at 1:10 PM, James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:

Ladies and Gentlemen:

We have a customer that's trying to do a prepared statement to create a DB2 record on their Midrange box, and one of the fields they're attempting to populate is a rather long VARLEN character field (EBCDIC, max length a little under 16k), with embedded line breaks.

I have very little experience with Prepared Statements, and none whatsoever with PHP. Here's a simplified fragment of what they have (and assume all variables have already been populated):

$nrecid = $accaid; // Record ID ( Passed from earlier in the function )
$temp = "Name: " . $name . "
Email Address: " . $emailAddress . "
Phone Number: " . $phoneNumber . "
Message: " . $message . "
HTTP_REFERRER: " . $_SERVER[ 'HTTP_REFERER' ]; // Notes
$nnotes = str_replace( " ", "", $temp );

$args = array(
$nrecid ,
$nnotes );

$query = "INSERT INTO " . $library . ".NOTEFILE
( NRECID, NNOTES )
VALUES ( ?, ? )";
$stmt = db2_prepare( $conn, $query );

if ( !db2_execute( $stmt, $args ) ) {
$error = array (
'Statement Error' =>db2_stmt_error( ),
'Error Message' => db2_stmt_errormsg( ),
'Query' => aiInterpolateQuery( $query, $args )
);

++$errorCount;
}

It looks like he's trying to use line breaks in the code to produce line breaks in the value of $nnotes. Is that even possible?

What we actually WANT to show up in the EBCDIC value of the NNOTES field is a Hex'0A' for each line break.

--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.