use MySQL's but as true || false

jrahma

Hi,

I have a field called is_closed in MySQL table. It's a bit datatype which means it's 0 or 1

I want to know how to deal with it in PHP, like how can I (IF) it?

and is there any way to deal with it as if (is_closed == true)?

Thanks
Jassim

Weedpacket

What have you tried?

bradgrafelman

You can use [man]var_dump/man to get more information about a variable.

jrahma

Hi,

I tried:

$is_closed = $mysql_row["is_closed"]; // with and without (bool);

then I tried both:

if ($is_closed === 1) // with and without (bool);

and

if ($is_closed === 1) // with and without (bool);\

but with all above, IF is failing to understand the condition.

Thanks,
Jassim

dalecosp

jrahma;11035219 wrote:
Hi,

I tried:
$is_closed = $mysql_row["is_closed"]; // with and without (bool);
then I tried both:
if ($is_closed === 1) // with and without (bool);
and
if ($is_closed === 1) // with and without (bool);\
but with all above, IF is failing to understand the condition.

Thanks,
Jassim

But did you try:

var_dump($mysql_row);
var_dump($is_closed);

as Brad suggested?

jrahma

yes my friend

it's returning the correct value.

here is the details:

this is an inoute hidden value and I set it to 1

<input type="hidden" id="chkSupportReply" name="chkSupportReply" value="1">

then reading it here:

$is_support_reply = $_POST['chkSupportReply'];

the checking if the value is true then send an email like this:

if ($is_support_reply === 1)

the var_dump output is here:

string(1) "1"

bradgrafelman

It's returning the correct value, yes. However, the problem is you're testing for an incorrect value. "1" and 1 are not the same thing; the former is a string containing the character "1" (in ASCII, hex value 0x34). You're comparing that with the number one, hex value 0x01. Since the number 0x34 does not equal the number 0x01, your if() statement is correctly evaluating to false.

Either test for the correct value, or use the "equal" operator and not the "identical" operator. See [man]operators.comparison[/man] for more information about PHP's comparison operators.

EDIT: Furthermore, I'm confused why your first post talks about MySQL, yet the code you've shown us above has nothing to do with MySQL and everything to do with external POST'ed data from an HTML form.

Weedpacket

And note that MySQL's BIT-pattern type is not the same thing as MySQL's excuse for a BOOLEAN type; one is a string type and the other is an alias for TINYINT(1).

And yes, as bradgrafelman pointed out, POSTed form data is not the same thing as a database result set.

jrahma

EDIT: Furthermore, I'm confused why your first post talks about MySQL, yet the code you've shown us above has nothing to do with MySQL and everything to do with external POST'ed data from an HTML form.

because I have the same problem with $is_closed which is a bit field in MySQL and I trying the same way to read it.

so to check if true when posting it from <input> field I should use:

if ($is_support_reply === "1")

what about the value from a bit field in MySQL? is it also the same. Can I use it like this:

$is_closed = $mysql_row["is_closed"];
if ($is_closed === "1")

bradgrafelman

jrahma;11035259 wrote:
because I have the same problem with $is_closed which is a bit field in MySQL and I trying the same way to read it.

How do you know it's the same? Retrieving values from a database is most definitely not the same as parsing POST'ed data from a form, so trying to handle both in the same manner could very well be a problem.

jrahma;11035259 wrote:
what about the value from a bit field in MySQL? is it also the same.

Maybe. Maybe not. You'll have to examine what value you get back to find out.

jrahma

thanks bradgrafelman . One more question please.

Isn't it possible to say $is_support_reply = true? I mean by global setting or php configuration or anything else?

bradgrafelman

You could define the variable in a PHP script that gets automatically included before every file; see the auto_prepend_file directive.

jrahma

Hi,

I tried the $is_support_reply as you mentioned with "1" and it's working perfectly but I am still having a problem when it comes from a bit field from MySQL. I tried all the following but non of it worked.

please help...

if ((bool)$mysql_row["is_support_reply"] == 1)
if ((bool)$mysql_row["is_support_reply"] == "1")
if ($mysql_row["is_support_reply"] == 1)
if ($mysql_row["is_support_reply"] == "1")

bradgrafelman

Again, use [man]var_dump/man to determine the exact value of a variable.

jrahma

var_dump result is:

string(1)

but still not getting what I want. Here is what I want:

var_dump($mysql_row["is_support_reply"]);
if ($mysql_row["is_support_reply"] == "1")
{
    echo "<div style='background-color: #eee9e9; padding: 10px;'>";
    echo "<b>Support Team Replies :</b><br><br>";
}
echo date('d M Y - H:i', strtotime($mysql_row['created_date']));
echo "<br><br><hr>";
echo $mysql_row["support_ticket_message"];
echo "<br><br>";
if ($mysql_row["is_support_reply"] == "1") echo "</div>";
echo "<br>";

jrahma

string(1) "1"

cretaceous

Why not just use the MySql fake boolean of tinyInt and only set value of 0 or 1 ( which do evaluate to true or false ) ?

jrahma

well, i just noticed something wierd!!

The last code which I posted is working fine on my localhost but not working on my remote host.

I am getting the colored <div> when I open it on my localhost but not on remote although I am getting the same var_dump on both.

what's the reason?

Thanks
Jassim