Re: [PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

On 2011-03-26, at 9:00 AM, Richard Quadling wrote: > Hi. > > What preferences do you all have when using SQL. Stored Procedures or > PHP generated dynamic SQL or parameterized static SQL. I used both. SPs work for some of the larger reports, especially when combined with a view or two. For m

Re: [PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

On Saturday, March 26, 2011, Richard Quadling wrote; > What preferences do you all have when using SQL. Stored Procedures or > PHP generated dynamic SQL or parameterized static SQL. > Whichever you use how do you test them? Do you use unit testing in > your PHP code? If so, do you also have unit

[PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

Hi. What preferences do you all have when using SQL. Stored Procedures or PHP generated dynamic SQL or parameterized static SQL. Whichever you use how do you test them? Do you use unit testing in your PHP code? If so, do you also have unit code testing for the SQL statements (I suppose this mainl

Re: [PHP-DB] Stored Procedures vs mysqli_multi_query

Iulian Manea wrote: Hey everybody, Here is my problem: i have to exectute multiple SELECT queries to the database, ad my question is how it would be how it would be faster: How are you going to check for errors or whether the queries worked? If you run multiple queries in the same funct

[PHP-DB] Stored Procedures vs mysqli_multi_query

Hey everybody, Here is my problem: i have to exectute multiple SELECT queries to the database, ad my question is how it would be how it would be faster: 1) either calling a stored procedure with mysqli_multi_query. That stored procedure wold contain all of the SELECT queries. 2) using mys

Re: [PHP-DB] Stored Procedures ?

Ricardo Lopes wrote: Is possible to call database stored procedures from php with oracle or any other db? There is a complete Oracle example in Frank Naudé's Oracle/PHP FAQ: http://otn.oracle.com/tech/opensource/php_faq.html#PROC Chris -- PHP Database Mailing List (http://www.php.net/) To un

Re: [PHP-DB] Stored Procedures ?

That's fantastic. Thank you very much. - Original Message - From: "Alban Médici (NetCentrex)" <[EMAIL PROTECTED]> To: "Ricardo Lopes" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 19, 2004 9:58 AM Subject: Re: [PHP-DB] Store

Re: [PHP-DB] Stored Procedures ?

yep just call the name of your function as : SELECT MyFunction(); Ricardo Lopes wrote: Is possible to call database stored procedures from php with oracle or any other db? -- Alban Médici R&D software engineer -- you can contact me @ : IPPhone : +33 (0)2 31 46 37 68

[PHP-DB] Stored Procedures ?

Is possible to call database stored procedures from php with oracle or any other db?

Re: [PHP-DB] stored procedures on mssql

Use mssql_bind -- bob On Mon, 5 Jan 2004, Filipe Girafa wrote: > Hi, > > how do i pass the arguments to the db when using the mssql_execute function? > > thanks, > Filipe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] stored procedures on mssql

Hi, how do i pass the arguments to the db when using the mssql_execute function? thanks, Filipe

[PHP-DB] stored procedures with ODBC

Are there any consideration for a ODBC-Driver, which is able to handle the return values of stored procedures in PHP?? We´re using the new ODBC driver for the IBM DB2 which uses unixODBC and it works fine, even with stored procedures which produce temporary tables. For stored procedures which pro