<?php
require_once 'script/pdocrud.php';

$pdocrud = new PDOCrud();
$pdomodel =  $pdocrud->getPDOModelObj();//get pdomodel object
$pdomodel->setColumns(array("currency"));
$data= $pdomodel->select("currency");

$currency= array_column ($data,'currency','currency');

//$pdocrud->formDisplayInPopup();
 $pdocrud->fieldHideLable("casino_id");
 $pdocrud->formFieldValue("casino_id", "5");//set some default value for CASINO
 $pdocrud->fieldDataAttr("casino_id", array("style"=>"display:none"));
  $pdocrud->fieldHideLable("date_sale");
 $pdocrud->formFieldValue("date_sale", "2018-01-01");//set some default value for DATE
 $pdocrud->fieldDataAttr("date_sale", array("style"=>"display:none"));

$pdocrud->where("casino_id", "2","=");
$pdocrud->where("date_sale", "2017-11-30","=");
//$pdocrud->setSettings("editbtn", false);
$pdocrud->setSettings("searchbox", false);
$pdocrud->setSettings("inlineEditbtn", true);
$pdocrud->setSettings("checkboxCol", false);
$pdocrud->setSettings("deleteMultipleBtn", false);
$pdocrud->setSettings("viewbtn", false);
$pdocrud->fieldDataBinding("casino_id", array("2"), "", "","array");
$pdocrud->fieldTypes("currency", "select");
$pdocrud->fieldDataBinding("currency",$currency,"","","array");
// also tried $pdocrud->fieldDataBinding("currency",$data,"","","array");
echo $pdocrud->dbTable("results")->render();


$drop_down_to_populate='currency';
$table_where_to_fetch_data = 'currency';
$primary_key_fetch_data_table = 'id';
$value_to_fetch_in_data_table = 'currency';

?>