|
¾È³çÇϼ¼¿ä. ³¯¾¾°¡ Á¤¸» ¸¹ÀÌÃß¿öÁ³³×¿ä. °¨±â Á¶½ÉÇϽñ¸¿ä^^;
jsonÀ¸·Î ¹è¿ÀúÀåÇØ¼ °¡Á®¿Í¾ß Çϴµ¥ °¡Á®¿À¸é¼ ÅØ½ºÆ®·Î ÀνÄÀ» ÇÏ´Â°Í °°¾Æ¿ä
///==== ÇØ´ç¼Ò½º =====////
function carLayer_jeri3() {
var f = document.getElementById("fom8");
var parms = "c_session=<?=$st_session?>&sd=<?=$sd?>&ed=<?=$ed?>&hour1="+f.hour1.value+"&hour2="+f.hour2.value;
$.ajax({
url : '/ajax/layer/carAjax2.php',
method : 'POST',
type : 'POST',
dataType : 'JSON',
data : parms,
success : function(response) {
var JSONobject = response;
//var JSONobject = [{"inSuImg":"1_1.gif","inSuDate":"2011-12-07","inSuDate2":"09"},{"backImg":"1_1.gif","backDate":"2011-12-09","backDate2":"09"}]; // ÀÌ°Í Âï¾î¸é °æ°íâ Àß¶å´Ï´Ù.
//alert(JSONobject);
$.each(JSONobject,function(key) {
$.each(JSONobject[key], function(k, v) {
alert(k + " -> " + v);
});
});
//$('#carLayer1').html(response);
},
complete : function(response) {
}
});
}
//====== carAjax2.php =====///
<?
header('Content-type: application/json');
$db_conn = mysql_connect("localhost","aaaaa","bbbbb");
//mysql_query("SET NAMES utf8");
mysql_selectdb("aaaaaa",$db_conn);
$dayHap = ( ( strtotime($ed) - strtotime($sd) )/86400 );
// ·»Æ®Ä« ·çÇÁ
$re = mysql_query("select gs_idx from ajax_product_temp where cart_session_id='$c_session' and gs_code='T02' and IsTrash=0");
$ro = mysql_fetch_array($re);
$ox = mysql_fetch_array(mysql_query("select main_img from citypass_product where idx='$ro[gs_idx]'"));
//while($ro = mysql_fetch_array($re)) {
for($i=0; $i<$dayHap; $i++) {
if($i==0) {
$data[] = array(
'inSuImg'=>$ox[main_img],'inSuDate'=>$sd,'inSuDate2'=>$hour1);
} elseif($i==$dayHap-1) {
$data[] = array(
'backImg'=>$ox[main_img],'backDate'=>$ed,'backDate2'=>$hour2);
}
}
echo json_encodes($data);
//print_r($data);
?>
¾È³çÇϼ¼¿ä. ³¯¾¾°¡ Á¤¸» ¸¹ÀÌÃß¿öÁ³³×¿ä. °¨±â Á¶½ÉÇϽñ¸¿ä^^;
jsonÀ¸·Î ¹è¿ÀúÀåÇØ¼ °¡Á®¿Í¾ß Çϴµ¥ °¡Á®¿À¸é¼ ÅØ½ºÆ®·Î ÀνÄÀ» ÇÏ´Â°Í °°¾Æ¿ä
///==== ÇØ´ç¼Ò½º =====////
function carLayer_jeri3() {
var f = document.getElementById("fom8");
var parms = "c_session=<?=$st_session?>&sd=<?=$sd?>&ed=<?=$ed?>&hour1="+f.hour1.value+"&hour2="+f.hour2.value;
$.ajax({
url : '/ajax/layer/carAjax2.php',
method : 'POST',
type : 'POST',
dataType : 'JSON',
data : parms,
success : function(response) {
var JSONobject = response;
//var JSONobject = [{"inSuImg":"1_1.gif","inSuDate":"2011-12-07","inSuDate2":"09"},{"backImg":"1_1.gif","backDate":"2011-12-09","backDate2":"09"}]; // ÀÌ°Í Âï¾î¸é °æ°íâ Àß¶å´Ï´Ù.
//alert(JSONobject);
$.each(JSONobject,function(key) {
$.each(JSONobject[key], function(k, v) {
alert(k + " -> " + v);
});
});
//$('#carLayer1').html(response);
},
complete : function(response) {
}
});
}
//====== carAjax2.php =====///
<?
header('Content-type: application/json');
$db_conn = mysql_connect("localhost","aaaaa","bbbbb");
//mysql_query("SET NAMES utf8");
mysql_selectdb("aaaaaa",$db_conn);
$dayHap = ( ( strtotime($ed) - strtotime($sd) )/86400 );
// ·»Æ®Ä« ·çÇÁ
$re = mysql_query("select gs_idx from ajax_product_temp where cart_session_id='$c_session' and gs_code='T02' and IsTrash=0");
$ro = mysql_fetch_array($re);
$ox = mysql_fetch_array(mysql_query("select main_img from citypass_product where idx='$ro[gs_idx]'"));
//while($ro = mysql_fetch_array($re)) {
for($i=0; $i<$dayHap; $i++) {
if($i==0) {
$data[] = array(
'inSuImg'=>$ox[main_img],'inSuDate'=>$sd,'inSuDate2'=>$hour1);
} elseif($i==$dayHap-1) {
$data[] = array(
'backImg'=>$ox[main_img],'backDate'=>$ed,'backDate2'=>$hour2);
}
}
echo json_encodes($data);
//print_r($data);
?>
|