How to insert multiple rows from a textarea in MyS

2019-06-11 22:01发布

站内问答 / PHP
1422 2 5 

<html>
<form method="POST" action="insertlines.php">
<textarea name="url" rows="10" ></textarea>
<input type="submit" name="submit" value="Enter">
</form>
</html>

How can i put every single row of the textarea into a MySQL row ?

The thing I want is when I input:

John
Peter
Steven

in the textarea, I want them in my database with different ids each.

2条回答
女痞
2楼-- · 2019-06-11 22:22

You have to parse the text, looking for the "enter" character:

<?php
if(isset($_POST['url'])){
    if(strpos($_POST['url'], "\n")){
        $entries = explode("\n", $_POST['url']);
    } else {
        $entries = array($_POST['url']);
    }
    // connect to DB here
    // then iterate over entries
    foreach($entries as $e){
        // build some type of Prepared Statement to protect from SQL Injection
        $q = "INSERT INTO table (col1) VALUES (?)";
        // bind $e to statements
        // Execute SQL statements
    }
    // close DB connection
}
?>
查看更多
0人赞 添加讨论(0) 举报
神经病院院长
3楼-- · 2019-06-11 22:34

Try this:

$textarea=$_POST['url']
$sql = 'INSERT INTO YourTable(field1,field2,name) VALUES';
foreach(explode("\n", $textarea) as $row) {
$sql.='("field1","field2",.'$row'.)';
} 
$conn->query($sql)
查看更多
0人赞 添加讨论(0) 举报
登录 后发表回答
相关问题
查看全部
相关文章
查看全部
收藏的人(5)