src/Bi/Db.php
private function SetDebugDump($offset = null)
    {
        if (!$this->query_result or !$this->debug_on) {
            return;
        }

        $report = '<b>DATA:</b><br />
        <table border="0" cellpadding="5" cellspacing="1" style="background-color:#555555">
        <tr style="background-color:#eeeeee"><td nowrap valign="bottom"><font color="555599" size="2"><b>(row)</b></font></td>';

        if (is_numeric($offset)) {
            $z = 2;
            $report.= '<td nowrap align="left" valign="top"><font size="1" color="555599">'.$this->col_info[$offset]->type.' '.$this->col_info[$offset]->size.'</font><br><font size=2><b>'.$this->col_info[$offset]->name.'</b></font></td>';
        } else {
            $z = count($this->col_info);
            for ($i=0; $i < $z; $i++) {
                $report.= '<td nowrap align="left" valign="top"><font size="1" color="555599">'.$this->col_info[$i]->type.' '.$this->col_info[$i]->size.'</font><br><font size=2><b>'.$this->col_info[$i]->name.'</b></font></td>';
            }
        }

        $report .= "</tr>";

        if (is_array($this->result) and count($this->result) > 0) {
            $i=0;
            foreach ($this->result as $one_row) {
                $i++;
                $report.= '<tr bgcolor="ffffff"><td style="background-color:#eeeeee" nowrap align="middle"><font size="2" color="555599">'.$i.'</font></td>';

                if (is_array($one_row)) {
                    foreach ($one_row as $item) {
                        $report.= '<td nowrap style="background-color:#ffffff"><font size="2">'.htmlspecialchars($item).'</font></td>';
                    }
                } else {
                    $report.= '<td nowrap style="background-color:#ffffff"><font size="2">'.htmlspecialchars($one_row).'</font></td>';
                }


                $report.= "</tr>";
            }
        } else {
            $report.= '<tr bgcolor="ffffff"><td colspan="'.($z+1).'"><font size=2>No Results</font></td></tr>';
        }

        $report.= "</table>";
        $this->printOutStr .= $report;
    }
private function SetDebugDump($offset = null)
    {
        if (!$this->query_result or !$this->debug_on) {
            return;
        }

        $report = '<b>DATA:</b><br />
        <table border="0" cellpadding="5" cellspacing="1" style="background-color:#555555">
        <tr style="background-color:#eeeeee"><td nowrap valign="bottom"><font color="555599" size="2"><b>(row)</b></font></td>';

        if (is_numeric($offset)) {
            $z = 2;
            $report.= '<td nowrap align="left" valign="top"><font size="1" color="555599">'.$this->col_info[$offset]->type.' '.$this->col_info[$offset]->size.'</font><br><font size=2><b>'.$this->col_info[$offset]->name.'</b></font></td>';
        } else {
            $z = count($this->col_info);
            for ($i=0; $i < $z; $i++) {
                $report.= '<td nowrap align="left" valign="top"><font size="1" color="555599">'.$this->col_info[$i]->type.' '.$this->col_info[$i]->size.'</font><br><font size=2><b>'.$this->col_info[$i]->name.'</b></font></td>';
            }
        }

        $report .= "</tr>";

        if (is_array($this->result) and count($this->result) > 0) {
            $i=0;
            foreach ($this->result as $one_row) {
                $i++;
                $report.= '<tr bgcolor="ffffff"><td style="background-color:#eeeeee" nowrap align="middle"><font size="2" color="555599">'.$i.'</font></td>';

                if (is_array($one_row)) {
                    foreach ($one_row as $item) {
                        $report.= '<td nowrap style="background-color:#ffffff"><font size="2">'.htmlspecialchars($item).'</font></td>';
                    }
                } else {
                    $report.= '<td nowrap style="background-color:#ffffff"><font size="2">'.htmlspecialchars($one_row).'</font></td>';
                }


                $report.= "</tr>";
            }
        } else {
            $report.= '<tr bgcolor="ffffff"><td colspan="'.($z+1).'"><font size=2>No Results</font></td></tr>';
        }

        $report.= "</table>";
        $this->printOutStr .= $report;
    }
private function SetDebugDump ( $ offset = null ) { if ( ! $ this -> query_result or ! $ this -> debug_on ) { return ; } $ report = '<b>DATA:</b><br />
        <table border="0" cellpadding="5" cellspacing="1" style="background-color:#555555">
        <tr style="background-color:#eeeeee"><td nowrap valign="bottom"><font color="555599" size="2"><b>(row)</b></font></td>' ; if ( is_numeric ( $ offset ) ) { $ z = 2 ; $ report .= '<td nowrap align="left" valign="top"><font size="1" color="555599">' . $ this -> col_info [ $ offset ] -> type . ' ' . $ this -> col_info [ $ offset ] -> size . '</font><br><font size=2><b>' . $ this -> col_info [ $ offset ] -> name . '</b></font></td>' ; } else { $ z = count ( $ this -> col_info ) ; for ( $ i = 0 ; $ i < $ z ; $ i ++ ) { $ report .= '<td nowrap align="left" valign="top"><font size="1" color="555599">' . $ this -> col_info [ $ i ] -> type . ' ' . $ this -> col_info [ $ i ] -> size . '</font><br><font size=2><b>' . $ this -> col_info [ $ i ] -> name . '</b></font></td>' ; } } $ report .= "</tr>" ; if ( is_array ( $ this -> result ) and count ( $ this -> result ) > 0 ) { $ i = 0 ; foreach ( $ this -> result as $ one_row ) { $ i ++ ; $ report .= '<tr bgcolor="ffffff"><td style="background-color:#eeeeee" nowrap align="middle"><font size="2" color="555599">' . $ i . '</font></td>' ; if ( is_array ( $ one_row ) ) { foreach ( $ one_row as $ item ) { $ report .= '<td nowrap style="background-color:#ffffff"><font size="2">' . htmlspecialchars ( $ item ) . '</font></td>' ; } } else { $ report .= '<td nowrap style="background-color:#ffffff"><font size="2">' . htmlspecialchars ( $ one_row ) . '</font></td>' ; } $ report .= "</tr>" ; } } else { $ report .= '<tr bgcolor="ffffff"><td colspan="' . ( $ z + 1 ) . '"><font size=2>No Results</font></td></tr>' ; } $ report .= "</table>" ; $ this -> printOutStr .= $ report ; }
Data dump from select query
Data dump from select query