PHP AJAX 和 mySQL 不返回数据？

Question

我有以下 PHP block :

$word = mysql_real_escape_string(trim($_GET['word']));
    $firstletter = substr('$word', 0, 1);

    $query = "SELECT * FROM `dictionary` WHERE word LIKE '%$firstletter'";
    $result = mysql_query($query) or die(mysql_error().": ".$query);
    $row = mysql_fetch_assoc($result);
    // send back the word to ajax request
    $i = 0;
    $fullLoad = '';
    while ($i < mysql_numrows($result)) {
        $fullLoad = $fullload . '|' . $row['word'];
        $i++;
    }
    echo $fullLoad;

现在，我的 AJAX 调用:

$.ajax({
                type: "GET",
                url: "word-list.php",
                data: "word="+ theword,
                success: function(data){ //data retrieved
                    console.log(data);
                            }
    });

现在，假设缺少的单词变量是 apple - 所以 $word = 'apple';

但是当 console.log() 输出时——我得到的只是零，什么都没有，nada, zip, blahblah

>:(

Answer 1

试试这个

 $firstletter = substr($word, 0, 1);