nuBuilder Forum

Posted: **Tue Feb 03, 2015 12:38 pm**

Hi,

I have tried to get some PHP code to check if a record exists before posting to a table, followed another example, but it posts even when it is not supposed to; when $rcount <> NULL. The code:

Code: Select all

function CheckRowSave(){
    $sqlCheckRow =  "SELECT COUNT(*) FROM hrectemp
JOIN hrecord ON hrecord_classid = '#RECORD_ID#' AND hrecord_date = hrectemp_date;" ;
nuRunQuery($sqlCheckRow);
$rcount = mysqli_num_rows($sqlCheckRow);
    nuDebug($rcount); //This will place the SQL query into the zzzsys_debug table for viewing.
    if (empty($rcount)) {
    savehrec();
    }
}

What am I doing wrong please?

Posted: **Tue Feb 03, 2015 12:39 pm**

Forgot to mention, this is in the "Before Save" window of a form.

Posted: **Wed Feb 04, 2015 11:36 pm**

mahmud,

You might be better off doing something simpler like this..

Code: Select all


if('#this_field#' == ''){
   nuDisplayError("This Field cannot be left blank..");
}

If there are any error messages a record will not be updated or deleted.

http://wiki.nubuilder.net/index.php/PHP ... message.29

Here is more about where you can use hash variables.

http://wiki.nubuilder.net/index.php/Hash_Variables

Steven

Posted: **Sat Feb 07, 2015 3:43 pm**

Thanks for your response, but if you look at the code, I am trying to determine if a record already exists in a table so a user doesn't post it twice.

Mahmud

Posted: **Sun Feb 08, 2015 11:30 pm**

Mahmud,

I have no idea what you are attempting to do in you code.

The point I was trying to make is if you want nuBuilderPro to not save a record, have it create an error message.

Steven

nuBuilder Forum

PHP Check for Record Exists

PHP Check for Record Exists

Re: PHP Check for Record Exists

Re: PHP Check for Record Exists

Re: PHP Check for Record Exists

Re: PHP Check for Record Exists