Page is blank when loaded - is it the echoed table?

[rawky1976]

<?php

$user = $_GET['userid'];

include 'config.php';
include 'opendb.php';

$query = "select * from users WHERE user_id LIKE '$user'"; 

$result = mysql_db_query("servicemgmt", $query . mysql_error());

$r = mysql_fetch_array($result)

$firstname = $r['user_fname'];
$lastname = $r['user_lname'];
$ext = $r['user_ext'];
$bleep = $r['user_bleep'];
$exttel = $r['user_extno'];
$email = $r['user_email'];


echo "<table style="width: 80%">";
echo "<tr><td>First Name</td><td><input type=\"text\" value=\"$firstname\"\n name="firstname" id="firstname" style="width: 160px"/></td><td>Last Name</td><td> <input type=\"text\" value=\"$lastname\">\n name="lastname" id="lastname" style="width: 160px"/></td></tr>";
echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
echo "<tr><td>Extension</td><td> <input type=\"text\" value=\"$ext\">\n name="ext" id="ext" style="width: 160px"/></td><td>Bleep No.</td><td> <input type=\"text\" value=\"$bleep\">\n name="bleep" id="bleep" style="width: 160px"/></td></tr>";
echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
echo "<tr><td>External Tel.</td><td><input type=\"text\" value=\"$exttel\">\n name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>";
echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
echo "<tr><td>Email</td><td><input type=\"text\" value=\"$email\">\n name="email" id="email" style="width: 200px" /></td><td> </td><td> </td></tr>";
echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
echo "<tr><td><input name="updateuser" type="submit" id="updateuser" value="Update User Details" /></td><td> </td><td> </td><td><input name="reset1" type="reset" value="Clear Form" /></td></tr>";
echo "</table>";

?>

[akitchin]

1. please use code tags when posting code.

2. posting plain code and asking to fix it without any background or foreword is a little bit rude.  how do you think a doctor would feel if i just walked up to him, said not a damned word, and stuck my arm out to show him my hives?  he may help, but he'd probably also charge you money for it.  we don't get paid.

 

try explaining the problem, even if it seems trivial.  we aren't here to baby you.

[NArc0t1c]

@akitchin - lmga

 

Try echo statements with single quotes.

It should give an php error actually.

[rawky1976]

Sorry guys!

 

From the previous page is: <a href=\"editSearcheduser.php?userid=$id\">

 

When clicked this goes to the page in the code which should reload the Add User form but this time with the fields populated. Then you change what you want and submit it back?

 

[GingerRobot]

The problem is you have a lot of unescaped double quote. You can't place a double quote inside the string you are echoing wihtout escaping it with a backslash if you are using double quotes so surround the string. The reason why you get a blank page is because you have the display_errors directive set to off.

 

If you were to add:

 

error_reporting(E_ALL);
ini_set('display_errors','On');

 

To to top of your page, you would get some error messages. To fix, go through and escape all of the double quotes inside your string, or use single quotes to surround the attribtues of your html tags/your string.

 

Beaten to it - but thought id post anyways. Might add something with the explanation of display errors.

[akitchin]

@akitchin - lmga

 

i have no idea what lmga means.  all i could find was "Location Managers Guild of America" and "Louisiana Meat Goat Association."

[GingerRobot]

@akitchin - lmga

 

i have no idea what lmga means.  all i could find was "Location Managers Guild of America" and "Louisiana Meat Goat Association."

 

Haha, i wasn't the only one to google. Even urbandictionary.com doesn't have any suggestions. I thought it had gotten to the stage where you could put any 3/4 letter combination in and someone had come up with a meaning

[NArc0t1c]

@akitchin - lmga

 

i have no idea what lmga means.  all i could find was "Location Managers Guild of America" and "Louisiana Meat Goat Association."

 

afr for lol.

[akitchin]

i guess i'll be forever lost on both AFR and LMGA.

 

PS:  your sig link goes to "Quantim_theory," might want to fix that.

[rawky1976]

I think it might be laughing my goddamn a** (off) with a missing 'o'?

 

What is the \n for inside the echo after it inserts a value into the textbox please?

[akitchin]

<input type=\"text\" value=\"$exttel\">\n name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>

 

you're ending every input tag early, right after the value.  if you changed it to single quotes, it's because you're now escaping the ending double quote.  when HTML sees \" after a starting quote, it assumes you mean that double quote literally as opposed to meaning it as a delimiter.

 

if you're using single quotes, you can remove every backslash used to escape the double quotes.

[NArc0t1c]

afr short for Afrikaans.

lmga directly translated: laugh my ass off(laugh out loud).

Will fix the wikipedia link.

 

