PHP / mysqli does not echo single zero

Question

This is a strange bug I've come across when switching my code over from 000webhost to ipage. It's the same code and a consistently different result.

The following example does nothing.

echo 0;

This example gives us '00'

echo 0;
echo 0;

@user2588666 can you post the view source of the html page, make sure it isn't hidden in there. — Arian Faurtosh, May 10 '14 at 03:16
@Arian: The expected result isn't hidden in the source, thanks. It works fine when the count is 1, for example. — user2588666, May 10 '14 at 03:21
@GonzaloBahamondez: I've tried exit; right afterwards, and it didn't work. — user2588666, May 10 '14 at 03:22
@user2588666 `var_dump` is showing that there is a string value in there. Are you showing all errors? — Ozair Patel, May 10 '14 at 03:23
Can you add : $result = mysqli_query($con,$sql) or mysqli_error($co); In Phpmyadmin do you have some result ? — Dev'Hamz, May 10 '14 at 03:28
It's probably an issue with your database (to me 000webhost is really bad...) — Dev'Hamz, May 10 '14 at 03:30
@Dev'Hamz: In phpmyadmin, I do have the correct result. However, my best guess is currently it has something to do with the webserver not liking to return just 0. As you can see in my edit, echo 0 does nothing, but echo 0 twice echoes it twice. My previous web host didn't do this. — user2588666, May 10 '14 at 03:30
I have no idea what you're trying to achieve, or get as results. You're doing an `AS count` Are you aware of what using an alias does, or is for? — Funk Forty Niner, May 10 '14 at 03:40
This is NOT a MySQL issue. It can be replicated without even touching MySQL so this has NOTHING to do with MySQL. — smcjones, May 10 '14 at 03:42
@Fred-ii-: The use of the alias is irrelevant to the issue. I get your point, but it doesn't make a difference. The alias was previously used, but I made the code more concise for posting it on here. The problem is simply that on this web host, when you try to echo 0, nothing happens. When you try to echo 1, it works. When you try to echo 00, it works. So, these "issues" are separate. Thank you for taking a look at it, though. — user2588666, May 10 '14 at 03:44
Using `echo 0; exit;` doesn't work neither? It works on my server. — Funk Forty Niner, May 10 '14 at 03:45
@user2588666 you will keep getting these requests until you change your question to remove MySQL and probably get rid of your MySQL example. You should really be focusing on your follow up example because that is the root of the issue. — smcjones, May 10 '14 at 03:46
@Fred-ii-: Correct; echo 0; exit; shockingly doesn't work either on my server. — user2588666, May 10 '14 at 03:48
@Fred-ii-: `echo (int)0;` doesn't help, but as you can expect `echo (int)0;echo (int)0;` gives us `00`. (Just like `echo 0; echo 0;` did) — user2588666, May 10 '14 at 03:54
I'm out of ideas. See if you can contact that host and report it as a probable bug. — Funk Forty Niner, May 10 '14 at 03:56
@Fred-ii-: Will do. Again, I appreciate you trying for a reason with me! — user2588666, May 10 '14 at 03:58
This similar question might have something to do with it, and probably some server setting too http://stackoverflow.com/questions/4948663/php-get-bool-to-echo-false-when-false — Cleric, May 10 '14 at 04:02

user2588666 · Accepted Answer · 2014-05-12T22:22:03.167

0

Seems to be a problem with ipage's host. This is my current workaround. This workaround echoes 00 instead of 0, and the correct integer with no leading 0 otherwise.

if(empty($count[0])) echo 0; // Don't get why we need this--not needed on 000webhost, e.g.
echo $count[0];

Update: confirmed bug on ipage's end

edited May 12 '14 at 22:22

answered May 10 '14 at 03:35

user2588666

821
1
7
16

This is not usual behavior. You should contact ipage for support. – smcjones May 10 '14 at 17:21
@smcjones: I've contacted them, and I'm awaiting a reply. If they get back to me, I'll be sure to follow up! – user2588666 May 10 '14 at 17:45

PHP / mysqli does not echo single zero

1 Answers1