Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $fisier = fopen("rezultate.txt", "r");
- $host="localhost"; // Host name
- $username="onlyssl_oc151"; // Mysql username
- $password="lghqSA.EscDw"; // Mysql password
- $db_name="onlyssl_beta"; // Database name
- $tbl_name="product"; // Table name
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $sql="SELECT * FROM $tbl_name";
- $result=mysql_query($sql) or die($sql."<br/><br/>".mysql_error());
- $count=mysql_num_rows($result);
- $i = 0;
- while (!feof($fisier)) {
- $coduri[] = fgets($fisier);
- $current=0;
- }
- fclose($fisier);
- foreach ($coduri as $x){
- $qur="UPDATE $tbl_name SET quantity='0' WHERE model='oc-$x'";
- mysql_query( $qur) or die ("Error in query: $query".mysql_error());
- }
- ?>
Add Comment
Please, Sign In to add comment