View database code makes blank page...

Blob

Can anybody help me? This makes no errors, just a blank page... Why doesn't it display the form?

<?php
// DISPLAYDATABASE-viewdatabase.php
// Put the select table form's head tags and starting body tag into a variable called $formhead.
$formhead = "<html><head><title>Select a table to view</table></head><body>";
// Put the select table form into a variable called $form.
$form = "<form action=\"viewdatabase.php\" method=\"post\">
<input type=\"radio\" name=\"rad_table1\" value=\"ON\">
Table1, arrange in order of
<select name=\"box_table1\">
<option value=\"f1\" selected>f1
<option value=\"f2\">f2
<option value=\"f3\">f3
<option value=\"f4\">f4
<option value=\"f5\">f5
</select><br>
<input type=\"radio\" name=\"rad_table2\" value=\"ON\">
Table2, arrange in order of
<select name=\"box_table2\">
<option value=\"f1\" selected>f1
<option value=\"f2\">f2
<option value=\"f3\">f3
<option value=\"f4\">f4
<option value=\"f5\">f5
<option value=\"f6\">f6
<option value=\"f7\">f7
<option value=\"f8\">f8
<option value=\"f9\">f9
<option value=\"f10\">f10
<option value=\"f11\">f11
<option value=\"f12\">f12
<option value=\"f13\">f13
<option value=\"f14\">f14
<option value=\"f15\">f15
<option value=\"f16\">f16
<option value=\"f17\">f17
<option value=\"f18\">f18
</select><br>
<input type=\"radio\" name=\"rad_table3\" value=\"ON\">
table3, arrange in order of
<select name=\"box_table3\">
<option value=\"f1\" selected>f1
<option value=\"f2\">f2
<option value=\"f3\">f3
<option value=\"f4\">f4
<option value=\"f5\">f5
<option value=\"f6\">f6
<option value=\"r7\">f7
<option value=\"r8\">f8
<option value=\"r9\">f9
<option value=\"f10\">f10
<option value=\"f11\">f11
<option value=\"f12\">f12
<option value=\"f13\">f13
<option value=\"f14\">f14
<option value=\"f15\">f15
<option value=\"f16\">f16
<option value=\"f17\">f17
<option value=\"f18\">f18
<option value=\"f19\">f19
<option value=\"f20\">f20
<option value=\"f21\">f21
<option value=\"f22\">f22
<option value=\"f23\">f23
<option value=\"f24\">f24
<option value=\"f25\">f25
</select><br>
<input type=\"submit\" name=\"submit\" value=\"View!\"></form>";

if(!isset($submit))
 {
   // Form's being viewed for the first time.
   echo $formhead;
   echo $form;
 }
elseif(($_POST['rad_table1'] !== "ON") || ($_POST['rad_table2'] !== "ON") || ($_POST['rad_table3'] !== "ON"))
 {
   // No table was checked.
   echo $formhead;
   echo "<font color=\"#CC0000\" face=\"Verdana\">Pick a table!</font>";
   echo $form;
 }
else
 {
   // Everthing's good, attempt to connect to the database.
   mysql_pconnect("HOST","USERNAME","PASSWORD");
   mysql_select_db("DBNAME");
   if($_POST['rad_table1'] == "ON")
    {
      $result = mysql_query("select * from table1 order by ".$_POST['box_table1']);
      while($r=mysql_fetch_array($result))
       {
         $f1=$r["f1"];
         $f2=$r["f2"];
         $f3=$r["f3"];
         $f4=$r["f4"];
         $f5=$r["f5"];
         echo "$f1 $f2 $f3 $f4 $f5<br>";
       }
    }
   elseif($_POST['rad_table2'] == "ON")
    {
      $result = mysql_query("select * from table2 order by ".$_POST['box_table2']);
      while($r=mysql_fetch_array($result))
       {
         $f1=$r["f1"];
         $f2=$r["f2"];
         $f3=$r["f3"];
         $f4=$r["f4"];
         $f5=$r["f5"];
         $f6=$r["f6"];
         $f7=$r["f7"];
         $f8=$r["f8"];
         $f9=$r["f9"];
         $f10=$r["f10"];
         $f11=$r["f11"];
         $f12=$r["f12"];
         $f13=$r["f13"];
         $f14=$r["f14"];
         $f15=$r["f15"];
         $f16=$r["f16"];
         $f17=$r["f17"];
         echo "$f1 $f2 $f3 $f4 $f5 $f6 $f7 $f8 $f9 $f10 $f11 $f12 $f13 $f14 $f15 $f16<br>";
       }
    }
   elseif($_POST['rad_table3'] == "ON")
    {
      $result = mysql_query("select * from table3 order by ".$_POST['box_table3']);
      while($r=mysql_fetch_array($result))
       {
         $f1=$r["f1"];
         $f2=$r["f2"];
         $f3=$r["f3"];
         $f4=$r["f4"];
         $f5=$r["f5"];
         $f6=$r["f6"];
         $f7=$r["f7"];
         $f8=$r["f8"];
         $f9=$r["f9"];
         $f10=$r["f10"];
         $f11=$r["f11"];
         $f12=$r["f12"];
         $f13=$r["f13"];
         $f14=$r["f14"];
         $f15=$r["f15"];
         $f16=$r["f16"];
         $f17=$r["f17"];
         $f18=$r["f18"];
         $f19=$r["f19"];
         $f20=$r["f20"];
         $f21=$r["f21"];
         $f22=$r["f22"];
         $f23=$r["f23"];
         $f24=$r["f24"];
         echo "$f1 $f2 $f3 $f4 $f5 $f6 $f7 $f8 $f9 $f10 $f11 $f12 $f13 $f14 $f15 $f16 $f17 $f18 $f19 $f20 $f21 $f22 $f23<br>";
       }
    }
 }
