php, jQuery, Lightbox, Ajax GET and POST issue
I have a form in a lightbox (fancybox). I am trying to do an ajax get to run an update to the database. But I do not know why it does not work. The code below is what is in the lightbox:
<div id="timezonelightbox">
<div class="lightboxtitle">Select Time Zone</div>
<form method="get" action="" >
<select name="timezones" id="timezones" class="selecttimezones">
<option value="Afri开发者_运维问答ca/Abidjan ">Africa/Abidjan </option>
<option value="Africa/Accra ">Africa/Accra </option>
<option value="Africa/Addis_Ababa ">Africa/Addis_Ababa </option>
<option value="Africa/Algiers ">Africa/Algiers </option>
<option value="Africa/Asmara">Africa/Asmara</option>
</select>
<input type="button" id="confirmtimezone" class="confirmtimezone" value="Confirm now"
onclick="updateTimeZone(); $.fancybox.close();">
</form>
</div>
<script type="text/javascript">
function updateTimeZone(){
$.getScript('<?echo $site["url"];?>/updateTimeZone.php?timezones=<?echo $_GET["timezones"]?>');
}
</script>
This is what I have in the called file:
header("content-type:text/js");
if(isset($_GET['timezones'])){
$queryupdatetimezone="UPDATE `Profiles` SET `TimeZone` ='".$_GET['timezones']."' WHERE
ID=".(int)$_COOKIE['memberID'];
$resultupdatetimezone=mysql_query($queryupdatetimezone) or die("Errore update default timezones: ".mysql_error());
exit;
}else{
?>alert ('An error occured');<?
}
?>
Everything seems fine when I click the confirm button. No errors. But when I look in the database it saves an empty string. $_GET['timezones'] is empty. How is that possible? What am I doing wrong?
It's an emtry string, because you are sending an empty string. Look at this line you posted:
$.getScript('/updateTimeZone.php?timezones=');
You probably forgot to give the timezone you wanted into there like this:
$.getScript('/updateTimeZone.php?timezones=THE_TIMEZONE');
Replace THE_TIMEZONE
with the timezone you want to set...
精彩评论