Re: Interactive querys - Mailing list pgsql-php

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@yahoo.com.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@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


:->



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