Select上通过Ajax将Javascript变量传递到PHP文件中的问题

Issue in Passing Javascript variable to PHP file Through Ajax on Select

本文关键字:PHP 文件 问题 变量 Ajax Javascript Select      更新时间:2023-09-26

我有一个jquery日历,它存储选定的日期,我想将选定的日期发送到php文件,以从数据库中获得基于选定日期的结果。。这是我的代码:-

enter code here<div id="calendar"></div>

日期:

my scripr:-<script>var x='';$('#calendar').datepicker({

altField: '#datepicker_send',
    inline: true,
    firstDay: 1,
    showOtherMonths: true,
    altFormat: "dd/mm/yy",
    dateFormat: "dd/mm/yy",
    dayNamesMin: ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'],
     onSelect: function(dateText){
     $('#event-date').text(dateText)
      x=dateText;          
     // alert(x);
     $.ajax({ type: "GET", 
     url: 'check_events.php', 
     data: { y : x}, 
     //dataType: 'json',
     success: function(data)
     { alert(data); }   /// tried to get the value of date
          } );
    }
    });
</script>

Check_events.php:-

enter code here<?php mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("users") or die(mysql_error());
if(isset($_REQUEST['y']))
{
$y = date_format($_REQUEST['y'],'YYYY-MM-DD');
echo $y;
exit; //trying to print the date
//$uname = mysql_real_escape_string($x);
$sql_check = mysql_query("SELECT * FROM events WHERE date='$x'");
while($res=mysql_fetch_assoc($sql_check))
{
print_r($res);
}
}
?>
$.ajax({ type: "GET", 
 url: 'check_events.php', 
 data: { y : x}, 
 //dataType: 'json',
 success: function(data)
 { 
      alert(data); //Alert Data on success not result.
 }   
 });

只需从这里删除不必要的,

success: function(data),

所以新代码应该是:

$.ajax({ type: "GET", 
  url: 'check_events.php', 
  data: { y : x}, 
  //dataType: 'json',
  success: function(data) { 
    alert(data); //Alert Data on success not result.
  }
});