2. PHPRunner General questions
  3. Stored procedure returns Null value
This topic is locked

Stored procedure returns Null value

 		2/18/2016 9:22:46 AM
PHPRunner General questions
M
 mohini.jadhav author

I have written following code to call stored procedure on server side of button, But it gives me NULL value as output. Can anybody help me in it.
Here is my code:
$startDate = $params["startDate"];

$weekInterval = $params["weekIntervals"];

$stmt = mysqli_prepare( $connectionObj, "CALL Alloc_dashboard( ?, ?, @AllocDetails )" );

mysqli_stmt_bind_param( $stmt, "ss", $startDate, $weekInterval );

mysqli_stmt_execute($stmt);

mysqli_stmt_close($stmt);

$result = mysqli_query($link,'SELECT @AllocDetails');

var_dump($result);

list($AllocDetails) = mysqli_fetch_row($result);

mysqli_free_result($result);
Sergey Kornilov admin 2/18/2016

This sort of thing is impossible to troubleshoot without having access to your project, data and stored procedure code. Not to mention that this is a general programming question and not really related to PHPRunner.
M
 		mohini.jadhav author 2/19/2016



This sort of thing is impossible to troubleshoot without having access to your project, data and stored procedure code. Not to mention that this is a general programming question and not really related to PHPRunner.


This code is working properly when I call it in simple php page. But when I call it in buttonhandler.php file in phprunner it is giving me NULL value. I can share my project with you for getting help. Please update me if your able to help me out in it.

Thanks in advance.
Sergey Kornilov admin 2/19/2016

Sure, we can perform this kind of troubleshooting for you. Post your project to Demo Account and open a support ticket at http://xlinesoft.com/dss/support.asp sending your Demo Account URL, stored procedure source code and instructions on reproducing it.