I want to ask something what error is this. I want to display report book to PHP but the result showing like in picture Here is my report book: and here is the result showing in ASP.NET: Answer You need to consider the following: You need to use named (:name) or question mark (?) parameter markers in the prep…
Tag: stored-procedures
Can I call a stored procedure on each iteration of an array? PHP
I want to loop through an associative array that represents a table’s columns and values, and call a stored procedure on each iteration that will insert each value into its respective column. The assoc. array and loop looks like this: The stored procedure looks like this: Is this possible to do? Or is t…
Stored procedure – would like to read OUTPUT parameter and select-resultset
I have the following stored procedure: CREATE DEFINER=`CNX`@`%` PROCEDURE `sp_Facturatie_OpenstaandeBetalingen_Get`(OUT spResult varchar(200)) BEGIN DECLARE exit handler for SQLEXCEPTION BEGIN …
PHP get return value of stored procedure
I have pleasure to work with legacy PHP application using SQL Server via PDO. How in PHP can I retrieve return value of stored procedure which is using RETURN statement as output channel? Example procedure If possible, I would prefer to not modify procedure. I am aware that there are similar questions, but th…
MySQL 5.7 equivalent to PHP’s json_decode()?
I’m converting some php scripts into mysql stored procedures and have come across the usage of php’s json_decode() on a result set’s data. It occurs on a field which is stored as a mediumtext,utf8,utf8_unicode_ci How can I perform the ‘json_decode()’ process using pure MySQL? Sam…
Using pdo in php with stored procedure
I have a simple stored procedure in MySQL database: When calling this procedure in mysql-workbench it returns the data I put in: Now when I call it from PHP using pdo I get an error: Here is my php code: Answer You need to use bindValue instead of bindParam. When you use bindParam, it binds the variable provi…
mssql_bind empty string converting to NULL
I am currently using SQL Server 2000 Stored Procedures with PHP. Following the PHP doc, I use mssql_bind to assign value of parameters and then execute the Stored Procedure. The problem is that I got this bug which prevents me to bind empty strings to parameters (they are converted to NULL when the Stored Pro…