|
|
 |
|
|
Thread Tools | Display Modes |
Feb 17th, 2005, 6:01 PM
|
#1 |
|
PFO Founder
  
Join Date: Mar 2004
Location: Fargo, ND
Posts: 1,667
Rep Power: 10
    |
php and postgreSQL
Ok my question is when using php to connect to a postgreSQL database and when you send it a query what command is best and which one is the newest command. i have been look around and online i find pg_query but in this book i have it uses pg_exec. so which on is better or is there even a difference? thanks
__________________
BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead. |
|
|
|
Feb 17th, 2005, 9:53 PM
|
#2 |
|
Professional Programmer
Join Date: Dec 2004
Location: Worcester, MA
Posts: 441
Rep Power: 4
 |
for mysql i use mysql_query, i assume you should use pg_query, since i can't even find pg_exec in the PHP API...
 Dizz |
|
|
|
|
Feb 17th, 2005, 10:39 PM
|
#3 |
|
PFO Founder
Join Date: Mar 2004
Location: Fargo, ND
Posts: 1,667
Rep Power: 10
|
sounds good.
i didnt even find pg_exec anywhere either so thats what im goin to use thanks
__________________
BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead. |
|
|
|
|
Feb 18th, 2005, 9:57 AM
|
#4 |
|
Programming Guru
Join Date: May 2004
Location: Brandon, Manitoba, Canada
Posts: 2,023
Rep Power: 7
|
pg_query is what i use i think. pg_exec is back from the days when they first released version 4
__________________
Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! |
|
|
|
|
Feb 18th, 2005, 9:57 AM
|
#5 |
|
Professional Programmer
Join Date: Dec 2004
Location: Worcester, MA
Posts: 441
Rep Power: 4
|
cool, if you read the php.net comments in the API, A lot of people put their opinion down, or there's mention of which method is safer/faster if there are multiple ways to do something,
http://www.php.net/manual/en/funcref.php |
|
|
|
|
Feb 18th, 2005, 10:02 AM
|
#6 |
|
Programming Guru
Join Date: May 2004
Location: Brandon, Manitoba, Canada
Posts: 2,023
Rep Power: 7
|
yeah i love the user comments in the php manual. They've helped me more than once.
__________________
Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! |
|
|
|
|
Feb 18th, 2005, 10:24 AM
|
#7 |
|
PFO Founder
Join Date: Mar 2004
Location: Fargo, ND
Posts: 1,667
Rep Power: 10
|
yeah. i believe i will be using the pg_query as it is the newer of the 2 commands
__________________
BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead. |
|
|
|
|
Feb 18th, 2005, 10:24 AM
|
#8 |
|
Professional Programmer
Join Date: Dec 2004
Location: Worcester, MA
Posts: 441
Rep Power: 4
|
yeah, they usually have more information, and better examples than the docs themselves
|
|
|
|
|
Feb 18th, 2005, 10:52 AM
|
#9 |
|
Programming Guru
Join Date: May 2004
Location: Brandon, Manitoba, Canada
Posts: 2,023
Rep Power: 7
|
yeah for sure
__________________
Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! |
|
|
|
|
Feb 27th, 2005, 6:48 PM
|
#10 | |
|
Newbie
Join Date: Feb 2005
Posts: 12
Rep Power: 0
|
From php.net's page in regards to pg_query:
Quote:
__________________
--Vorlin "Systems administration - it's not just my job, it's how I buy video games!" |
|
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
