dates.php

来自「zapatec suite 最新版 20070204,非常棒的ajax widg」· PHP 代码 · 共 20 行

<?php
/* $Id: dates.php 4322 2006-09-04 08:49:33Z shacka $ */
	include("config.php");
	include($ado_lib_root);
	include($JSON_lib_root);
	$conn = &ADONewConnection($dsn); 
	$conn->SetFetchMode(ADODB_FETCH_ASSOC);
	
	$query = "SELECT id, day, div1, div2, start_time FROM $table WHERE ((month=".$_GET['month'].") OR (month IS NULL)) AND ((year=".$_GET['year'].") OR (year IS NULL))";
	$res = $conn->Execute($query);
	$json_obj = array();
	while (!$res->EOF && $res) {
		$json_obj[] = $res->fields;
		$res->MoveNext();
	}
	$json = new Services_JSON();
	$output = $json->encode($json_obj);
	echo $output;
?>