Skip site navigation (1) Skip section navigation (2)

Re: Interactive querys

From: <ripley(at)gazeta(dot)pl>
To: "ngelo Marcos Rigo" <angelo_rigo(at)yahoo(dot)com(dot)br>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Interactive querys
Date: 2003-12-22 12:41:46
Message-ID: 1072096906867.ew10.ripley@gazeta.pl (view raw or flat)
Thread:
Lists: 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(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)

pgsql-php by date

Next:From: Mariusz PekalaDate: 2003-12-22 17:02:24
Subject: Re: Interactive querys
Previous:From: ripleyDate: 2003-12-22 10:46:45
Subject: Re: Interactive querys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group