使用Ajax查询数据库

Using Ajax to query a database

本文关键字：数据库 查询 Ajax 使用      更新时间：2023-09-26

我想从JavaScript函数内部检查我的数据库。我以前从来没有做过这个，我似乎弄不明白。我不知道这条路对不对，但这是我找到的。这是我的简单HTML:

<!doctype html>
<html>
<head>
    <script src="Test.js"></script>
</head>
<body >
<p><a href="#" onClick="start();">Click me</a></p>
</body>

JavaScript: 

function start(){
    $.ajax({
        type: "POST",
        url: "checkDatet.php",
        datatype: "html",
        data: {functionname: 'Name', arguments: ['John']},
        success: function(data) {
            alert(data);
        }
    });
}

和PHP:

<?php
function familyName($name1) {
    $username = "user";
    $password = "pass";
    $hostname = "localhost";
    $output ="AAA";
    $dbhandle = mysql_connect($hostname, $username, $password)
        or die("Unable to connect to MySQL");
    $selected = mysql_select_db("databasee", $dbhandle)
        or die("Could not select database 'databasee'");
    $names = mysql_query("SELECT name WHERE name1 = '$name'");
    if($row = mysql_fetch_assoc($names)){
        $data = $row{'name'};
        if($data <> null)
            $output= "found it";
        else
            $output= "havent found it";
    }
    echo $output;
}
?>

实际上没有调用您的函数!这样做:

function start(){
    $.get('checkDatet.php?name=John', function(data) {
        alert(data);
    }
});

然后在" checkdate .php"中你需要调用你的函数:

<?php
familyName($_GET['name']);
function familyName($name1) {
$username = "user";
$password = "pass";
$hostname = "localhost";
$output ="AAA";
$dbhandle = mysql_connect($hostname, $username, $password)
    or die("Unable to connect to MySQL");
$selected = mysql_select_db("databasee", $dbhandle)
    or die("Could not select database 'databasee'");
$names = mysql_query("SELECT name WHERE name1 = '$name'");
if($row = mysql_fetch_assoc($names)){
    $data = $row{'name'};
    if($data <> null)
        $output= "found it";
    else
        $output= "havent found it";
}
echo $output;
}
?>

调用一个文件，而不是调用函数，所以只需像这样修改php代码

<?php
    $username = "user";
    $password = "pass";
    $hostname = "localhost";
    $output ="AAA";
    $name = $_POST['name'];
    $dbhandle = mysql_connect($hostname, $username, $password)
        or die("Unable to connect to MySQL");
    $selected = mysql_select_db("databasee", $dbhandle)
        or die("Could not select database 'databasee'");
    $names = mysql_query("SELECT name WHERE name1 = '$name'");
    if($row = mysql_fetch_assoc($names)){
        $data = $row{'name'};
        if($data <> null)
            $output= "found it";
        else
            $output= "havent found it";
    }
    echo $output;
?>
相关文章：