Forums

I created a form with DBRead:

<?php
$user = JFactory::getUser();
return array("user_id" => $user->get("id"));
?>

Now the problem is, if a not registered user opens the form, he gets information of another (not registered) user filled the form before.
How can I give the not registered users an emty form?
Thanks for help.

Hi hcohl,

Please try this

<?php
$user = \JFactory::getUser();
if ( $user->id > 0 ) {
  return array( 'user_id' => $user->id );
} else {
  return array( ": 'AAA' = 'ZZZ' " );
}
?>

That should return an empty array for a guest.

Bob

Hallo Bob,
thank you for your answer.
But this returns error 1054 - Unknown column 'Data.AAA'.
What do I have to set for "AAA" and "ZZZ"?
HC Ohl

Thank you Bob - it works.

HC