Member Avatar for NilovSerge

Hi, all!
How in PHP get ResultSet from function PostGreSql8.0.3(Windows) and how is constructed
this PostGreSql-function?
If possible, please, link to some example.
Thanks in advance
Nilov Serge

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by srikanth1243
Member Avatar for srikanth1243

You have to use adodb interface to connect to postgresql db.
use this:
$con=&ADONewConnection('postgres');//postgres is default super user for postgresql db.
$con->PConnect(server name,username of u'r DB,password,database name);//connect to DB with specified username you can also use Connect in place of PConnect
$con->Execute(query);//This will gives you the result set object.
OR $con->GetAll(query);//will gives you double dimensional array of resultset (rows and columns)
OR $co->GetRow(query);//will give single row of result set as single dimensional array

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.