Search query coming from a Dynamic form (Codeigniter)

Question

I have a problem to build a QUERY that comes from a dynamic form.

I have a search form in which the fields for search are dynamic (can be text or checkbox), or whenever a new field is added it must be possible to search for this field, someone can give me a light on how to do it?

Thank you

Answer 1

Orange, could you explain your situation better?

From what I understand, you have a single screen application and in this there are Textbox and Combobox fields, and you need to create a query to the database with these fields, when these are filled, this is it?

If yes, a simple idea.

Use an if to identify which Text or Combo has been filled or selected and fill in the field TAG with the table column name. Ex:

private void DefineNomeCampos()
    {
        comboBox1.Tag = "COL_TIPOPESSOA";
        textBox1.Tag = "COL_NOMEPESSOA";

    }
    private void PreencheQuery()
    {
        StringBuilder sbSelect = new StringBuilder();
        StringBuilder sbWhere = new StringBuilder();

        sbSelect.Append("Select ");
        if (!string.IsNullOrEmpty(textBox1.Text))
        {
            sbSelect.Append(textBox1.Tag + ",");
            sbWhere.Append(textBox1.Tag + "=" + textBox1.Text + ",");

        }
        if (Convert.ToInt32(comboBox1.SelectedValue) != -1)
        {
            sbSelect.Append(comboBox1.Tag + ",");
            sbSelect.Append(comboBox1.Tag + "," + comboBox1.SelectedText + "," );

        }
    }