?>
</body>
</html>

It just shows a blank page...
Any help would be appreciated. 🙂

ir4z0r

you've probably a parse error somewhere

insert in first line
error_reporting (E_ALL);
to have all errors displayed

Blob

I changed the very first line:
<?php
to:
<?php error_reporting(E_ALL);
And it still does the blank page. 🙁
Thanks anyway. 🙂

ir4z0r

okay, some issues:

you closed your <title> with </table>

echo'ing large strings best with echo 'blabla'
php will parse it faster, you don't need to escape () quotes ("),
just variables won't be parsed

you use $submit in your 1st if clause, you might want to use $_POST['submit']

at last: why doing the $fxx = $r['xx'] stuff? you're only using it once,
hence just echo $r['xx'] . $r['xy'] ...

edit the opposite of == (equality) is != not !==

Blob

@.@

...I...close a title...with...table? @.@

Thanks a lot for pointing those out, I'll fix them right now! 🙂

Blob

It still makes a blank page though. 🙁

ir4z0r

hmmm, why do you use mysql_pconnect() instead of mysql_connect()?

try commenting out eveything inside the if-clauses and add a
echo "condition nr x"; to see which if/else it enters

it would be possible that if all $fxx are empty, nothing is printed

(sorry, !== exists but it's slightly different)

Blob

It should print the form (where you can choose a table to print, and the order in which it's printed), no matter what, though. 🙁

ir4z0r

hmmm again, I tried it at home (code from 1st post) and after
replacing the </table> with </title> it was displayed 😕

please assure, you changed it, too. If you did, please post your new
code again.

Blob

That pconnect was supposed to be connect - a typo. 😛
Here's my latest code:

<?php error_reporting(E_ALL);
// DISPLAYDATABASE-viewdatabase.php
// Put the select table form's head tags and starting body tag into a variable called $formhead.
$formhead = "<html><head><title>Select a table to view</title></head><body>";
// Put the select table form into a variable called $form.
$form = '<form action="viewdatabase.php" method="post">
<input type="radio" name="rad_tbl1" value="ON">
Table 1, arrange in order of
<select name="box_tbl2">
<option value="f1" selected>f1
<option value="f2">f2
<option value="f3">f3
<option value="f4">f4
<option value="f5">f5
</select><br>
<input type="radio" name="rad_tbl2" value="ON">
Table 2, arrange in order of
<select name="box_tbl2">
<option value="f1" selected>f1
<option value="f2">f2
<option value="f3">f3
<option value="f4">f4
<option value="f5">f5
<option value="f6">f6
<option value="f7">f7
<option value="f8">f8
<option value="f9">f9
<option value="f10">f10
<option value="f11">f11
<option value="f12">f12
<option value="f13">f13
<option value="f14">f14
<option value="f15">f15
<option value="f16">f16
<option value="f17">f17
<option value="f18">f18
</select><br>
<input type="radio" name="rad_tbl3" value="ON">
Table 3, arrange in order of
<select name="box_tbl3">
<option value="f1" selected>f1
<option value="f2">f2
<option value="f3">f3
<option value="f4">f4
<option value="f5">f5
<option value="f6">f6
<option value="f7">f7
<option value="f8">f8
<option value="f9">f9
<option value="f10">f10
<option value="f11">f11
<option value="f12">f12
<option value="f13">f13
<option value="f14">f14
<option value="f15">f15
<option value="f16">f16
<option value="f17">f17
<option value="f18">f18
<option value="f19">f19
<option value="f20">f20
<option value="f21">f21
<option value="f22">f22
<option value="f23">f23
<option value="f24">f24
<option value="f25">f25
</select><br>
<input type="submit" name="submit" value="View!"></form>';

if(!isset($_POST['submit']))
 {
   // Form's being viewed for the first time.
   echo $formhead;
   echo $form;
 }
elseif(($_POST['rad_tbl1'] !== "ON") || ($_POST['rad_tbl2] !== "ON") || ($_POST['rad_tbl3] !== "ON"))
 {
   // No table was checked.
   echo $formhead;
   echo '<font color="#CC0000" face="Verdana">Pick a table!</font>';
   echo $form;
 }
else
 {
   // Everthing's good, attempt to connect to the database.
   MYSQL_CONNECT("HOST","USERNAME","PASSWORD");
   MYSQL_SELECT_DB("DBNAME");
   if($_POST['rad_tbl1] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl1 order by ".$_POST['box_tbl1]);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo "$r["f1"] $r["f2"]  $r["f3"]  $r["f4"]  $r["f5"]<br>";
       }
    }
   elseif($_POST['rad_tbl2] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl2 order by ".$_POST['box_tbl2]);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo "$r["f1"]  $r["f2"]  $r["f3"]  $r["f4"]  $r["f5"]  $r["f6"]  $r["f7"]  $r["f8"]  $r["f9"]  $r["f10"]  $r["f11"]  $r["f12"]  $r["f13"]  $r["f14"]  $r["f15"]  $r["f16"]  $r["f17"]  $r["f18"]<br>";
       }
    }
   elseif($_POST['rad_tbl3] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl3 order by ".$_POST['box_tbl3]);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo "$r["f1"]  $r["f2"]  $r["f3"]  $r["f4"]  $r["f5"]  $r["f6"]  $r["f7"]  $r["f8"]  $r["f9"]  $r["f10"]  $r["f11"]  $r["f12"]  $r["f13"]  $r["f14"]  $r["f15"]  $r["f16"]  $r["f17"]  $r["f18"]  $r["f19"]  $r["f20"]  $r["f21"]  $r["f22"]  $r["f23"]  $r["f24"]  $r["f25"]<br>";
       }
    }
   MYSQL_CLOSE();
 }
