Using PHP read word in textarea line by line and insert to mySQL

by 

you can code like:

$val="Veg
Tomato
Potato

Fruits
mango
banana";
$textAreaVal = $val;
$arrVal = explode(PHP_EOL, $textAreaVal);
for($i=0; $i < count($arrVal); $i++){
    $type="";
    $isInIf = false;
    if($arrVal[i] == 'Veg'){
        $type="Veg";
    }else if($arrVal[i] == 'Fruits'){
        $type="Fruits";
    }

    if($type != ''){
        // your insert query here
        // insert into tbl(type, name) values('$type', '$arrVal[i]')
    }
}

More Related Contents:

  1. How to insert multiple rows from array using CodeIgniter framework?
  2. PHP mysql insert date format
  3. Incorrect Integer (2147483647) is inserted into MySQL?
  4. Escaping single quote in PHP when inserting into MySQL [duplicate]
  5. PHP/MySQL Insert null values
  6. MySQL – ignore insert error: duplicate entry
  7. Object of class DateTime could not be converted to string
  8. php run once and insert twice in mysql database
  9. PHP mySQL – Insert new record into table with auto-increment on primary key
  10. Replacing \r\n with PHP
  11. How to create this type of JSON data from PHP [closed]
  12. how to write php code for the key press enter button when fill the form?
  13. Organization db for blog posts with Mysql and Php [closed]
  14. PHP – Change value y,n in database [closed]
  15. mysqli or PDO – what are the pros and cons? [closed]
  16. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  17. How to resolve ambiguous column names when retrieving results?
  18. Maximum execution time in phpMyadmin
  19. Calling stored procedure with Out parameter using PDO
  20. How to display an BLOB image stored in MySql database?
  21. How to bind LIKE values using the PDO extension?
  22. How do I set the selected item in a drop down box
  23. Fatal error: Call to undefined function mysqli_result()
  24. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  25. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  26. How can I employ “if exists” for creating or dropping an index in MySQL?
  27. PHP MySQL pagination with random ordering
  28. Create PHP array from MySQL column
  29. UNION syntax in Cakephp
  30. How do i search from serialize field in mysql database?

Leave a Comment