Advertisement
Guest User

Untitled

a guest
Aug 19th, 2016
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. $sql = "INSERT IGNORE INTO `table_name` (`field1`,`field2`)
  2. VALUES ('val1','val2') ('val3','val4') ... ";
  3. // php_mysql_insert_function
  4.  
  5. $db = new mysqli('127.0.0.1','...','...','...');
  6. $sql = "INSERT IGNORE INTO Test (id,test) VALUES (1,2),(1,3),(2,2),(3,4)";
  7. $ins_test = $db->prepare($sql);
  8. $ins_test->execute();
  9. echo $db->affected_rows;
  10.  
  11. <?php
  12. $host = '';
  13. $user = '';
  14. $password = '';
  15. $database = '';
  16.  
  17.  
  18. $link = mysqli_connect($host, $user, $password, $database);
  19.  
  20. if(!$link)
  21. {
  22. echo('Unable to connect to the database!');
  23. }
  24. ELSE {
  25. $sql = "INSERT IGNORE INTO `table_name` (`field1`,`field2`) VALUES ('val1','val2'), ('val3','val4')";
  26. $result = mysqli_query($link, $sql);
  27. echo mysqli_affected_rows($link);
  28. }
  29.  
  30. mysqli_close($link);
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement