phplib-users — A list for users of phplib to talk / discuss phplib

Re: [Phplib-users] DB putting results to strings

[Stefan M. <me...@me...>]

Hello Matthew,

thanks for you fast responding. So I solved my problem by your 
suggestion in this way now:

query="SELECT * FROM exampleDB";
$db1->query($query);
$meta=$db1->metadata("", true);
while ($db1->next_record()) {
	for ($i=0; $i<=$meta["num_fields"]; $i++) {
			$col=$meta[$i]["name"];
			$$col=$db1->f($col);
	}
	echo $loginID;
	echo $other_colnamevalues;
}

Do you see an easier solution or a chance to put this whole thing 
into a function inside a new class that extends DB_Sql?
Tried this in my own class DB_Example in local.inc:

class DB_Example extends DB_Sql {
	var $classname = "DB_Example";
	var $Host = "localhost";
	var $Database = "example_base";
	var $User = "user";
	var $Password = "pass";
	function get_values($table="") {
		global $query;
      	$this->db = new $this->classname;
		$this->db->query($query);
		$meta=$this->db->metadata($table, true);
		for ($i=0; $i<=$meta["num_fields"]; $i++) {
			$col=$meta[$i]["name"];
			$$col=$this->db->Record[$col];
			}
		return $$col;
	}
}


Which should be used in this context:

$query="SELECT * FROM exampleDB;
$db->query($query);
while ($db->next_record()) {
	$db->get_values();
	echo $loginID;
	echo $other_colnamevalues;
}

But this didn't worked. Any new ideas?

Thanks and Greetings,
Stefan

Re: [Phplib-users] DB putting results to strings

[Michael C. <mdc...@mi...>]

On Fri, Aug 09, 2002 at 07:06:41AM -0400, Matthew Leingang wrote:
> Hi,
> 
> You can use the metadata method to get the list of column names.  
> 
> Or you can access the Record member directly and use extract.
> extract($db->Record) would work great except that there are numeric keys 
> in $db->Record.  I'm pretty sure PHP can be told to ignore these.

Actually, it's no big deal.  You get some variables that are ${'0'},
${'1'}, etc.  Make sure to use:

extract($db->Record, EXTR_OVERWRITE);

When you do.

Michael
-- 
Michael Darrin Chaney
mdc...@mi...
http://www.michaelchaney.com/

Re: [Phplib-users] DB putting results to strings

[Matthew L. <lei...@ma...>]

Hi,

You can use the metadata method to get the list of column names.  

Or you can access the Record member directly and use extract.
extract($db->Record) would work great except that there are numeric keys 
in $db->Record.  I'm pretty sure PHP can be told to ignore these.

Read the documentation or better yet, the source code.

HTH,
Matt

On Fri, 9 Aug 2002, Stefan Melcher wrote:

> Hello,
> 
> donno if this is still possible with current version of PHPLib or 
> maybe an idea for the future. Can I automatically put a database 
> value into a string named after the column where the value belongs 
> to?
> 
> Example:
> $db=new DB_Example;
> $query="SELECT * FROM exampleDB WHERE testID='test'";
> $db->query($query);
> while ($db->next_record()) {
> 	$$active_column_name=$db1->f("active_column_value");
> }
> 
> The old version was:
> $db=new DB_Example;
> $query="SELECT * FROM exampleDB WHERE testID='test'";
> $db->query($query);
> while ($db->next_record()) {
> 	$column_name1=$db->f("column_value1");
> 	$column_name2>=$db->f("column_value2);
> 	$column_name3=$db->f("column_value3");
> 	[...]
> }
> 
> 
> Any thoughts about it?
> 
> Thanks and greetings,
> Stefan
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users
> 

-- 
----------------------------------------------------------------
Matthew Leingang                http://www.math.rutgers.edu/
Rutgers University              lei...@ma...
Department of Mathematics       "This signature needs no quote."

[Phplib-users] DB putting results to strings

[Stefan M. <me...@me...>]

Hello,

donno if this is still possible with current version of PHPLib or 
maybe an idea for the future. Can I automatically put a database 
value into a string named after the column where the value belongs 
to?

Example:
$db=new DB_Example;
$query="SELECT * FROM exampleDB WHERE testID='test'";
$db->query($query);
while ($db->next_record()) {
	$$active_column_name=$db1->f("active_column_value");
}

The old version was:
$db=new DB_Example;
$query="SELECT * FROM exampleDB WHERE testID='test'";
$db->query($query);
while ($db->next_record()) {
	$column_name1=$db->f("column_value1");
	$column_name2>=$db->f("column_value2);
	$column_name3=$db->f("column_value3");
	[...]
}


Any thoughts about it?

Thanks and greetings,
Stefan

[Phplib-users] Problem with different browswer in sesson.nc

[Serghej P. <sp...@ti...>]

Hello

I have problems to login wint IE 5.5 i get this error:

Warning: Variable passed to reset() is not an array or object in =
D:\www\includes\phplib\session.inc(281) : eval()'d code on line 1=20

and on any reload or change page i prompted to insert login and password =
(crcloginform.ihtml)

Apache 1.3.26 php 4.2.2 Mysql WinNT 2000


Somebody has had pb like this?

Best
Serghej

RE: [Phplib-users] Help need for AUTH - ho to make unprotected pages

[Layne W. <la...@if...>]

> I have in my autoprepend.php this string:
> page_open(array("sess" => "TiSid", "auth" => "Crypt_Auth", 
> "perm" => "Perm", "user" => "User"));
> 
> Of corse you prompted to login and password in any page. But 
> how can i unprotect the pages for registration and 
> changepassword without putting page_open() in any single page 
> only for esclude two pagese from authtentication scheme?

I would never make the change password page unprotected, but you can make
your own decision on that. Here's what I do:

switch($HTTP_SERVER_VARS["SCRIPT_NAME"])
	{
	case "/forgot_password.php":
	case "/register.php":
		page_open(array("sess" => "mySession"));
		break;
	default:
		page_open(array("sess" => "mySession", "auth" =>
"myChallenge_Crypt_Auth", "perm" => "myPerm", "user" => "myUser"));
	}


Layne Weathers
Ifworld Inc. 

[Phplib-users] RE: Phplib-users digest, Vol 1 #255 - 1 msg

[Serghej P. <sp...@ti...>]

Try to use crcloginform.ihtml it's work fine for me

Best

Serghej

-----Original Message-----
From: php...@li...
[mailto:php...@li...]
Sent: Wednesday, August 07, 2002 9:14 PM
To: php...@li...
Subject: Phplib-users digest, Vol 1 #255 - 1 msg


Send Phplib-users mailing list submissions to
	php...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/phplib-users
or, via email, send a message with subject or body 'help' to
	php...@li...

You can reach the person managing the list at
	php...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Phplib-users digest..."


Today's Topics:

   1. App does not work any more ! Help needed (Jose L. Marcos)

--__--__--

Message: 1
Date: Wed, 07 Aug 2002 16:58:52 +0200
From: "Jose L. Marcos" <jos...@cn...>
To: php...@li...
Subject: [Phplib-users] App does not work any more ! Help needed

Hi folks,

may be it's a faq, but here it goes...

I've been using quite happily an intranet app. based on PHPLib 7.2c /=20
Apache 1.3.14 / PHP 4.06 / Netscape 4.77 browser.

As I've upgraded the Linux Box, I've also tried to upgrade the softs on=20
this box... By idea, this was... ;-(

I've moved to PHP 4.2.2, Apache 1.3.26, Mozilla 0.99.8 and PHPLib=20
7.4pre1. I've made the modifications in my prepend.php3 / local.inc and=20
crLoginForm.ihtml (well I use the auth_md5 class) but it doesn't work=20
anymore :

- I get my usual login form, but entering user/password just gives me a=20
new blank login form.

Looking in the mysqld.log file, the only thing I see is that the query=20
made against auth_user table is looking for a username =3D ''... This =
make=20
me think that the values I enter in the login form are not correctly=20
passed to auth_validatelogin method.

But that's the only thing I've found !

Any help really apreciated,

--=20
	Jose Luis

-------------------------------------------------------------------------=
---
    Y no llegaste a quererme, y eran mis cinco sentidos
     Y no llegaste a quererme, y que desgraciaito he sido
      Y que ha tenido que aborrecerte tanto como te ha querido (Camaron)
-------------------------------------------------------------------------=
---




--__--__--

_______________________________________________
Phplib-users mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phplib-users


End of Phplib-users Digest

[Phplib-users] Help need for AUTH - ho to make unprotected pages

[Serghej P. <sp...@ti...>]

Hello everybody.

I have in my autoprepend.php this string:
page_open(array("sess" =3D> "TiSid", "auth" =3D> "Crypt_Auth", "perm" =
=3D> "Perm", "user" =3D> "User"));

Of corse you prompted to login and password in any page. But how can i =
unprotect the pages for registration and changepassword without putting =
page_open() in any single page only for esclude two pagese from =
authtentication scheme?

Please help=20

Best

Serghej

Re: [Phplib-users] App does not work any more ! Help needed

[Justin S. <ju...@ia...>]

sounds like a problem with register_globals.  By default the php.ini
configuration directive register_globals is turned off as of 4.2.0.  It
used to be on by default, which is why you could POST or GET variables
to a php script and refer to them as $username or $password.  Now you
are supposed to use the superglobals, and refer to the POST'ed variables
as _$POST['username'] and _$POST['password'] .  This is much safer,
which is why the change was made, but you can always just set
register_globals to off in your php.ini file if you want the old
behaviour back.

all about superglobals:
http://www.php.net/manual/en/language.variables.predefined.php#language.variables.superglobals

read more here about security in php:
http://www.zend.com/zend/art/art-oertli.php


Justin Simpson

On Wed, 2002-08-07 at 07:58, Jose L. Marcos wrote:
> Hi folks,
> 
> may be it's a faq, but here it goes...
> 
> I've been using quite happily an intranet app. based on PHPLib 7.2c / 
> Apache 1.3.14 / PHP 4.06 / Netscape 4.77 browser.
> 
> As I've upgraded the Linux Box, I've also tried to upgrade the softs on 
> this box... By idea, this was... ;-(
> 
> I've moved to PHP 4.2.2, Apache 1.3.26, Mozilla 0.99.8 and PHPLib 
> 7.4pre1. I've made the modifications in my prepend.php3 / local.inc and 
> crLoginForm.ihtml (well I use the auth_md5 class) but it doesn't work 
> anymore :
> 
> - I get my usual login form, but entering user/password just gives me a 
> new blank login form.
> 
> Looking in the mysqld.log file, the only thing I see is that the query 
> made against auth_user table is looking for a username = ''... This make 
> me think that the values I enter in the login form are not correctly 
> passed to auth_validatelogin method.
> 
> But that's the only thing I've found !
> 
> Any help really apreciated,
> 
> -- 
> 	Jose Luis
> 
> ----------------------------------------------------------------------------
>     Y no llegaste a quererme, y eran mis cinco sentidos
>      Y no llegaste a quererme, y que desgraciaito he sido
>       Y que ha tenido que aborrecerte tanto como te ha querido (Camaron)
> ----------------------------------------------------------------------------
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users
> 

[Phplib-users] App does not work any more ! Help needed

[Jose L. M. <jos...@cn...>]

Hi folks,

may be it's a faq, but here it goes...

I've been using quite happily an intranet app. based on PHPLib 7.2c / 
Apache 1.3.14 / PHP 4.06 / Netscape 4.77 browser.

As I've upgraded the Linux Box, I've also tried to upgrade the softs on 
this box... By idea, this was... ;-(

I've moved to PHP 4.2.2, Apache 1.3.26, Mozilla 0.99.8 and PHPLib 
7.4pre1. I've made the modifications in my prepend.php3 / local.inc and 
crLoginForm.ihtml (well I use the auth_md5 class) but it doesn't work 
anymore :

- I get my usual login form, but entering user/password just gives me a 
new blank login form.

Looking in the mysqld.log file, the only thing I see is that the query 
made against auth_user table is looking for a username = ''... This make 
me think that the values I enter in the login form are not correctly 
passed to auth_validatelogin method.

But that's the only thing I've found !

Any help really apreciated,

-- 
	Jose Luis

----------------------------------------------------------------------------
    Y no llegaste a quererme, y eran mis cinco sentidos
     Y no llegaste a quererme, y que desgraciaito he sido
      Y que ha tenido que aborrecerte tanto como te ha querido (Camaron)
----------------------------------------------------------------------------

[Phplib-users] problems with installation

[Alvaro <i16...@pe...>]

When i try to open the example pages,before installation,i recive thi =
erreo message:

Fatal error: Cannot instantiate non-existent class: bd_example in =
D:\Proyecto\php\phplib-7.2d\php\ct_sql.inc on line 32


I use php4,apache,mysql,Windows XP.Thanks

[Phplib-users] problems with installation

[Alvaro <al...@ho...>]

When i try to open the example pages,before installation,i recive thi =
erreo message:

Fatal error: Cannot instantiate non-existent class: bd_example in =
D:\Proyecto\php\phplib-7.2d\php\ct_sql.inc on line 32

I use php4,apache,mysql,Windows XP.Thanks

[Phplib-users] any vhost can force gc_maxlifetime and empty the cauldron?

[Giancarlo <gia...@na...>]

This is about the php session4, module with save_handler 'files'
Is it true like that? 
any vhost can force gc_maxlifetime and delete everyone else's session?
Out Of Service?
Well, this seems to happen to me, by zeroing the session life to everyone 
because session.gc_maxlifetime is INI_ALL, settable anywhere.
This is for sessions managed by that apache in a vhost env, where more sites 
use the /tmp cauldron.
Maybe the umask directive of PHP (but where is it? I am sure there was one..)

I did some quick test and...
ought to shed some lite...
ahi ahi ahi...
tell me that ain't true...
woo woo woo...

Gian

Re: Re[4]: [Phplib-users] Access denied, 2 databases, extrange error

[Giancarlo <gia...@na...>]

>
> The system is working, connect and get results from the different
> databases, and shows correctly but the only problem its the error when
> finishing after the </html> label. As I said previously I suspect that
> this error occurs when PHP try to finish the conection, but I have no
> idea why its mixing conection details from the different classes.
>
> I maked all the changes proposed: use different users, put the database
> name in the query, etc.
>

Did you try to disable mysql persistent connections? it can be done via 
htaccess, php ini, or in the script top.

Gian

Re[4]: [Phplib-users] Access denied, 2 databases, extrange error

[3s <3s...@se...>]

Hi Donncha,

yes I was looking for an answer from yesterday, but without no luck.

The system is working, connect and get results from the different
databases, and shows correctly but the only problem its the error when
finishing after the </html> label. As I said previously I suspect that
this error occurs when PHP try to finish the conection, but I have no
idea why its mixing conection details from the different classes.

I maked all the changes proposed: use different users, put the database
name in the query, etc.

I was seeing in the forums a lot of problems to manage multiple
connections with PHPLIB, ADODB and others, none of then seems suitable
for this purpose.

That is the reason to look for a different approach, OOP approach,
because I'm not an expert in this way and possibly must be a better way
to do it.

Regards,
Jos=E9 Valle

On/El Thu, 1 Aug 2002 10:15:08 +0100
Donncha O Caoimh <don...@tr...> wrote/escribi=F3:

> If you did change the username used by each db class and still got that e=
rror=20
> there's something really strange going on.=20
> I presume you have setup MySQL correctly, that the usernames you chose do=
 have=20
> permission to access those tables, that your webserver can talk to the My=
SQL=20
> server, etc.
>=20
> Have you tried googling for an answer?
>=20
> Donncha.
>=20

--=20
3s <3s...@se...>

Re: Re[2]: [Phplib-users] Access denied, 2 databases, extrange error

[Donncha O C. <don...@tr...>]

On Thursday 01 August 2002 08:43, 3s wrote:
> Hi,
>
> after checking the proposals from woodbri and Donncha, still not workin=
g
> and I'm thinking that the problem must be solve in other way. Because
> its a conceptual matter possibly.
>
[snip]
> =093-db classes, one db class for every table or group of
> =09tables, including their own common methods for insert, update,
> =09etc in every class

If you did change the username used by each db class and still got that e=
rror=20
there's something really strange going on.=20
I presume you have setup MySQL correctly, that the usernames you chose do=
 have=20
permission to access those tables, that your webserver can talk to the My=
SQL=20
server, etc.

Have you tried googling for an answer?

Donncha.

Re: [Phplib-users] parse error in auth.inc

[Donncha O C. <don...@tr...>]

What version of PHP are you using?
Try the following..

## back compatibility: if database_class is set, create db object
if(isset($this->database_class)) {
  $t =3D $this->database_class;
  $this->db =3D new $t;
}

I know there was a problem with PHP3 using the original format.=20
Phplib 6.1 had this workaround.. It's still running on one of our servers=
!
Here's the original code:

## Set up the database connection
$class    =3D $this->database_class; ## PHP - I hate it!
$this->db =3D new $class;

Donncha.



On Thursday 01 August 2002 00:11, Marco wrote:
> Hi Peter,
>
> I looked in my local.inc. I've found some different extensions of the
> Auth class (to test some different kinds of logins). But all of them
> have a $database_call =3D "DB_Example"; in it. I think this should be o=
k.
>
> Marco
>
> Peter Kursawe wrote:
> >Hi Marco,
> >

Re[2]: [Phplib-users] Access denied, 2 databases, extrange error

[3s <3s...@se...>]

Hi,

after checking the proposals from woodbri and Donncha, still not working
and I'm thinking that the problem must be solve in other way. Because
its a conceptual matter possibly.

The main problem, I think, it is the way I use PHPLIB into my
applications. I'm not an OOP master obviouslly, will try to explain you,
if you can sugest a better approach I'll appreciate very much your
advice.

Applications are build in many layers:

1-index page, load general modules, make security tasks and if all goes
well, load the requested page, if not redirect to the home page
2-Page that calls, has their own code for make specific tasks calling to
other modules:
	3-db classes, one db class for every table or group of
	tables, including their own common methods for insert, update,
	etc in every class
	4-template
	5-layout
		5a-layout calls other pages or modules needed for it own



What is the problem? I make a new instance of the main db class in every
method of every class that manage tables.

Example:

class categories extends pageNavigation {

  function categories(){
   //calls to libs, language error files, etc
  }

  function add($array){

    // HERE IT IS THE PROBLEM------------------------------------
    // extension of the db_sql class with their own connection
    // parameters

    $q= new tbl;

    //-----------------------------------------------------------

    $query="insert into categories set bla, bla";
    if(!$q->query($query)){
      $this->error=$this->msg['NOCONNECTION'];
      return;
    }
    return TRUE;
  }

}

What is the advantage? every class for table manage, has their code very
well enclosed and can be changed little by little. Every table class has
also a constructor for call common libs, language files, etc.

I have two different possibilities, change all my code to implement a
new solution around PHPLIB db class or migrate to other database library
and make a lot of work also.

Regards,
-- 
3s <3s...@se...>

Re: [Phplib-users] parse error in auth.inc

[Marco <new...@dk...>]

Hi Peter,

I looked in my local.inc. I've found some different extensions of the 
Auth class (to test some different kinds of logins). But all of them 
have a $database_call = "DB_Example"; in it. I think this should be ok.

Marco



Peter Kursawe wrote:

>Hi Marco,
>
>
>>I don't know if it is or not. I simply want to "auto_prepend" my 
>>prepend.inc in php3.ini. I changed nothing in the source file so I think 
>>it should work as is, isn't it?
>>
>
>it should, but too often the "should's" do not work ;-)
>
>Usually you extend the Auth-Class in the local.inc. AFAIK the standard has a local.inc and it is included in the 
>prepend.php3
>Examine the local.inc and look into 
>
>class Auth_Example extends Auth { ...
>
>for the statement
>
>var $database_class = "xyz"; 
>
>(the xyz is something else, usually it is "DB_Example")
>
>You have to adopt the complete local.inc to your local circumstances.
>
>HTH Peter Kursawe
>

Re: [Phplib-users] parse error in auth.inc

[Marco <new...@dk...>]

Hi Peter,

I don't know if it is or not. I simply want to "auto_prepend" my 
prepend.inc in php3.ini. I changed nothing in the source file so I think 
it should work as is, isn't it?

Bye
Marco


Peter Kursawe wrote:

>Marco,
>
>>Parse error: parse error in /data/phplib/php-lib-stable/php/auth.inc on 
>>line 58
>>
>>The line is that one with the mark:
>>
>>       ## back compatibility: if database_class is set, create db object
>>       if(isset($this->database_class)) {
>>-->      $this->db = new $this->database_class;
>>       }
>>
>
>is your database_class set to a value different from '' ? Does the class name exist?
>
>Peter Kursawe
>

[Phplib-users] gc impossible if session.save_path depth > 2 ?

[Giancarlo P. <gia...@na...>]

Many hosted sites would like to keep their session.save_path separate, within their home dir, but are somehow prevented by the fact that gc wouldn't take place if the path depth is > 2.

Because they obviously see a problem in implementing their own garbage collection, as most hosting sites  do not offer a shell nor the possibility to set up cron jobs to do that, most give up that, and decide to drop their session in the common cauldron.

I went through php code, and it seems that this limit is just hardcoded in there.

I mean, is there a valid technical reason for this limit to be there or...

gian

Re: [Phplib-users] Access denied, 2 databases, extrange error

[<wo...@sw...>]

I ran into a similar problem a while back an made a permanent fix to 
the code to solve this. The changes are simple and benign and located 
in db_mysql.inc. I have posted this before and request that the 
changes get migrated into CVS, but I don't think it ever happened. 

Here is a diff of the orginal file and my changes:

[woodbri@linus php]$ diff db_mysql.inc db_mysql.inc.save
80,83c80,83
< #      if (!@mysql_select_db($Database,$this->Link_ID)) {
< #        $this->halt("cannot use database ".$this->Database);
< #        return 0;
< #      }
---
>       if (!@mysql_select_db($Database,$this->Link_ID)) {
>         $this->halt("cannot use database ".$this->Database);
>         return 0;
>       }
117c117
<     $this->Query_ID = @mysql_db_query($this->Database, 
$Query_String,$this->Link_ID);
---
>     $this->Query_ID = @mysql_query($Query_String,$this->Link_ID);
185c185
<     $res = @mysql_db_query($this->Database, $query, $this-
>Link_ID);
---
>     $res = @mysql_query($query, $this->Link_ID);
196c196
<     $res = @mysql_query("unlock tables", $this->Link_ID);
---
>     $res = @mysql_query("unlock tables");
244c244
<       $id  = @mysql_db_query($this->Database, $q, $this->Link_ID);
---
>       $id  = @mysql_query($q, $this->Link_ID);
254c254
<         $id = @mysql_db_query($this->Database, $q, $this->Link_ID);
---
>         $id = @mysql_query($q, $this->Link_ID);
263c263
<       $id = @mysql_db_query($this->Database, $q, $this->Link_ID);
---
>       $id = @mysql_query($q, $this->Link_ID);

HTH,
  -Steve

On 31 Jul 2002 at 12:39, Donncha O Caoimh wrote:

> This has been a bug that plagued me several times in the past. To fix it just 
> make sure that each database connection has a different user.
> 
> Donncha.
> 
> On Wednesday 31 July 2002 12:33, 3s wrote:
> > Hi,
> >
> > my first message to the list.
> >
> > I was using for 3 years ago DB classes from PHPLIB without problems,
> > until now.
> >
> > Normally we use the library with one database only, but in one of my
> > projects I need to connect to different databases (MySql), with different
> > servers and different users. Only in one point the system is showing me
> > the error, in other places works ok, but suspect that I have good look
> > and I doing something wrong.
> >
> > In the browser after the last </html> label shows the following error:
> >
> > Access denied for user: 'pro...@21...' to
> > database 'portal'
> >
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code1
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users
> 

Re: [Phplib-users] Access denied, 2 databases, extrange error

[Donncha O C. <don...@tr...>]

This has been a bug that plagued me several times in the past. To fix it =
just=20
make sure that each database connection has a different user.

Donncha.

On Wednesday 31 July 2002 12:33, 3s wrote:
> Hi,
>
> my first message to the list.
>
> I was using for 3 years ago DB classes from PHPLIB without problems,
> until now.
>
> Normally we use the library with one database only, but in one of my
> projects I need to connect to different databases (MySql), with differe=
nt
> servers and different users. Only in one point the system is showing me
> the error, in other places works ok, but suspect that I have good look
> and I doing something wrong.
>
> In the browser after the last </html> label shows the following error:
>
> Access denied for user: 'pro...@21...' to
> database 'portal'
>

[Phplib-users] Access denied, 2 databases, extrange error

[3s <3s...@se...>]

Hi,

my first message to the list.

I was using for 3 years ago DB classes from PHPLIB without problems,
until now.

Normally we use the library with one database only, but in one of my
projects I need to connect to different databases (MySql), with different
servers and different users. Only in one point the system is showing me
the error, in other places works ok, but suspect that I have good look
and I doing something wrong.

In the browser after the last </html> label shows the following error:

Access denied for user: 'pro...@21...' to
database 'portal'

The scritps makes all needed tasks, connect to 2 different databases,
one internal and one external, with different users, prepare the results
and shows correctly in the screen.

I use different extensions for the db_mysql class: tbl, tbl2, and so on.
Every extension has their own properties for database, user, etc. And I
make instances of this classes into the functions.

I suspect that the problem must be related to:

1st- the user must be probando@213.96.113.210, but for some reason
appears in the way pro...@21...

2nd- its trying to connect to the database 'portal' with the wrong user,
must be prueba@localhost

I tried to debug when makes connections, queries and free the results,
but doesnt shows else, during the execution of the script, only when PHP
its finishing.

Anybody can help me?

Regards,
Jose Valle
-- 
3s <3s...@se...>

[Phplib-users] unsuscribre

[<jc...@er...>]

unsuscribre