<html>
<form id="new_order" method="post" action="">
<p>
<label for="cust_name">Customer name:</label>
<input name="cust_name" id="cust_name" type="text" class="formbox" />
</p>
<p>
<label for="order_date">Order date:</label>
<input name="order_date" id="order_date" type="text" class="formbox" />
</p>
<p>
<label for="part_num">Part Number:</label>
<input name="part_num" id="part_num" type="text" class="formbox" />
</p>
<p>
<label for="qty">Quantity:</label>
<input name="qty" id="qty" type="text" class="formbox" />
</p>
<p>
<label for="price">Price:</label>
<input name="price" id="price" type="text" class="formbox" />
</p>
<p>
<label for="order_num">Order Number:</label>
<input name="order_num" id="order_num" type="text" class="formbox" />
</p>
<p>
<label for="order_sum">Order total:</label>
<input name="order_sum" id="order_sum" type="text" class="formbox" />
</p>
<p>
<input name="send" id="send" type="submit" value="Submit form data" />
</p>
</form>
</html>
<?php
if (array_key_exists('send', $_POST))
{
$database = 'my_db2_database';
$user = 'username';
$password = 'password';
$sql = 'CALL STORED_PROC(?, ?, ?, ?, ?, ?, ?)';
$conn = db2_connect($database, $user, $password);
$stmt = db2_prepare($conn, $sql);
$cust_name = $_POST["cust_name"];
$order_date = $_POST["order_date"];
$part_num = $_POST["part_num"];
$qty = $_POST["qty"];
$price = $_POST["price"];
/*
$order_num = $_POST['order_num'];
$order_sum = $_POST['order_sum'];
$cust_name = "Customer1";
$order_date = "04/02/2009";
$part_num = "Part_num1";
$qty = 3;
$price = 32.98;
*/
$order_num = 0;
$order_sum = 0;
db2_bind_param($stmt, 1, "cust_name", DB2_PARAM_IN);
db2_bind_param($stmt, 2, "order_date", DB2_PARAM_IN);
db2_bind_param($stmt, 3, "part_num", DB2_PARAM_IN);
db2_bind_param($stmt, 4, "qty", DB2_PARAM_IN);
db2_bind_param($stmt, 5, "price", DB2_PARAM_IN);
db2_bind_param($stmt, 6, "order_num", DB2_PARAM_OUT);
db2_bind_param($stmt, 7, "order_sum", DB2_PARAM_OUT);
if ($_POST) {print_r($_POST);}
// next are diagnostic lines
print "Values of input parameters:\n";
print " 1: {$cust_name} 2: {$order_date} 3: {$part_num} 4. {$qty} 5. {$price} 6. {order_num} 7. {order_sum}\n\n";
if (db2_execute($stmt)) //this is line 89
{
print "Values of output parameters:\n";
print " 1: {$order_num} 2: {$order_sum} \n\n";
}
else
{
print "Uh-oh!" . db2_stmt_error($stmt); //displays the SQLSTATE value
}
}
?>
********************output (does not display text fields)**************************
Customer name:
Order date:
Part Number:
Quantity:
Price:
Order Number:
Order total:
Values of input parameters: 1: Customer1 2: 04/02/2009 3: Part_num1 4. 3 5. 32.98 6. {order_num} 7. {order_sum}
Array ( [cust_name] => [order_date] => [part_num] => [qty] => [price] => [order_num] => [order_sum] => [send] => Submit form data )
Values of input parameters: 1: Customer1 2: 04/02/2009 3: Part_num1 4. 5. 32.98
6. {order_num} 7. {order_sum}
Warning: db2_execute() [function.db2-execute]: Statement Execute Failed in C:\Inetpub\wwwroot\SP_Test.php on line 89
Uh-oh!22007
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Our community of experts have been thoroughly vetted for their expertise and industry experience.