MX Kollection Forum :: How to break transaction?

If we manage some check trigger before insert or update transaction such as check old password, it will do some check and decide to do the insert or not by the result of check, it's like

1. check password
    1. correct
        executer insert transaction
    2. wrong
        skip insert transaction
        diaplay transaction error

tha's mean if we check something wrong, it's skip the insert and show the error message, I want to know how to stop the transaction if I do some check by myself

1. check something
    1. right
        execute insert transaction
    2. wrong
        skip insert transaction
        diaplay transaction error

Hi David,

When you build your form decide what fields to validate / check.

It will then stop the transaction from happening.

You can add the "Validate Form" SB to achive this is you did not do it when you created the form in the first place.

If you are looking to do it manually I just found this tutorial

I did not really look at it but it will most certainly give you a basis to work from.

 I am sorry, I didn't see anything to do with transaction engine in the website you offer?

If you do not want to use the interakt validation script you will need to code the solution yourself.

That is the reason I sent you the link to the php tutorial.

I want to code by myself that's right, and I also want to follow the transaction engine, that's why I make a trigger to do the check before insert transaction, I put the check in that trigger before insert transaction, but I don't know how to pass the insert transaction and doing something else if I want to, for example

//start checkPmIns trigger
function checkPmIns(&$tNG) {
    /*check duplicate*/
    include('../../Connections/conndb.php');
    include('../../backsite/functions_backsite.php');
    mysql_select_db($database_conndb, $conndb);
    $query = sprintf("SELECT * FROM bag_product_manage WHERE p_id = %s AND pm_type = %s",
        toSql($_GET['pid'], 'int'),
        toSql($_GET['type'], 'int'));
    $Rec = mysql_query($query) or die(mysql_error());
    $num = mysql_num_rows($Rec);
    mysql_free_result($Rec);
    if ($num > 0) {
        echo '<div id="res">this product is already in database</div>';
        exit;
    }
}

Now I use exit, but it's not the bese way.

I see you want to check if a product is already in the DB.

Why don't you just use the "Check Unique Key" SB and take it from there?

because I have two condition, and I really want to know how to do it.

Not exactly sure what you are trying to achieve.

If you simply want to do something else if the expression is "true" then you can do something like this or look at the php manual on controll structures here.

if ($num > 0) {
        echo '<div id="res">this product is already in database</div>';

    // Redirect the user to the wherever1.php page.

    // Start defining the URL.

    $url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);

    

    // Check for a trailing slash.

    if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {

        $url = substr ($url, 0, -1); // Chop off the slash.

    }

    

    // Add the page.

    $url .= '/wherever1.php';

    

    header("Location: $url");

    exit();    }