Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "INSERT IGNORE INTO `table_name` (`field1`,`field2`)
- VALUES ('val1','val2') ('val3','val4') ... ";
- // php_mysql_insert_function
- $db = new mysqli('127.0.0.1','...','...','...');
- $sql = "INSERT IGNORE INTO Test (id,test) VALUES (1,2),(1,3),(2,2),(3,4)";
- $ins_test = $db->prepare($sql);
- $ins_test->execute();
- echo $db->affected_rows;
- <?php
- $host = '';
- $user = '';
- $password = '';
- $database = '';
- $link = mysqli_connect($host, $user, $password, $database);
- if(!$link)
- {
- echo('Unable to connect to the database!');
- }
- ELSE {
- $sql = "INSERT IGNORE INTO `table_name` (`field1`,`field2`) VALUES ('val1','val2'), ('val3','val4')";
- $result = mysqli_query($link, $sql);
- echo mysqli_affected_rows($link);
- }
- mysqli_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement