将PHP脚本从mysqli重写为pdo代码

I am rewriting my php code form mysqli to PDO, now I get a few error messages when I want to post my data.

I hope someone can help me im a starter with learning pdo :)

Over here a screenshot with the error messages

screenshot: https://gyazo.com/f4c6f6686014facb59d0fd40f1ebe522

<body>
            <font color="black">
                <form method="post" enctype='multipart/form-data'>
                    <table class="table-fill">
                        <thead>
                            <tr>
                                <th class="text-left">Film:</th>
                                <th class="text-left">
                                    <input style="text" name="txtFilm">
                                </th>
                            </tr>
                        </thead>
                        <tbody class="table-hover">
                            <tr>
                                <td class="text-left">Genre:</td>
                                <td class="text-left">
                                    <select name="Genre">
                            <option value="Actie">Actie</option>
                            <option value="Fantasie">Fantasie</option>
                            <option value="Horror">Horror</option>
                            <option value="Avontuur">Avontuur</option>
                            <option value="Komedie">Komedie</option>
                            <option value="Romantiek">Romantiek</option>
                            <option value="Historisch">Historisch</option>
                        </select>
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Film omschrijving:</td>
                                <td class="text-left">
                                    <textarea style="width:100%;resize:none;height:200px;" type="text" name="txtFilmomschrijving"></textarea>
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Datum van uitkomst:</td>
                                <td class="text-left">
                                    <input type="date" name="uitkomstdate">
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Datum uit bioscoop:</td>
                                <td class="text-left">
                                    <input type="date" name="Biosdate">
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Film draai dagen:</td>
                                <td class="text-left">
                                    <input type="checkbox" value="Maandag" name="draaidag[]">Maandag
                                    <input type="checkbox" value="Dinsdag" name="draaidag[]">Dinsdag
                                    <input type="checkbox" value="Woensdag" name="draaidag[]">Woensdag
                                    <input type="checkbox" value="Donderdag" name="draaidag[]">Donderdag
                                    <input type="checkbox" value="Vrijdag" name="draaidag[]">Vrijdag
                                    <input type="checkbox" value="Zaterdag" name="draaidag[]">Zaterdag
                                    <input type="checkbox" value="Zondag" name="draaidag[]">Zondag
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Film tijd dagen:</td>
                                <td class="text-left">
                                    <input type="checkbox" value="12uur" name="tijddagen[]">12:00
                                    <input type="checkbox" value="14uur" name="tijddagen[]">14:00
                                    <input type="checkbox" value="16uur" name="tijddagen[]">16:00
                                    <input type="checkbox" value="18uur" name="tijddagen[]">18:00
                                    <input type="checkbox" value="20uur" name="tijddagen[]">20:00
                                    <input type="checkbox" value="22uur" name="tijddagen[]">22:00
                                    <input type="checkbox" value="24uur" name="tijddagen[]">24:00
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Zaal:</td>
                                <td class="text-left">
                                    <select name="zaal">
                                    <option value="normaal">Normaal</option>
                                    <option value="groot">Groot</option>
                        </select>
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left">Film afbeelding:</td>
                                <td class="text-left">
                                    <input type="file" name="filmafbeelding" id="filmafbeelding">
                                </td>
                            </tr>
                            <tr>
                                <td class="text-left"></td>
                                <td class="text-left">
                                     <center><input type="submit" value="Film toevoegen" name="btnHuur"></center>
                                </td>
                            </tr>
                           
                        </tbody>
                    </table>
                    <br>
                </form>


                <br>

                <?php
include ("loginDB.php");
if (isset($_POST['btnHuur'])) {
$filmimage =$_FILES["filmafbeelding"]["name"]; 
$filmimagemap = "images/";      
$filmimagedoel = $filmimagemap.$filmimage;      
$draaidagen = $_POST['draaidag'];
$draaidag=""; 
foreach($draaidagen as $draaidagcheck) 
{ 
$draaidag.= $draaidagcheck.","; 
} 
$tijddagen = $_POST['tijddagen'];
$tijddag=""; 
foreach($tijddagen as $tijddagcheck) 
{ 
$tijddag.= $tijddagcheck.","; 
} 
    //film moet in de map /bioscoop/banner/ of /bioscoop/images/ staan//

$uploadfilm = "INSERT INTO films (film, movieimage, genre, Filmomschrijving, Datumvanuitkomst, Datumuitbioscoop, Filmdraaidagen, Filmtijddragen, Zaal) VALUES ('".$_POST["txtFilm"]."','$filmimagedoel','".$_POST["Genre"]."','".$_POST["txtFilmomschrijving"]."','".$_POST["uitkomstdate"]."','".$_POST["BiosDate"]."','$draaidag','$tijddag','".$_POST["zaal"]."')";
$result = mysqli_query($db,$uploadfilm);
    echo "Film toegevoegt!";
}
                
