TurnKey Linux Virtual Appliance Library

connecting to postgresql data dase

info_26's picture

How do i connect the php pages to the database?  -- this is what I'm trying

pg_connect("host=localhost port=5432 user=postgres password=pottery dbname=postgres")
        or die("could not connect to pg db");
how would I test to display the records on the table mailing_list_sources with fields id and name  ?

The PostgreSQL host configuration file /etc/postgresql/pg_hba.conf was not found on your system. Maybe PostgreSQL has not been initialised, or your module configuration is incorrect.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)