AJAX + ... jQuery的变量不传递给PHP [英] AJAX + jQuery... Variables not passing to PHP

问题描述

嘿，伙计们， 试图做一些很简单：通过2文本变量到PHP脚本，并把它们插入到一个MySQL数据库。出于某种原因，但我不能得到变量传递（所以，我会在我的数据库空记录）。

Hey guys, Trying to do something very simple: Pass 2 text variables to a php script and insert them into a MySQL db. For some reason however I can't get the variables to pass (so I just get empty records in my DB).

function ajaxCall(){

        $.ajax({
            type: "GET",
            url: "http://www.*.be/bubblingAjax.php",
            cache: false,
            data: "colour="+colour+"&size="+size,
        dataType: "html",
            success: onSuccess
        });
        return false;
    };

和PHP的：

<?php
    try
    {
        $connection = mysql_connect("#");
        mysql_select_db("#");

        $colour = mysql_real_escape_string($_GET['colour']);
        $size = mysql_real_escape_string($_GET['size']);

        mysql_query("INSERT INTO bubble (colour, size) VALUES ('$colour', '$size')");
        mysql_close($connection);
        echo "SUCCESS";
        echo $colour;
        echo $size;
    }
    catch(Exception $e)
    {
        echo $e->getMessage();
    }
?>

任何人都愿意采取快速浏览一下它，并指出我的 - 可能obvious-错误？它被我发疯了一个多一天！

Anyone willing to take a quick look at it and point out my -probably obvious- mistake? It's been driving me nuts for over a day!

谢谢！

推荐答案

这有工作：

<script type="text/javascript">
$(document).ready(function() {
   //you can wrap the code into an event, e.g click()
   var colour=...
   var size=...
   $.post("http://www.website.com/bubblingajax.php", { colour: colour, size: size },
   function(data) {
     alert("Respond: " + data);
   }); 
});

</script>

和PHP的（只是改去后）

and the PHP (only changed get to post)

<?php
    try
    {
        $connection = mysql_connect("#");
        mysql_select_db("#");

        $colour = mysql_real_escape_string($_POST['colour']);
        $size = mysql_real_escape_string($_POST['size']);

        mysql_query("INSERT INTO bubble (colour, size) VALUES ('$colour', '$size')");
        mysql_close($connection);
        echo "SUCCESS";
        echo $colour;
        echo $size;
    }
    catch(Exception $e)
    {
        echo $e->getMessage();
    }
?>

另外需要调试，我建议使用萤火虫或Chrome的打造检查工具。

Also to debug, I would suggest using firebug or chrome's build in inspect tools.

这篇关于AJAX + ... jQuery的变量不传递给PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！