Field Data Binding settings Bind data to fields in PDOCrud

You can set the data for different types of fields using fieldDataBinding function. You can set data directly from database table or using array or by passing select query (sql option is added in Version 4.0). It is really useful for setting data of fields like select, radio button, checkbox etc. Dropdown field option consists of two things, one is display value and other is the value saved. Display value comes from $val parameter and $key contains the value being saved. e.g <option value="$key">$val</option>. Both $key and $val can be same or different depending upon how you want to save the value in database.
Please note in case of array, if you pass numeric array then it will save index of array in database so if you want to save display value, you need to pass as associative array i.e. array with key and value where key and val can be same or different. for example numeric array $country = array("X","Y","Z"); will save 0,1,2 as per the selected value but if you want to save displayed value i.e. X,Y,Z then you need to pass associative array $country = array("X"=>"X","Y"=>"Y","Z"=>"Z");

Version 4.0 - We have added two more option.

  1. You can now pass valid select query to generate the data of fields directly by running queries.
  2. You can now combine two or more columns in the display value for example join first_name and last_name with a separator to display as name. 

  
                                $pdocrud = new PDOCrud();
                                /**
                                   * Sets data binding of the field i.e. load the field data from some datasource
                                   * @param   string  $fieldName                             field name to be bind
                                   * @param   mixed   $dataSource                            data source either tablename or array of data
                                   * @param   string  $key                                   name of col, that will serve as data key
                                   * @param   mixed   $val                                   name of col as string or array of columns, that will serve as field value
                                   * @param   string  $bind                                  whether datasource is db table or array or sql, default is db table
                                   * @param   string  $separator                             Separator string in case of $val is an array of columns. Default value is " "
                                   * @param   string  $where                                 Where condition for the datasource
                                   * @param   string  $orderby                               Order by clause for the datasource
                                   * return   object                                         Object of class
                                   */
                                $pdocrud->fieldTypes("gender", "radio");//change gender to radio button
                                $pdocrud->fieldDataBinding("gender", array("male","female"), "", "","array");//add data binding using array
                                $pdocrud->fieldTypes("country", "select");//change type to select
                                $pdocrud->fieldDataBinding("country", "country", "country_id", "country_name", "db");//add data using another table name country
                                $pdocrud->fieldTypes("state", "select");//change state to select dropdown
                                $pdocrud->fieldDataBinding("state", array("Andhra Pradesh","Bihar","Patna","Gujarat","Madhya Pradesh"), "", "","array");//add data using array in select dropdown
                                //Version 4.0 features
                                //1. Pass select query to generate the data
                                $pdocrud->fieldTypes("hobbies", "checkbox");//change field type to checkbox
                                $query = "select * from `hobbies` where `hobby_status` = 1 order by `hobby_name`";
                                $pdocrud->fieldDataBinding("hobbies", $query, "hobby_id", "hobby_name", "sql");
                                //2. Combine two or more columns in the display value 
                                $pdocrud->fieldTypes("city", "select");//change city field to select
                                //add data using another table name city and merge columns "city_code" and "city_name" with separator "-" 
                                $pdocrud->fieldDataBinding("city", "city", "city_id", array("city_code","city_name"), "db", "-");
                                echo $pdocrud->dbTable("users")->render("insertform");
                                //Version 4.2 features
                                //Add 'where' and 'orderby' statement.
                                //$pdocrud->fieldTypes("city", "select");//change city field to select
                                //add data using another table name city and merge columns "city_code" and "city_name" with separator "-" 
                                //$pdocrud->fieldDataBinding("city", "city", "city_id", array("city_code","city_name"), "db", "-", array(array("city_code","0001","=")), array("city_name"));

Field Data binding using PDOCrud