PHP validation for uniqueness

[dimoss]

Hi,

I use the following validation to validate the uniqueness of a value:

$a = (int)$formModel->_formData['fab_iperories___etos_raw'];
$b = (int)$formModel->_formData['fab_iperories___minas_raw'];
$c = $data;
$query = "SELECT count(*) FROM fab_iperories WHERE am = $c AND etos = $a AND minas = $b";$db = & JFactory::getDBO();$db->setQuery( $query );$x = (int)$db->loadResult();return $x === 0;

However the code doesn't work in F3. On the contrary works ok in F2.

Any ideas?

Thanks in advance.

Denis

 

[dimoss]

The following doesn't work either in F3:

$db = & JFactory::getDBO();$post = JRequest::get('post');
$a = (int)$post['fab_iperories___etos_raw'];
$a = (int)$post['fab_iperories___minas_raw'];
$c = $data;
$query = "SELECT count(*) FROM fab_iperories WHERE am = $c AND etos = $a AND minas = $b";
$db->setQuery( $query );$x = (int)$db->loadResult();return $x === 0;

However works in F2

Denis

 

[cheesegrits]

Have you used var_dump() to check that the data you are getting from the placeholders is what you expect?

-- hugh

 

[dimoss]

Finally after Hugh valuable help once again...!
The problem solved..
The code in case someone interested is is:

$db = JFactory::getDBO();
$etos = $formModel->getElementData('fab_iperories___etos', true);if (is_array($etos)) {$etos = $etos[0];}
$minas = $formModel->getElementData('fab_iperories___minas', true);if (is_array($minas)) {$minas = $minas[0];}
$c = $data;
$query = "SELECT count(*) FROM fab_iperories WHERE am = $c AND etos = $etos AND minas = $minas";$db->setQuery($query);$x = (int)$db->loadResult();return $x == 0;

Thanks again Hugh!