rawky1976 try this:

<?php

$user = $_GET['userid'];

include 'config.php';
include 'opendb.php';

$query = "select * from users WHERE user_id LIKE '$user'"; 

$result = mysql_db_query("servicemgmt", $query . mysql_error());

$r = mysql_fetch_array($result);

$firstname = $r['user_fname'];
$lastname = $r['user_lname'];
$ext = $r['user_ext'];
$bleep = $r['user_bleep'];
$exttel = $r['user_extno'];
$email = $r['user_email'];


echo '<table style="width: 80%">';
echo '<tr><td>First Name</td><td><input type="text" value="$firstname" name="firstname" id="firstname" style="width: 160px "/></td><td>Last Name</td><td> <input type="text" value="$lastname" name="lastname" id="lastname" style="width: 160px" /></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Extension</td><td> <input type="text" value="$ext" name="ext" id="ext" style="width: 160px" /></td><td>Bleep No.</td><td> <input type="text" value="$bleep" name="bleep" id="bleep" style="width: 160px"/></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>External Tel.</td><td><input type="text" value="$exttel" name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Email</td><td><input type="text" value="$email" name="email" id="email" style="width: 200px" /></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td><input name="updateuser" type="submit" id="updateuser" value="Update User Details" /></td><td> </td><td> </td><td><input name="reset1" type="reset" value="Clear Form" /></td></tr>';
echo '</table>';

?>

[willpower]

for example

 

echo "so he said to her.."get in bed now, I want some action," whilst stripping off!"

 

is wrong as the echo statement looks for the " to start the statment and the next " to stop.

 

Clearly this would result in a very strange output.

 

SO

 

we can do this

 

echo "so he said to her..\"get in bed now, I want some action,\" whilst stripping off!"

 

which 'escapes' the " or we can do this

 

echo 'so he said to her.."get in bed now, I want some action," whilst stripping off!'.

 

Hope that makes sense to you

[akitchin]

for example

 

echo "so he said to her.."get in bed now, I want some action," whilst stripping off!"

 

is wrong as the echo statement looks for the " to start the statment and the next " to stop.

 

Clearly this would result in a very strange output.

 

SO

 

we can do this

 

echo "so he said to her..\"get in bed now, I want some action,\" whilst stripping off!"

 

which 'escapes' the " or we can do this

 

echo 'so he said to her.."get in bed now, I want some action," whilst stripping off!'.

 

Hope that makes sense to you

 

.. followed by "not tonight honey, 'i have a headache.'"

[GingerRobot]

NArc0t1c:

 

It'll need to be this:

 

<?php

$user = $_GET['userid'];

include 'config.php';
include 'opendb.php';

$query = "select * from users WHERE user_id LIKE '$user'"; 

$result = mysql_db_query("servicemgmt", $query . mysql_error());

$r = mysql_fetch_array($result)

$firstname = $r['user_fname'];
$lastname = $r['user_lname'];
$ext = $r['user_ext'];
$bleep = $r['user_bleep'];
$exttel = $r['user_extno'];
$email = $r['user_email'];


echo '<table style="width: 80%">';
echo '<tr><td>First Name</td><td><input type="text" value="'.$firstname.'" name="firstname" id="firstname" style="width: 160px "/></td><td>Last Name</td><td> <input type="text" value="'.$lastname.'" name="lastname" id="lastname" style="width: 160px" /></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Extension</td><td> <input type="text" value="'.$ext.'" name="ext" id="ext" style="width: 160px" /></td><td>Bleep No.</td><td> <input type="text" value="'.$bleep.'" name="bleep" id="bleep" style="width: 160px"/></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>External Tel.</td><td><input type="text" value="'.$exttel.'" name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Email</td><td><input type="text" value="'.$email.'" name="email" id="email" style="width: 200px" /></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td><input name="updateuser" type="submit" id="updateuser" value="Update User Details" /></td><td> </td><td> </td><td><input name="reset1" type="reset" value="Clear Form" /></td></tr>';
echo '</table>';

?>

 

Otherwise your variables wont get evaluated.

[NArc0t1c]

heh, Sorry didn't notice the variables(might seem weird because there is a mysql query).

[rawky1976]

Now I am confused, I have this which is still blank:

 

<?php

error_reporting(E_ALL);
ini_set('display_errors','1');

$user = $_GET['userid'];

include 'config.php';
include 'opendb.php';

$query = "select * from users WHERE user_id LIKE '$user'"; 

$result = mysql_db_query("servicemgmt", $query . mysql_error());

$r = mysql_fetch_array($result)

