X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C34F4D1B453 for ; Mon, 22 Dec 2003 12:42:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08626-05 for ; Mon, 22 Dec 2003 08:41:48 -0400 (AST) Received: from imail1.gazeta.pl (imail1.gazeta.pl [193.42.231.143]) by svr1.postgresql.org (Postfix) with ESMTP id 963B9D1B43C for ; Mon, 22 Dec 2003 08:41:44 -0400 (AST) Received: from ew10 (unverified [172.20.26.240]) by (imail1.gazeta.pl) with ESMTP id 21180355 for multiple; Mon, 22 Dec 2003 13:41:46 +0300 Message-ID: <1072096906867.ew10.ripley@gazeta.pl> Date: Mon, 22 Dec 2003 13:41:46 +0100 (CET) From: To: "Ângelo Marcos Rigo" Subject: Re: Interactive querys Cc: pgsql-php@postgresql.org In-Reply-To: <20031222112338.83525.qmail@web14812.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-mailer: (c)Agora mailer (v3.00) Organization: Portal Agory S.A. X-IP: dabrowskiego.demo.pl X-Complaints-To: abuse@gazeta.pl X-URL: http://www.gazeta.pl X-QuoteString: :-> X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char C2 hex) in message header 'To' To: "\302ngelo Marcos Ri... ^ X-Archive-Number: 200312/63 X-Sequence-Number: 2509 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 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 :-> 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)