www.webdeveloper.com
Results 1 to 5 of 5

Thread: Problems with Postgresql and PHP

  1. #1
    Join Date
    Aug 2009
    Location
    Virginia, USA
    Posts
    14

    Problems with Postgresql and PHP

    So, I'm new to using postgresql, and I'm having some issues getting data out using PHP. I am able to connect to the database, and I've printed my query string out and run it in pgAdmin III, and it works fine, but I do not get a result set back.

    PHP Code:
    $my_pg pg_connect('host='.$hostname.' dbname='.$dbGeomName.' user='.$username.' password='.$password);
    if (!
    $my_pg)
    {echo 
    "didn't connect<br>";}
    else
    {echo 
    "connected<br>";}

      function 
    colorCode($county)
      {
        
    $query "select \"1HR\" from \"Flood_Advisor\" where \"name\" ilike '".$county."%'";
        
    $result pg_query($my_pg$query) ;//or die ("failed to get results ".pg_last_error());
        
    if(!$result)
        { echo 
    "failed to get rows<br>"; }
        else
        {echo 
    "got rows<br>";}
        
    $resultArray pg_fetch_array($result0) ;//or die ("no rows");
        
    $stuff $resultArray['1HR'];
        echo 
    $query." ".$county." is ".$stuff."<br>";
      }
    colorCode("Augusta"); 
    for output I get:
    ---------------------------------------
    connected
    failed to get rows
    select "1HR" from "Flood_Advisor" where "name" ilike 'Augusta%' Augusta is
    ---------------------------------------
    So, it seems I am connecting to postresql, but fail to get a result, the query spit out does return a result though. Any help is greatly appreciated.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,328
    How about echoing the result of pg_last_error() in your error code if the pg_query() fails?

    (Or look into using pg_send_query(), pg_get_result() and pg_result_error() to possibly get more useful data.)
    Last edited by NogDog; 11-24-2009 at 12:36 PM.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Aug 2009
    Location
    Virginia, USA
    Posts
    14
    I added in:
    PHP Code:
        echo "row: ".pg_numrows($result)."<br>";
        echo 
    "error: ".pg_last_error(); 
    I also tried changing my query to:
    PHP Code:
    $result pg_query($my_pg$query) or die ("failed to get results ".pg_last_error()); 
    But in both instances, I do not receive an error message from pg_last_error, and I also do not receive a row count. I'm looking into the other methods you suggested now.

  4. #4
    Join Date
    Aug 2009
    Location
    Virginia, USA
    Posts
    14
    I just tried using pg_send_query() and pg_get_result(), and get the exact same output as with pg_query() and pg_fetch_array(). Also, pg_result_error() does the same as pg_last_error() and does not return any text.

  5. #5
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,328
    As far as I can see from the info you've provided and compared to the manual example page, I don't know why you don't get any error data. If you don't get any satisfaction here, I know there are at least a couple guys at the PHPbuilder.com forum who regularly use PostgreSQL and might have better insights into it than I do.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.17104 seconds
  • Memory Usage 2,892KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (73):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates