why I am not getting the value on remote

[jrahma]

Hi,

Have a look at this page:

http://www.xoompage.com/ticket?id=034abd84-47fd-11e3-bea0-782bcb3e3838

you'll see the value returned is string(1) "" but it's actually a bit value from MySQL and I am using this to read it:

SELECT * FROM support_ticket_messages WHERE support_ticket_id = param_ticket_id ORDER BY support_ticket_message_id DESC;

I am getting the correct value when running it on my localhost and I am also getting the correct value when running the stored procedure on the database.

Then why the PHP is not showing it when I try:

if ($is_support_reply)
{
    echo "<div style='background-color: #eee9e9; padding: 10px;'>";
    echo "<b>XoomPage Replies :</b><br><br>";
}

or

if ($mysql_row["is_support_reply"])
{
    echo "<div style='background-color: #eee9e9; padding: 10px;'>";
    echo "<b>XoomPage Replies :</b><br><br>";
}

Please help..

Thanks

[traq]

jrahma;11035301 wrote:

you'll see the value returned is string(1) ""

No… I see that you've printed that to the page, but you haven't shown (or told us) what code you used to produce it. Superficially, it looks like it's from [man]var_dump[/man], but I would expect that to read either [font=monospace]string(0) ""[/font] or [font=monospace]string(1) " "[/font].

jrahma;11035301 wrote:

but it's actually a bit value from MySQL and I am using this to read it:

That's an SQL query. It won't give you a value, but a result resource. You need to let us know what you're actually doing to read that result.

jrahma;11035301 wrote:

Then why the PHP is not showing it when I try:

if ($is_support_reply)
{
    echo "<div style='background-color: #eee9e9; padding: 10px;'>";
    echo "<b>XoomPage Replies :</b><br><br>";
}

or

if ($mysql_row["is_support_reply"])
{
    echo "<div style='background-color: #eee9e9; padding: 10px;'>";
    echo "<b>XoomPage Replies :</b><br><br>";
}

Why is what not showing?

Looking at the page you linked to, the code [font=monospace]<div style='background-color: #eee9e9; padding: 10px;'><b>XoomPage Replies :</b><br><br>[/font] shows up quite a bit &#8212;which would seem to indicate that your code actually is working.

[jrahma]

traq;11035303 wrote:

No… I see that you've printed that to the page, but you haven't shown (or told us) what code you used to produce it. Superficially, it looks like it's from [man]var_dump[/man], but I would expect that to read either [font=monospace]string(0) ""[/font] or [font=monospace]string(1) " "[/font].

yes it's using var_dump. the value should be string(1) "1" or string(1) "0" as I can see on the same page on my localhost.

traq;11035303 wrote:

That's an SQL query. It won't give you a value, but a result resource. You need to let us know what you're actually doing to read that result.

What I mean to say that the value were read correctly from the database so it's for sure not a database problem...

Why is what not showing?

Looking at the page you linked to, the code [font=monospace]<div style='background-color: #eee9e9; padding: 10px;'><b>XoomPage Replies :</b><br><br>[/font] shows up quite a bit —which would seem to indicate that your code actually is working.

it's not determining the if, for example the top 4 post (20:42 to 22:30) are all with is_support_reply = 0 which means it should not come within the div but it should have just a normal background

[traq]

jrahma;11035307 wrote:

yes it's using var_dump. the value should be string(1) "1" or string(1) "0" as I can see on the same page on my localhost.

But on your live page, it says [font=monospace]string(1) ""[/font] (i.e., it claims the string length is 1, but prints an empty string). I don't know of any situation where [man]var_dump[/man] would produce this output normally (or, at all). Can you show us the code that you are using to produce this output?

jrahma;11035307 wrote:

What I mean to say that the value were read correctly from the database so it's for sure not a database problem...

…as you say, on your local machine. By "remote" (in your thread title) I assume you mean your live server - have you confirmed that the query is successful there?

[jrahma]

But on your live page, it says string(1) "" (i.e., it claims the string length is 1, but prints an empty string). I don't know of any situation where var_dump would produce this output normally (or, at all). Can you show us the code that you are using to produce this output?

<?php
    $mysql_query = $mysql_connection->prepare("CALL sp_admin_populate_ticket_messages(:param_ticket_id)");
    $mysql_query->bindParam(':param_ticket_id', $support_ticket_id, PDO::PARAM_STR);
    $mysql_query->execute();

while ($mysql_row = $mysql_query->fetch())
{
    $is_support_reply = $mysql_row["is_support_reply"];

    var_dump($mysql_row["is_support_reply"]);
    echo "<br><br>";
    if ($is_support_reply)
    {
        echo "<div style='background-color: #eee9e9; padding: 10px;'>";
        echo "<b>Our 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 ($is_support_reply) echo "</div>";
    echo "<br>";
}
?>
<?php if ($allow_replies) { ?>
<div>
<form method="post" action="reply_support_ticket?id=<?php echo $_GET["id"]; ?>">
<h1>Reply :</h1>
<textarea cols="80" id="txtMessage" name="txtMessage" rows="20" required></textarea>
<script>
    // Replace the <textarea id="editor"> with an CKEditor
    // instance, using default configurations.
    CKEDITOR.replace( 'txtMessage', {
        uiColor: '#14B8C4',
        toolbar: [
            [ 'Bold', 'Italic', '-', 'NumberedList', 'BulletedList', '-', 'Link', 'Unlink' ],
            [ 'FontSize', 'TextColor', 'BGColor' ]
        ],
        height: 200,
        width: 600
    });
</script>
<br><br>
<input type="hidden" id="chkSupportReply" name="chkSupportReply" value="0">
<input type="hidden" id="chkCloseTicket" name="chkCloseTicket" value="0">
<button id="btnSend" type="submit" style="width:180px">Send</button><br><br>
</form>
</div>
<?php } ?>

…as you say, on your local machine. By "remote" (in your thread title) I assume you mean your live server - have you confirmed that the query is successful there?

yes it's the live server at dreamhost.com and yes it's the query is successful on remote server.

[bradgrafelman]

So it claims it's a string of length 1... try adding something like this:

var_dump( ord( $mysql_row["is_support_reply"][0] ) );

after your existing var_dump() call.

[jrahma]

on my localhost, I am getting:

string(1) "0" 
int(48)

and

string(1) "1" 
int(49)

but in my remote I am just getting:

string(1) "" 
int(0)

and

string(1) "" 
int(1)

[traq]

jrahma;11035355 wrote:

but in my remote I am just getting:

string(1) "" 
int(0)

and

string(1) "" 
int(1)

There we have it - NULL and SOH, respectively.

@ - do you have any hint for us as to why this is happening? Obviously, the integer values are being interpreted as character codes, but I've never seen that happen before. Does it have to do with binding the input param as PDO:😛ARAM_STR? or maybe it's something about the connection? My first thought was a problem with the way the stored procedure returns the values, but, since it's working on his local machine, I was unsure&#8230;

[bradgrafelman]

traq;11035359 wrote:

There we have it - NULL and SOH, respectively.

Probably more appropriately referred to (based on intentions) as 0b0 and 0b1... in other words, FALSE and TRUE.

traq;11035359 wrote:

@ - do you have any hint for us as to why this is happening? Obviously, the integer values are being interpreted as character codes

Right. To reiterate what I mentioned from a similar thread, values "0" and 0 are represented numerically as 48 and 0, respectively. Thus, one has to be careful (and consistent) with how each are handled since they're obviously different values.

@: What column type is this field? Are you using the same version of MySQL and PHP on your local computer as you are on the remote? Did you populate the databases in both environments using the same data/method?

[jrahma]

What column type is this field?

it's bit column.

Are you using the same version of MySQL and PHP on your local computer as you are on the remote?

• 5.1.39 on Server

• 5.6.14 on local

Did you populate the databases in both environments using the same data/method?

Yes exactly same.

[bradgrafelman]

First thing I personally do when starting development on a project is to make sure my development environment matches my production environment and closely as possible/feasible. You might consider doing that in case PHP and/or MySQL versions are actually a factor.

I can't think of any reason off the top of my head why you're getting the conflicting results. I also would have thought that PDO would be nice and return BIT columns as numeric values rather than strings, but apparently that isn't the case.

Out of curiosity, can you show us how you're populating the databases with data? Specifically, how you represent the value you're attempting to store in this BIT column?

[jrahma]

bradgrafelman;11035377 wrote:

First thing I personally do when starting development on a project is to make sure my development environment matches my production environment and closely as possible/feasible. You might consider doing that in case PHP and/or MySQL versions are actually a factor.

I can't think of any reason off the top of my head why you're getting the conflicting results. I also would have thought that PDO would be nice and return BIT columns as numeric values rather than strings, but apparently that isn't the case.

Out of curiosity, can you show us how you're populating the databases with data? Specifically, how you represent the value you're attempting to store in this BIT column?

You are the man @. Thanks for the hint. I updated my PHP on the hst to 5.4 (it was 5.2) and now it's working as you can see here:

http://www.xoompage.com/ticket?id=034abd84-47fd-11e3-bea0-782bcb3e3838

Thanks everyone.