CODEWITHSUNDEEP
phpmysql
Somenoob
Somenoob

Reputation: 27

PHP & MYSQL Insert into database with a textarea (new line & new line into database)?

 <?php
require 'db2.php';
?>
<html>
<form action="" method="POST">
<textarea rows="5" cols="80" id="proxies" name="proxies">
</textarea>
<input type="submit" name="insert" value="Insert">
</form>
</html>
<?php
if (isset($_POST['insert']))
{
$string = $_POST['proxies'];
$arrray = explode(':',$string);
$proxy = $arrray[0] . ':' . $arrray[1];
$country = $arrray[2];
$state = $arrray[3];
$city = $arrray[4];
$query = mysqli_query($link,"INSERT INTO `proxies`(`proxy`,`country`, `state`, `city`) VALUES ('{$proxy}', '{$country}', '{$state}', '{$city}')");
}
?>

So basically, I'm confused I thought this would add every new line, but obviously I was wrong.

How would I get this text area to submit into my database line per line like e.g.

If I entered this into the text area

test:80:test:test:test
test:80:test:test:test
test:80:test:test:test
test:80:test:test:test

It'll add all of those 4 records, cheers!

Upvotes: 0

Views: 3186

Answers (3)

Fawzan
Fawzan

Reputation: 4849

I would recommend you to append 

PHP_EOL

PHP_EOL - is a End of line constant in PHP, Append that at the end of string instead of '\n'

I hope it will solve the problem,

Upvotes: 0

Sabin Jose
Sabin Jose

Reputation: 658

Please try this code: 

$string = trim($_POST['proxies']);
$stringArray = explode("\n" , $string);
$stringArray = array_filter($stringArray,'trim');

foreach($stringArray as $ $string){
$arrray = explode(':',$string);
$proxy = $arrray[0] . ':' . $arrray[1];
$country = $arrray[2];
$state = $arrray[3];
$city = $arrray[4];
$query = mysqli_query($link,"INSERT INTO `proxies`(`proxy`,`country`, `state`, `city`) VALUES ('{$proxy}', '{$country}', '{$state}', '{$city}')");
}

Upvotes: 0

dardar.moh
dardar.moh

Reputation: 6715

use this code :

 $text = trim($_POST['textareaname']); 
    $textAr = explode("\n", $text);  // remove the last \n or whitespace character
    $textAr = array_filter($textAr, 'trim'); // remove any extra \r characters left behind

    foreach ($textAr as $line) {
        // processing here. 
    }

for more explanation see this question.

Upvotes: 1

Related Questions