Insert Mutiple Record into Database Using Php Mysql

by 
     $arr = array();
    foreach($_POST['sj'] as $key => $value) {
         $eflt = $_POST['sflt'][$key];
         $emodel = $_POST['smodel'][$key];
         $eengine =$_POST['sengine'][$key];
         $eloc = $_POST['sloc'][$key];
         $estye = $_POST['sstye'][$key];
         $ensvr = $_POST['snsvr'][$key];
         $eehd = $_POST['sehd'][$key];
         array_push($arr,"('$eflt','$emodel','$eengine','$eloc','$estye','$ensvr','$eehd')");
}
$inExp = mysqli_query($link,"INSERT INTO table_name(fltno,model,engine,loc,serviceType,nextSvr,usageHr) VALUES ".implode(',',$arr));

Do it with one query. Also you can do it with prepared statements easily..

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. Commands out of sync; you can’t run this command now
  3. mysqli_query() expects at least 2 parameters, 1 given
  4. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  5. Strict Standards: mysqli_next_result() error with mysqli_multi_query
  6. Why does mysqli num_rows always return 0?
  7. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  8. What is the difference between MySQL, MySQLi and PDO? [closed]
  9. parameters in MySQLi
  10. Retrieving Multiple Result sets with stored procedure in php/mysqli
  11. Mysql No connection could be made because the target machine actively refused it
  12. How to connect to MySQL database in PHP using mysqli extension?
  13. How do I count query result rows?
  14. Bind Param with array of parameters
  15. How do you use IN clauses with mysqli prepared statements [duplicate]
  16. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  17. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  18. Using wildcards in prepared statement – MySQLi
  19. How to fetch all in assoc array from a prepared statement?
  20. Fatal error: Call to undefined function mysqli_result()
  21. Fatal error: Call to a member function close() on a non-object. MySQLi issue
  22. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  23. Why I am getting an error when using w3school tutorial? [duplicate]
  24. Using wildcards in prepared statement
  25. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  26. How to remove the fatal error when fetching an assoc array
  27. Fatal error: Call to undefined method mysqli_stmt::get_result()
  28. PHP MySQLi Multiple Inserts
  29. Fatal error: Call to a member function prepare() on a non-object in
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment