Re: Interactive querys

------ Wiadomość oryginalna ------


Od:    Ângelo Marcos Rigo <angelo_rigo@yahoo.com.br>


Data:  2003-12-15 14:23


Temat: Re: [PHP] Interactive querys




:-> Using two textareas side by side, with the query


:-> options coming from the left?


:->


:-> =====


:-> Ângelo Marcos Rigo


---------------------------------------------


Hi Angelo


It's possible to write it using only PHP


1. First - you have to put on the web-form all the fields, that user
will use to customer his query - like:


 - checkboxes - whose correspond to columns, wich user want to put
in a query


 - text fields - where user can enter the expression used to "where"
condition


 - lists fields - which for egzample includes positions "asceding",
"descending"


 - some "hidden" fields, that will provide some addtitional
information to the script.php which will build the query


- in the tag < form action="..." > use the method=post


//I always name this fileds using full name of column + some keyword
- it helps ;)//


2. Second - you have only to build your query string - using
conditions "if..." :


start with:


$query_str = "select ";


if ($_POST["id_chbox"] = 1)


     $query_str += $_POST["id_chbox"];


if ($_POST["name_chbox"] = 1)


       $query_str += ", ".$_POST["id_name"];


..............


and so on


You can also try to make this script "universal" by using iterations
through $_POST variables - its possible to write something like


for ($n=0; n < ...;$n++)


   {


   $_POST[$cols[$n]."_chbox"]............


   }


The only minus of this method is that it can take some time :)


I hope it helps


Asia Sledzik


//sory for readers for this additional enters beetween every, but my
e-mail server put them all and I can't help for it//



------------ R E K L A M A ------------
Gotowy do drogi? Swiateczny Kalendarz SAS zaprasza!
Przez 24 dni oferujemy 24 oferty specjalne do Europy i USA.
Tylko na stronie http://www.scandinavian.net/ (wybierz Polske)