Guest User

Untitled

a guest
Dec 3rd, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2.  
  3. $fisier = fopen("rezultate.txt", "r");
  4. $host="localhost"; // Host name
  5. $username="onlyssl_oc151"; // Mysql username
  6. $password="lghqSA.EscDw"; // Mysql password
  7. $db_name="onlyssl_beta"; // Database name
  8. $tbl_name="product"; // Table name
  9.  
  10. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  11. mysql_select_db("$db_name")or die("cannot select DB");
  12.  
  13. $sql="SELECT * FROM $tbl_name";
  14. $result=mysql_query($sql) or die($sql."<br/><br/>".mysql_error());
  15.  
  16. $count=mysql_num_rows($result);
  17.  
  18. $i = 0;
  19. while (!feof($fisier)) {
  20.     $coduri[] = fgets($fisier);
  21.     $current=0;
  22. }
  23. fclose($fisier);
  24.  
  25. foreach ($coduri as $x){
  26.  
  27. $qur="UPDATE $tbl_name SET quantity='0' WHERE model='oc-$x'";
  28. mysql_query( $qur) or die ("Error in query: $query".mysql_error());
  29.  
  30. }
  31.  
  32. ?>
Add Comment
Please, Sign In to add comment