fetch Information Collection information

Thursday 26 June 2008 6:37:01 pm

I have a form (using information collection) that collects the e-mail of the internaut.

I would like to query the database (inside PHP code, not in template code) to know if a determined e-mail address is already collected.

What's the best way to do that?

Should I use eZPersistentObject::fetchObjectList()? If so, how?

Thank you
Michael

Thursday 26 June 2008 10:20:05 pm

I just did it.

I will write the code I used in hope that it will help someone:

// gets DB instance			
$db = eZDB::instance();
				
// SQL
$sql = "
   SELECT 
      count( ezinfocollection_attribute.id ) as count 
   FROM 
      ezinfocollection_attribute
   WHERE 
      ezinfocollection_attribute.contentobject_attribute_id = '" . $contentObjectAttribute->attribute('id') . "'
      AND ezinfocollection_attribute.contentclass_attribute_id = '" . $contentObjectAttribute->attribute('contentclassattribute_id') . "'
      AND ezinfocollection_attribute.data_text LIKE '" . addslashes($email) . "'
				";
				
// executes query
$resArray = $db->arrayQuery( $sql );
				
// verifies if the e-mail was found
if (intval($resArray[0]['count']) > 0) {
   // found

}
// not found

Michael