php– 将textarea中的文本插入MySQL数据库而不会丢失格式

概述我正在尝试将我站点上的textarea中的文本添加到MySQL数据库中.下面是将文本添加到数据库的PHP代码.if (isset($_POST['text'])) { $text = sanitizeString($_POST['text']); $text = preg_replace('/\s\s+/', ' ', $text);

我正在尝试将我站点上的textarea中的文本添加到MySQL数据库中.

下面是将文本添加到数据库的PHP代码.

if (isset($_POST['text'])){    $text = sanitizeString($_POST['text']);    $text = preg_replace('/\s\s+/',' ',$text);    $query = "SELECT * FROM profiles WHERE user='$user'";    if (MysqL_num_rows(queryMysqL($query)))    {        queryMysqL("UPDATE profiles SET text='$text' where user='$user'");    }    else    {        $query = "INSERT INTO profiles VALUES('$user','$text')";        queryMysqL($query);    }}else{    $query  = "SELECT * FROM profiles WHERE user='$user'";    $result = queryMysqL($query);    if (MysqL_num_rows($result))    {        $row  = MysqL_fetch_row($result);        $text = stripslashes($row[1]);    }    else $text = "";}$text = stripslashes(preg_replace('/\s\s+/',$text));

以下是表单的代码.

</pre><p>但是当输入数据时,它会在数据库中显示正确但未显示正确显示的数据.见下图：</p><p>输入的文本</p><p>文本在页面上的显示方式</p><p>文本在数据库中的方式</p><p>这是在代码页上显示文本的PHP代码.</p><p></p><pre><code>$result = queryMysqL("SELECT * FROM profiles WHERE user='$user'");    if (MysqL_num_rows($result))    {        $row = MysqL_fetch_row($result);        echo stripslashes($row[1]) . "<br clear=left /><br /></code></pre><p>希望你能帮忙！</p><p>编辑：添加额外的PHP代码</p>最佳答案您的文本,除非您使用的是富文本编辑器,例如Mark-down(如Stackoverflow),它由您的CSS设置样式,而不是由textarea本身的内容设置.</p><p>如果问题是保留换行,那么您可以在存储或从数据库检索之前通过<code>nl2br($text)</code>函数运行该字符串.</p><p>我建议检索会更好,但这只是我的意见(我不能提供任何证据来支持它).</p>          总结       <p>以上是内存溢出为你收集整理的php  – 将textarea中的文本<strong class="superseo"><a href="/tag/17040.html" class="superseo">插入</a></strong>MySQL数据库而不会丢失格式全部内容，希望文章能够帮你解决php  – 将textarea中的文本插入MySQL数据库而不会丢失格式所遇到的程序开发问题。</p><p>如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。</p>					
										


					<div class="entry-copyright">
						<p>欢迎分享，转载请注明来源：<a href="http://outofmemory.cn" title="内存溢出">内存溢出</a></p><p>原文地址: <a href="http://outofmemory.cn/sjk/1168089.html" title="php– 将textarea中的文本插入MySQL数据库而不会丢失格式">http://outofmemory.cn/sjk/1168089.html</a></p>
					</div>
				</div>
								<div class="entry-tag">
										<a href="/tag/17040.html" rel="tag">插入</a>
										<a href="/tag/16704.html" rel="tag">文本</a>
										<a href="/tag/104.html" rel="tag">数据库</a>
										<a href="/tag/16725.html" rel="tag">格式</a>
										<a href="/tag/20771.html" rel="tag">丢失</a>
									</div>
								<div class="entry-action">
					<a id="thread-like" class="btn-zan" href="javascript:;" tid="1168089">
						<i class="wpcom-icon wi">
							<svg aria-hidden="true">
								<use xlink:href="#wi-thumb-up-fill"></use>
							</svg>
						</i> 赞
						<span class="entry-action-num">(0)</span>
					</a>
					<div class="btn-dashang">
						<i class="wpcom-icon wi">
							<svg aria-hidden="true">
								<use xlink:href="#wi-cny-circle-fill"></use>
							</svg></i> 打赏
						<span class="dashang-img dashang-img2">
							<span>
								<img src="/view/img/theme/weipay.png" alt="微信扫一扫" /> 微信扫一扫
							</span>
							<span>
								<img src="/view/img/theme/alipay.png" alt="支付宝扫一扫" /> 支付宝扫一扫
							</span>
						</span>
					</div>
				</div>
				<div class="entry-bar">
					<div class="entry-bar-inner clearfix">
						<div class="author pull-left">
							<a data-user="86179" target="_blank" href="/user/86179.html" class="avatar j-user-card">
								<img alt="传奇网站模板" src="/view/img/avatar.png" class="avatar avatar-60 photo" height="60" width="60" />
								<span class="author-name">传奇网站模板</span>
								<span class="user-group">一级用户组</span>
							</a>
						</div>
						<div class="info pull-right">
							<div class="info-item meta">
								<a class="meta-item j-heart" id="favorites" rel="nofollow" tid="1168089" href="javascript:void(0);" title="自己的内容还要收藏吗？" aria-label="自己的内容还要收藏吗？">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-star"></use></svg>
									</i>
									<span class="data">0</span>
								</a>
								<a class="meta-item" href="#comments">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-comment"></use></svg>
									</i>
									<span class="data">0</span>
								</a>
							</div>
							<div class="info-item share">
								<a class="meta-item mobile j-mobile-share22" a href="javascript:;" data-event="poster-popover">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-share"></use></svg>
									</i>
									生成海报
								</a>
								<a class="meta-item wechat" data-share="wechat" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-wechat"></use></svg>
									</i>
								</a>
								<a class="meta-item weibo" data-share="weibo" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-weibo"></use></svg>
									</i>
								</a>
								<a class="meta-item qq" data-share="qq" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-qq"></use></svg>
									</i>
								</a>
								<a class="meta-item qzone" data-share="qzone" target="_blank" rel="nofollow" href="#">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-qzone"></use></svg>
									</i>
								</a>
							</div>
							<div class="info-item act">
								<a href="javascript:;" id="j-reading">
									<i class="wpcom-icon wi">
										<svg aria-hidden="true"><use xlink:href="#wi-article"></use></svg>
									</i>
								</a>
							</div>
						</div>
					</div>
				</div>
			</div>
			<!--尾部广告-->
            <div class="wrap">
            	<script src="https://v.2lian.com/static/s/tubiao.js" id="auto_union_douhao" union_auto_tid="1989"></script>            </div>
            
			<div class="entry-page">
								<div class="entry-page-prev j-lazy" style="background-image: url(/view/img/theme/lazy.png);" data-original="/aiimages/mysql%E5%AF%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%95%B0%E9%87%8F%E6%9C%89%E4%BB%BB%E4%BD%95%E9%99%90%E5%88%B6.png">
					<a href="/sjk/1168087.html" title="mysql对数据库的数量有任何限制" rel="prev">
						<span>mysql对数据库的数量有任何限制</span>
					</a>
					<div class="entry-page-info">
         				<span class="pull-left">
							<i class="wpcom-icon wi">
								<svg aria-hidden="true"><use xlink:href="#wi-arrow-left-double"></use></svg>
							</i> 上一篇
						</span>
						<span class="pull-right">2022-06-01</span>
					</div>
				</div>
												<div class="entry-page-next j-lazy" style="background-image: url(/view/img/theme/lazy.png);" data-original="/aiimages/%E6%89%A7%E8%A1%8Ccount%28%29%E8%AE%A1%E7%AE%97%E4%BC%9A%E5%87%8F%E6%85%A2%E6%88%91%E7%9A%84mysql%E6%9F%A5%E8%AF%A2%E5%90%97%EF%BC%9F.png">
					<a href="/sjk/1168091.html" title="执行count()计算会减慢我的mysql查询吗？" rel="next">
						<span>执行count()计算会减慢我的mysql查询吗？</span>
					</a>
					<div class="entry-page-info">
         				<span class="pull-right">
							下一篇 <i class="wpcom-icon wi">
           						<svg aria-hidden="true"><use xlink:href="#wi-arrow-right-double"></use></svg>
							</i>
						</span>
						<span class="pull-left">2022-06-01</span>
					</div>
				</div>
							</div>

			
			<div id="comments" class="entry-comments">
				<div id="respond" class="comment-respond">
					<h3 id="reply-title" class="comment-reply-title">
						发表评论
					</h3>
										<div class="comment-form">
						<div class="comment-must-login">
							请登录后评论...
						</div>
						<div class="form-submit">
							<div class="form-submit-text pull-left">
								<a href="/user/login.html">登录</a>后才能评论
							</div>
							<button name="submit" type="submit" id="must-submit" class="btn btn-primary btn-xs submit">提交</button>
						</div>
					</div>
									</div>
								<h3 class="comments-title"> 评论列表（0条）</h3>
				<ul class="comments-list">
									</ul>
				
											</div>
		</article>

	</main>

	<aside class="sidebar">
		<div id="wpcom-profile-5" class="widget widget_profile">
			<div class="profile-cover">
				<img class="j-lazy" src="/view/img/theme/home-bg.jpg" alt="传奇网站模板" />
			</div>
			<div class="avatar-wrap">
				<a target="_blank" href="/user/86179.html" class="avatar-link">
					<img alt="传奇网站模板" src="/view/img/avatar.png" class="avatar avatar-120 photo" height="120" width="120" />
				</a>
			</div>
			<div class="profile-info">
				<a target="_blank" href="/user/86179.html" class="profile-name">
					<span class="author-name">传奇网站模板</span>
					<span class="user-group">一级用户组</span>
				</a>
				<!--<p class="author-description">Enjoy coding, enjoy life!</p>-->
				<div class="profile-stats">
					<div class="profile-stats-inner">
						<div class="user-stats-item">
							<b>220</b>
							<span>文章</span>
						</div>
						<div class="user-stats-item">
							<b>0</b>
							<span>评论</span>
						</div>
												<div class="user-stats-item">
							<b>0</b>
							<span>问题</span>
						</div>
						<div class="user-stats-item">
							<b>0</b>
							<span>回答</span>
						</div>
												<!--<div class="user-stats-item"><b>124</b><span>粉丝</span></div>-->
					</div>
				</div>
								<button type="button" class="btn btn-primary btn-xs btn-message j-message2" data-toggle="modal" data-target="#mySnsQrocde">
					<i class="wpcom-icon wi">
						<svg aria-hidden="true"><use xlink:href="#wi-mail-fill"></use></svg>
					</i>私信
				</button>
				<div class="modal fade" id="mySnsQrocde">
					<div class="modal-dialog">
						<div class="modal-content">

							<!-- 模态框头部 -->
							<!--<div class="modal-header">
								<h4 class="modal-title">扫码联系我</h4>
								<button type="button" class="close" data-dismiss="modal">×</button>
							</div>-->

							<!-- 模态框主体 -->
							<div class="modal-body" style="text-align: center">
								<img src="/upload/sns_qrcode/86179.png" style="width: 300px">
							</div>

						</div>
					</div>
				</div>
			</div>

						<div class="profile-posts">
				<h3 class="widget-title"><span>最近文章</span></h3>
				<ul>
										<li>
						<a href="/zaji/5827497.html" title="象数的基本解释">
							象数的基本解释						</a>
					</li>
										<li>
						<a href="/bake/5768584.html" title="啤酒保质期是多少">
							啤酒保质期是多少						</a>
					</li>
										<li>
						<a href="/bake/5763530.html" title="黄瓜种植中的“怨种”">
							黄瓜种植中的“怨种”						</a>
					</li>
										<li>
						<a href="/bake/5746911.html" title="在家自己如何制作火锅 在家自己怎样制作火锅">
							在家自己如何制作火锅 在家自己怎样制作火锅						</a>
					</li>
										<li>
						<a href="/bake/5742246.html" title="船员是做什么工作的 船员是做啥工作的">
							船员是做什么工作的 船员是做啥工作的						</a>
					</li>
									</ul>
			</div>
					</div>
				<div id="wpcom-post-thumb-5" class="widget widget_post_thumb">
			<h3 class="widget-title"><span>相关文章</span></h3>
						<ul>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/589557.html" title="sql按照中文拼音排序">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="sql按照中文拼音排序"  data-original="/aiimages/sql%E6%8C%89%E7%85%A7%E4%B8%AD%E6%96%87%E6%8B%BC%E9%9F%B3%E6%8E%92%E5%BA%8F.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/589557.html" title="sql按照中文拼音排序">
								sql按照中文拼音排序							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/589400.html" title="css3卡片阴影效果">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="css3卡片阴影效果"  data-original="/aiimages/css3%E5%8D%A1%E7%89%87%E9%98%B4%E5%BD%B1%E6%95%88%E6%9E%9C.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/589400.html" title="css3卡片阴影效果">
								css3卡片阴影效果							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/589222.html" title="Go语言 map的实现">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="Go语言 map的实现"  data-original="/aiimages/Go%E8%AF%AD%E8%A8%80+map%E7%9A%84%E5%AE%9E%E7%8E%B0.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/589222.html" title="Go语言 map的实现">
								Go语言 map的实现							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/589167.html" title="sublime快捷键">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="sublime快捷键"  data-original="/aiimages/sublime%E5%BF%AB%E6%8D%B7%E9%94%AE.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/589167.html" title="sublime快捷键">
								sublime快捷键							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/588897.html" title="看过这篇剖析，你还不懂 Go sync.Map 吗？">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="看过这篇剖析，你还不懂 Go sync.Map 吗？"  data-original="/aiimages/%E7%9C%8B%E8%BF%87%E8%BF%99%E7%AF%87%E5%89%96%E6%9E%90%EF%BC%8C%E4%BD%A0%E8%BF%98%E4%B8%8D%E6%87%82+Go+sync.Map+%E5%90%97%EF%BC%9F.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/588897.html" title="看过这篇剖析，你还不懂 Go sync.Map 吗？">
								看过这篇剖析，你还不懂 Go sync.Map 吗？							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/588339.html" title="java队列">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="java队列"  data-original="/aiimages/java%E9%98%9F%E5%88%97.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/588339.html" title="java队列">
								java队列							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/588263.html" title="Python获取股票历史、实时数据与更新到数据库">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="Python获取股票历史、实时数据与更新到数据库"  data-original="/aiimages/Python%E8%8E%B7%E5%8F%96%E8%82%A1%E7%A5%A8%E5%8E%86%E5%8F%B2%E3%80%81%E5%AE%9E%E6%97%B6%E6%95%B0%E6%8D%AE%E4%B8%8E%E6%9B%B4%E6%96%B0%E5%88%B0%E6%95%B0%E6%8D%AE%E5%BA%93.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/588263.html" title="Python获取股票历史、实时数据与更新到数据库">
								Python获取股票历史、实时数据与更新到数据库							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587924.html" title="css伪元素选择器">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="css伪元素选择器"  data-original="/aiimages/css%E4%BC%AA%E5%85%83%E7%B4%A0%E9%80%89%E6%8B%A9%E5%99%A8.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587924.html" title="css伪元素选择器">
								css伪元素选择器							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587860.html" title="简单java采集程序一">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="简单java采集程序一"  data-original="/aiimages/%E7%AE%80%E5%8D%95java%E9%87%87%E9%9B%86%E7%A8%8B%E5%BA%8F%E4%B8%80.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587860.html" title="简单java采集程序一">
								简单java采集程序一							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587613.html" title="pyquery 学习">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="pyquery 学习"  data-original="/aiimages/pyquery+%E5%AD%A6%E4%B9%A0.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587613.html" title="pyquery 学习">
								pyquery 学习							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587592.html" title="uchome 常用函数示例">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="uchome 常用函数示例"  data-original="/aiimages/uchome+%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B0%E7%A4%BA%E4%BE%8B.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587592.html" title="uchome 常用函数示例">
								uchome 常用函数示例							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587589.html" title="excel中的TEXT函数">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="excel中的TEXT函数"  data-original="/aiimages/excel%E4%B8%AD%E7%9A%84TEXT%E5%87%BD%E6%95%B0.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587589.html" title="excel中的TEXT函数">
								excel中的TEXT函数							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587582.html" title="prompt">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="prompt"  data-original="/aiimages/prompt.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587582.html" title="prompt">
								prompt							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587566.html" title="scroll滚动条样式修改">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="scroll滚动条样式修改"  data-original="/aiimages/scroll%E6%BB%9A%E5%8A%A8%E6%9D%A1%E6%A0%B7%E5%BC%8F%E4%BF%AE%E6%94%B9.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587566.html" title="scroll滚动条样式修改">
								scroll滚动条样式修改							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587492.html" title="ArcMap 标注、注记、图形文本">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="ArcMap 标注、注记、图形文本"  data-original="/aiimages/ArcMap+%E6%A0%87%E6%B3%A8%E3%80%81%E6%B3%A8%E8%AE%B0%E3%80%81%E5%9B%BE%E5%BD%A2%E6%96%87%E6%9C%AC.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587492.html" title="ArcMap 标注、注记、图形文本">
								ArcMap 标注、注记、图形文本							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587389.html" title="word 的使用 —— 分页符与分节符">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="word 的使用 —— 分页符与分节符"  data-original="/aiimages/word+%E7%9A%84%E4%BD%BF%E7%94%A8+%E2%80%94%E2%80%94+%E5%88%86%E9%A1%B5%E7%AC%A6%E4%B8%8E%E5%88%86%E8%8A%82%E7%AC%A6.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587389.html" title="word 的使用 —— 分页符与分节符">
								word 的使用 —— 分页符与分节符							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587376.html" title="STOMP">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="STOMP"  data-original="/aiimages/STOMP.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587376.html" title="STOMP">
								STOMP							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587335.html" title="旭日图（sunburst chart）绘制：R语言 &amp; excel">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="旭日图（sunburst chart）绘制：R语言 &amp; excel"  data-original="/aiimages/%E6%97%AD%E6%97%A5%E5%9B%BE%EF%BC%88sunburst+chart%EF%BC%89%E7%BB%98%E5%88%B6%EF%BC%9AR%E8%AF%AD%E8%A8%80+%26amp%3Bamp%3B+excel.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587335.html" title="旭日图（sunburst chart）绘制：R语言 &amp; excel">
								旭日图（sunburst chart）绘制：R语言 &amp; excel							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587123.html" title="1、HTML学习 - IT软件人员学习系列文章">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="1、HTML学习 - IT软件人员学习系列文章"  data-original="/aiimages/1%E3%80%81HTML%E5%AD%A6%E4%B9%A0+-+IT%E8%BD%AF%E4%BB%B6%E4%BA%BA%E5%91%98%E5%AD%A6%E4%B9%A0%E7%B3%BB%E5%88%97%E6%96%87%E7%AB%A0.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587123.html" title="1、HTML学习 - IT软件人员学习系列文章">
								1、HTML学习 - IT软件人员学习系列文章							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
								<li class="item">
					<div class="item-img">
						<a class="item-img-inner" href="/zaji/587072.html" title="LDA主题模型评估方法–Perplexity">
							<img width="480" height="300" src="/view/img/theme/lazy.png" class="attachment-default size-default wp-post-image j-lazy" alt="LDA主题模型评估方法–Perplexity"  data-original="/aiimages/LDA%E4%B8%BB%E9%A2%98%E6%A8%A1%E5%9E%8B%E8%AF%84%E4%BC%B0%E6%96%B9%E6%B3%95%E2%80%93Perplexity.png" />
						</a>
					</div>
					<div class="item-content">
						<p class="item-title">
							<a href="/zaji/587072.html" title="LDA主题模型评估方法–Perplexity">
								LDA主题模型评估方法–Perplexity							</a>
						</p>
						<p class="item-date">2022-4-12</p>
					</div>
				</li>
							</ul>
					</div>
		
		<div class="widget widget_post_thumb">
									<h3 class="widget-title"><span>随机标签</span></h3>
			<div class="entry-tag">
				<!-- 循环输出 tag 开始 -->
																																																																																																																																																																												<a href="/tag/605683.html" rel="tag">膳房</a>
		        																																																																																																																																																																																																								<a href="/tag/605634.html" rel="tag">acg</a>
		        																																																																																																																																																																																																												<a href="/tag/605584.html" rel="tag">奇侠传</a>
		        																																																																																																																																																																				<a href="/tag/605544.html" rel="tag">Sheet1Cells</a>
		        																				<a href="/tag/605540.html" rel="tag">向明</a>
		        																																																																																																																																																																																												<a href="/tag/605494.html" rel="tag">保护生态环境</a>
		        																																																																																																																																				<a href="/tag/605462.html" rel="tag">刘某</a>
		        																																																																																																												<a href="/tag/605436.html" rel="tag">千年之恋</a>
		        																																																																								<a href="/tag/605419.html" rel="tag">帕特森</a>
		        												<a href="/tag/605417.html" rel="tag">酒店设备</a>
		        																																<a href="/tag/605410.html" rel="tag">幼儿园教学</a>
		        																																																																<a href="/tag/605395.html" rel="tag">练歌房</a>
		        								<a href="/tag/605394.html" rel="tag">何塞</a>
		        																																																																<a href="/tag/605379.html" rel="tag">考试办公室</a>
		        																																																																																												<a href="/tag/605357.html" rel="tag">布拉斯</a>
		        																																																																																																				<a href="/tag/605333.html" rel="tag">国际大酒店</a>
		        																																																																																																																																												<a href="/tag/605299.html" rel="tag">洗手盆</a>
		        																																																																																																																																												<a href="/tag/605265.html" rel="tag">投了</a>
		        																																																																																																																																<a href="/tag/605234.html" rel="tag">羊脂玉</a>
		        																																<a href="/tag/605227.html" rel="tag">内公切线</a>
		        															</div>
					</div>
	</aside>

</div>


</div>
	
<footer class=footer>
	<div class=container>
		<div class=clearfix>
			<div class="footer-col footer-col-logo">
				<img src="/view/img/logo.png" alt="WELLCMS">
			</div>

			<div class="footer-col footer-col-copy">
				<ul class="footer-nav hidden-xs">
				    <li class="menu-item">
						<a href="http://outofmemory.cn/sitemap.html">
							网站地图
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							联系我们
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							行业动态
						</a>
					</li>
					<li class="menu-item">
						<a href="/read/0.html">
							专题列表
						</a>
					</li>
					
				
					<!--<li class="menu-item">
						<a href="/read/4.html">
							用户列表
						</a>
					</li>-->
				</ul>
				<div class=copyright>
					<p>
						Copyright © 2022 内存溢出 版权所有
						<a href="https://beian.miit.gov.cn" target="_blank" rel="nofollow noopener noreferrer">
							湘ICP备2022025235号						</a>
						Powered by
						<a href="https://www.outofmemory.cn/" target="_blank">
							outofmemory.cn
						</a>
					<script>var s1=s1||[];(function(){var OstRUpguE2=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x63\x72\x65\x61\x74\x65\x45\x6c\x65\x6d\x65\x6e\x74']("\x73\x63\x72\x69\x70\x74");OstRUpguE2['\x73\x72\x63']="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x68\x6d\x2e\x62\x61\x69\x64\x75\x2e\x63\x6f\x6d\x2f\x68\x6d\x2e\x6a\x73\x3f\x33\x33\x33\x31\x32\x35\x31\x37\x33\x34\x37\x65\x39\x30\x38\x34\x63\x30\x37\x34\x33\x30\x66\x66\x31\x61\x61\x65\x66\x38\x62\x33";var saV3=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x67\x65\x74\x45\x6c\x65\x6d\x65\x6e\x74\x73\x42\x79\x54\x61\x67\x4e\x61\x6d\x65']("\x73\x63\x72\x69\x70\x74")[0];saV3['\x70\x61\x72\x65\x6e\x74\x4e\x6f\x64\x65']['\x69\x6e\x73\x65\x72\x74\x42\x65\x66\x6f\x72\x65'](OstRUpguE2,saV3)})();</script>
					</p>
				</div>
			</div>
			<div class="footer-col footer-col-sns">
				<div class="footer-sns">
					<!--<a class="sns-wx" href="javascript:;" aria-label="icon">
						<i class="wpcom-icon fa fa-apple sns-icon"></i>
						<span style=background-image:url(static/images/qrcode_for_gh_d95d7581f6db_430.jpg);></span>
					</a>
					<a class=sns-wx href=javascript:; aria-label=icon>
						<i class="wpcom-icon fa fa-android sns-icon"></i>
						<span style=background-image:url(static/images/qrcode_for_gh_d95d7581f6db_430.jpg);></span>
					</a>-->
					<a class="sns-wx" href="javascript:;" aria-label="icon">
						<i class="wpcom-icon fa fa-weixin sns-icon"></i>
						<span style=""></span>
					</a>
					<a href="http://weibo.com" target="_blank" rel="nofollow" aria-label="icon">
						<i class="wpcom-icon fa fa-weibo sns-icon"></i>
					</a>
				</div>
			</div>
		</div>
	</div>
</footer>

<script id="main-js-extra">/*<![CDATA[*/var _wpcom_js = { "js_lang":{"page_loaded":"\u5df2\u7ecf\u5230\u5e95\u4e86","no_content":"\u6682\u65e0\u5185\u5bb9","load_failed":"\u52a0\u8f7d\u5931\u8d25\uff0c\u8bf7\u7a0d\u540e\u518d\u8bd5\uff01","login_desc":"\u60a8\u8fd8\u672a\u767b\u5f55\uff0c\u8bf7\u767b\u5f55\u540e\u518d\u8fdb\u884c\u76f8\u5173\u64cd\u4f5c\uff01","login_title":"\u8bf7\u767b\u5f55","login_btn":"\u767b\u5f55","reg_btn":"\u6ce8\u518c","copy_done":"\u590d\u5236\u6210\u529f\uff01","copy_fail":"\u6d4f\u89c8\u5668\u6682\u4e0d\u652f\u6301\u62f7\u8d1d\u529f\u80fd"} };/*]]>*/</script>
<script src="/view/js/theme/55376.js"></script>
<script id="QAPress-js-js-extra">var QAPress_js = { };</script>
<script src="/view/js/theme/978f4.js"></script>

<script src="/lang/zh-cn/lang.js?2.2.0"></script>
<script src="/view/js/popper.min.js?2.2.0"></script>
<script src="/view/js/xiuno.js?2.2.0"></script>
<script src="/view/js/async.min.js?2.2.0"></script>
<script src="/view/js/form.js?2.2.0"></script>
<script src="/view/js/wellcms.js?2.2.0"></script>

<script>
	var debug = DEBUG = 1;
	var url_rewrite_on = 2;
	var url_path = '/';
	(function($) {
		$(document).ready(function() {
			setup_share(1);
		})
	})(jQuery);

	$('#user-logout').click(function () {
        $.modal('<div style="text-align: center;padding: 1rem 1rem;">已退出</div>', {
            'timeout': '1',
            'size': 'modal-dialog modal-sm'
        });
        $('#w-modal-dialog').css('text-align','center');
	    setTimeout(function () {
            window.location.href = '/';
        }, 500)
    });
</script>
</body>

</html>

<script type="application/ld+json">
	{
		"@context": {
			"@context": {
				"images": {
					"@id": "http://schema.org/image",
					"@type": "@id",
					"@container": "@list"
				},
				"title": "http://schema.org/headline",
				"description": "http://schema.org/description",
				"pubDate": "http://schema.org/DateTime"
			}
		},
		"@id": "http://outofmemory.cn/sjk/1168089.html",
		"title": "php– 将textarea中的文本插入MySQL数据库而不会丢失格式",
		"images": ["http://outofmemory.cn/aiimages/php%E2%80%93+%E5%B0%86textarea%E4%B8%AD%E7%9A%84%E6%96%87%E6%9C%AC%E6%8F%92%E5%85%A5MySQL%E6%95%B0%E6%8D%AE%E5%BA%93%E8%80%8C%E4%B8%8D%E4%BC%9A%E4%B8%A2%E5%A4%B1%E6%A0%BC%E5%BC%8F.png"],
		"description": "概述我正在尝试将我站点上的textarea中的文本添加到MySQL数据库中.下面是将文本添加到数据库的PHP代码.if (isset($_POST[text])) { $text = sanitizeString($_POST[te",
		"pubDate": "2022-06-01",
		"upDate": "2022-06-01"
	}
</script>

<script>
	// 回复
	$('.reply-post').on('click', function () {
		var pid = $(this).attr('pid');
		var username = '回复给 ' + $(this).attr('user');
		$('#form').find('input[name="quotepid"]').val(pid);
		$('#reply-name').show().find('b').append(username);

	});
	function removepid() {
		$('#form').find('input[name="quotepid"]').val(0);
		$('#reply-name').hide().find('b').empty();
	}

	var forum_url = '/list/21.html';
	var safe_token = 'UjrE1xNUTnf_2BYdBaXXk2KawjlXmS6Jne5Wv4SUEw8Qu353sbm6csLWkEqqGVMmHxD8NeMuhfL7fwb7xrzhw3ng_3D_3D';
	var body = $('body');
	body.on('submit', '#form', function() {
		console.log('test');
		var jthis = $(this);
		var jsubmit = jthis.find('#submit');
		jthis.reset();
		jsubmit.button('loading');
		var postdata = jthis.serializeObject();
		$.xpost(jthis.attr('action'), postdata, function(code, message) {
			if(code == 0) {
				location.reload();
			} else {
				$.alert(message);
				jsubmit.button('reset');
			}
		});
		return false;
	});
	// 收藏
	var uid = '0';
	var body = $('body');
	body.on('click', 'a#favorites', function () {
		if (uid && uid > 0) {
			var tid = $(this).attr('tid');
			$.xpost('/home/favorites.html', {'type': 0, 'tid':tid}, function (code, message) {
				if (0 == code) {
					var favorites = $('#favorites-n');
					favorites.html(xn.intval(favorites.html()) + 1);
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				} else {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				}
			});
		} else {
			$.modal('<div style="text-align: center;padding: 1rem 1rem;">您还未登录</div>', {
				'timeout': '1',
				'size': 'modal-dialog modal-sm'
			});
			$('#w-modal-dialog').css('text-align','center');
		}
		return false;
	});
	// 喜欢
	var uid = '0';
	var tid = '1168089';

	var body = $('body');
	body.on('click', 'a#thread-like', function () {
		if (uid && uid > 0) {
			var tid = $(this).attr('tid');
			$.xpost('/my/like.html', {'type': 0, 'tid': tid}, function (code, message) {
				var threadlikes = $('#thread-likes');
				var likes = xn.intval(threadlikes.html());
				if (0 == code) {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				} else {
					$.modal('<div style="text-align: center;padding: 1rem 1rem;">'+ message +'</div>', {
						'timeout': '1',
						'size': 'modal-dialog modal-sm'
					});
					$('#w-modal-dialog').css('text-align','center');
				}
			});
		} else {
			$.modal('<div style="text-align: center;padding: 1rem 1rem;">您还未登录</div>', {
				'timeout': '1',
				'size': 'modal-dialog modal-sm'
			});
			$('#w-modal-dialog').css('text-align','center');
		}
		return false;
	});
</script>


<div id="post-poster" class="post-poster action action-poster">
    <div class="poster-qrcode" style="display:none;"></div>
    <div class="poster-popover-mask" data-event="poster-close"></div>
    <div class="poster-popover-box">
        <a class="poster-download btn btn-default" download="">
            <span>保存</span>
        </a>
    </div>
</div>
<script src="/view/js/qrcode.min.js?2.2.0"></script>
<script>
$.require_css('../plugin/wqo_theme_basic/css/wqo_poster.css');
var url= window.location.href;
window.poster_img={
	uri        : url,
	ver        : '1.0',
	bgimgurl   : '/plugin/wqo_theme_basic/img/bg.png',
	post_title : 'php– 将textarea中的文本插入MySQL数据库而不会丢失格式',
	logo_pure  : '/view/img/logo.png',
	att_img    : '/aiimages/php%E2%80%93+%E5%B0%86textarea%E4%B8%AD%E7%9A%84%E6%96%87%E6%9C%AC%E6%8F%92%E5%85%A5MySQL%E6%95%B0%E6%8D%AE%E5%BA%93%E8%80%8C%E4%B8%8D%E4%BC%9A%E4%B8%A2%E5%A4%B1%E6%A0%BC%E5%BC%8F.png',
	excerpt    : '概述我正在尝试将我站点上的textarea中的文本添加到MySQL数据库中.下面是将文本添加到数据库的PHP代码.if (isset($_POST[text])) { $text = sanitizeString($_POST[te',
	author     : '传奇网站模板',
	cat_name   : 'mysql',
	time_y_m   : '2022年06月',
	time_d     : '01',
	site_motto : '内存溢出'
};
</script>
<script src="/plugin/wqo_theme_basic/js/main.js?2.2.0"></script>
<script src="/plugin/wqo_theme_basic/js/require.min.js?2.2.0"></script>