doushao8399 2016-05-30 09:16
浏览 11

MySQL插入问题

Im new to PHP/MYSQL so im sry if you feel this is a bad question but i cant get this to work. Its for a login form. The issue i have is with the insert into with the insert query part. I apreciate if anyone could help me get this fixed :) TY in advance.

    function InsertIntoDB(&$formvars)
{

    $confirmcode = $this->MakeConfirmationMd5($formvars['email']);

    $formvars['confirmcode'] = $confirmcode;

    $insert_query = 'insert into '.$this->tablename.'(
            name,
            email,
            username,
            password,
            confirmcode
            )
            values
            (
            "' . $this->SanitizeForSQL($formvars['name']) . '",
            "' . $this->SanitizeForSQL($formvars['email']) . '",
            "' . $this->SanitizeForSQL($formvars['username']) . '",
            "' . md5($formvars['password']) . '",
            "' . $confirmcode . '"
            )';      
    if(!mysqli_query( $this->connection, $insert_query ))
    {
        $this->HandleDBError("Error inserting data to the table
query:$insert_query");
        return false;
    }        
    return true;
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ogg dd trandata 报错
    • ¥15 高缺失率数据如何选择填充方式
    • ¥50 potsgresql15备份问题
    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错