Adodb using php with PostgreSQL

Question

I have database name "TestDB" and under that I have table called "User". Above TestDB database and User table have been created in both mysql and postgres.

I have written the following code. it is working for mysql & not working for postgres.

/* The below code is show the output as array with currentuser key value property / (this is if we execute directly @ postgres prompt it will give the current user query result/ not the actual table located inside the Testdb */

php code

     include('adodb/adodb.inc.php');

     $db = ADONewConnection("mysql"); # eg 'mysql' or 'postgres'

     $db->debug = true;

     $db->Connect(localhost, "mysql", "mysql123","TestDB");

     $rs = $db->Execute('select * from User');

     print "<pre>";

     print_r($rs->GetRows());

     print "</pre>";

     $db1 = ADONewConnection("postgres"); # eg 'mysql' or 'postgres'

     $db1->debug = true;

     $db->Connect(localhost, "postgres", "postgres123","TestDB");

     $rs = $db->Execute('select * from User');

     print "<pre>";

     print_r($rs->GetRows());

     print "</pre>";

Please suggest me what to do this.

I think you posted the same code snippets twice?

LondonAppDev
– LondonAppDev

2013-10-22 06:48:44 +00:00
Commented Oct 22, 2013 at 6:48 — LondonAppDev
– LondonAppDev, Commented Oct 22, 2013 at 6:48

Community · Accepted Answer · 2017-05-23 12:28:05Z

1

As answered here, PostgreSQL defaults to lower case characters while being case sensitive with column and table names.

After the PostgreSQL connection, you could try the following:

$rs = $db->Execute('select * from "User"');

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Oct 22, 2013 at 19:38

evalarezo

1,1538 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user2822934 Over a year ago

fine. it worked. But in this case I can't write single code for mysql as well as postgressql. is it ? how to resolve that?

evalarezo Over a year ago

You could use only lower case in column and table names.

user2822934 Over a year ago

Now I have used only lowercase letters for database,tablename,columns. still it is not displaying respective table user

evalarezo Over a year ago

That is always tricky. Instead do you have consider to use some kind of ORM library, as RedBean? Or a full framework, as Laravel?

user2822934 Over a year ago

yes it is working now. i recreated all the database names,tables,column names in lowercase.

Collectives™ on Stack Overflow

Adodb using php with PostgreSQL

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related