Re: Interactive querys

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(at)yahoo(dot)com(dot)br>

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(at)yahoo(dot)com(dot)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

:->

------------ 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)