PHP - Oop Class Assigning Issue

Hello,

I am creating a class which contains one private function that deals with connecting to a SQL Server and executing the sql that is passed in to that function.
I have defined a class variable which is assigned the value of sqlsrv_query like so.

$this->QueryResult = sqlsrv_query($conn,$sql);
I have placed private $QueryResult at the top of my class.

The other public methods call this private function to assign the result set to the class variable, the private method returns and then the public methods loop through the results array like so.

while($row = sqlsrv_fetch_array($this->QueryResult))

.. but the while loop never gets entered.

If I declare everything in the same method then it works, however there are going to be several public methods that will use this private method and I don't want to duplicate all the database coding.

Hope someone can help

I have a basic pagination class, I have used on several pages of a site I am working on. It works fine on 3 of the pages, but when I try to use it on any other pages, or even a new blank page I wrote, it does not work.

class Pagination {

    public $current_page;
    public $per_page;
    public $total_count;

    public function  __construct($page=1, $per_page=20, $total_count=0) {
        $this->current_page = (int)$page;
        $this->per_page = (int)$per_page;
        $this->total_count = (int)$total_count;
    }

    public function offset(){
        return ($this->current_page - 1) * $this->per_page;
    }

    public function total_pages(){
        return ceil($this->total_count/$this->per_page);
    }

    public function previous_page(){
        return $this->current_page - 1;
    }

    public function next_page(){
        return $this->current_page + 1;
    }

    public function has_prev_page(){
        return $this->previous_page() >= 1 ? true : false;
    }

    public function has_next_page(){
        return $this->next_page() <= $this->total_pages() ? true : false;
    }
That is the pagination class, and this is the code I use to call it, along with some debugging information I am using.
      
