How to make form autocomplete on fmx delphi website?

Question

Delphi

this is how it is done for PC, but how to do it for FMX Android on Delphi?

var
A : Variant;
  SVal : String;
    ovElements: OleVariant;
  i: Integer;
  begin
 A := EmbeddedWB1.OleObject.Document.getElementById('theme');
  A.Value := 'old';
 
  ovElements := EmbeddedWB1.OleObject.Document.forms.item(0).elements;
  for i := 0 to (ovElements.Length - 1) do
    if (ovElements.item(i).type = 'submit') and
      (ovElements.item(i).Value = 'Переключить') then
      ovElements.item(i).Click;
 
 end;

Answer 1

.OleObject.Document.forms.item(0).elements; there is no this OleObject parameter, I don’t understand what it was replaced with ... ???

Answer 2

If the number of param_1 satisfying the condition is not very large (up to a thousand), then it is best to do it in 2 queries:

select distinct param_1 from table where param_3 is not null;
select * from table where param_1 IN (явное перечисление значений из прошлого запроса);

But in principle, the option Sergey

select * from table where param_1 IN (select param_1 from table where param_3 not null);

will also work, albeit slower

Answer 3

Writing:

$sql = "select * from table where param_1 IN (select param_3 from table where param_3 not null)";
$r =  mysql_query($sql);
    while($row = mysql_fetch_array($r)) {
         echo $row['id'];    
    }

As a result, nothing is output
. Warning: mysql_fetch_array() expects parameter 1 to be resource