如何使用 php 在 mysql 中存储多语言文本字段? [英] How store multiple language textfield in mysql with php?

问题描述

我正在尝试按语言保存多个文本字段，并且在保存时如果有任何语言的空文本字段，请忽略它，但由于某些错误，我的代码无法正常工作，当我单击提交时仅保存第一个文本字段

数据库

+----------+------------+---------------+|email_id |email_lang |电子邮件内容|+------------+------------+--------------+||||+------------+------------+--------------+

HTML

<输入类型=文本"value="";name="email_lang"><textarea type="text";值=1"name=email_content"><?php endforeach ?><按钮类型=提交"名称=保存">保存"</表单>

PHP

prepare(INSERT INTO emailtemplates (email_id,email_lang,email_content) VALUES (:email_id, :email_lang, :email_content)");$email_id = $_POST['email_id'];$email_lang = $_POST['email_lang'];$email_content = $_POST['email_content'];$句子->执行(数组(':email_id' =>$email_id,':email_lang' =>$email_lang,':email_content' =>$email_content));}$languages = ['en', 'fr', 'ru'];需要'../views/new.email.view.php';?>

预期结果

+----------+------------+---------+|email_id |email_lang |电子邮件内容|+------------+------------+-----------------+|1 |zh |英文内容||1 |fr |法语内容|+------------+------------+-----------------+

解决方案

HTML 部分

HTML 表单中的输入字段需要具有名称，以便您识别语言.在 HTML 中，您可以使用方括号创建字段名称.当 PHP 收到这些值时，它会将它们视为一个数组.您可以像这样定义 </code>:</p><pre class="lang-html Prettyprint-override"><code><textarea name="email_content[fr]"></code></pre><p>然后在 PHP 中，您可以使用以下语法访问该值:</p><pre class="lang-php prettyprint-override"><code>$french = $_POST['email_content']['fr'];</code></pre><p>注意事项:</p><ul><li>HTML <code><textarea></code> 没有 <code>type</code> 和 <code>value</code> 属性.</li><li>无需向 <code><input></code> 元素添加 <code>hidden</code> 属性，只需指定 <code>type=hidden"</code>.</li><li>在 HTML 中输出任何动态内容时，您应该注意<a href="https://stackoverflow.com/questions/1996122/how-to-prevent-xss-with-html-php">XSS 保护</a>.</li><li>您可以使用更短的语法 <code><?=$var ?></code></li> 而不是 <code><?php echo $var ?></code></ul><p>您的完整 HTML 表单可能如下所示:</p><pre><code><form action="<?=htmlspecialchars($_SERVER['PHP_SELF'])?>";方法=发布"><输入类型=隐藏"值=<?=$id?>"name="email_id"><?php foreach ($languages as $lang) : ?><textarea 值=1"name="email_content[<?=htmlspecialchars($lang)?>]";placeholder="<?=htmlspecialchars($lang)?>";value="<?=htmlspecialchars($lang)?>"></textarea><?php endforeach ?><按钮类型=提交"名称=保存">保存"</按钮></表单></code></pre><p>在 PHP 中收到表单后，您的 <code>$_POST</code> 应该包含如下内容:</p><pre><code>数组 ('email_id' =>'12','email_content' =>大批 ('en' =>'','fr' =>'法语文本','ru' =>'',),'保存' =>'',)</code></pre><p><h2>PHP 部分</h2><p>要使用 PDO 在 PHP 中保存多个值，您需要使用循环.在循环之前，您应该准备语句并绑定参数.<code>PDO_stmt::bind_param()</code> 很少使用，但在这种情况下它可以使您的代码更简洁.您还应该在事务内执行所有插入操作.</p><pre><code>$pdo->beginTransaction();$stmt = $pdo->prepare("INSERT INTO emailtemplates (email_id,email_lang,email_content)VALUES (:email_id, :email_lang, :email_content)");$stmt->bindParam('email_id', $_POST['email_id']);$stmt->bindParam('email_lang', $lang);$stmt->bindParam('email_content', $contents);foreach ($_POST['email_content'] as $lang => $contents) {if ($contents && in_array($lang, $languages, true)) {$stmt->execute();}}$pdo->commit();</code></pre><p>如果您希望使用更简单的语法，您可以使用 <code>PDO_stmt::execute()</code> 无需事先绑定即可传递参数.</p><pre><code>$pdo->beginTransaction();$stmt = $pdo->prepare("INSERT INTO emailtemplates (email_id,email_lang,email_content)VALUES (:email_id, :email_lang, :email_content)");foreach ($_POST['email_content'] as $lang => $contents) {if ($contents && in_array($lang, $languages, true)) {$stmt->执行(['email_id' =>$_POST['email_id'],'email_lang' =>$lang,'email_content' =>$内容，]);}}$pdo->commit();</code></pre><p>以下行检查是否提供了内容以及语言是否在您指定的语言数组中.</p><pre><code>if ($contents && in_array($lang, $languages, true)) {</code></pre><p><p>I am trying to save multiple textfield by language, and when saving if there is an empty textfield of any language, ignore it but for some error my code does not work correctly and when i click submit only save the first textfield</p> <p><strong>Database</strong></p><pre><code>+----------+------------+---------------+ | email_id | email_lang | email_content | +----------+------------+---------------+ | | | | +----------+------------+---------------+ </code></pre><p><strong>Html</strong></p><pre><code><form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post"> <input type="text" value="<?php echo $_GET['id']; ?>" name="email_id" hidden> <?php foreach ($languages as $lang): ?> <input type="text" value="<?php echo $lang ?>" name="email_lang"> <textarea type="text" value="1" name="email_content"></textarea> <?php endforeach ?> <button type="submit" name="save">Save</button> </form> </code></pre><p><strong>Php</strong></p><pre><code><?php if ($_SERVER['REQUEST_METHOD'] == 'POST'){ $sentence = $connect->prepare("INSERT INTO emailtemplates (email_id,email_lang,email_content) VALUES (:email_id, :email_lang, :email_content)"); $email_id = $_POST['email_id']; $email_lang = $_POST['email_lang']; $email_content = $_POST['email_content']; $sentence->execute(array( ':email_id' => $email_id, ':email_lang' => $email_lang, ':email_content' => $email_content )); } $languages = ['en', 'fr', 'ru']; require '../views/new.email.view.php'; ?> </code></pre><p>Expected results</p><pre><code>+----------+------------+-----------------+ | email_id | email_lang | email_content | +----------+------------+-----------------+ | 1 | en | english content | | 1 | fr | french content | +----------+------------+-----------------+ </code></pre><p> </p><div class="h2_lin"> 解决方案 </div><p><h2>HTML part</h2> <p>Your input fields in the HTML form need to have names which will allow you to identify the language. In HTML you can create field names with square brackets. When PHP receives these values it will treat them as an array. You can define a <code><textarea></code> like this:</p><pre class="lang-html prettyprint-override"><code><textarea name="email_content[fr]"> </code></pre><p>Then in PHP you can access the value using the following syntax:</p><pre class="lang-php prettyprint-override"><code>$french = $_POST['email_content']['fr']; </code></pre><p>Notes:</p> <ul> <li>HTML <code><textarea></code> doesn't have <code>type</code> nor <code>value</code> attributes.</li> <li>Instead of adding <code>hidden</code> attribute to the <code><input></code> elements, just specify the <code>type="hidden"</code>.</li> <li>When outputting any dynamic content within HTML you should take care of <a href="https://stackoverflow.com/questions/1996122/how-to-prevent-xss-with-html-php">XSS protection</a>.</li> <li>Instead of <code><?php echo $var ?></code> you can use the shorter syntax <code><?=$var ?></code></li> </ul> <p>Your complete HTML form might then look something like this:</p><pre><code><form action="<?=htmlspecialchars($_SERVER['PHP_SELF'])?>" method="post"> <input type="hidden" value="<?=$id?>" name="email_id"> <?php foreach ($languages as $lang) : ?> <textarea value="1" name="email_content[<?=htmlspecialchars($lang)?>]" placeholder="<?=htmlspecialchars($lang)?>" value="<?=htmlspecialchars($lang)?>"></textarea> <?php endforeach ?> <button type="submit" name="save">Save</button> </form> </code></pre><p>Once the form is received in PHP your <code>$_POST</code> should contain something like this:</p><pre><code>array ( 'email_id' => '12', 'email_content' => array ( 'en' => '', 'fr' => 'French text', 'ru' => '', ), 'save' => '', ) </code></pre><p> <h2>PHP part</h2> <p>To save multiple values in PHP using PDO you need to use a loop. Before the loop, you should prepare the statement and bind parameters. <code>PDO_stmt::bind_param()</code> is rarely used, but in this situation it can make your code cleaner. You should also perform all inserts inside of a transaction.</p><pre><code>$pdo->beginTransaction(); $stmt = $pdo->prepare("INSERT INTO emailtemplates (email_id,email_lang,email_content) VALUES (:email_id, :email_lang, :email_content)"); $stmt->bindParam('email_id', $_POST['email_id']); $stmt->bindParam('email_lang', $lang); $stmt->bindParam('email_content', $contents); foreach ($_POST['email_content'] as $lang => $contents) { if ($contents && in_array($lang, $languages, true)) { $stmt->execute(); } } $pdo->commit(); </code></pre><p>If you wish to use the simpler syntax you can use <code>PDO_stmt::execute()</code> to pass the parameters without prior binding.</p><pre><code>$pdo->beginTransaction(); $stmt = $pdo->prepare("INSERT INTO emailtemplates (email_id,email_lang,email_content) VALUES (:email_id, :email_lang, :email_content)"); foreach ($_POST['email_content'] as $lang => $contents) { if ($contents && in_array($lang, $languages, true)) { $stmt->execute([ 'email_id' => $_POST['email_id'], 'email_lang' => $lang, 'email_content' => $contents, ]); } } $pdo->commit(); </code></pre><p>The following line checks if contents were provided and language is in the array of languages you specified.</p><pre><code>if ($contents && in_array($lang, $languages, true)) { </code></pre><p> <p>这篇关于如何使用 php 在 mysql 中存储多语言文本字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！</p> </div> <div class="arc-body-main-more"> <span onclick="unlockarc('2307994');">查看全文</span> </div> </div> <div> </div> <div class="wwads-cn wwads-horizontal" data-id="166" style="max-width:100%;border: 4px solid #666;"></div> </div> </article> <div id="arc-ad-2" class="mb-1"> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-5038752844014834" crossorigin="anonymous"></script> <ins class="adsbygoogle" style="display:block" data-ad-format="autorelaxed" data-ad-client="ca-pub-5038752844014834" data-ad-slot="3921941283"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> <div class="widget bgwhite radius-1 mb-1 shadow widget-rel"> <h5>相关文章</h5> <ul> <li> <a target="_blank" title="PHP多语言-如何切换语言?" href="/1649721.html"> PHP多语言-如何切换语言?; </a> </li> <li> <a target="_blank" title="多语言存储过程" href="/1433018.html"> 多语言存储过程; </a> </li> <li> <a target="_blank" title="PHP多语言站点" href="/1649806.html"> PHP多语言站点; </a> </li> <li> <a target="_blank" title="PHP:多语言问题" href="/2306344.html"> PHP:多语言问题; </a> </li> <li> <a target="_blank" title="多语言php脚本" href="/1649744.html"> 多语言php脚本; </a> </li> <li> <a target="_blank" title="使用PIL绘制多语言文本" href="/769012.html"> 使用PIL绘制多语言文本; </a> </li> <li> <a target="_blank" title="PHP中多语言的实现" href="/2306346.html"> PHP中多语言的实现; </a> </li> <li> <a target="_blank" title="PHP-多语言网站" href="/1425093.html"> PHP-多语言网站; </a> </li> <li> <a target="_blank" title="限制输入字段的多语言" href="/1106845.html"> 限制输入字段的多语言; </a> </li> <li> <a target="_blank" title="如何在php中编写多语言代码?" href="/1744694.html"> 如何在php中编写多语言代码?; </a> </li> <li> <a target="_blank" title="翻译PHP日期（）多语言网站" href="/610919.html"> 翻译PHP日期（）多语言网站; </a> </li> <li> <a target="_blank" title="在PHP中实现多语言的最佳方法" href="/1649733.html"> 在PHP中实现多语言的最佳方法; </a> </li> <li> <a target="_blank" title="多语言用法" href="/1345911.html"> 多语言用法; </a> </li> <li> <a target="_blank" title="多语言问题" href="/637046.html"> 多语言问题; </a> </li> <li> <a target="_blank" title="多语言HTML" href="/1342965.html"> 多语言HTML; </a> </li> <li> <a target="_blank" title="VC多语言" href="/1463262.html"> VC多语言; </a> </li> <li> <a target="_blank" title="多语言程序" href="/1408449.html"> 多语言程序; </a> </li> <li> <a target="_blank" title="多语言应用" href="/1440405.html"> 多语言应用; </a> </li> <li> <a target="_blank" title="多语言选项" href="/1388491.html"> 多语言选项; </a> </li> <li> <a target="_blank" title="多语言网站" href="/1651.html"> 多语言网站; </a> </li> <li> <a target="_blank" title="多语言网站" href="/1243331.html"> 多语言网站; </a> </li> <li> <a target="_blank" title="多语言安装" href="/2275391.html"> 多语言安装; </a> </li> <li> <a target="_blank" title="任何开发多语言网站的想法 - SEO，php，mysql" href="/602234.html"> 任何开发多语言网站的想法 - SEO，php，mysql; </a> </li> <li> <a target="_blank" title="从多语言Unicode文本中删除Emoji；" href="/2903976.html"> 从多语言Unicode文本中删除Emoji；; </a> </li> <li> <a target="_blank" title="如何（正确）在Qt-Embedded中输出多语言文本？" href="/769222.html"> 如何（正确）在Qt-Embedded中输出多语言文本？; </a> </li> </ul> </div> <div class="mb-1"> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-5038752844014834" crossorigin="anonymous"></script> <ins class="adsbygoogle" style="display:block" data-ad-format="autorelaxed" data-ad-client="ca-pub-5038752844014834" data-ad-slot="3921941283"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> <div class="side"> <div class="widget widget-side bgwhite mb-1 shadow"> <h5>PHP最新文章</h5> <ul> <li> <a target="_blank" title="请求头字段Access-Control-Allow-Headers在预检响应中不允许Access-Control-Allow-Headers" href="/558143.html"> 请求头字段Access-Control-Allow-Headers在预检响应中不允许Access-Control-Allow-Headers; </a> </li> <li> <a target="_blank" title="路由问题导致Symfony \ Component \ HttpKernel \ Exception \ NotFoundHttpException错误" href="/548154.html"> 路由问题导致Symfony \ Component \ HttpKernel \ Exception \ NotFoundHttpException错误; </a> </li> <li> <a target="_blank" title="什么是NCFB和NOFB模式？" href="/681571.html"> 什么是NCFB和NOFB模式？; </a> </li> <li> <a target="_blank" title="警告：mysqli_connect（）：（HY000 / 1045）：访问被拒绝用户'用户名'@'localhost'（使用密码：是）" href="/594668.html"> 警告：mysqli_connect（）：（HY000 / 1045）：访问被拒绝用户'用户名'@'localhost'（使用密码：是）; </a> </li> <li> <a target="_blank" title="如何处理致命错误：cURL错误7：无法连接到xxxx端口443" href="/589688.html"> 如何处理致命错误：cURL错误7：无法连接到xxxx端口443; </a> </li> <li> <a target="_blank" title="参数3传递给GuzzleHttp\Client :: request（）必须是数组类型，给定字符串" href="/748988.html"> 参数3传递给GuzzleHttp\Client :: request（）必须是数组类型，给定字符串; </a> </li> <li> <a target="_blank" title="phpMyAdmin的＃2054无法登录到MySQL服务器" href="/218086.html"> phpMyAdmin的＃2054无法登录到MySQL服务器; </a> </li> <li> <a target="_blank" title="SSL错误SSL3_GET_SERVER_CERTIFICATE：证书验证失败" href="/215284.html"> SSL错误SSL3_GET_SERVER_CERTIFICATE：证书验证失败; </a> </li> <li> <a target="_blank" title="在PHPExcel中设置字体颜色，字体和字体大小" href="/511258.html"> 在PHPExcel中设置字体颜色，字体和字体大小; </a> </li> <li> <a target="_blank" title="如何解决cURL错误（7）：无法连接到主机？" href="/588378.html"> 如何解决cURL错误（7）：无法连接到主机？; </a> </li> </ul> </div> <div class="widget widget-side bgwhite mb-1 shadow"> <h5> 热门教程 </h5> <ul> <li> <a target="_blank" title="Java教程" href="/OnLineTutorial/java/index.html"> Java教程 </a> </li> <li> <a target="_blank" title="Apache ANT 教程" href="/OnLineTutorial/ant/index.html"> Apache ANT 教程 </a> </li> <li> <a target="_blank" title="Kali Linux教程" href="/OnLineTutorial/kali_linux/index.html"> Kali Linux教程 </a> </li> <li> <a target="_blank" title="JavaScript教程" href="/OnLineTutorial/javascript/index.html"> JavaScript教程 </a> </li> <li> <a target="_blank" title="JavaFx教程" href="/OnLineTutorial/javafx/index.html"> JavaFx教程 </a> </li> <li> <a target="_blank" title="MFC 教程" href="/OnLineTutorial/mfc/index.html"> MFC 教程 </a> </li> <li> <a target="_blank" title="Apache HTTP客户端教程" href="/OnLineTutorial/apache_httpclient/index.html"> Apache HTTP客户端教程 </a> </li> <li> <a target="_blank" title="Microsoft Visio 教程" href="/OnLineTutorial/microsoft_visio/index.html"> Microsoft Visio 教程 </a> </li> </ul> </div> <div class="widget widget-side bgwhite mb-1 shadow"> <h5> 热门工具 </h5> <ul> <li> <a target="_blank" title="Java 在线工具" href="/Onlinetools/details/4"> Java 在线工具 </a> </li> <li> <a target="_blank" title="C(GCC) 在线工具" href="/Onlinetools/details/6"> C(GCC) 在线工具 </a> </li> <li> <a target="_blank" title="PHP 在线工具" href="/Onlinetools/details/8"> PHP 在线工具 </a> </li> <li> <a target="_blank" title="C# 在线工具" href="/Onlinetools/details/1"> C# 在线工具 </a> </li> <li> <a target="_blank" title="Python 在线工具" href="/Onlinetools/details/5"> Python 在线工具 </a> </li> <li> <a target="_blank" title="MySQL 在线工具" href="/Onlinetools/Dbdetails/33"> MySQL 在线工具 </a> </li> <li> <a target="_blank" title="VB.NET 在线工具" href="/Onlinetools/details/2"> VB.NET 在线工具 </a> </li> <li> <a target="_blank" title="Lua 在线工具" href="/Onlinetools/details/14"> Lua 在线工具 </a> </li> <li> <a target="_blank" title="Oracle 在线工具" href="/Onlinetools/Dbdetails/35"> Oracle 在线工具 </a> </li> <li> <a target="_blank" title="C++(GCC) 在线工具" href="/Onlinetools/details/7"> C++(GCC) 在线工具 </a> </li> <li> <a target="_blank" title="Go 在线工具" href="/Onlinetools/details/20"> Go 在线工具 </a> </li> <li> <a target="_blank" title="Fortran 在线工具" href="/Onlinetools/details/45"> Fortran 在线工具 </a> </li> </ul> </div> </div> </div> <script type="text/javascript">var eskeys = '如何,使用,php,在,mysql,中,存储,多语言,文本,字段'; var cat = 'cc';';//php</script> </div> <div id="pop" onclick="pophide();"> <div id="pop_body" onclick="event.stopPropagation();"> <h6 class="flex flex101"> 登录 <span onclick="pophide();">关闭</span> </h6> <div class="pd-1"> <div class="wxtip center"> <span>扫码关注<em>1秒</em>登录</span> </div> <div class="center"> <img id="qr" src="https://huajiakeji.com/Content/Images/qrydx.jpg" alt="" style="width:150px;height:150px;" /> </div> <div style="margin-top:10px;display:flex;justify-content: center;"> <input type="text" placeholder="输入验证码" id="txtcode" autocomplete="off" /> <input id="btngo" type="button" onclick="chk()" value="GO" /> </div> <div class="center" style="margin: 4px; font-size: .8rem; color: #f60;"> 发送“验证码”获取 <em style="padding: 0 .5rem;">|</em> <span style="color: #01a05c;">15天全站免登陆</span> </div> <div id="chkinfo" class="tip"></div> </div> </div> </div> <script type="text/javascript" src="https://lib.sinaapp.com/js/jquery/1.9.1/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="https://cdn.bootcss.com/jquery-cookie/1.4.1/jquery.cookie.min.js"></script> <script type="text/javascript" src="https://img01.yuandaxia.cn/Scripts/highlight.min.js"></script> <script type="text/javascript" src="https://img01.yuandaxia.cn/Scripts/base.js?v=0.22"></script> <script type="text/javascript" src="https://img01.yuandaxia.cn/Scripts/tui.js?v=0.11"></script> <footer class="footer"> <div class="container"> <div class="flink mb-1"> 友情链接： <a href="https://www.it1352.com/" target="_blank">IT屋</a> <a href="https://huajiakeji.com/" target="_blank">Chrome插件</a> <a href="https://www.cnplugins.com/" target="_blank">谷歌浏览器插件</a> </div> <section class="copyright-section"> <a href="https://www.it1352.com" title="IT屋-程序员软件开发技术分享社区">IT屋</a> ©2016-2022 <a href="http://www.beian.miit.gov.cn/" target="_blank">琼ICP备2021000895号-1</a> <a href="/sitemap.html" target="_blank" title="站点地图">站点地图</a> <a href="/Home/Tags" target="_blank" title="站点标签">站点标签</a> <a target="_blank" alt="sitemap" href="/sitemap.xml">SiteMap</a> <a href="/1155981.html" title="IT屋-免责申明"><免责申明></a> 本站内容来源互联网,如果侵犯您的权益请联系我们删除. </section> <!--统计代码--> <script type="text/javascript"> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?0c3a090f7b3c4ad458ac1296cb5cc779"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script> <script type="text/javascript"> (function () { var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </div> </footer> </body> </html>