increment number

[DANINAP]

something like that...
I'm sorry but I'm not that good ..

$db = FabrikWorker::getDbo();
$query = $db->getQuery(true);
$query
->select('coalasce(max(numero_pratica),0 +1')
->from($db->quoteName('movimenti'));
$db->setQuery($query);
$count = $db->loadResult();
return $count;
$ formModel-> data ['movimenti___numero_pratica'] = $count;

 

[DANINAP]

syntax error, unexpected 'formModel' (T_STRING), expecting variable (T_VARIABLE) or '{' or '$'

 

[lousyfool]

You:

$ formModel-> data ['movimenti___numero_pratica'] = $count;

PHP:

$formModel->data['movimenti___numero_pratica'] = $count;

This time I had to remove "only" three spaces, but they're equally important. Please learn at least the basics of PHP, we here can't always fix it for you. Thank you.

Other than that, I'm not sure this will do what you expect it to do, but you'll find out.

 

[DANINAP]

sto provando

 

[DANINAP]

mi restituisce un errore di sintassi, '$ db' imprevisto (T_VARIABLE)

 

[lousyfool]

... '$ db' ...

Am I the only one seeing the space in between $ and db?

 

[lousyfool]

sto provando

Sorry, but you really need to try harder. Actually, it's not that hard to get the syntax right, especially if you get error messages telling you what and where your bug is.

 

[DANINAP]

I'm sorry but I don't see spaces in the code. this is the error it returns me

 

[DANINAP]

ok... missed a;
unfortunately, however, it does not do what I hoped

 

[lousyfool]

Other than that, I'm not sure this will do what you expect it to do, but you'll find out.

Sorry, I'm giving up on this one now. Maybe someone else will take over. In bocca al lupo!

 

[deant]

If I correctly understand your english you like to increment number for your "center field". So you have in table 3 ABC and add new ABC you have now 4 ABC?

Then you should count "center field" + 1
Maybe something like this

$centro = '{movimenti___centro_raw}';
if ($centro != ''){
    $db = FabrikWorker::getDbo();
    $query = $db->getQuery(true);
    $query
        ->select('COUNT(*)')
        ->from($db->quoteName('movimenti'))
        ->where($db->quoteName('centro') . ' = ' . $db->quote($centro));
    $db->setQuery($query);
    $count = $db->loadResult();

    if ($count == '' || $count == 0){
        return 1;
    }
    else {
        return $count + 1;
    }
}