php - 将值插入数据库并使用 Ajax 和 php 返回另一个值

Question

我正在尝试通过ajax向数据库中插入数据

当用户登录到 facebook 时，它会调用该函数这将返回用户 ID

我的代码

  function testAPI() {
    console.log('Welcome!  Fetching your information.... ');
    FB.api('/me', function(response) {
      console.log('Successful login for: ' + response.id);
      document.getElementById('status').innerHTML =
        'Thanks for logging in, <b>' + response.name + '!</b><br>';


        document.getElementById('pic').innerHTML = "<img class='image-wrap' style=' width: 100px; height: 100px;' id='profileImage' src='http://graph.facebook.com/" + response.id + "/picture?width=180&height=180'>"

function callPHP(params) {
    var httpc = new XMLHttpRequest(); 
    var url = "test.php";
    httpc.open("POST", url, true); 

    httpc.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
    httpc.setRequestHeader("Content-Length", params.length); 

    httpc.onreadystatechange = function() { 
    if(httpc.readyState == 4 && httpc.status == 200) { 
        alert(httpc.responseText); 
        }
    }
    httpc.send(params);
}



callPHP(response.id);

  } 

测试.php

<?php
// configuration
$dbtype     = "sqlite";
$dbhost     = "localhost";
$dbname     = "test";
$dbuser     = "root";
$dbpass     = "1234";

// database connection
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);

// new data
$link = $_GET;
$crr = rand(5, 15);

// query
$sql = "INSERT INTO user (link,crr) VALUES (:link,:crr)";
$q = $conn->prepare($sql);
$q->execute(array(':link'=>$link,
                  ':crr'=>$crr));

echo $crr;
?> 

我想插入(response.id)到数据库并返回 ( $crr )

但是我得到的是空值
或者我得到 ( 500 (Internal Server Error) )

Answer 1

首先 - $_GET 是一个数组。将数组转换为字符串意味着您在字段中得到字符串 'Array'。

第二 - ':link'=>$lnik,。那么是 $link 还是 $lnik。更正您的拼写错误。

第三 - 读取错误日志。 始终。