php – 如何捕获并将第二个粗体文本存储到数据库中？_php教程

上一篇: php – 与Eloquent的多级别hasMa... 下一篇:php – 根据最后一条记录插入一行...

php – 如何捕获并将第二个粗体文本存储到数据库中？

发布时间：2022-04-30 发布网站：脚本宝典

脚本宝典收集整理的这篇文章主要介绍了php – 如何捕获并将第二个粗体文本存储到数据库中？，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

假设将整个字符串存储到数据库中,并将句子拆分,选项和答案存储在自己的列中.

管理将整个字符串存储到数据库中并将它们存储到相应的列中,并能够捕获第一个粗体文本并将其存储到数据库中.

但是无法捕获并将第二个粗体文本存储到数据库的列中.

<?PHP 
define('DB_HOST','localhost');
define('DB_NamE','palmdatas'); 
define('DB_USER','root');
define('DB_PASSWORD',''); 

$con=MysqL_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MysqL: " . MysqL_error());
$db=MysqL_select_db(DB_NAME,$con) or die("Failed to connect to MysqL: " . MysqL_error()); 
$mode = $_POST['mode']; 
$question = $_POST['edITor1']; 
$text = $question;

echo "\n";

$text = strip_tags($text);


function multiexplode ($delimiters,$string) {

$ready = str_replace($delimiters,$delimiters[0],$string);
$launch = explode($delimiters[0],$ready);
return  $launch;
}

$exploded = multiexplode(array(",","(",")"),$text);
 $question = $_POST['editor1']; 

 $answer1 = extractString($question,'<strong>','</strong>');

$sql="INSERT INTO strucquestions (part1,op1,op2,oP3,op4,ans1,part2,op1a,op2a,op3a,op4a,ans2,part3,mode) VALUES ('$exploded[0]','$exploded[1]','$exploded[2]','$exploded[3]','$exploded[4]','$answer1','$exploded[5]','$exploded[6]','$exploded[7]','$exploded[8]','$exploded[9]','$answer2','$exploded[10]','$mode')";

echo "Successfully Inserted!";
$result = MysqL_query($sql);
if (!$result) {
 die('Invalid query: ' . MysqL_error());
}

function extractString($question,$start,$end) {
$question = " ".$question;
$ini = strpos($question,$start);
if ($ini == 0) return "";
$ini += strlen($start);
$len = strpos($question,$end,$ini) - $ini;
return substr($question,$ini,$len);

echo "close";
        MysqL_close($con);      

} 
?>
<button onclick="window.location.href='insertion.PHP'">Next</button><br>        <br>