<?
// loop all returned rows
while($row = mysql_fetch_assoc($query)
{
  // loop all items within the $row array
  $elements = count($row) - 1;
  for(i = 0; i<=$elements; i++)
  {
    // conditional select based on index of $row array
    switch($i)
    {
      // first two indexes
      case 0:
      case 1:
        // output non-field cell
        break;
      // all other indexes
      default:
        // output field cell
        break;
    }
  }
}?>

DoctorScurvy fucked around with this message at 08:18 on Apr 26, 2010

<?

<center><h2>Product Tab-ulator</h2></center>
<form action="formatter.php" method="post">
<div>
Product Info: (Product Details Tab)<br>
<textarea name="item_longdesc" rows="5" cols="80"><?php echo $_POST[item_longdesc] ?></textarea><br>
</div>
<div style="float: left;">
Specification name: (Specifications Tab, Left Column)<br>
<textarea name="item_desc" rows="30" cols="40"><?php echo $_POST[item_desc] ?></textarea><br>
</div>
<div style="float: left;">
Specification value:(Specifications Tab, Right Column)<br>
<textarea name="item_spec" rows="30" cols="70"><?php echo $_POST[item_spec] ?></textarea><br>
</div>
<div>
Updates Available:(Updates tab)<br>
<textarea name="item_updates" rows="30" cols="40"><?php echo $_POST[item_updates] ?></textarea><br>
<input type="submit" />
</div>
</form> 

<?php
    $header="<div class='tabber'><div class='tabbertab'><h2>Product Details</h2><p>"; 
$header=$header. $_POST[item_longdesc] . "</p></div><div class='tabbertab'><h2>Product Specifications</h2>";
$header=$header. "<p><div style='min-height:500px;' ><div class='itemlist'>";
    //<div class='itemdesc'>40<br></div></p></div></div>
    
    $idesc=explode("\n", $_POST[item_desc]);
    $ispec=explode("\n", $_POST[item_spec]);
    foreach ($idesc as $item){
        $header =  $header . "<b>".  $item . "</b><br>";
    }
    $header=$header . "</div> <div class='itemdesc'>";
    foreach ($ispec as $item){
        $header =  $header .  $item . "<br>";
    }
    $header=$header . "</div></div></div><div class='tabbertab'><h2>Product Updates</h2><p>" . $_POST[item_updates] . "</p></div></div>";
    echo "<h2>Results - Do not use until you have hit the submit query button:<br><div style='background-color: #C4E5F3;'>";
    echo htmlspecialchars($header) . "</div>";
?>
    
?>

the chip fucked around with this message at 01:32 on Apr 26, 2010

the chip fucked around with this message at 04:36 on Apr 26, 2010

<?
$_ = array('some_var' => 'Hello World!');
include '../templates/my-template.php';
?>

<p><?=$_['some_var']?></p>

MrMoo fucked around with this message at 10:40 on Apr 27, 2010

<?
class Sta{
 static public function funcA()
 {
  echo "OOOOH!";
 }
}

class Stb{
 public function bar()
 {
  Sta::funcA();
 }
}
$pie = new Stb();
$pie->bar();
?>

<?
class Sta{
 static public function funcA()
 {
  echo "OOOOH!";
 }
}

class Stb{
 private $className;
 private $methodName = 'funcA';

 function __construct( $n )
 {
   $this->className = $n;
 } 

 public function bar()
 {
  //call_user_func( $this->className . '::' . $this->methodName ); // works in 5.3.x and up
  call_user_func( array( $this->className , $this->methodName ) );

 }
}

$pie = new Stb( 'Sta' );
$pie->bar();
?>

Lumpy fucked around with this message at 15:37 on Apr 29, 2010

hasegawa fucked around with this message at 20:08 on Apr 30, 2010

<?php
$counter = 0;
while($allCollegeArray = mysql_fetch_array($allCollegeQuery, MYSQL_ASSOC))
{
  $add = collegeCount($allCollegeArray['college_id'], $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool);     
  $counter+$add;
}
echo $counter;
?>

SiCk fucked around with this message at 11:04 on Apr 30, 2010

hasegawa fucked around with this message at 16:21 on Apr 30, 2010

<?php

    $collegeCounter = 0;
    while($collegeArray = mysql_fetch_array($collegeQuery, MYSQL_ASSOC))
    {
        echo "<br />\n";
        print_r($collegeArray);
        echo "<br />\n";
        $toolSQL = "SELECT tool_identifier FROM tooltable WHERE tooltable.tool_id = '" . $userSelectedTool . "'";
        $ToolString = mysql_query($toolSQL);                            
        $deptCounter += deptCount2($usrSelClg, $collegeArray['dept_id'], $usrSelCourse, $usrSelTerm, $usrSelTool);
        echo $deptCounter;
        $collegeCounter += $deptCounter;        
    }
    return $collegeCounter;

?>

SiCk fucked around with this message at 17:00 on Apr 30, 2010

<?php
$con = mysql_connect("localhost", "name", "pass");
    if(!$con) {die("could not connect to MYSQL");}
    mysql_select_db("db1", $con);

function selectProperArrayType($usrSelClg, $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool)
{
    if ($usrSelClg == "" && $usrSelDept == "" && $usrSelCourse == "")
    {
        $allCollegeSQL = "SELECT college_id, name FROM collegetable ORDER BY name";
        $allCollegeQuery = mysql_query($allCollegeSQL);
        $counter = 2;    
        while($allCollegeArray = mysql_fetch_array($allCollegeQuery, MYSQL_ASSOC))
        {
            $add = collegeCount($allCollegeArray['college_id'], $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool);
            $counter+=$add;
                
        }
    echo $counter;
    echo "<br />";
    echo $add;
    }
    else
    {
    echo "problem";
    }
    
}
function collegeCount($usrSelClg, $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool)
{
    $collegeSQL = "SELECT dept_id, dept_name
                    FROM db1.depttable
                    LEFT JOIN db1.collegetable
                    ON db1.depttable.college = db1.collegetable.college_id
                    WHERE college_id = '" . $usrSelClg . "'
                    ORDER BY dept_name ASC";
    echo $collegeSQL;
    echo "<br />\n";
    
        
    $collegeQuery = mysql_query($collegeSQL);
    while($collegeArray = mysql_fetch_array($collegeQuery, MYSQL_ASSOC))
    {
        echo "<br />\n";
        //print_r($collegeArray);
        echo "<br />\n";
        $toolSQL = "SELECT tool_identifier FROM db1.db1_tools WHERE db1.db1_tools.tool_id = '" . $usrSelTool . "'";
        $ToolString = mysql_query($toolSQL);                            
        $deptCounter += deptCount2($usrSelClg, $collegeArray['dept_id'], $usrSelCourse, $usrSelTerm, $usrSelTool);
        echo $deptCounter;
        //$collegeCounter = $deptCounter;        
        //return $collegeCounter;
        $collegeCounter += $deptCounter;    
    }
    return $collegeCounter;
}

function deptCount2($usrSelClg, $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool)
{
    $deptSQL = "SELECT id, longtitle 
        FROM proddb.coursetble 
        LEFT JOIN db1.depttable 
        ON db1.depttable.dept_name = proddb.coursetble.depttitle 
        WHERE db1.depttable.dept_id = '" . $usrSelDept . "'
        AND proddb.coursetble.term = '" . $usrSelTerm . "'
        ORDER BY longtitle DESC            
        ";
    
    $deptQuery = mysql_query($deptSQL);
        
    while($deptArray = mysql_fetch_array($deptQuery, MYSQL_ASSOC))
    {            
        
        echo "<br />\n";
        print_r($deptArray);
        echo "<br />\n";
        $toolSQL = "SELECT tool_identifier FROM db1.db1_tools WHERE db1.db1_tools.tool_id = '" . $usrSelTool . "'";        
        $ToolString = mysql_query($toolSQL);
        $usageQuantity = getQuantity($deptArray['id'], $ToolString);    
        return $usageQuantity;        
    }
}
function getQuantity($usrSelCourse, $ToolString)
{
    $ToolArray = mysql_fetch_array($ToolString, MYSQL_ASSOC);    
    $sql = "SELECT
            count(*) as Quantity
        FROM
            db1.apache_log
        LEFT JOIN
            proddb.courseadmin
            ON proddb.courseadmin.id = db1.apache_log.log_id_param
        LEFT JOIN
            proddb.enroll_table
            ON proddb.enroll_table.coursesourcedid = proddb.courseadmin.idnumber
        LEFT JOIN
            proddb.people
            ON proddb.people.username = db1.apache_log.log_user
        LEFT JOIN
            proddb.coursetble
            ON proddb.coursetble.sourcedid = proddb.courseadmin.idnumber
        WHERE
            db1.apache_log.log_request = '" . $ToolArray['tool_identifier'] . "' AND
            proddb.enroll_table.personsourcedid = proddb.people.sourcedid AND
            proddb.enroll_table.role = 1 AND
            proddb.coursetble.id = '" . $usrSelCourse ."'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result, MYSQL_ASSOC);
    return $row['Quantity'];
}


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

$usrSelTerm = "201010";
$usrSelClg = "";
$usrSelDept = "";
$usrSelCourse = "";
$usrSelTool = "6";

selectProperArrayType($usrSelClg, $usrSelDept, $usrSelCourse, $usrSelTerm, $usrSelTool);


?>
</body>
</html>        

hasegawa fucked around with this message at 20:50 on Apr 30, 2010

hasegawa fucked around with this message at 21:30 on Apr 30, 2010