Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 9A14E9FB251 for ; Thu, 9 Nov 2006 06:18:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 14677-01 for ; Thu, 9 Nov 2006 06:18:15 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 89C3E9FB24B for ; Thu, 9 Nov 2006 06:18:15 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so97738nzh for ; Thu, 09 Nov 2006 02:18:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ig48twefUVs8nXx2fx7cItfTpImrNZVGI7LvSX+jmOSw6jObYe5Nc4pqJHKQXZIGOjcEpBlFne8M64Gw/RjhYSA0LJnMcriLXAzyBM7vqgzQlGHhdW6H8llhWFwAZ5zLziU9UPiFr56JRfyTwAZcn9/SDBI/DrALzyvZGwDcw4s= Received: by 10.65.211.1 with SMTP id n1mr913393qbq.1163067493874; Thu, 09 Nov 2006 02:18:13 -0800 (PST) Received: by 10.65.249.11 with HTTP; Thu, 9 Nov 2006 02:18:13 -0800 (PST) Message-ID: <7b872b430611090218k55fc4cf3kf1fc83f0dccdebf2@mail.gmail.com> Date: Thu, 9 Nov 2006 13:48:13 +0330 From: "Servers24 Network" To: pgsql-php@postgresql.org Subject: PgSQL and integration between 2 PHP programs and a Java program MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19344_19846362.1163067493848" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/28 X-Sequence-Number: 3645 ------=_Part_19344_19846362.1163067493848 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I'm a newby so please bare with me : I want to integrate 2 PHP scripts and a Java program that all have the capability of using PgSQL as their databases. The point is that all the programs have their own DB and table structure. What I want to do is to have a single DB for all of them and have them authenticate the users somehow that a registered user in PHP script can login to Java program too! suppose that PHP1 scripts have a table called members with 2 fields "username" and "password". PHP2 has its own table called logins and have 2 fields "login_name" & "login_password". and my Java program have a table called profiles with "plogin" and "ppass". suppose that the password field in all the programs are MD5. Now I want to integrate them. I have read some PgSQL help books and it seems that there are many options that PgSQL offers for this, like inheritance, views and join. but I don't know exactly what to do. Can anyone help please? -- Warm Regards, Amir ------=_Part_19344_19846362.1163067493848 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,
 
I'm a newby so please bare with me :
 
I want to integrate 2 PHP scripts and a Java program that all have the capability of using PgSQL as their databases.
The point is that all the programs have their own DB and table structure.
What I want to do is to have a single DB for all of them and have them authenticate the users somehow that a registered user in PHP script can login to Java program too!
suppose that PHP1 scripts have a table called members with 2 fields "username" and "password". PHP2 has its own table called logins and have 2 fields "login_name" & "login_password". and my Java program have a table called profiles with "plogin" and "ppass". suppose that the password field in all the programs are MD5. Now I want to integrate them. I have read some PgSQL help books and it seems that there are many options that PgSQL offers for this, like inheritance, views and join. but I don't know exactly what to do. Can anyone help please?


--

Warm Regards,
Amir
------=_Part_19344_19846362.1163067493848--