Member Avatar for tintavivek

is call procedurename() is work in
php version:5.2.4
mysql:5.0.45
server version:5.0.27

  • 2 Contributors
  • 3 Replies
  • 91 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

Try to ask an understandable question; then you will likely get an helpful answer.

Member Avatar for tintavivek

is the call function in mysql is work in:php version:5.2.4
mysql:5.0.45
server version:5.0.27

Member Avatar for smantscheff

If your question is whether you can use the "CALL" statement in PHP against an MySQL server, the answer is YES. The version of your MySQL client is irrelevant.
You can test it with

delimiter //
create procedure t()
begin
  update a set x = 1;
end
//
delimiter ;

drop table if exists a;
create table a (x integer default 0);
insert into a values (0);

and the php program

<?php
require_once('db.php');
mysql_connect( MYSQL_HOST, MYSQL_USER, MYSQL_PWD );
mysql_select_db( MYSQL_DATABASE );
mysql_query( 'update a set x = 0' );
mysql_query( 'call t' );

Result

select * from a;
+---+
| x |
+---+
| 1 |
+---+
1 row in set

So I wonder why you don't just try.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.