?>

NOTE THIS IS MY OLD MYSQLI PHP CODE SCRIPT:

   <center>
        <div class="gallery1">
            <h3>Film toevoegen</h3>
        </div>
        <br>
        <br>

 <form method="post" enctype='multipart/form-data'>
        <table class="table-fill">
            <thead>
                <tr>
                    <th class="text-left">Film:</th>
                    <th class="text-left"><input style="text" name="txtFilm"></th>
                </tr>
            </thead>
            <tbody class="table-hover">
                <tr>
                    <td class="text-left">Genre:</td>
                    <td class="text-left"> <select name="Genre">
                            <option value="Actie">Actie</option>
                            <option value="Fantasie">Fantasie</option>
                            <option value="Horror">Horror</option>
                            <option value="Avontuur">Avontuur</option>
                            <option value="Komedie">Komedie</option>
                            <option value="Romantiek">Romantiek</option>
                            <option value="Historisch">Historisch</option>
                        </select></td>
                </tr>
                <tr>
                    <td class="text-left">Film omschrijving:</td>
                    <td class="text-left"><textarea style="width:100%;resize:none;height:200px;" type="text" name="txtFilmomschrijving"></textarea></td>
                </tr>
                <tr>
                    <td class="text-left">Datum van uitkomst:</td>
                    <td class="text-left"><input type="date" name="uitkomstdate"></td>
                </tr>
                <tr>
                    <td class="text-left">Datum uit bioscoop:</td>
                    <td class="text-left"><input type="date" name="Biosdate"></td>
                </tr>
                <tr>
                    <td class="text-left">Film draai dagen:</td>
                    <td class="text-left"><input type="checkbox" value="Maandag" name="draaidag[]">Maandag
                                    <input type="checkbox" value="Dinsdag" name="draaidag[]">Dinsdag
                                    <input type="checkbox" value="Woensdag" name="draaidag[]">Woensdag
                                    <input type="checkbox" value="Donderdag" name="draaidag[]">Donderdag
                                    <input type="checkbox" value="Vrijdag" name="draaidag[]">Vrijdag
                                    <input type="checkbox" value="Zaterdag" name="draaidag[]">Zaterdag
                                    <input type="checkbox" value="Zondag" name="draaidag[]">Zondag</td>
                </tr>
                  <tr>
                                <td class="text-left">Film tijd dagen:</td>
                                <td class="text-left">
                                    <input type="checkbox" value="12uur" name="tijddagen[]">12:00
                                    <input type="checkbox" value="14uur" name="tijddagen[]">14:00
                                    <input type="checkbox" value="16uur" name="tijddagen[]">16:00
                                    <input type="checkbox" value="18uur" name="tijddagen[]">18:00
                                    <input type="checkbox" value="20uur" name="tijddagen[]">20:00
                                    <input type="checkbox" value="22uur" name="tijddagen[]">22:00
                                    <input type="checkbox" value="24uur" name="tijddagen[]">24:00
                                </td>
                            </tr>
                <tr>
                    <td class="text-left">Zaal:</td>
                    <td class="text-left"><select name="zaal">
                                    <option value="normaal">Normaal</option>
                                    <option value="groot">Groot</option></td>
                </tr>
                <tr>
                    <td class="text-left">Film afbeelding:</td>
                    <td class="text-left"><input type="file" name="filmafbeelding" id="filmafbeelding"></td>
                </tr>
                  <tr>
                                <td class="text-left"></td>
                                <td class="text-left">
                                     <center><input type="submit" value="Film toevoegen" name="submit"></center>
                                </td>
                            </tr>
            </tbody>
        </table>
        </form>
    </center>
    
     <?php
