Databases
in [PHP]
|
Any good explanations of pg_send_execute and friends? Has anyone found anything in their travels around the web? The manual is okay, but the examples are so simplistic it's difficult to understand how it should really be used. For example, if I have a loop of pg_send_execute based INSERT statements inside a transaction*, and one of them fails, how and when do I chec... 27 Apr 2010 07:40
UNION ALL query help I am received the error message: Unknown column 'title' in 'field list' from the query below. I am not understanding what I have done wrong. The goal of the query is with for a RSS feed determining the 15 most current articles. Ron SELECT title, content_date, content, reference FROM ( ( SELECT `p... 26 Apr 2010 04:48
Problem with pg_prepare - PostgresSQL Hi all. I'm receiving the following message when I try to use pg_prepare() function: "Call to undefined function pg_prepare()". My application works very well with others pg_* commands... I already checked my configuration files and I have no more ideas about how to fix it. Any suggestions? Thank y... 26 Apr 2010 19:31
session management Hey Guys, I need some help on an effficient session management, right now what I do is check if the user has loggedin using his username, and create a SESSION['logged']=1, setting a login flag actually, I am not sure if this is the best way ? What do you guys use for sessions, and which is the best possible wa... 23 Apr 2010 07:38
PDOException: could not find driver (postgres) What could be causing this please? Going direct, using pg_connect, is not a problem. The code in question looks like $pdo = new PDO('pgsql:host=localhost;port=5432;dbname=mydb', 'dbuser', 'dbpass'); (I think - I've yet to be able to debug it down to a single line) ... 22 Apr 2010 09:18
Sharing happiness！！ Dear friend, I get good news. rictrade now has a big promotion. Every day the first 100 customers will be offered 50% discount for its all products. Besides, they accept payment via credit cards for customers convenience. It is very nice, isnt it? Lets have a look at www.rictrade.org ... 22 Apr 2010 01:01
andrew bower http://www.h-dslovakia.sk/home.php -- Charles Morris cmorris(a)cs.odu.edu, cmorris(a)occs.odu.edu Network Security Administrator, Software Developer Office of Computing and Communications Services, CS Systems Group Old Dominion University http://www.cs.odu.edu/~cmorris ... 21 Apr 2010 02:14
UPPER(AES_DECRYPT(...)) bug? must be kidding.. of course its a bug !! The docs clearly state as "The encryption returns binary string" and if you notice function discussed here is for Decryption... Refer : http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_aes-encrypt It clearly says, "AES_DECRYPT() decrypts the ... 20 Apr 2010 13:27
Fwd: Apache log: database shutdown Since yesterday I have following situation. 1) Everything works fine for about one hour. 2) Site didn't show up and apache log is following: [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: database Centrum:Centrum shut... 20 Apr 2010 10:20
Session Timeout question What is the best way to set a user timeout on a session? Say if the user steps away from their computer for say 5 min, and they come back to the page they were on, I want when the user clicks something for the session to kick them off and redirect to login saying their session has timed out. I have this code ... 18 Apr 2010 20:51 |