Re: [PHP-DB] php sessions

2005-02-15 Thread The Disguised Jedi
you could put in a database an action field, and have a function check the action on every page. If the action says certain things, like KILL or REVALIDATE, then have it perform certain actions. For the first, I'd output an error page that says something like "Your session was killed by administr

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP withsame username

2005-02-15 Thread Bastien Koert
sounds like a mysql account user permissions problem to me, too bastien From: Martin Norland <[EMAIL PROTECTED]> Reply-To: php-db@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP withsame username Date: Tue, 15 Feb 2005 15:59:09 -0600 Ell

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with same username

2005-02-15 Thread Martin Norland
Elliot Mackenzie wrote: I have encountered a "hidden database" issue with mod_php, apache2 and mySQL that I have thus far been unable to resolve. I am able to connect to the mysql socket using mysql_connect, but then find that mysql_list_dbs only returns the "test" database. This *sounded* like

[PHP-DB] Database visible via mysql CLI but not MOD_PHP with same username

2005-02-15 Thread Elliot Mackenzie
I have encountered a "hidden database" issue with mod_php, apache2 and mySQL that I have thus far been unable to resolve. I am able to connect to the mysql socket using mysql_connect, but then find that mysql_list_dbs only returns the "test" database. This *sounded* like an issue with the SHOW

Re: [PHP-DB] referencing external functions

2005-02-15 Thread Bastien Koert
You can have that happen even with this code. If they limit the max_connections, then the only thing you can do is to manage the connections the best you can. OPen and close then for the bare minimum time. Create the SQL, then open the connection, process it, get the resultback and close the li

Re: [PHP-DB] referencing external functions

2005-02-15 Thread J. Connolly
Thanks Bastian, I did not understand that require and include are not considered arguments. When i removed the parentheses everything was ok. I was also having a problem because my hosting company shut down my database for having too many connections... jzf -- PHP Database Mailing List (http://

RE: [PHP-DB] php sessions

2005-02-15 Thread Bastien Koert
The only way to be able to track user sessions would be to use a db, for the functionality that you want. Move your entire sessoion handling to the db (see here for an article on this:http://www.phpbuilder.com/columns/ying2602.php3?aid=19 ) You can track user ids, session ids, ip addresses

RE: [PHP-DB] referencing external functions

2005-02-15 Thread Bastien Koert
the error tells me that the files are not in the same dir...I have run into this one as well and it was always that case. Your usage is off though...What you need to do is to include the functions.php page and then call a particular function..also any error handling should be with the function

Re: [PHP-DB] referencing external functions

2005-02-15 Thread Matt M.
> and am trying to use it in this links3.php > > include('functions.php') or die (mysql_error()); > ?> > > but I keep getting the error message > *Warning*: main(1): failed to open stream: No such file or directory in > *C:\Accounts\dbadream\wwwRoot\links3.php* on line *4* > *Warning*: main(): F

[PHP-DB] referencing external functions

2005-02-15 Thread J. Connolly
Sorry if this is a duplicate. I accidentally sent to the listserve from the wrong address. I am having trouble calling external functions. I am trying to use this to clean up the code in the display. I have this as the function.php function links() { global $link; $sql = "select * from jozef_l

RE: [PHP-DB] To login a user without grant on ISP mysql

2005-02-15 Thread Bastien Koert
You need an account with at least select privileges to run any query. Are you trying to create an account on the mysql for each user? Don't do that. Use table based authentication for each user and use whatever default mysql account you have to run the queries. Bastien From: "moses Woldeselassi

[PHP-DB] To login a user without grant on ISP mysql

2005-02-15 Thread moses Woldeselassie
I tested all my php code on localhost.They were working fine using (localhost,bm_user, pss), but now I am using mysql on ISP side. in this case I don't have any Privileges on the db. the registration system works fine, but i do have a problem with login. I am looking for simple example or any he

RE: [PHP-DB] Cannot connect to local server

2005-02-15 Thread Denis Gerasimov
Thanks, Miles! But actually I have PHP 5.0.2 + MySQL 4.1.9 + mysqli + PEAR::DB latest installed on the server. I have spent some weeks struggling with connection and charset problems. But today I finally solved all these issues except one thing that seems to be a bug of PEAR::DB package. The pr

[PHP-DB] php sessions

2005-02-15 Thread mel list_php
Hi! I have a few questions about the sessions in php. I have a website where users are authentified through a login/password stored in a database. Once accepted, I start a session. - can I "disconnect" an user? I mean I have a logout script, which is called when the user wants to logout, but can