?>
</body>
</html>

😕

ir4z0r

okay, this works, you forgot a lot of ' in the ['blabla] and it looks like
you copied and pasted a lot 😉

i severed the form into an extra file: form.inc.php

<?php 
error_reporting(E_ALL);
// DISPLAYDATABASE-viewdatabase.php

if(!isset($_POST['submit']))
{
   // Form's being viewed for the first time.
   echo '<html><head><title>Select a table to view</title></head><body>';
   include ("form.inc.php");
}
elseif(($_POST['rad_tbl1'] !== "ON") || ($_POST['rad_tbl2'] !== "ON") || ($_POST['rad_tbl3'] !== "ON"))
{
   // No table was checked.
   echo '<html><head><title>Select a table to view</title></head><body>';
   echo '<font color="#CC0000" face="Verdana">Pick a table!</font>';
   include ("form.inc.php");
}
else
{
   // Everthing's good, attempt to connect to the database.
   MYSQL_CONNECT("HOST","USERNAME","PASSWORD");
   MYSQL_SELECT_DB("DBNAME");
   if($_POST['rad_tbl1'] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl1 order by " . $_POST['box_tbl1']);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo $r["f1"] .$r["f2"] . $r["f3"] . $r["f4"]  .$r["f5"]."<br>";
       }
    }
   elseif($_POST['rad_tbl2'] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl2 order by ".$_POST['box_tbl2']);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo $r["f1"] . $r["f2"] . $r["f3"] . $r["f4"] . $r["f5"] . $r["f6"] . $r["f7"] . $r["f8"] . $r["f9"] . $r["f10"] . $r["f11"] . $r["f12"] . $r["f13"] . $r["f14"] . $r["f15"] . $r["f16"] . $r["f17"] . $r["f18"]."<br>";
       }
    }
   elseif($_POST['rad_tbl3'] == "ON")
    {
      $result = MYSQL_QUERY("select * from tbl3 order by ". $_POST['box_tbl3']);
      while($r=MYSQL_FETCH_ARRAY($result))
       {
         echo $r["f1"] . $r["f2"] . $r["f3"] . $r["f4"] . $r["f5"] . $r["f6"] . $r["f7"] . $r["f8"] . $r["f9"] . $r["f10"] . $r["f11"] . $r["f12"] . $r["f13"] . $r["f14"] . $r["f15"] . $r["f16"] . $r["f17"] . $r["f18"] . $r["f19"] . $r["f20"] . $r["f21"] . $r["f22"] . $r["f23"] . $r["f24"] . $r["f25"] . "<br>";
       }
    }
   MYSQL_CLOSE();
 }
?>
</body>
</html>

the form.inc.php contains the form (without any phpcode)

Blob

I tried it, and it still does the blank page...
Thanks anyway. 🙁

If I view the source, I see the form but it doesn't display...
😕

ir4z0r

but you copied my posted code into a file?

please try to echo a "helloworld" in the 2nd line, to check if it displays sth at all

(some PHP's are configured to not show parse errors)

running out of ideas ...

proof vvv

Blob

It didn't display it.

o.O

ir4z0r

so here are the files that worked for me, maybe you want
upgrade your PHP or install it at home (if not done yet)

sorry, I couldn't help you :rolleyes:

ir4z0r

2nd

Blob

Thanks anyway. :/
I tried installing apache, php, and mysql on my computer a while ago, and it messed everything up lol. My host should have the latest version of php... 🙁