$firstname = $r['user_fname'];
$lastname = $r['user_lname'];
$ext = $r['user_ext'];
$bleep = $r['user_bleep'];
$exttel = $r['user_extno'];
$email = $r['user_email'];


//echo "<table style=\"width: 80%\">";
//echo "<tr><td>First Name</td><td><input type=\"text\" value=\"$firstname\"\n name=\"firstname\" id=\"firstname\" style=\"width: 160px\"/></td><td>Last Name</td><td> <input type=\"text\" value=\"$lastname\">\n name=\"lastname\" id=\"lastname\" style=\"width: 160px\"/></td></tr>";
//echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
//echo "<tr><td>Extension</td><td> <input type=\"text\" value=\"$ext\">\n name=\"ext\" id=\"ext\" style=\"width: 160px\"/></td><td>Bleep No.</td><td> <input type=\"text\" value=\"$bleep\">\n name=\"bleep\" id=\"bleep\" style=\"width: 160px\"/></td></tr>";
//echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
//echo "<tr><td>External Tel.</td><td><input type=\"text\" value=\"$exttel\">\n name=\"exttel\" id=\"exttel\" style=\"width: 160px\"/></td><td> </td><td> </td></tr>";
//echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
//echo "<tr><td>Email</td><td><input type=\"text\" value=\"$email\">\n name=\"email\" id=\"email\" style=\"width: 200px\" /></td><td> </td><td> </td></tr>";
//echo "<tr><td> </td><td> </td><td> </td><td> </td></tr>";
//echo "<tr><td><input name=\"updateuser\" type=\"submit\" id=\"updateuser\" value=\"Update User Details\" /></td><td> </td><td> </td><td><input name=\"reset1\" type=\"reset\" value=\"Clear Form\" /></td></tr>";
//echo "</table>";

//echo '<table style="width: 80%">';
//echo '<tr><td>First Name</td><td><input type="text" value="'.$firstname.'" name="firstname" id="firstname" style="width: 160px "/></td><td>Last Name</td><td> <input type="text" value="'.$lastname.'" name="lastname" id="lastname" style="width: 160px" /></td></tr>';
//echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
//echo '<tr><td>Extension</td><td> <input type="text" value="'.$ext.'" name="ext" id="ext" style="width: 160px" /></td><td>Bleep No.</td><td> <input type="text" value="'.$bleep.'" name="bleep" id="bleep" style="width: 160px"/></td></tr>';
//echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
//echo '<tr><td>External Tel.</td><td><input type="text" value="'.$exttel.'" name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>';
//echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
//echo '<tr><td>Email</td><td><input type="text" value="'.$email.'" name="email" id="email" style="width: 200px" /></td><td> </td><td> </td></tr>';
//echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
//echo '<tr><td><input name="updateuser" type="submit" id="updateuser" value="Update User Details" /></td><td> </td><td> </td><td><input name="reset1" type="reset" value="Clear Form" /></td></tr>';
//echo '</table>';	

echo '<table style="width: 80%">';
echo '<tr><td>First Name</td><td><input type="text" value="$firstname" name="firstname" id="firstname" style="width: 160px "/></td><td>Last Name</td><td> <input type="text" value="$lastname" name="lastname" id="lastname" style="width: 160px" /></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Extension</td><td> <input type="text" value="$ext" name="ext" id="ext" style="width: 160px" /></td><td>Bleep No.</td><td> <input type="text" value="$bleep" name="bleep" id="bleep" style="width: 160px"/></td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>External Tel.</td><td><input type="text" value="$exttel" name="exttel" id="exttel" style="width: 160px"/></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td>Email</td><td><input type="text" value="$email" name="email" id="email" style="width: 200px" /></td><td> </td><td> </td></tr>';
echo '<tr><td> </td><td> </td><td> </td><td> </td></tr>';
echo '<tr><td><input name="updateuser" type="submit" id="updateuser" value="Update User Details" /></td><td> </td><td> </td><td><input name="reset1" type="reset" value="Clear Form" /></td></tr>';
echo '</table>';
?>

[akitchin]

missing something?

 

$r = mysql_fetch_array($result)

 

you didn't put the error reporting lines that Ginger gave you at the top of the file, did you?  if you did, you'd have to come back to us a lot less often.

[rawky1976]

Aren't those the error reporting lines under the opening <php tag?

 

I see a missing ';' !!!

 

Thanks

[akitchin]

Aren't those the error reporting lines under the opening <php tag?

 

touché.  that'll teach me for posting first and reading later.  you need to reverse the order, and 'display_errors' should be set to 'On', not '1'.

[rawky1976]

Still no errors (blank). I'm off to bed (22:48 in the UK)

 

Thanks all, maybe I'll fix it tomorrow...maybe