JS将变量传递给.php,php根据变量返回,由javascript显示,使用AJAX和带绑定的触发器(';inp


JS passing variable to .php, php returning based on variable, displayed by javascript, using AJAX and triggers with bind('input', function ()

我正在尝试让一个表单自动填充一些输入feild onchange,我似乎不知道如何将#url-feild发送到我的php脚本,任何输入或建议都是非常受欢迎的。

$('#url').bind('input', function () {});

在密钥更改时,将输入id$url的值发送到ajax.php

这将以的值运行

$query = "SELECT * FROM `inserted_posts` WHERE `search_name` = '$url'";

结果被回显

echo json_encode($array);

然后显示在其他输入框中

           $.ajax({
            url: 'ajax.php',   
            data: "", 
            dataType: 'json', //data format      
            success: function (data) //on recieve of reply
            {
                var catagoryPHP = data[1]; 
                var imageNamePHP = data[3];
                $('#catagory').html(catagoryPHP);
                $('#imageName').html(imageNamePHP);
            }
            });

我似乎不知道如何将$URL发送到ajax.php并启动事件链?

我的所有代码

JS:

$(function () {
$('#url').bind('input', function () {
    $(this).val() // get  value


    $(function () {
        //-----------------------------------------------------------------------
        // 2) Send a http request with AJAX http://api.jquery.com/jQuery.ajax/
        //-----------------------------------------------------------------------
        $.ajax({
            url: 'ajax.php', //the script to call to get data          
            data: "", //you can insert url argumnets here to pass to api.php
            //for example "id=5&parent=6"
            dataType: 'json', //data format      
            success: function (data) //on recieve of reply
            {
                var catagoryPHP = data[1]; 
                var imageNamePHP = data[3];
                //--------------------------------------------------------------------
                // 3) Update html content
                //--------------------------------------------------------------------
                $('#catagory').html(catagoryPHP);
                $('#imageName').html(imageNamePHP);
            }
        });
    });
});
});

ajax.php

<?php
require_once ('DBconnect.php');
$query = "SELECT * FROM `inserted_posts` WHERE `search_name` = '$url'";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
echo json_encode($array);
?>
    $.ajax({
        type: 'POST', // Can be 'GET'
        url: 'ajax.php',      
        data: { url: $('#url').val() },         
        success: function (data) //on recieve of reply
        {
            /* Your code to execute on success of the request */
        }
    });

#url将在php脚本中以$_POST['url']或$_GET['url']的形式访问,具体取决于您为请求在type中输入的类型。

请记住使用准备好的语句或mysqli_escape_string()函数来净化所有用户输入。