douyinzha5820 2019-04-27 01:21
浏览 393
已采纳

如何使用AJAX调用PHP函数?

I'm running my server on localhost using XAMPP, and I want to call a Javascript function which sends some data from the browser to a php script

The JS function is called when the a button on my html page is pressed:

function send_verification_code(){
    var xhttp = window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject('Microsoft.XMLHTTP');
    xhttp.open('GET','database.php?email='+email_address)
    xhttp.send()
}

So I want to add, to the $_GET array, a key-value pair of email=>email_address, where email_address is a string, in the function above.

Immediately after the function above executes, I want to call another function, a PHP function which adds that data to a SQL database on my server by calling add_email_to_be_verified (the function belongs to the php script im sending the data to):

database.php:

<?php
     $dbhost = "localhost";
     $dbuser = "root";
     $dbpass = "";
     $db = "example";
     $conn;

     function add_email_to_be_verified(){
        connect();
         $sql = 'insert into emailstobeverified values(';
         $sql .= $_GET['email'];
         $sql .= ',';
         $sql .= generate_verification_code();
         $sql .= ',';
         $sql .= date("Y-m-d H:i:s");
         $sql .= ');';
         query($sql);
         disconnect();

     }
     function generate_verification_code(){ //generates a random 6-digit verification code
        $code = mt_rand(0,999999);
        $padded_code = sprintf('%06d', $code);
        return $padded_code;
     }
     function connect(){
        $conn = new mysqli($dbhost, $dbuser, $dbpass,$db) or die("Connect failed: %s
". $conn -> error);
     }
     function query(sql){
        $conn->query($sql);
     }
     function disconnect(){
        $conn -> close();
     }
?>

How can I call the php function using AJAX?

  • 写回答

1条回答 默认 最新

  • doudun3910 2019-04-27 01:38
    关注

    You can call the function when the get emaiAddress is detected on your database.php page. For example:

    if(isset($_GET['email'])){
        add_email_to_be_verified($_GET['email']);
    }
    

    I would also modify your function to take the email in as a parameter, but you could also have that function find the email from the get as well.

    Here's and example of the function with the email parameter:

    function add_email_to_be_verified($email){
    
         connect();
         $sql = 'insert into emailstobeverified values(';
         $sql .= $email;
         $sql .= ',';
         $sql .= generate_verification_code();
         $sql .= ',';
         $sql .= date("Y-m-d H:i:s");
         $sql .= ');';
         query($sql);
         disconnect();
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 帮我解决一下膳食平衡的线性规划模型的数据实例
  • ¥40 万年历缺少农历,需要和阳历同时显示
  • ¥250 雷电模拟器内存穿透、寻基址和特征码的教学
  • ¥200 比特币ord程序wallet_constructor.rs文件支持一次性铸造1000个代币,并将它们分配到40个UTXO上(每个UTXO上分配25个代币),并设置找零地址
  • ¥15 关于Java的学习问题
  • ¥15 如何使用chatgpt完成文本分类任务?
  • ¥15 已知速度v关于位置s的等式,怎么转化为已知位置求速度v的等式
  • ¥15 我有个餐饮系统,用wampserver把环境配置好了,但是后端的网页却进去,是为什么,能不能帮远程一下?
  • ¥15 R运行没有名称为"species"的插槽对于此对象类"SDMmodelCV"
  • ¥20 基于决策树的数字信号处理,2ask 2psk 2fsk的代码,检查下报错的原因