<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.
分享
You have to parse the text, looking for the "enter" character:
<?php
if(isset($_POST['url'])){
if(strpos($_POST['url'], "
")){
$entries = explode("
", $_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
}
?>
