On 5 November 2010 05:21, Tamara Temple wrote:
>
> On Nov 4, 2010, at 6:36 AM, Jay Blanchard wrote:
>
>> [snip]
>> If you have a query in your PHP code, which you are going to be
>> executing a lot, even if you are using prepared statements, you can go
>> one further by creating a stored procedure
On Nov 4, 2010, at 6:36 AM, Jay Blanchard wrote:
[snip]
If you have a query in your PHP code, which you are going to be
executing a lot, even if you are using prepared statements, you can go
one further by creating a stored procedure. Now the SQL server will
only ever need to compile the statem
On Thu, 4 Nov 2010 02:48:55 -0500
Tamara Temple wrote:
> I'm wondering what the advantages/disadvantage of using prepared
> statements with mysqli are. I'm used to using the mysqli::query and
> mysqli::fetch_assoc functions to deal with retrieving data and
> bulding my sql statement in php co
One thing to remember is that dealing with results from prepared statements
is different then getting results from queries, so if you are using both,
confusion can easily set in (and lets face it, prepared statements arent
always the best thing to use)... if its of any help, i have written a class
[snip]
Just don't go too far.
[/snip]
I absolutely agree! Doing SP's for SP sake is not desired and be truly
careful about cascading the procedures. And always, ALWAYS document your
code and put copious comments in the SP's.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit
"Jay Blanchard" didst scribe:
> using stored procedures has a lot of advantages. If you need to
> change your SQL you can do it in one spot. It reinforces MVS or
> modular coding behavior, the SP becomes very re-usable. Security
> is improved. Performance can be improved. You can put the bulk of
>
[snip]
If you have a query in your PHP code, which you are going to be
executing a lot, even if you are using prepared statements, you can go
one further by creating a stored procedure. Now the SQL server will
only ever need to compile the statement once. No matter how many times
it is used. You on
On 4 November 2010 10:42, Richard Quadling wrote:
> On 4 November 2010 08:19, Shreyas Agasthya wrote:
>> Tamara,
>>
>> In one of the earlier threads, it was mentioned mysqli APIs are more secure,
>> faster, and actually maintained.
>>
>> Also, if you use some of the mysql_xxx(), you actually get
On 4 November 2010 08:19, Shreyas Agasthya wrote:
> Tamara,
>
> In one of the earlier threads, it was mentioned mysqli APIs are more secure,
> faster, and actually maintained.
>
> Also, if you use some of the mysql_xxx(), you actually get a warning saying
> that it will be or it is being deprecate
Tamara,
In one of the earlier threads, it was mentioned mysqli APIs are more secure,
faster, and actually maintained.
Also, if you use some of the mysql_xxx(), you actually get a warning saying
that it will be or it is being deprecated and paves the way for you to
approach the same thing with mys
10 matches
Mail list logo