if(isset($_POST["submit"])){
$hostname='localhost';
$username='root';
$password='';

try {
$dbh = new PDO("mysql:host=$hostname;dbname=fastmovierenessefrank",$username,$password);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
$sql = "INSERT INTO films (film, movieimage, genre, Filmomschrijving, Datumvanuitkomst, Datumuitbioscoop, Filmdraaidagen, Filmtijddragen, Zaal)
VALUES ('".$_POST["txtFilm"]."','$filmimagedoel','".$_POST["Genre"]."','".$_POST["txtFilmomschrijving"]."','".$_POST["uitkomstdate"]."','".$_POST["BiosDate"]."','$draaidag','$tijddag','".$_POST["zaal"]."')";
if ($dbh->query($sql)) {
echo "Film toegevoegt!";
}
else{
echo "Er is iets misgegaan...";
}

$dbh = null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}

}
?>

</div>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

dongnanke4106 2018-06-03 18:40

关注

Here are the issues:

$_POST["BiosDate"] != name="Biosdate"
No $draaidag =
No $filmimagedoel =, this item also isn't present in the PDO HTML form.
No $tijddag =.

You aren't assigning in the PDO code like you did in the mysqli code. In additional the real benefit to using these drivers is there ability to use prepared statements and parameterized queries. I think this would be closer to what you want. You'll need to figure out what the $filmimagedoel is suppose to be:

if(isset($_POST["submit"])){
    $hostname='localhost';
    $username='root';
    $password='';
    try {
        $dbh = new PDO("mysql:host=$hostname;dbname=fastmovierenessefrank",$username,$password);
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
        $sql = "INSERT INTO films (film, movieimage, genre, Filmomschrijving, Datumvanuitkomst, Datumuitbioscoop, Filmdraaidagen, Filmtijddragen, Zaal)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $params = array($_POST["txtFilm"], $filmimagedoel, $_POST["Genre"], $_POST["txtFilmomschrijving"], $_POST["uitkomstdate"], $_POST["Biosdate"], implode(',', $_POST['draaidag']), implode(',', $_POST['tijddag']), $_POST["zaal"]);
        $sth = $dbh->prepare($sql);
        if ($sth->execute($params)) {
            echo "Film toegevoegt!";
        } else{
            echo "Er is iets misgegaan...";
        }
        $dbh = null;
    } catch(PDOException $e) {
        echo $e->getMessage();
    }
}

Additionally, storing delimited data in a DB is bad practice. You should only have one data value in a column.

报告相同问题？

关注问题

如何将此代码从mysqli更改为PDO php
2019-04-14 10:20

回答 1 已采纳 This is how you would do it: // Execute query and fetch a single cell from the result $total_reco
将PHP示例代码从mysqli转换为PDO html5 mysql php
2017-08-30 15:47

回答 1 已采纳 This is how you would do this query in PDO database connection: $host = 'localhost'; $db = '';
PHP-试图将Mysqli转换为PDO php
2016-12-22 15:39

回答 4 已采纳 That's a horrifically awful way to select data from a database. It's far more complex than is nece
php中pdo,PHP中PDO
2021-03-26 11:19

weixin_39917437的博客 PDO与mysqli曾经被建议用来取代原本PHP在用的mysql相关函数，基于数据库使用的安全性，因为后者欠缺对于SQL注入的防护。PHP 数据对象(PDO) 扩展为PHP访问数据库定义了一个轻量级的一致接口。实现 PDO 接口的每个...
用PHP将MySQLi转换为PDO？ mysql php
2015-03-04 19:31

