douxi3432 2013-12-05 02:57
浏览 52
已采纳

php注册脚本不添加到mysql数据库

Just wondering what I'm doing wrong here guys. This is my register screen, I'm using an older version of php as im following a tutorial. The script so far detects missing fields and existing usernames, however when I try to register new user it doesnt add to the mysql database ?

<!DOCTYPE html>
<html lang="en">
<head>
    <title> Exercise 3</title>
    <meta charset="utf-8">
</head>
<body>
    <?php
        $name = “Frank”;
        $age = “28”;

        var_dump($name);
        echo "<br>";

        print_r($name);
        echo "<br>";

        var_dump($age);
        echo "<br>";
    ?>
</body>
</html>
  • 写回答

1条回答 默认 最新

  • dsj1961061 2013-12-05 03:09
    关注

    There are lot of things you need to change:

    • I am assuming that your connecting to your database twice i.e config.php and by using mysql_connect.

    • Your website is highly vulnerable to SQL injection. So use mysqli_real_escape_string or some other functions to prevent from such attacks.

    • In the below query:

    Change this:

        $taken=("SELECT * FROM employee WHERE username ='{$myusername}'");
    

    Remove those brackets like this:

        $taken="SELECT * FROM employee WHERE username ='{$myusername}'";
    
    • Start using mysqli or PDO as mysql is being deprecated.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 一直显示正在等待HID—ISP