PHP Blank Page.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • techjohnny@gmail.com
    #1

    PHP Blank Page.

    Ok,

    I posted earlier about this, a blank php page. I've enabled logging
    ALL in the php.ini, but nothing. If I change the name of the db in
    the include file, I get an error message, so I guess this means it's
    connecting to the mysql db. I've included the first couple lines of
    code for this page:

    index.php
    <?php
    session_start() ;
    require_once('i nc/db_config.inc.p hp');
    $conn = db_connect();
    $sqlsu = "SELECT * FROM subjects ORDER BY ID";
    $ressu = mysql_query($sq lsu, $conn);
    if (mysql_num_rows ($ressu)) {
    while ($qry = mysql_fetch_arr ay($ressu)) {
    $cat = stripSlashes($q ry['cat']);
    $resns = mysql_query("SE LECT * FROM questions WHERE test LIKE '$cat'",
    $conn);
    $numcat = mysql_num_rows( $resns);

    inc/db_config.inc.p hp


    function db_connect()
    {
    $result = @mysql_pconnect ('localhost', 'root', 'password);
    if (!$result)
    return false;
    if (!@mysql_select _db('quiz'))
    return false;

    return $result;
    }
    ?>

    Tags: None
    • Rik
      #2
      Re: PHP Blank Page.

      On Tue, 19 Jun 2007 19:18:02 +0200, techjohnny@gmai l.com
      <techjohnny@gma il.comwrote:
      Ok,
      >
      I posted earlier about this, a blank php page. I've enabled logging
      ALL in the php.ini, but nothing. If I change the name of the db in
      the include file, I get an error message, so I guess this means it's
      connecting to the mysql db. I've included the first couple lines of
      code for this page:
      First rule of hunting errors: do not surpress any errors by @ if something
      isn't working.

      Second: I do not see any output, so as far as I'm concerned if you've got
      no errors you would still see nothing.

      - $qry['cat'] doesn't seem to be set anywhere, how come?
      - check your queries for errors: echo mysql_error(), and the query itself.

      --
      Rik Wasmus

        Comment

        • techjohnny@gmail.com
          #3
          Re: PHP Blank Page.

          On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
          On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
          >
          <techjoh...@gma il.comwrote:
          Ok,
          >
          I posted earlier about this, a blank php page. I've enabled logging
          ALL in the php.ini, but nothing. If I change the name of the db in
          the include file, I get an error message, so I guess this means it's
          connecting to the mysql db. I've included the first couple lines of
          code for this page:
          >
          First rule of hunting errors: do not surpress any errors by @ if something
          isn't working.
          >
          Second: I do not see any output, so as far as I'm concerned if you've got
          no errors you would still see nothing.
          >
          - $qry['cat'] doesn't seem to be set anywhere, how come?
          - check your queries for errors: echo mysql_error(), and the query itself.
          >
          --
          Rik Wasmus
          The entire page:

          <?php
          include('inc/header.inc.php' );
          require_once('i nc/db_config.inc.p hp');
          session_start() ;
          $conn = db_connect();

          $sqlsu = "SELECT * FROM subjects ORDER BY ID";
          $ressu = mysql_query($sq lsu, $conn);
          if (mysql_num_rows ($ressu)) {
          while ($qry = mysql_fetch_arr ay($ressu)) {
          $cat = stripSlashes($q ry['cat']);
          $resns = mysql_query("SE LECT * FROM questions WHERE test LIKE '$cat'",
          $conn);
          $numcat = mysql_num_rows( $resns);
          if ($numcat 0) {
          // Check if scoreboard contains entries in this category and, if so,
          list results
          if (isset($HTTP_SE SSION_VARS['scoreboard']) &&
          ($HTTP_SESSION_ VARS['scoreboard'][$cat])) {
          $totsub = 0;
          $correctans = 0;
          foreach ($HTTP_SESSION_ VARS['scoreboard'][$cat] as $questi)
          {
          if ($questi == 'c') { $correctans++; }
          $totsub++;
          }
          }
          echo "\n".'<form name="teststart '.$qry['ID'].'" action="quiz.ph p"
          method="post">' ;
          echo '<li><p id="hornav">';
          if ((!$totsub) || ($totsub < $numcat)) {
          if ($totsub) { $togo = ($numcat - $totsub); } else { $togo =
          $numcat; }
          echo '<select name="limit">';
          if ($togo 5) { echo '<option value="5" SELECTED>5 questions</
          option>'; }
          for ($j = 1; $j < 12; $j++) {
          if ($togo ($j * 10)) { echo '<option value="'.($j*10 ).'">'.($j*10). '
          questions</option>'; }
          }
          echo '<option value="'.$togo. '">';
          if ($togo 1) {echo ' all '; }
          echo $togo;
          if ($totsub 0) { echo ' remaining'; }
          echo '</option></select>';
          }
          if ($totsub >= $numcat) {
          echo ' Test completed</p>'; }
          else if ($totsub 0) {
          echo '<a href="javascrip t:document.test start'.
          $qry['ID'].'.submit()">Co ntinue Test</a></p>'; }
          else {
          echo '<a href="javascrip t:document.test start'.
          $qry['ID'].'.submit()">St art Test</a></p>'; }

          echo '<strong>'.$cat .'</strong';
          echo '<em>('.$numcat .' questions)</em>';
          echo '<br />';
          echo '<input type="hidden" name="testsub" value="'.$cat.' ">';
          echo stripslashes($q ry['descr']);

          if ($totsub 0) {
          echo '<h3>Total score: '.$correctans.'/'.$totsub.'</h3>';
          $totsub = 0;
          $correctans = 0;
          }

          echo '</li>'."\n".'</form>'."\n";

          echo '<hr />';
          }
          }
          }
          ?>

          </ol>
          <br />
          <?php include_once('i nc/footer.inc.php' ); ?>

            Comment

            • Rik
              #4
              Re: PHP Blank Page.

              On Tue, 19 Jun 2007 20:11:44 +0200, techjohnny@gmai l.com
              <techjohnny@gma il.comwrote:
              On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
              >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
              >>
              ><techjoh...@gm ail.comwrote:
              Ok,
              >>
              I posted earlier about this, a blank php page. I've enabled logging
              ALL in the php.ini, but nothing. If I change the name of the db in
              the include file, I get an error message, so I guess this means it's
              connecting to the mysql db. I've included the first couple lines of
              code for this page:
              >>
              >First rule of hunting errors: do not surpress any errors by @ if
              >something
              >isn't working.
              >>
              >Second: I do not see any output, so as far as I'm concerned if you've
              >got
              >no errors you would still see nothing.
              >>
              >- $qry['cat'] doesn't seem to be set anywhere, how come?
              >- check your queries for errors: echo mysql_error(), and the query
              >itself.
              >
              The entire page:
              Well, that's nice, I do not spot any clear syntax errors.(That is, if I
              assume correctly that '// Check if scoreboard contains entries in this
              category and, if so,list results' is on 1 single line) However, with no
              query result the only output would be '</ol><br />', which obviously
              doesn't show up in a browser.

              Wether there's a parse error in your other includes I couldn't say.

              So, check your queries, echo mysql_error(), check mysql_num_rows( ) and
              echo it to check wether the result has data or is empty, etc.

              --
              Rik Wasmus

                Comment

                • techjohnny@gmail.com
                  #5
                  Re: PHP Blank Page.

                  On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                  On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                  >
                  >
                  >
                  <techjoh...@gma il.comwrote:
                  On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                  On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                  >
                  <techjoh...@gma il.comwrote:
                  Ok,
                  >
                  I posted earlier about this, a blank php page. I've enabled logging
                  ALL in the php.ini, but nothing. If I change the name of the db in
                  the include file, I get an error message, so I guess this means it's
                  connecting to the mysql db. I've included the first couple lines of
                  code for this page:
                  >
                  First rule of hunting errors: do not surpress any errors by @ if
                  something
                  isn't working.
                  >
                  Second: I do not see any output, so as far as I'm concerned if you've
                  got
                  no errors you would still see nothing.
                  >
                  - $qry['cat'] doesn't seem to be set anywhere, how come?
                  - check your queries for errors: echo mysql_error(), and the query
                  itself.
                  >
                  The entire page:
                  >
                  Well, that's nice, I do not spot any clear syntax errors.(That is, if I
                  assume correctly that '// Check if scoreboard contains entries in this
                  category and, if so,list results' is on 1 single line) However, with no
                  query result the only output would be '</ol><br />', which obviously
                  doesn't show up in a browser.
                  >
                  Wether there's a parse error in your other includes I couldn't say.
                  >
                  So, check your queries, echo mysql_error(), check mysql_num_rows( ) and
                  echo it to check wether the result has data or is empty, etc.
                  >
                  --
                  Rik Wasmus
                  Thanks.
                  echo mysql_error();


                  Warning: session_start() : Cannot send session cache limiter - headers
                  already sent (output started at /www13/htdocs/quiz/inc/header.inc.php:
                  3) in /www13/htdocs/quiz/index.php on line 4

                    Comment

                    • techjohnny@gmail.com
                      #6
                      Re: PHP Blank Page.

                      On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                      wrote:
                      On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                      >
                      >
                      >
                      On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                      >
                      <techjoh...@gma il.comwrote:
                      On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                      >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                      >
                      ><techjoh...@gm ail.comwrote:
                      Ok,
                      >
                      I posted earlier about this, a blank php page. I've enabled logging
                      ALL in the php.ini, but nothing. If I change the name of the db in
                      the include file, I get an error message, so I guess this means it's
                      connecting to the mysql db. I've included the first couple lines of
                      code for this page:
                      >
                      >First rule of hunting errors: do not surpress any errors by @ if
                      >something
                      >isn't working.
                      >
                      >Second: I do not see any output, so as far as I'm concerned if you've
                      >got
                      >no errors you would still see nothing.
                      >
                      >- $qry['cat'] doesn't seem to be set anywhere, how come?
                      >- check your queries for errors: echo mysql_error(), and the query
                      >itself.
                      >
                      The entire page:
                      >
                      Well, that's nice, I do not spot any clear syntax errors.(That is, if I
                      assume correctly that '// Check if scoreboard contains entries in this
                      category and, if so,list results' is on 1 single line) However, with no
                      query result the only output would be '</ol><br />', which obviously
                      doesn't show up in a browser.
                      >
                      Wether there's a parse error in your other includes I couldn't say.
                      >
                      So, check your queries, echo mysql_error(), check mysql_num_rows( ) and
                      echo it to check wether the result has data or is empty, etc.
                      >
                      --
                      Rik Wasmus
                      >
                      Thanks.
                      echo mysql_error();
                      >
                      Warning: session_start() : Cannot send session cache limiter - headers
                      already sent (output started at /www13/htdocs/quiz/inc/header.inc.php:
                      3) in /www13/htdocs/quiz/index.php on line 4
                      OK. I removed the header file and now it doesn't report anything.

                      -TJ

                        Comment

                        • Rik
                          #7
                          Re: PHP Blank Page.

                          On Tue, 19 Jun 2007 21:47:46 +0200, techjohnny@gmai l.com
                          <techjohnny@gma il.comwrote:
                          On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                          wrote:
                          >On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                          >>
                          >>
                          >>
                          On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                          >>
                          <techjoh...@gma il.comwrote:
                          On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                          >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                          >>
                          ><techjoh...@gm ail.comwrote:
                          Ok,
                          >>
                          I posted earlier about this, a blank php page. I've enabled
                          >logging
                          ALL in the php.ini, but nothing. If I change the name of the db
                          >in
                          the include file, I get an error message, so I guess this means
                          >it's
                          connecting to the mysql db. I've included the first couple
                          >lines of
                          code for this page:
                          >>
                          >First rule of hunting errors: do not surpress any errors by @ if
                          >something
                          >isn't working.
                          >>
                          >Second: I do not see any output, so as far as I'm concerned if
                          >you've
                          >got
                          >no errors you would still see nothing.
                          >>
                          >- $qry['cat'] doesn't seem to be set anywhere, how come?
                          >- check your queries for errors: echo mysql_error(), and the query
                          >itself.
                          >>
                          The entire page:
                          >>
                          Well, that's nice, I do not spot any clear syntax errors.(That is, if
                          >I
                          assume correctly that '// Check if scoreboard contains entries in this
                          category and, if so,list results' is on 1 single line) However, with
                          >no
                          query result the only output would be '</ol><br />', which obviously
                          doesn't show up in a browser.
                          >>
                          Wether there's a parse error in your other includes I couldn't say.
                          >>
                          So, check your queries, echo mysql_error(), check mysql_num_rows( ) and
                          echo it to check wether the result has data or is empty, etc.
                          >>
                          --
                          Rik Wasmus
                          >>
                          >Thanks.
                          >echo mysql_error();
                          >>
                          >Warning: session_start() : Cannot send session cache limiter - headers
                          >already sent (output started at /www13/htdocs/quiz/inc/header.inc.php:
                          >3) in /www13/htdocs/quiz/index.php on line 4
                          >
                          OK. I removed the header file and now it doesn't report anything.
                          And how many rows in the dataset? Keep in mind I normally say different
                          things in a post, not just one.

                          --
                          Rik Wasmus

                            Comment

                            • techjohnny@gmail.com
                              #8
                              Re: PHP Blank Page.

                              On Jun 19, 1:38 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                              On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmai l.com
                              >
                              >
                              >
                              <techjoh...@gma il.comwrote:
                              On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                              wrote:
                              On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                              >
                              On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                              >
                              <techjoh...@gma il.comwrote:
                              On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                              >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                              >
                              ><techjoh...@gm ail.comwrote:
                              Ok,
                              >
                              I posted earlier about this, a blank php page. I've enabled
                              logging
                              ALL in the php.ini, but nothing. If I change the name of the db
                              in
                              the include file, I get an error message, so I guess this means
                              it's
                              connecting to the mysql db. I've included the first couple
                              lines of
                              code for this page:
                              >
                              >First rule of hunting errors: do not surpress any errors by @ if
                              >something
                              >isn't working.
                              >
                              >Second: I do not see any output, so as far as I'm concerned if
                              you've
                              >got
                              >no errors you would still see nothing.
                              >
                              >- $qry['cat'] doesn't seem to be set anywhere, how come?
                              >- check your queries for errors: echo mysql_error(), and the query
                              >itself.
                              >
                              The entire page:
                              >
                              Well, that's nice, I do not spot any clear syntax errors.(That is, if
                              I
                              assume correctly that '// Check if scoreboard contains entries in this
                              category and, if so,list results' is on 1 single line) However, with
                              no
                              query result the only output would be '</ol><br />', which obviously
                              doesn't show up in a browser.
                              >
                              Wether there's a parse error in your other includes I couldn't say.
                              >
                              So, check your queries, echo mysql_error(), check mysql_num_rows( ) and
                              echo it to check wether the result has data or is empty, etc.
                              >
                              --
                              Rik Wasmus
                              >
                              Thanks.
                              echo mysql_error();
                              >
                              Warning: session_start() : Cannot send session cache limiter - headers
                              already sent (output started at /www13/htdocs/quiz/inc/header.inc.php:
                              3) in /www13/htdocs/quiz/index.php on line 4
                              >
                              OK. I removed the header file and now it doesn't report anything.
                              >
                              And how many rows in the dataset? Keep in mind I normally say different
                              things in a post, not just one.
                              >
                              --
                              Rik Wasmus
                              Here is the mysql query:

                              DROP TABLE IF EXISTS questions;
                              CREATE TABLE questions (
                              ID int(4) unsigned zerofill NOT NULL auto_increment,
                              question text NOT NULL,
                              test varchar(31) NOT NULL default '',
                              ans1 text NOT NULL,
                              ans2 text NOT NULL,
                              ans3 text NOT NULL,
                              ans4 text NOT NULL,
                              ans5 text,
                              ans6 text,
                              corans varchar(8) NOT NULL default '',
                              expl text NOT NULL,
                              PRIMARY KEY (ID)
                              ) TYPE=MyISAM;

                              DROP TABLE IF EXISTS subjects;
                              CREATE TABLE subjects (
                              ID int(4) unsigned zerofill NOT NULL auto_increment,
                              cat varchar(31) NOT NULL default '',
                              descr text NOT NULL,
                              random int(1) default NULL,
                              PRIMARY KEY (ID)
                              ) TYPE=MyISAM;

                                Comment

                                • Rik
                                  #9
                                  Re: PHP Blank Page.

                                  On Tue, 19 Jun 2007 23:22:29 +0200, techjohnny@gmai l.com
                                  <techjohnny@gma il.comwrote:
                                  On Jun 19, 1:38 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                  >On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmai l.com
                                  >>
                                  >>
                                  >>
                                  ><techjoh...@gm ail.comwrote:
                                  On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                                  wrote:
                                  >On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                  >>
                                  On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                                  >>
                                  <techjoh...@gma il.comwrote:
                                  On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                  >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                                  >>
                                  ><techjoh...@gm ail.comwrote:
                                  Ok,
                                  >>
                                  I posted earlier about this, a blank php page. I've enabled
                                  >logging
                                  ALL in the php.ini, but nothing. If I change the name of the
                                  >db
                                  >in
                                  the include file, I get an error message, so I guess this
                                  >means
                                  >it's
                                  connecting to the mysql db. I've included the first couple
                                  >lines of
                                  code for this page:
                                  >>
                                  >First rule of hunting errors: do not surpress any errors by @if
                                  >something
                                  >isn't working.
                                  >>
                                  >Second: I do not see any output, so as far as I'm concerned if
                                  >you've
                                  >got
                                  >no errors you would still see nothing.
                                  >>
                                  >- $qry['cat'] doesn't seem to be set anywhere, how come?
                                  >- check your queries for errors: echo mysql_error(), and the
                                  >query
                                  >itself.
                                  >>
                                  The entire page:
                                  >>
                                  Well, that's nice, I do not spot any clear syntax errors.(That is,
                                  >if
                                  >I
                                  assume correctly that '// Check if scoreboard contains entries in
                                  >this
                                  category and, if so,list results' is on 1 single line) However,
                                  >with
                                  >no
                                  query result the only output would be '</ol><br />', which
                                  >obviously
                                  doesn't show up in a browser.
                                  >>
                                  Wether there's a parse error in your other includes I couldn't say.
                                  >>
                                  So, check your queries, echo mysql_error(), check mysql_num_rows( )
                                  >and
                                  echo it to check wether the result has data or is empty, etc.
                                  >>
                                  --
                                  Rik Wasmus
                                  >>
                                  >Thanks.
                                  >echo mysql_error();
                                  >>
                                  >Warning: session_start() : Cannot send session cache limiter - headers
                                  >already sent (output started at
                                  >/www13/htdocs/quiz/inc/header.inc.php:
                                  >3) in /www13/htdocs/quiz/index.php on line 4
                                  >>
                                  OK. I removed the header file and now it doesn't report anything.
                                  >>
                                  >And how many rows in the dataset? Keep in mind I normally say different
                                  >things in a post, not just one.
                                  >>
                                  >
                                  Here is the mysql query:
                                  >
                                  DROP TABLE IF EXISTS questions;
                                  CREATE TABLE questions (
                                  ID int(4) unsigned zerofill NOT NULL auto_increment,
                                  question text NOT NULL,
                                  test varchar(31) NOT NULL default '',
                                  ans1 text NOT NULL,
                                  ans2 text NOT NULL,
                                  ans3 text NOT NULL,
                                  ans4 text NOT NULL,
                                  ans5 text,
                                  ans6 text,
                                  corans varchar(8) NOT NULL default '',
                                  expl text NOT NULL,
                                  PRIMARY KEY (ID)
                                  ) TYPE=MyISAM;
                                  >
                                  DROP TABLE IF EXISTS subjects;
                                  CREATE TABLE subjects (
                                  ID int(4) unsigned zerofill NOT NULL auto_increment,
                                  cat varchar(31) NOT NULL default '',
                                  descr text NOT NULL,
                                  random int(1) default NULL,
                                  PRIMARY KEY (ID)
                                  ) TYPE=MyISAM;
                                  >
                                  I can clearly see that's not the query you are performing. Round 2, try
                                  again. Still keep in mind the earlier remark that if the query has zero
                                  rows it will not show you anything in a browser (unless you look at the
                                  source).

                                  --
                                  Rik Wasmus

                                    Comment

                                    • techjohnny@gmail.com
                                      #10
                                      Re: PHP Blank Page.

                                      On Jun 19, 2:26 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                      On Tue, 19 Jun 2007 23:22:29 +0200, techjoh...@gmai l.com
                                      >
                                      >
                                      >
                                      <techjoh...@gma il.comwrote:
                                      On Jun 19, 1:38 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                      On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmai l.com
                                      >
                                      <techjoh...@gma il.comwrote:
                                      On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                                      wrote:
                                      On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                      >
                                      On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                                      >
                                      <techjoh...@gma il.comwrote:
                                      On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                      >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                                      >
                                      ><techjoh...@gm ail.comwrote:
                                      Ok,
                                      >
                                      I posted earlier about this, a blank php page. I've enabled
                                      logging
                                      ALL in the php.ini, but nothing. If I change the name of the
                                      db
                                      in
                                      the include file, I get an error message, so I guess this
                                      means
                                      it's
                                      connecting to the mysql db. I've included the first couple
                                      lines of
                                      code for this page:
                                      >
                                      >First rule of hunting errors: do not surpress any errors by @ if
                                      >something
                                      >isn't working.
                                      >
                                      >Second: I do not see any output, so as far as I'm concerned if
                                      you've
                                      >got
                                      >no errors you would still see nothing.
                                      >
                                      >- $qry['cat'] doesn't seem to be set anywhere, how come?
                                      >- check your queries for errors: echo mysql_error(), and the
                                      query
                                      >itself.
                                      >
                                      The entire page:
                                      >
                                      Well, that's nice, I do not spot any clear syntax errors.(That is,
                                      if
                                      I
                                      assume correctly that '// Check if scoreboard contains entries in
                                      this
                                      category and, if so,list results' is on 1 single line) However,
                                      with
                                      no
                                      query result the only output would be '</ol><br />', which
                                      obviously
                                      doesn't show up in a browser.
                                      >
                                      Wether there's a parse error in your other includes I couldn't say.
                                      >
                                      So, check your queries, echo mysql_error(), check mysql_num_rows( )
                                      and
                                      echo it to check wether the result has data or is empty, etc.
                                      >
                                      --
                                      Rik Wasmus
                                      >
                                      Thanks.
                                      echo mysql_error();
                                      >
                                      Warning: session_start() : Cannot send session cache limiter - headers
                                      already sent (output started at
                                      /www13/htdocs/quiz/inc/header.inc.php:
                                      3) in /www13/htdocs/quiz/index.php on line 4
                                      >
                                      OK. I removed the header file and now it doesn't report anything.
                                      >
                                      And how many rows in the dataset? Keep in mind I normally say different
                                      things in a post, not just one.
                                      >
                                      Here is the mysql query:
                                      >
                                      DROP TABLE IF EXISTS questions;
                                      CREATE TABLE questions (
                                      ID int(4) unsigned zerofill NOT NULL auto_increment,
                                      question text NOT NULL,
                                      test varchar(31) NOT NULL default '',
                                      ans1 text NOT NULL,
                                      ans2 text NOT NULL,
                                      ans3 text NOT NULL,
                                      ans4 text NOT NULL,
                                      ans5 text,
                                      ans6 text,
                                      corans varchar(8) NOT NULL default '',
                                      expl text NOT NULL,
                                      PRIMARY KEY (ID)
                                      ) TYPE=MyISAM;
                                      >
                                      DROP TABLE IF EXISTS subjects;
                                      CREATE TABLE subjects (
                                      ID int(4) unsigned zerofill NOT NULL auto_increment,
                                      cat varchar(31) NOT NULL default '',
                                      descr text NOT NULL,
                                      random int(1) default NULL,
                                      PRIMARY KEY (ID)
                                      ) TYPE=MyISAM;
                                      >
                                      I can clearly see that's not the query you are performing. Round 2, try
                                      again. Still keep in mind the earlier remark that if the query has zero
                                      rows it will not show you anything in a browser (unless you look at the
                                      source).
                                      >
                                      --
                                      Rik Wasmus
                                      mysqlshow tables;
                                      +----------------+
                                      | Tables_in_quiz |
                                      +----------------+
                                      | questions |
                                      | subjects |
                                      +----------------+
                                      2 rows in set (0.01 sec)

                                      mysqlselect * from questions;
                                      Empty set (0.00 sec)

                                      mysqlselect * from subjects;
                                      +------+---------+---------+--------+
                                      | ID | cat | descr | random |
                                      +------+---------+---------+--------+
                                      | 0001 | TESTING | TESTING | 1 |
                                      +------+---------+---------+--------+
                                      1 row in set (0.00 sec)

                                      Just a little more information.


                                        Comment

                                        • Rik
                                          #11
                                          Re: PHP Blank Page.

                                          On Wed, 20 Jun 2007 00:54:52 +0200, techjohnny@gmai l.com
                                          <techjohnny@gma il.comwrote:
                                          On Jun 19, 2:26 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                          >On Tue, 19 Jun 2007 23:22:29 +0200, techjoh...@gmai l.com
                                          >>
                                          >>
                                          >>
                                          ><techjoh...@gm ail.comwrote:
                                          On Jun 19, 1:38 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                          >On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmai l.com
                                          >>
                                          ><techjoh...@gm ail.comwrote:
                                          On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                                          wrote:
                                          >On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                          >>
                                          On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                                          >>
                                          <techjoh...@gma il.comwrote:
                                          On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                          >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                                          >>
                                          ><techjoh...@gm ail.comwrote:
                                          Ok,
                                          >>
                                          I posted earlier about this, a blank php page. I've enabled
                                          >logging
                                          ALL in the php.ini, but nothing. If I change the name of
                                          >the
                                          >db
                                          >in
                                          the include file, I get an error message, so I guess this
                                          >means
                                          >it's
                                          connecting to the mysql db. I've included the first couple
                                          >lines of
                                          code for this page:
                                          >>
                                          >First rule of hunting errors: do not surpress any errors by
                                          >@ if
                                          >something
                                          >isn't working.
                                          >>
                                          >Second: I do not see any output, so as far as I'm concerned
                                          >if
                                          >you've
                                          >got
                                          >no errors you would still see nothing.
                                          >>
                                          >- $qry['cat'] doesn't seem to be set anywhere, how come?
                                          >- check your queries for errors: echo mysql_error(), and the
                                          >query
                                          >itself.
                                          >>
                                          The entire page:
                                          >>
                                          Well, that's nice, I do not spot any clear syntax errors.(That
                                          >is,
                                          >if
                                          >I
                                          assume correctly that '// Check if scoreboard contains entries
                                          >in
                                          >this
                                          category and, if so,list results' is on 1 single line) However,
                                          >with
                                          >no
                                          query result the only output would be '</ol><br />', which
                                          >obviously
                                          doesn't show up in a browser.
                                          >>
                                          Wether there's a parse error in your other includes I couldn't
                                          >say.
                                          >>
                                          So, check your queries, echo mysql_error(), check
                                          >mysql_num_rows ()
                                          >and
                                          echo it to check wether the result has data or is empty, etc.
                                          >>
                                          --
                                          Rik Wasmus
                                          >>
                                          >Thanks.
                                          >echo mysql_error();
                                          >>
                                          >Warning: session_start() : Cannot send session cache limiter -
                                          >headers
                                          >already sent (output started at
                                          >/www13/htdocs/quiz/inc/header.inc.php:
                                          >3) in /www13/htdocs/quiz/index.php on line 4
                                          >>
                                          OK. I removed the header file and now it doesn't report anything.
                                          >>
                                          >And how many rows in the dataset? Keep in mind I normally say
                                          >different
                                          >things in a post, not just one.
                                          >>
                                          Here is the mysql query:
                                          >>
                                          DROP TABLE IF EXISTS questions;
                                          CREATE TABLE questions (
                                          ID int(4) unsigned zerofill NOT NULL auto_increment,
                                          question text NOT NULL,
                                          test varchar(31) NOT NULL default '',
                                          ans1 text NOT NULL,
                                          ans2 text NOT NULL,
                                          ans3 text NOT NULL,
                                          ans4 text NOT NULL,
                                          ans5 text,
                                          ans6 text,
                                          corans varchar(8) NOT NULL default '',
                                          expl text NOT NULL,
                                          PRIMARY KEY (ID)
                                          ) TYPE=MyISAM;
                                          >>
                                          DROP TABLE IF EXISTS subjects;
                                          CREATE TABLE subjects (
                                          ID int(4) unsigned zerofill NOT NULL auto_increment,
                                          cat varchar(31) NOT NULL default '',
                                          descr text NOT NULL,
                                          random int(1) default NULL,
                                          PRIMARY KEY (ID)
                                          ) TYPE=MyISAM;
                                          >>
                                          >I can clearly see that's not the query you are performing. Round 2, try
                                          >again. Still keep in mind the earlier remark that if the query has zero
                                          >rows it will not show you anything in a browser (unless you look at the
                                          >source).
                                          >
                                          mysqlshow tables;
                                          2 rows in set (0.01 sec)
                                          >
                                          mysqlselect * from questions;
                                          Empty set (0.00 sec)
                                          >
                                          mysqlselect * from subjects;
                                          1 row in set (0.00 sec)
                                          >
                                          Just a little more information.
                                          Little droplets keep pouring in, I've got a feeling we're almost
                                          there...:-). This offcourse is still not what I was asking, but it'll do:
                                          no data in the resultsets, so no output, ergo no information screen.
                                          Please fill you database, with junk if need be, but no data in it equals
                                          no output from it I'd think.

                                          --
                                          Rik Wasmus

                                            Comment

                                            • techjohnny@gmail.com
                                              #12
                                              Re: PHP Blank Page.

                                              On Jun 19, 4:39 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                              On Wed, 20 Jun 2007 00:54:52 +0200, techjoh...@gmai l.com
                                              >
                                              >
                                              >
                                              <techjoh...@gma il.comwrote:
                                              On Jun 19, 2:26 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                              On Tue, 19 Jun 2007 23:22:29 +0200, techjoh...@gmai l.com
                                              >
                                              <techjoh...@gma il.comwrote:
                                              On Jun 19, 1:38 pm, Rik <luiheidsgoe... @hotmail.comwro te:
                                              On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmai l.com
                                              >
                                              <techjoh...@gma il.comwrote:
                                              On Jun 19, 12:46 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
                                              wrote:
                                              On Jun 19, 11:39 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                              >
                                              On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmai l.com
                                              >
                                              <techjoh...@gma il.comwrote:
                                              On Jun 19, 10:59 am, Rik <luiheidsgoe... @hotmail.comwro te:
                                              >On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmai l.com
                                              >
                                              ><techjoh...@gm ail.comwrote:
                                              Ok,
                                              >
                                              I posted earlier about this, a blank php page. I've enabled
                                              logging
                                              ALL in the php.ini, but nothing. If I change the name of
                                              the
                                              db
                                              in
                                              the include file, I get an error message, so I guess this
                                              means
                                              it's
                                              connecting to the mysql db. I've included the first couple
                                              lines of
                                              code for this page:
                                              >
                                              >First rule of hunting errors: do not surpress any errors by
                                              @ if
                                              >something
                                              >isn't working.
                                              >
                                              >Second: I do not see any output, so as far as I'm concerned
                                              if
                                              you've
                                              >got
                                              >no errors you would still see nothing.
                                              >
                                              >- $qry['cat'] doesn't seem to be set anywhere, how come?
                                              >- check your queries for errors: echo mysql_error(), and the
                                              query
                                              >itself.
                                              >
                                              The entire page:
                                              >
                                              Well, that's nice, I do not spot any clear syntax errors.(That
                                              is,
                                              if
                                              I
                                              assume correctly that '// Check if scoreboard contains entries
                                              in
                                              this
                                              category and, if so,list results' is on 1 single line) However,
                                              with
                                              no
                                              query result the only output would be '</ol><br />', which
                                              obviously
                                              doesn't show up in a browser.
                                              >
                                              Wether there's a parse error in your other includes I couldn't
                                              say.
                                              >
                                              So, check your queries, echo mysql_error(), check
                                              mysql_num_rows( )
                                              and
                                              echo it to check wether the result has data or is empty, etc.
                                              >
                                              --
                                              Rik Wasmus
                                              >
                                              Thanks.
                                              echo mysql_error();
                                              >
                                              Warning: session_start() : Cannot send session cache limiter -
                                              headers
                                              already sent (output started at
                                              /www13/htdocs/quiz/inc/header.inc.php:
                                              3) in /www13/htdocs/quiz/index.php on line 4
                                              >
                                              OK. I removed the header file and now it doesn't report anything.
                                              >
                                              And how many rows in the dataset? Keep in mind I normally say
                                              different
                                              things in a post, not just one.
                                              >
                                              Here is the mysql query:
                                              >
                                              DROP TABLE IF EXISTS questions;
                                              CREATE TABLE questions (
                                              ID int(4) unsigned zerofill NOT NULL auto_increment,
                                              question text NOT NULL,
                                              test varchar(31) NOT NULL default '',
                                              ans1 text NOT NULL,
                                              ans2 text NOT NULL,
                                              ans3 text NOT NULL,
                                              ans4 text NOT NULL,
                                              ans5 text,
                                              ans6 text,
                                              corans varchar(8) NOT NULL default '',
                                              expl text NOT NULL,
                                              PRIMARY KEY (ID)
                                              ) TYPE=MyISAM;
                                              >
                                              DROP TABLE IF EXISTS subjects;
                                              CREATE TABLE subjects (
                                              ID int(4) unsigned zerofill NOT NULL auto_increment,
                                              cat varchar(31) NOT NULL default '',
                                              descr text NOT NULL,
                                              random int(1) default NULL,
                                              PRIMARY KEY (ID)
                                              ) TYPE=MyISAM;
                                              >
                                              I can clearly see that's not the query you are performing. Round 2, try
                                              again. Still keep in mind the earlier remark that if the query has zero
                                              rows it will not show you anything in a browser (unless you look at the
                                              source).
                                              >
                                              mysqlshow tables;
                                              2 rows in set (0.01 sec)
                                              >
                                              mysqlselect * from questions;
                                              Empty set (0.00 sec)
                                              >
                                              mysqlselect * from subjects;
                                              1 row in set (0.00 sec)
                                              >
                                              Just a little more information.
                                              >
                                              Little droplets keep pouring in, I've got a feeling we're almost
                                              there...:-). This offcourse is still not what I was asking, but it'll do:
                                              no data in the resultsets, so no output, ergo no information screen.
                                              Please fill you database, with junk if need be, but no data in it equals
                                              no output from it I'd think.
                                              >
                                              --
                                              Rik Wasmus
                                              Thanks for all your time. I'm closing this issue, because it's now
                                              working.

                                              There's a good chance this was working all along. Since the questions
                                              were failing to populated, the page wasn't displaying the subjects.

                                              Lack of awareness is my problem.

                                              --TJ

                                                Comment

                                                Previous template Next
                                                Working...