help on class

[osusano]

hi there i would like to ask something im not really that good into class but i am trying to challenge myself to learn more 🙂

here it goes

<?
   //filename : commonClass.php
   class query {
      function queryList($sql, $link, $page, $rowsPerPage='10', $pageLimit='10', $var1='', $value1='', $var2='', $value2='') {
?>

and the code is like this

<?
   //filename : test.php
   include("dbConnect.php");
   include("commonClass.php");
   $sql = "select * from sections";
   $queryList = new queryList( $sql, 'test.php', $page, 15, 10 );
   $res = mysql_query ($queryList->sql);
   while ( list ( $sectionId, $sectionCode, $sectionName, $section ) = mysql_fetch_row($res) ){
      print $sectionName.'<br>';
   }
?>

but this just gives me an error like this

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\webserver\home\oliver\test.php on line 7

what do u think should be the problem here?

try changing the query class to queryList and it will give you no error.

[HalfaBee]

In your class query you don't have a query() function.
Your querylist function should prob. be called query

HalfaBee

[osusano]

ye si know there is no that what im trying to do im planning to put up multiple functions and it is before individual classes so do u think this is possible?

[HalfaBee]

You can have functions in your class.
But you need to call them after the creation.

$question = new query;

$question->querylist( .... );

HalfaBee

[osusano]

still gives me an error

here the original code

//filename : test.php
<?
   include("dbConnect.php");
   include("common.class.php");
   $sql = "select * from sections";
   $queryList = new query( $sql, 'index.php', $page, 15, 10 );
   $res = mysql_query ($queryList->$queryList->sql);
   while ( list ( $sectionId, $sectionCode, $sectionName, $section ) = mysql_fetch_row($res) ){
      print $sectionName.'<br>';
   }
?>

//filename : common.class.php
<?
   /**
   ** Author	: Oliver Susano ([e-mail])
   ** website	: [url]http://vher.port5.com[/url]
   **/
   class query {
      function queryList($sql, $link, $page, $rowsPerPage='10', $pageLimit='10', $var1='', $value1='', $var2='', $value2='') {
      $result = mysql_query($sql);
      $totalRows = mysql_num_rows($result);
      $totalPages = ceil($totalRows / $rowsPerPage);
      $page = $page*1; $rowsPerPage = $rowsPerPage*1; $pageLimit = $pageLimit*1; 
      if(!is_int($rowsPerPage) || $rowsPerPage < 1) { $rowsPerPage = 10; }
      if(!is_int($pageLimit)   || $pageLimit   < 1) { $pageLimit   = 10; }
      if($page > $totalPages) { $page = $totalPages; }
      if(!is_int($page) || $page < 1) { $page = 1; }
      if($totalPages > $pageLimit ) { $value = $pageLimit; } 
         else { $value = $totalPages; }
      if($page > $pageLimit) { $i = $page - $pageLimit; $value = $pageLimit+$i; }
      $pages = "";
      if($page > 1){
         if($var1 == ''){
            $pages .= '&nbsp;<b>[ <a href="'.$link.'?page='.($page-1).'">prev</a> ] &nbsp;</b>';
         } else { $pages .= '&nbsp;<b>[ <a href="'.$link.'?page='.($page-1).'&'.$var1.'='.$value1.'&'.$var2.'='.$value2.'">prev</a> ] &nbsp;</b>'; }
      }
      while ($i < $value){
         $i++;
         if ($i == $page){
            $pages .= "<b>[ $i ]</b> ";
         } else { 
            if($var1 == ''){
               if($i <= $totalPages) { $pages .= '<a href="'.$link.'?page='.$i.'">'.$i.'</a> '; }
            } else {
               if($i <= $totalPages) { $pages .= '<a href="'.$link.'?page='.$i.'&'.$var1.'='.$value1.'&'.$var2.'='.$value2.'">'.$i.'</a> '; }
            }
         }
      }
      if($i <= $totalPages){
         if($totalPages != $page){
            if($var1 == ''){
               $pages .= '&nbsp;<b>[ <a href="'.$link.'?page='.($page+1).'">next</a> ]</b>';
            } else {
               $pages .= '&nbsp;<b>[ <a href="'.$link.'?page='.($page+1).'&'.$var1.'='.$value1.'&'.$var2.'='.$value2.'">next</a> ]</b>';
            }
         }
      }
      $this->result = $pages;
      $this->start  = (($page-1) * $rowsPerPage) + 1;
      $this->total  = $totalRows;
      $this->pages  = $totalPages;
      $this->sql	  = $sql." LIMIT ".($page-1)*$rowsPerPage.",".$rowsPerPage;
      if($page==$totalPages) { 
         $this->stop = ($page-1)*$rowsPerPage+($totalRows-(($page-1)*$rowsPerPage)); 
      } else { $this->stop = $page * $rowsPerPage; }
   }
}
?>

[osusano]

the error is

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\webserver\home\oliver\test.php on line 7

[HalfaBee]

Try this

//filename : test.php
<?
   include("dbConnect.php");
   include("common.class.php");
   $sql = "select * from sections";
   $queryList = new query;
  $sql_query = $queryList->queryList( $sql, 'index.php', $page, 15, 10 );
   $res = mysql_query($sql_query);
   while ( list ( $sectionId, $sectionCode, $sectionName, $section ) = mysql_fetch_row($res) ){
      print $sectionName.'<br>';
   }
?> 

your querylist function does not return anything or echo anything,
what are you expecting it to do?

HalfaBee

[osusano]

i tried the code u post but still got an error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\webserver\home\oliver\test.php on line 8

well the code should just diaply the value of $sectionName

[HalfaBee]

It doesn't have any echo's or prints and doesn't return anything.

HalfaBee