예제 #1
0
                      </div>
                    </a>
                  </li>
                <?php 
        }
        ?>
              <?php 
    }
    ?>
						<?php 
}
if (empty($params) || count($params) == 0 || isset($params['p'])) {
    ?>
 
              <?php 
    $result_func1 = loadimage(0, 30);
    while ($row_result_func1 = mysql_fetch_assoc($result_func1)) {
        $p_number = $row_result_func1['p_number'];
        $at_number = $row_result_func1['album_type_number'];
        $c_number = $row_result_func1['club_number'];
        $p_code = $row_result_func1['p_code'];
        $filename = $row_result_func1['filename'];
        ?>
                <li class="photo" id="photo_<?php 
        echo $p_number;
        ?>
" code="<?php 
        echo $p_code;
        ?>
" c="<?php 
        echo $c_number;
    while ($row_result = mysql_fetch_assoc($result_sql)) {
        if ($i == 1) {
            $i++;
        } else {
            $c_number .= ", ";
        }
        $c_number .= $row_result['c_number'];
    }
    $sql_func1 = "SELECT * FROM ( SELECT * FROM `photo` WHERE `club_number` in ({$c_number}) ORDER BY `time` DESC LIMIT {$start}, {$count} ) AS T2 ORDER BY RAND()";
    $result_func1 = mysql_query($sql_func1);
    return $result_func1;
}
if (isset($_GET['start']) && isset($_GET['count'])) {
    $start = intval($_GET['start']);
    $count = intval($_GET['count']);
    $result_func1 = loadimage($start, $count);
    $data = array();
    while ($row_result_func1 = mysql_fetch_array($result_func1, MYSQL_NUM)) {
        $data[] = $row_result_func1;
    }
    return $result_func1;
    //$json->encode( $data );
}
if (isset($_GET['p']) && $_GET['p'] != '') {
    // function 2 依點選的相片去選取相片
    $sql_func2 = "SELECT * FROM `photo` WHERE `p_number`= '" . $_GET['p'] . "'";
    $result_func2 = mysql_query($sql_func2);
    $row_result_func2 = mysql_fetch_assoc($result_func2);
    // function 3 選取 點選照片後 該相簿裡的其他相片
    $sql_func3 = "SELECT * FROM `photo` WHERE `album_type_number` = '" . $row_result_func2['album_type_number'] . "' ";
    $result_func3 = mysql_query($sql_func3);
예제 #3
0
        } else {
            if ($type == "load") {
                loadNote();
            } else {
                if ($type != "lecturecourse") {
                    header("HTTP/1.1 400 Invalid Request");
                    die("HTTP/1.1 400 Invalid Request - you passed in a wrong type parameter.");
                }
            }
        }
    }
} else {
    if (isset($_POST["lecturecourse"])) {
        if (isset($_POST["lecturenumber"])) {
            if (isset($_POST["page"])) {
                loadimage();
            } else {
                pageList();
            }
        } else {
            lectureList();
        }
    }
}
function getLastNum()
{
    $db = new LectureNote();
    $order = $db->getLastNum();
    if ($order == NULL) {
        $order = 1;
    } else {