Reading boolean correctly from Postgres by PHP

Question

The main problem of this thread is moved to here about boolean datatype in PHP / Postgres.

The problem is the conversion of t and f to true and false, since Postgres stores true and false as such.

How can you use the variable a_moderator in SESSION?

I fetch the value of the variable a_moderator by

#1 code of how I get the variable

    $result = pg_prepare($dbconn, "moderator_check_query", 
        "SELECT a_moderator 
        FROM users
        WHERE email = $1;"
    );
    $a_moderator = pg_execute($dbconn, "moderator_check_query", array($_SESSION['login']['email']));

    $rows = pg_fetch_all ( $a_moderator );
  
    foreach ( $rows as $row ) {
       $_SESSION['login']['a_moderator'] = $row['a_moderator'];
    }

I use it unsuccessfully by

#2 code of how I use the variable unsuccessfully

if ( $_SESSION['login']['a_moderator'] == 't' ) {
   // do this
}

I also ran unsuccessufully the values such as true in the place of t. The variable in the SESSION has the value f such that

#3 Output which tells me he value of the varibale

Array ( [login] => Array ( 
   [passhash_md5] => dd2f85814c35fd465c30b1472f5d3af8 
   [email] => [email protected] 
   [logged_in] => 1 [user_id] => 13 
   [username] => oeauoeh 
   [a_moderator] => t ) 
)

you're still not properly fetching the data from with pg_fetch_array. It needs the PGSQL_ASSOC flag. — davethegr8
– davethegr8, Commented Aug 21, 2009 at 22:50
davethegr8: You suggest me that it is best to use pg_fetch_all and then simply foreach to read the data. — Léo Léopold Hertz 준영
– Léo Léopold Hertz 준영, Commented Aug 21, 2009 at 23:00
davethegr8: I fixed the problem with pg_fethch_array. I have still the same problem. — Léo Léopold Hertz 준영
– Léo Léopold Hertz 준영, Commented Aug 21, 2009 at 23:08

Bhavesh Patadiya · Accepted Answer · 2012-12-20 11:48:35Z

19

Select boolean field from postgre as ::int and in php cast to bool.

 "SELECT a_moderator::int 
        FROM users
        WHERE email = $1;"

$isModerator = (bool)$row['a_moderator'];

edited Dec 20, 2012 at 11:48

Bhavesh Patadiya

25.8k15 gold badges77 silver badges107 bronze badges

answered Dec 20, 2012 at 11:32

marko

2062 silver badges2 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Frank Farmer Over a year ago

Alternately, you can skip the cast in postgres, and do the conversion in PHP: $isModerator=($row['a_moderator'] === 't');

happy_marmoset Over a year ago

@Frank Farmer, you didn't got idea of question. Idea is to make code cross-platform between database extensions php_mysql, php_pgsql, php_sqlite and so on.

Frank Farmer · Accepted Answer · 2009-08-22 00:48:45Z

3

This isn't a direct answer to the question, but here's an example demonstrating that pg_*() functions do in fact return the postgres boolean true value as the PHP string 't':

[example]$ cat scratch.php 
<?php
//connect to the database...
require_once 'db_connect.php';

//query
$rows = pg_fetch_all(pg_query('SELECT TRUE::bool AS true'));
//dump returned array, and test with type-safe identity comparator
var_dump($rows, $rows[0]['true'] === 't');

[example]$ php scratch.php 
array(1) {
  [0]=>
  array(1) {
    ["true"]=>
    string(1) "t"
  }
}
bool(true)
[example]$

answered Aug 22, 2009 at 0:48

Frank Farmer

39.6k12 gold badges73 silver badges90 bronze badges

1 Comment

Léo Léopold Hertz 준영 Over a year ago

I am not sure what exactly is the main point of your answer. I opened this thread stackoverflow.com/questions/1314869/… to solve the main problem.

sth · Accepted Answer · 2011-01-18 13:00:50Z

1

I wrote a function in postgres to export boolean to PHP readable boolean:

You just use it this way:

SELECT php_bool(columna) from
table

Here is the function:

CREATE OR REPLACE FUNCTION php_bool(boolean)
RETURNS numeric LANGUAGE plpgsql

AS
$BODY$

BEGIN

  IF $1 = true THEN
    RETURN 1;
  ELSE
    RETURN 0;
  END IF;
END
$BODY$

edited Jan 18, 2011 at 13:00

sth

231k56 gold badges288 silver badges370 bronze badges

answered Jan 18, 2011 at 7:53

S. Cultura

111 bronze badge

Comments

Rob Drimmie · Accepted Answer · 2009-08-22 00:32:36Z

-3

Try:

if ( $_SESSION['login']['a_moderator'] ) {
  // do this
}

It is a boolean, not a string.

answered Aug 22, 2009 at 0:32

Rob Drimmie

1,5861 gold badge13 silver badges16 bronze badges

1 Comment

Frank Farmer Over a year ago

No, postgres booleans are returned in string form (as evidenced by the 't' in his print_r() output). Try it. I promise, pg_* never returns boolean row values as actual PHP booleans.

Collectives™ on Stack Overflow

Reading boolean correctly from Postgres by PHP

The main problem of this thread is moved to here about boolean datatype in PHP / Postgres.

#1 code of how I get the variable

#2 code of how I use the variable unsuccessfully

#3 Output which tells me he value of the varibale

4 Answers 4

2 Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

The main problem of this thread is moved to here about boolean datatype in PHP / Postgres.

#1 code of how I get the variable

#2 code of how I use the variable unsuccessfully

#3 Output which tells me he value of the varibale

4 Answers 4

2 Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related