未插入表中的值

fbcarpbf  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(277)

我需要代码方面的帮助。我正在尝试在注册后将用户详细信息插入到我的数据库中,但这些详细信息没有插入到所选表中。
在表中插入的项目中,自动生成4个值。
下面是处理表单和将值插入数据库的php代码,请告诉我为什么没有插入值。谢谢您。

<?php
$msg = "";

    if(isset($_POST['add'])){

        $name = addslashes($_POST['name']);
        $email = addslashes($_POST['email']);
        $number = addslashes($_POST['number']);
        $address = addslashes($_POST['address']);
        $balance = addslashes($_POST['balance']);
        $username = addslashes($_POST['username']);

            function generateAccountString($length = 10) 
            {

                $characters = '0123456789';
                $charactersLength = strlen($characters);
                $randomString = '';

                for ($i = 0; $i < $length; $i++) 
                {

                    $randomString .= $characters[rand(0, $charactersLength - 1)];

                }

                return $randomString;

            }

            $account = generateAccountString();

            function generateAccessString($length = 6) 
            {

                $characters = '0123456789abcdefghijklmnopqrstuvwxyz';
                $charactersLength = strlen($characters);
                $randomString = '';

                for ($i = 0; $i < $length; $i++) 
                {

                    $randomString .= $characters[rand(0, $charactersLength - 1)];

                }

                return $randomString;

            }

            $access = generateAccessString();

            function generatePasswordString($length = 8) 
            {

                $characters = '0123456789abcdefghijklmnopqrstuvwxyz';
                $charactersLength = strlen($characters);
                $randomString = '';

                for ($i = 0; $i < $length; $i++) 
                {

                    $randomString .= $characters[rand(0, $charactersLength - 1)];

                }

                return $randomString;

            }

            $password = generatePasswordString();

            function generateCotString($length = 6) 
            {

                $characters = '0123456789abcdefghijklmnopqrstuvwxyz';
                $charactersLength = strlen($characters);
                $randomString = '';

                for ($i = 0; $i < $length; $i++) 
                {

                    $randomString .= $characters[rand(0, $charactersLength - 1)];

                }

                return $randomString;

            }

            $cot = generateCotString();

        if($name != "" && $email != "" && $username != "" && $address != "" && $number != "" && $balance != ""){

            $_SESSION['name'] = $name;
            $_SESSION['email'] = $email;
            $_SESSION['number'] = $number;
            $_SESSION['address'] = $address;
            $_SESSION['balance'] = $balance;
            $_SESSION['username'] = $username;
            $_SESSION['cot'] = $cot;
            $_SESSION['access'] = $access;
            $_SESSION['account'] = $account;
            $_SESSION['password'] = $password;

            $sql = "INSERT INTO `user`(`name`, `email`, `number`, `address`, `acc-no`, `balance`, `username`, `password`, `cot`, `access`) VALUES ('$name','$email','$number','$address','$account','$balance','$username','$password','$cot','$access')";

            if (mysqli_query($con, $sql)) {
            header ('Location: successful');
            }
            else{
                $msg = "Something went wrong, please try again.";
            }

        } else { 
        $msg = "Please Fill Out All Fields!"; 
        }
    }   

?>

如果你有任何见解,我将不胜感激。

u5i3ibmn

u5i3ibmn1#

试着改变你的习惯 INSERT 对此进行查询:

$sql = "INSERT INTO `user`(`name`, `email`, `number`, `address`, `acc-no`, `balance`, `username`, `password`, `cot`, `access`) VALUES ('{$name}','{$email}','{$number}','{$address}','{$account}','{$balance}','{$username}','{$password}','{$cot}','{$access}')";

相关问题