Advertisement
Guest User

Untitled

a guest
Feb 27th, 2012
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.81 KB | None | 0 0
  1. <?php
  2.  $link3 = mysqli_connect("localhost", "root", "pass","db");
  3.  $kol_err=0;
  4.  $num_qu=0;
  5.  $buffer='';
  6.  $result3=mysqli_query($link3, "truncate uc_spareshop_spare");
  7.  $result3=mysqli_query($link3, "set names 'utf8'");
  8.  
  9.  
  10.  $handle = fopen("sparefile1.txt", "r");
  11.  while (!feof($handle)) {
  12.     $buffer .= fgets($handle, 4096);
  13. }  
  14.  $query_spare = $buffer;
  15.  if (mysqli_multi_query($link3, $query_spare)) {
  16.     do { ++$num_qu;
  17.  
  18.         if ($result3 = mysqli_store_result($link3)) {
  19.            
  20.             mysqli_free_result($result3);
  21.         } else { ++$kol_err; }
  22.  
  23.         if (mysqli_more_results($link3)) {
  24.  
  25.         }
  26.     } while (mysqli_next_result($link3));
  27. }
  28.  
  29. $result4=mysqli_query($link3, 'select * from uc_spareshop_spare');
  30. $num_rows2=mysqli_num_rows($result4);
  31. echo     $num_rows2;
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement