时间戳

首页 > 解决方案 > php 和 Mysql 不向服务器发送查询

php - php 和 Mysql 不向服务器发送查询

问题描述

我开发了 web 表单并连接到 mysql db。当我在本地主机（在我的计算机上）上进行测试时，它工作正常，所有 INSERT 查询都成功完成，但是当我在主机上上传（在 2 个托管公司上尝试）时，db 中的所有插入都是空的。

可能是什么问题？

我的代码

$db = mysqli_connect('localhost', 'cy57447_forms', '123456789', 'cy57447_forms');

if(isset($_POST['register'])) {
    $email = mysql_real_escape_string($_POST['email']);
    $tg_username = mysql_real_escape_string($_POST['tg_username']);
    $bitcointalk_username = mysql_real_escape_string($_POST['bitcointalk_username']);
    $bitcointalk_profile_link = mysql_real_escape_string($_POST['bitcointalk_profile_link']);
    $twitter_account_url = mysql_real_escape_string($_POST['twitter_account_url']);
    $number_of_followers = mysql_real_escape_string($_POST['number_of_followers']);
    $twitter_audit_link = mysql_real_escape_string($_POST['twitter_audit_link']);
    $ethereum_wallet = mysql_real_escape_string($_POST['ethereum_wallet']);
    $tokens = '';
}

    $sql = "INSERT INTO twitter_form (`tg_username`, `bitcointalk_username`, `bitcointalk_profile_link`, `twitter_account_url`, `number_of_followers`, `twitter_audit_link`, `ethereum_wallet`, `email`, `tokens`) VALUES ('$tg_username', '$bitcointalk_username', '$bitcointalk_profile_link', '$twitter_account_url', '$number_of_followers', '$twitter_audit_link', '$ethereum_wallet','$email', '');";
    $result = mysqli_query($db, $sql);

标签： phpmysql

解决方案

检查您的主机、用户名、密码和数据库名称是否都正确？

为了帮助您的调试过程，我建议在您的连接尝试周围使用 try catch

    try{
    $db = mysqli_connect('localhost', 'cy57447_forms', '123456789', 'cy57447_forms');
         //if condition
         $sql = "INSERT INTO twitter_form
                    ( ` tg_username ` ,
                     ` bitcointalk_username ` ,
                     ` bitcointalk_profile_link ` ,
                     ` twitter_account_url ` ,
                     ` number_of_followers ` ,
                     ` twitter_audit_link ` ,
                     ` ethereum_wallet ` ,
                     ` email ` ,
                     ` tokens ` )
        VALUES      ('$tg_username',
                     '$bitcointalk_username',
                     '$bitcointalk_profile_link',
                     '$twitter_account_url',
                     '$number_of_followers',
                     '$twitter_audit_link',
                     '$ethereum_wallet',
                     '$email',
                     '');";
    } catch (Exception $e) {
        $error = [
            'error' => $e->getCode(),
            'message' => $e->getMessage(),
            'traceString' => $e->getTraceAsString()
        ];
        var_dump($error);
    }
        $result = mysqli_query($db, $sql);

推荐阅读