        if(isset($_GET['order'])){ $order = $_GET['order']; } else { $order = "id"; }
        if(isset($_GET['orderby'])){ $order_by = $_GET['orderby']; } else { $order_by = "ASC"; }      
            $page = !empty($_GET['page']) ? (int)$_GET['page'] : 1;
            $per_page = 2;
            $sql = mysql_query("SELECT * FROM orders WHERE customerid = 4");
            $result = mysql_fetch_array($sql);
            $total_count = mysql_num_rows($sql);
            //$total_count = Order::count_by_cust(4);
            $pagination = new Pagination($page, $per_page, $total_count);
            $sql = "SELECT * FROM orders WHERE customerid = 4 ORDER BY {$order} {$order_by} ";
            $sql .= "LIMIT {$per_page} ";
            $sql .= "OFFSET {$pagination->offset()}";  
            $orders = Order::find_by_sql($sql); 
            echo "Page:" . $page . "<br />PerPage:" . $per_page . "<br />Total:" . $total_count . "<br />Total Pages:" . $pagination->total_pages();
?>

SOME FOREACH INFORMATION HERE

<?php 
echo "Has Prev Page:" . $pagination->has_prev_page() . "<br />";
echo "Total Pages:" . $pagination->total_pages() . "<br />";
echo "Has Next Page:" . $pagination->has_next_page() . "<br />";

?>
<div id="pagination" style="clear: both; text-align: center;">
    <?php
    if ($pagination->total_pages() > 1){
        if ($pagination->has_prev_page() == 1){
            echo "<a href=\"orders.php?search&uid={$order->customerid}&order={$order}&orderby={$order_by}&page=";
            echo $pagination->previous_page();
            echo "\">&laquo; Previous</a>";
        }

        for($i=1; $i<=$pagination->total_pages(); $i++){
            if($i == $page){
               echo " <span class=\"selected\">{$i}</span> ";
            } else {
            echo " <a href=\"orders.php?search&uid={$order->customerid}&order={$order}&orderby={$order_by}&page={$i}\">{$i}</a> ";
            }
        }

        if ($pagination->has_next_page() == 1){
            echo "<a href=\"orders.php?search&uid=" . $order->customerid . "&order=" . $order . "&orderby=" . $order_by . "&page=";
            echo $pagination->next_page();
            echo "\">Next &raquo;</a>";
        }
    }
    ?>
    </div>


The customer ID is dynamic, but for debugging sake I am using the customer ID of 4. The output of the page has the following informaton:
Page:1
PerPage:2
Total:15
Total Pages:8

Has Prev Page:
Total Pages:8
Has Next Page:1

So i know all the variables are right, the problem is, it only prints a bold "1". Thats all, no numbers, or Next Page option.
However i use the EXACT same code in another couple pages, and it works fine, but with this current page and a few others. It does not work.

I have also tryed extracting just this information into a blank file to just get the page numbers, taking out all the pages other code, and it still only gives me "1".

Any ideas?

I am using a PHP class for a web app that works perfectly well when developing on local machine (PHP 5.2) using the NuSphere IDE. NuSphere sees the class, and when I run the app locally everything seems to work, but when i port the app to the host (Linux Ubuntu with Apache2, PHP 5.3, MySQL 5.1 ), the class is not found (using the remote host debugger).

The exact mesage is: Class 'ExcelXML' not found at <line of code>.

Here is the code snippet:
Code: [Select]
<?php
    function setExcelData($sql, $title, $fileName, $idref=0)
    {
        $retVal=false;
        //$fileName=$fileName.'.xml';
        $fileName=$fileName.'.xls';
        include ('ExcelXML.inc.php');
        include_once $_SERVER['DOCUMENT_ROOT'].'/truck/inc/db.inc.php';
        $input = ($idref==0?"blank1.xml":"blank.xml"); 
        // create ExcelXML object
        $xml = new ExcelXML();
        // read template file
        if (!$xml->read($input))
        {
            echo "Failed to open Tempalate Excel XML file<br>";
        }
...
?>

Here is the class
Code: [Select]
<?php 
/**
 * Class ExcelXML
 * Provide functions to modify the content of file in Excel's XML format.
 * 
 * REQUIRED:
 * - An ExcelXML file as template
 * 
 * FEATURES:
 * - read, modify, and save Excel's XML file
 * - create download stream as Excel file format (*.xls)
 * 
 * CHANGELOG:
 * 06-08-2008
 * - Update setCellValue function
 * - Fix setCellValue bug
 * 13-07-2008
 * - First created 
 * 
 * 
 * @author Herry Ramli (herry13@gmail.com)
 * @license GPL
 * @version 0.1.1
 * @copyright August 06, 2008
 */
class ExcelXML
{
    var $domXML;
    var $activeWorksheet;
    
    function ExcelXML()
    {
    }
...
?>

The class is in the same folder location as the calling php file. Any ideas? I don't get it.

I have an issue that with some testing on an Access  class with a method getControlAccess it should only return true or false but as soon as I place a string of any sort
into the return my tests always returns true. Any help to point out if it is the way I am testing or the way I have written the method would be great. In the example
below it would return true.


In one class I have this method
Code: [Select]
class Access{
public function getControlAccess(){

return   'I am stuffed';
}
}

In the second class I have this
Code: [Select]
class AccessTests extends Access{
public function controlAccessTest(){
$return = "<ul>";
 
if ($this->getControlAccess() == TRUE){

$return .= "<li>getControlAcess should be true and is returning:<b> ". $this->getControlAccess() ."</b></li>";

} elseif ($this->getControlAccess() == FALSE){

$return .= "<li>getControlAcess should be false and is returning:<b> ". $this->getControlAccess() ."<b></li>";
} else {

$return .= "<li>getControlAcess is really stuffed:<b>". $this->getControlAccess() ."<b></li>";
}

$return .= "</ul>";
return $return;
}

public function setAccessTest($set){
return $set;
}

}

I am doing some practice with classes. MY class below echoes out input and radio fields based on the instantiation of the Form class (the code below is working!), but I am trying to resolve how to get my form radio fields so they are not in between every other form field as they are supposed to be next to eachother. If you run the below, you will see what I mean. And also is my approach at all sensible? I am only doing this for learning experience, so any advice please.

<?php
  class Form
  {
      private $fields = array();
      private $radios = array();
      private $actionValue;
      private $submit = "Submit Form";
      private $Nradios = 0;
      private $Nfields = 0;
      function __construct($actionValue, $submit)
      {
          $this->actionValue = $actionValue;
          $this->submit = $submit;
      }
      function displayForm()
      {
          echo "<form action='{$this->actionValue}' method='post'>\n\n";
          for ($j = 1, $i = 1; $j <= sizeof($this->fields), $i <= sizeof($this->radios); $j++, $i++) {
              echo "<p>\n<label>{$this->fields[$j-1]['label']} : </label>\n";
              echo "<input type='text' name='{$this->fields[$j-1]['name']}'>\n</p>\n\n";
              echo "<p>\n<label>{$this->radios[$i-1]['rlabel']} : </label>\n";
              echo "\n<input type='radio' name='{$this->radios[$i-1]['rname']}' value='{$this->radios[$i-1]['rvalue']}'>\n</p>\n\n";
          }
          echo "\n\n<input type='submit' value='{$this->submit}'>\n</form>";
      }
      function addField($name, $label)
      {
          $this->fields[$this->Nfields]['name'] = $name;
          $this->fields[$this->Nfields]['label'] = $label;
          $this->Nfields = $this->Nfields + 1;
      }
      function addRadio($rname, $rvalue, $rlabel)
      {
          $this->radios[$this->Nradios]['rname'] = $rname;
          $this->radios[$this->Nradios]['rvalue'] = $rvalue;
          $this->radios[$this->Nradios]['rlabel'] = $rlabel;
          $this->Nradios = $this->Nradios + 1;
      }
  }
?>

<?php
  $contact_form = new Form("process.php", "Submit Data >>");
  $contact_form->addField("first_name", "First Name");
  $contact_form->addField("last_name", "Last Name");
  $contact_form->addRadio("gender", "male", "Male");
  $contact_form->addRadio("gender", "femail", "Female");
  $contact_form->displayForm();
?>