dqpdb82600 2015-12-06 21:20
浏览 13

通过PHP实时插入MySQL?

I want to show a list in PHP with the entries in a mysql-database. it works, now Now in the same .php file, a form should insert a new entry in the database, and it should be shown then in the list. How could I make that? I am a beginner in PHP, so please help me :) I've got no Ideas

Thank you very much

//EDIT So, I tried the following: PHP-Part adminlist.php:

$adminname = mysqli_real_escape_string($con, $_POST['adminname']);
    $server = mysqli_real_escape_string($con, $_POST['server']);

    if(!empty($adminname && $server))
    {
        $insert =  "INSERT INTO admins (ID, Name, Passwort, Server, Anmeldungen) VALUES (NULL, '" . $adminname . "', '', '" . $server . "', '0')";
        $insertquery = mysqli_query($con, $insert);
    }

HTML-Part adminlist.php:

<form name='einfuegen' action='adminlist.php' method='post'>
            <table>
                <tr>
                    <th>Name</th>
                    <th>Server</th>
                </tr>
                <tr>
                    <td><input name='adminname' value='' /></td>
                    <td><input name='server' value='' /></td>
                    <td><input type='submit' value='Einf&uuml;gen' /></td>
                </tr>
            </table>
        </form>

in this case the last entry is always inserted in the database on every access to the site.

I've tried also to set under the form

$server = 0;
$adminname = 0;

and edited the above:

if(!empty($adminname && $server) && ($server != 0) && ($adminname != 0))

In this case it won't work and nothing is inserted. How could I set only one to be inserted and be shown then in the list?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c