php mysql bit fields

Question

Strange, i am using apache + php with windows. php processed mysql bit fields as number: it's work correct;

$b = $row['bit_field'] 
if ($b == 1) {
  echo 'ok';
}

with centos and php 5.3.3 './configure' '--with-mysql' '--with-mcrypt' '--enable-mbstring' '--with-imap' '--with-kerberos' '--with-imap-ssl' '--with-libjpeg' '--with-libpng' '--with-gd'

i need

$b = $row['bit_field'] 
if (ord($b) == 1) {
  echo 'ok';
}

What option changing it?

-- Thanx

"Strange, I am using apache + php with windows." - Indeed. :-) — Tomalak
– Tomalak, Commented Oct 17, 2010 at 11:57
@Tomalak pah. It's not 1999 anymore. Apache + Win work like a charm :) — Pekka
– Pekka, Commented Oct 17, 2010 at 12:06
I have the exact problem, under Linux/php I have to use ord($row['bit_field']) to get a 0 or 1 value, while for windows, I can simply use $row['bit_field']. I'm using the same MySQL server. — Roalt
– Roalt, Commented Mar 15, 2011 at 10:23

GordonM · Accepted Answer · 2010-10-18 10:32:03Z

5

If the field you're dealing with is indeed a bit field, then surely you should be using the bit field operators to test what bits are set in the value?

if ($b & 0X1) { echo ('Least significant bit in byte set'); }
if ($b & 0X80) { echo ('Most significant bit in byte set'); }
if ($b & 0X80000000) { echo ('Most significant bit in 32 bit word set'); }

You can use these to check individual bits in a bit field regardless of the values of the other bits.

answered Oct 18, 2010 at 10:32

GordonM

31.9k17 gold badges94 silver badges134 bronze badges

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

Collectives™ on Stack Overflow

php mysql bit fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related