php无法将值传入数据库,PHP-无法将句子插入数据库

我有几句话.我必须选择包含6个以上单词的句子.然后将它们插入数据库.

require_once 'conf/conf.php';

$text = " Poetry. Do you read poetry while flying? Many people find it relaxing to read on long flights. Poetry can be divided into several genres, or categories. ";

$sentences = explode(".", $text);

foreach ($sentences as $sentence) {

if (count(preg_split('/\s+/', $sentence)) > 6) {

$save = $sentence. ".";

$sql = mysql_query("INSERT INTO tb_name VALUES('','$save')");

}

}

?>

结果只是插入数据库=>中的第二句话. ‘你在飞行时读诗吗？许多人发现在长途飞行中阅读很轻松.而第三句也应该插入.请帮助我,谢谢：)

解决方法:

这是您要寻找的解决方案.您不能添加多行,因为您的ID值未指定,这是表的关键.由于要将句子添加到同一行,因此需要执行一个查询.

$text = " Poetry. Do you read poetry while flying? Many people find it relaxing to read on long flights. Poetry can be divided into several genres, or categories. ";

$sentences = explode(".", $text); $save = array();

foreach ($sentences as $sentence) {

if (count(preg_split('/\s+/', $sentence)) > 6) {

$save[] = $sentence. ".";

}

}

if( count( $save) > 0) {

$sql = mysql_query("INSERT INTO tb_name VALUES('','" . implode( ' ', $save) . "')");

}

现在,两个句子将插入到数据库的同一行中,并以空格分隔.如果将第一个参数修改为implode(),则可以更改它们的分隔符.

生成的查询是这样的：

INSERT INTO tb_name VALUES('',' Do you read poetry while flying? Many people find it relaxing to read on long flights. Poetry can be divided into several genres, or categories.')

标签：mysql,php

来源： https://codeday.me/bug/20191101/1981472.html