Hi Angelo
First take my apologise for my mistake ;)
It shouldn't be $query_str += ", ".$_POST["id_name"];, but
$query_str .= ", ".$_POST["id_name"];
The '.' it's a concatenation of strings and variables:
if $_POST["id_name"]=15, it gives you ", 15"
The '$query_str .=' it is taken from C language - it is equivalent
to $query_str = $query_str.", ".$_POST["id_name"]
Aaa.... and don't forget about adding '' when you want to insert a
string into query: "'".$_POST["name_tx"]."'" //I always forget about
it =D//
Happy To Helped
Asia Sledzik
------ Wiadomość oryginalna ------
Od: Ângelo Marcos Rigo <angelo_rigo@xxxxxxxxxxxx>
Data: 2003-12-22 12:23
Temat: Re: [PHP] Interactive querys
:-> Thank´s Sledzik
:-> Now it is very clear! the query will just concatenate
:-> :
:-> Let me ask about the . in: .$_POST["id_name"] :-> from :
:->
:-> $query_str += ", ".$_POST["id_name"];
:->
:-> this syntax is not familiar to me yet , what it does?
:->
:-> thank´s in advance
:-> ----- Wiadomo?? oryginalna ------
:->
:->
:-> Od: Ângelo Marcos Rigo <angelo_rigo@xxxxxxxxxxxx>
:-> 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
:->
------------ 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)
