[MySQL][PHP]mysqli_commit Opcje

[kamilo818]

Cześć, moj kod:

[PHP] pobierz, plaintext 
$conn = self::getConnection();
                mysqli_autocommit($conn,FALSE);
                $SQL = "UPDATE fr_product SET name='".$name."', image='".$image."',description='".$description."',price='".$price."',code='".$code."',seo_title='".$seo_title."',seo_keywords='".$seo_keywords."',seo_description='".$seo_description."',newest='".$newest."',recommended='".$recommended."',promotion='".$promotion."',image_promotion='".$image_promotion."',promotion_for_home='".$promotion_main."',products_category='".$category."' WHERE id='".$id."'";
                $conn->query($SQL);
 
 
                foreach($filters as $k=>$f){
 
                    $conn->query("UPDATE fr_product_filter SET filter_valuee='".$f."' WHERE product_code='".$code."' AND filter_id='".$k."'");
 
                }
 
 
                if(mysqli_commit($conn)){
                    echo '<div class="alert alert-success" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>Operacja wykonana poprawnie!</div>';
                }else{
                    mysqli_rollback($conn);
                    echo '<div class="alert alert-danger" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a><strong>Nieoczekiwany błąd. </div>';
 
                }
 
                mysqli_close($conn);
                break;
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 if(mysqli_commit($conn)
[PHP] pobierz, plaintext 

- zawsze jest true mimo że

[PHP] pobierz, plaintext 
$conn->query("UPDATE fr_product_filter SET filter_valuee='".$f."' WHERE product_code='".$code."' AND filter_id='".$k."'");
[PHP] pobierz, plaintext 

nie wykonuje się (filter_valuee zamiast filter_value)

Czy ja to zle stosuję?

Chce uzyskać efekt ze jeśli któreś zapytanie nie wykona sie poprawnie to wszystko wraca do punktu poczatkowego.

Będę wdzieczny za pomoc.

[kamilo818]

Mam InnoDB.

Czyli teraz mam tak

[PHP] pobierz, plaintext 
 
                $conn = self::getConnection();
 
                $conn->autocommit(false);
 
 
                $SQL = "UPDATE fr_product SET name='".$name."', image='".$image."',description='".$description."',price='".$price."',code='".$code."',seo_title='".$seo_title."',seo_keywords='".$seo_keywords."',seo_description='".$seo_description."',newest='".$newest."',recommended='".$recommended."',promotion='".$promotion."',image_promotion='".$image_promotion."',promotion_for_home='".$promotion_main."',products_category='".$category."' WHERE id='".$id."'";
                $result = $conn->query($SQL);
 
 
                $err_f = false;
                foreach($filters as $k=>$f){
 
                    if(!$result_filter = $conn->query("UPDATE fr_product_filter SET filter_valuee='".$f."' WHERE product_code='".$code."' AND filter_id='".$k."'")){
                        $err_f=true;
                    }
                }
 
 
                $conn->commit();
 
                if($result && $err_f==false){
                    echo '<div class="alert alert-success" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>Operacja wykonana poprawnie!</div>';
                }else{
                    $conn->rollback();
                    echo '<div class="alert alert-danger" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a><strong>Nieoczekiwany błąd. </div>';
 
                }
 
                $conn->close();
                break;
 
[PHP] pobierz, plaintext 

Ok i teraz wydaje mi się że nie działa

[PHP] pobierz, plaintext 
$conn->rollback();
[PHP] pobierz, plaintext 

ponieważ

[PHP] pobierz, plaintext 
$result = $conn->query($SQL);
[PHP] pobierz, plaintext 

wykonuje się poprawnie (zmiana w bazie) a

[PHP] pobierz, plaintext 
if(!$result_filter = $conn->query("UPDATE fr_product_filter SET filter_valuee='".$f."' WHERE product_code='".$code."' AND filter_id='".$k."'")){
                        $err_f=true;
                    }
[PHP] pobierz, plaintext 

rzuca błąd w wchodzi w else

[PHP] pobierz, plaintext 
$conn->rollback();
                    echo '<div class="alert alert-danger" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a><strong>Nieoczekiwany błąd. </div>';
[PHP] pobierz, plaintext 

ale to pierwsze zapytanie nie jest cofnięte.

Jakieś pomysły?

------------------------------
edit

OK działa

[PHP] pobierz, plaintext 
$conn = self::getConnection();
 
                $conn->autocommit(false);
 
 
                $SQL = "UPDATE fr_product SET name='".$name."', image='".$image."',description='".$description."',price='".$price."',code='".$code."',seo_title='".$seo_title."',seo_keywords='".$seo_keywords."',seo_description='".$seo_description."',newest='".$newest."',recommended='".$recommended."',promotion='".$promotion."',image_promotion='".$image_promotion."',promotion_for_home='".$promotion_main."',products_category='".$category."' WHERE id='".$id."'";
                $result = $conn->query($SQL);
 
 
                $err_f = false;
                foreach($filters as $k=>$f){
 
                    if(!$result_filter = $conn->query("UPDATE fr_product_filter SET filter_valuee='".$f."' WHERE product_code='".$code."' AND filter_id='".$k."'")){
                        $err_f=true;
                    }
                }
 
 
 
 
                if($result && $err_f==false){
                  [b] $conn->commit();[/b]
                    echo '<div class="alert alert-success" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>Operacja wykonana poprawnie!</div>';
                }else{
                    $conn->rollback();
                    echo '<div class="alert alert-danger" role="alert"><a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a><strong>Nieoczekiwany błąd. </div>';
 
                }
 
                $conn->close();
                break;
 
[PHP] pobierz, plaintext