回答 1 已采纳 Assuming $stmt is your connection parameter...then $query = $stmt->prepare("SELECT * FROM tabl
2006年从mysqli迁移到PDO的错误代码映射 php
2016-10-17 07:59

回答 1 已采纳 You can use the array of PDO::errorInfo. There you get an array like the following: Array ( [
将$ result更改为MySQLi或PDO PHP [复制] mysql php
2016-04-13 09:49

回答 3 已采纳 You are using mysql in place of mysqli, and mysqli needs connection with the query. Just Replace
php mysql 替换 pdo_php – 如何用PDO替换MySQL函数？
2021-01-27 04:51

weixin_39557199的博客其他人(包括我自己)的评论迫使提问者放弃MySQL功能并开始使用PDO或MySQLI.这篇文章是为了帮助.您可以参考它,因为它提供了对它们被弃用的原因和PDO的解释,以及实现PDO的最小代码示例.首先：从mysql函数到PDO的转换...
我如何将mysql脚本转换为mysqli或pdo？ [重复] mysql php sql
2015-07-10 04:16

回答 1 已采纳 First of all avoid using mysql_* these functions are deprecated, Your code is vulnrable to SQL Inj
PHP脚本从Mysqlnd转换为mysqli html php
2014-03-20 03:55

回答 1 已采纳 mysqli_stmt::get_result is only available in PHP >= 5.3.0. I suggest using bind_result instead
我想将Consolibyte PHP QuickBooks库与PDO一起使用 php
2018-09-24 19:13

回答 2 已采纳 Update: It turned out to be various PHP Errors when creating the PDO Objects. This may seem obviou
php pdo模仿mysql函数_php – 如何用PDO替换MySQL函数？
2021-03-16 23:55

TsingGuo 郭卿的博客其他人(包括我自己)的评论迫使提问者放弃MysqL功能并开始使用PDO或MysqLI.这篇文章是为了帮助.您可以参考它,因为它提供了对它们被弃用的原因和PDO的解释,以及实现PDO的最小代码示例.首先：从MysqL函数到PDO的转换...
从PDO转换为MySQLI php
2013-04-29 12:01

回答 2 已采纳 If you have in your mind to change hosting in future i suggest you to implement PDO interface by y
【云原生 | 38】Docker快速部署开源脚本语言PHP
2022-10-21 10:13

小鹏linux的博客 PHP（Hypertext Preprocessor，超文本预处理器）是一种通用的开源脚本语言。语法吸收了C、Java和Perl等语言的特点，利于学习，使用广泛，主要适用于Web开发领域。PHP执行效率比完全生成HTML标记的CGI 要高许多；PHP...
php pdo mysql 转移_php – 如何用PDO替换MySQL函数？
2021-01-19 07:11

张崇子的博客其他人(包括我自己)的评论迫使提问者放弃MySQL功能并开始使用PDO或MySQLI.这篇文章是为了帮助.您可以参考它,因为它提供了对它们被弃用的原因和PDO的解释,以及实现PDO的最小代码示例.首先：从mysql函数到PDO的转换...
PHP 开发与代码审计(总结)
2021-01-27 19:46

微软技术分享的博客笔者将学习PHP时的学习笔记分享出来，基本上是前面的那些博文的汇总，看起来更方便一些，笔者最近放弃了PHP代码审计部分，所以不再继续学下去了，由于精力实在达不到，只能选择一样进行发展，不想成为半瓶子醋，以后...
php deployer 从入门到精通
2022-08-27 17:46

azh89125的博客 php deployer 从入门到精通
PHP简介：设置 PHP 环境
2024-02-18 05:15

新华的博客设置 PHP 环境是运行动态 Web 应用程序的关键过程。它涉及选择和安装 Web 服务器，例如 Apache 和 PHP。配置步骤包括在 Web 服务器设置中启用 PHP 模块，以及通过相关扩展与 MySQL 等数据库建立连接。微调 php.ini ...
PHP复习资料
2023-05-23 18:22

okfang616的博客（未完待续，请持续关注此板块）【计科一二】PHP第一章练习题【计科一二】PHP第二章练习题【计科一二】PHP第三章练习题【计科一二】PHP第四章练习题【计科一二】PHP第五章练习题暂无【计科一二】PHP第六章练习题暂...
没有解决我的问题, 去提问

悬赏问题

¥15 聚类分析或者python进行数据分析
¥15 逻辑谓词和消解原理的运用
¥15 三菱伺服电机按启动按钮有使能但不动作
¥15 js，页面2返回页面1时定位进入的设备
¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
¥15 （希望可以解决问题）ma和mb文件无法正常打开，打开后是空白，但是有正常内存占用，但可以在打开Maya应用程序后打开场景ma和mb格式。
¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
¥20 腾讯企业邮箱邮件可以恢复么
¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗？
¥15 错误 LNK2001 无法解析的外部符号

码龄粉丝数原力等级 --

将PHP脚本从mysqli重写为pdo代码

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

将PHP脚本从mysqli重写为pdo代码

1条回答 默认 最新

悬赏问题

1条回答默认最新