• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: How to retrieve the value in PHP request select ?

How to retrieve the value in PHP request select ? 4 years 1 month ago #41117

I wrote a php in the process after treatment such as :
$db = JFactory::getDBO();
$db->setQuery("SELECT rs.`SubmissionId` FROM mbss_rsform_submissions AS rs , mbss_rsform_submission_values AS rsv1 WHERE
rs.`SubmissionId`=rsv1.`SubmissionId`
AND rs.`UserId`='".JFactory::getUser()->id."'
AND rs.`FormId`=45
AND rsv1.`FieldName`='info_nom'
AND rsv1.`Fieldvalue`='"{info_nom:value}"'
AND exists (
select true from mbss_rsform_submission_values AS rsv2 where rsv1.`SubmissionId`= rsv2.`SubmissionId`
AND `FieldName` = 'info_prenom'
AND `Fieldvalue` = '"{info_prenom:value}"'

)
group by rs.`SubmissionId` ORDER BY rs.`SubmissionId` DESC LIMIT 2");
$oldSubId = '';
if(count($db->loadColumn()) == 2){
$oldSubId = $db->loadColumn()[1];
}
if(!empty($oldSubId)){
$db->setQuery("DELETE rs,rsv FROM #__rsform_submissions AS rs ,#__rsform_submission_values AS rsv WHERE
rs.`SubmissionId`=rsv.`SubmissionId` AND rs.`SubmissionId`='".$oldSubId."'");
$db->execute();
}

What is the correct writing to retrieve the {info_nom:value} of the recorded files ? such like in the following condition => AND rsv1.`Fieldvalue`='"{info_nom:value}"'
CEO of Sereniteam SAS - Paris 15me - France
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!