neil_pearce

MySQLi example

Mar 30th, 2024
1,025
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.42 KB | Source Code | 0 0
  1. $nr = 0;  // replace this with your existing code
  2.  
  3.  
  4. $sql = 'INSERT INTO %s(nr, mailadress, pnr) VALUES (?, ?, ?)';
  5. $utskick = mysqli_prepare($db, sprintf($sql, 'utskick'));
  6. $yahooadr = mysqli_prepare($db, sprintf($sql, 'yahooadr'));
  7.  
  8. while ($rad = mysqli_fetch_row($result)) {
  9.     $stmt = strpos($rad[0], 'yahoo') !== false ? $yahooadr : $utskick;
  10.     mysqli_execute($stmt, [$nr, $rad[0], $rad[1]]);
  11.     $nr++;
  12. }
  13.  
Advertisement
Comments
Add Comment
Please, Sign In to add comment