Re: [PHP-DB] PHP and MySQL 5.0 stored procedures

[mohamed naazir]

plese don't ask qustion i am now start to do php and my sql don't sent
any mail please





On Thu, 10 Mar 2005 20:37:02 +1100, Guy Harrison
[EMAIL PROTECTED] wrote:
 Hi all,
 
 I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas
 looking at the stored procedure implementation.  I wanted to work with
 stored procedures in the PHP mysqli interface, but it doesn't seem to be
 ready for them yet.
 
 The things I want to do with stored procedures that I can't seem to do yet
 are:
 
 *Create a prepared statement based on call stored proc (I get 'This
 command is not supported in the prepared statement protocol yet')
 *Retrieve the value of an OUT parameter from a stored procedure.  Eg,
 after I execute the stored procedure I should be able to look into a
 variable bound to the stored procedure and see the value put in there by the
 stored procedure.
 *Retrieve multiple result sets from the stored procedure.  Stored
 procedures can return any number of result sets, so I'm looking for somthing
 like the multi_query call to operate against a prepared statement.
 
 I'm wondering if anyone knows if there is any activity around getting mysqli
 ready for 5.0, and if there is any advanced info about how it might work.
 
 Thanks,
 Guy
 
 [EMAIL PROTECTED]
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Error handling

[Guillermo]

Hi,

I'm new to PHP; I installed version 5.0.3 using Apache 2 and Postgres 8 on 
Win XP SP2. I have a connection class and one of its methods is:

  public function EjecutaSQL($pe_textoSQL = )
  {
return pg_query($this-id, $pe_textoSQL);
  }

where $pe_textoSQL contains the SQL sentence. If after executing it there is 
a Constraint error sent by the DB for example, or a syntax error in the SQL 
statement, no error or warning is displayed in the browser, unless I use 
pg_last_error() and handle the error myself.

I checked the PHP.ini and I have the parameter error_reporting  =  E_ALL

Testing these examples on PHP 4, adjusting all the necesary code to run from 
5 to 4, all warnings and errors are displayed as sent by PostgreSQL.

Any help will be appreciated,

Thanx
Guillermo N 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Log in multiple users to MySql

[Mahmoud Badreddine]

I authenticate users of my database with the Apache dialog box. I would like 
to know where do these values (usernames and passwords) get stored so that I 
can use this information to log in to the MySql database.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php