Ok, first off your prepare statements look correct, you are using BEGIN & END properly.

I believe you are running into problems with this code:

# The values are _copied_ here 
$csr->bind_param(":serial_number", $Sno); 
$csr->bind_param(":app_name", $appname); 
$csr->bind_param(":max_time", $max); 
$csr->bind_param(":max_size", $maxs); 
$csr->bind_param_inout(":warranty_tbl", \$warra, -10); 
$csr->bind_param_inout(":return_status", \$return, 100);
[download]

You do not need the colon (:) prefix to the param name. I.E.

# The values are _copied_ here 
$csr->bind_param("serial_number", $Sno); 
$csr->bind_param("app_name", $appname); 
$csr->bind_param("max_time", $max); 
$csr->bind_param("max_size", $maxs); 
$csr->bind_param_inout("warranty_tbl", \$warra, -10); 
$csr->bind_param_inout("return_status", \$return, 100);
[download]

should work properly.

Normally I use numeric values for my procedure, so this is never an issue, but try this and see what happens.

- f o o g o d