I need insert multiple line from text area insert in to each row of database. but now is insert all line in one row how i can do it? also i want echo finished line, and echo if line exit with warning
My text area input is :
line1
line2
line3
line4
line5
I want insert like this
id url
1 line1
2 line2
3 line3
4 line4
5 line5
This is my insert.php
<html><body>
<h1>indian mp3 Database: indianmp3</h1>
<form action="post.php" method="post">
Firstname:<textarea name="url" id="term" cols="40" rows="10"></textarea><br><br>
Category: <select name="cat_id">
<option value="1">cat1</option>
<option value="2">cat2</option>
<option value="3">cat3</option>
</select>
<input type="submit"/>
</form>
</body></html>
This is my post.php
<html><body>
<?php
$host="localhost";
$user=" ";
$pass=" ";
$database=" ";
$con=mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_set_charset('UTF8', $con);
if(!$con) {
die('Could not connect: '.mysql_error());
}
if(isset($_POST['cat_id'])) {
$cat_it=(int)$_POST['cat_id'];
$url=$_POST[url];
mysql_select_db($database, $con) or die("Could not find database.");
$sql="INSERT INTO link (url, cat_id) VALUES ('$url' , '$cat_it')";
}
if(!mysql_query($sql, $con)) {
die('Error: '.mysql_error());
}
echo "inserted all line";
mysql_close($con)
?>
</body></html>