subject:"RE\: \[PHP\] Select"

Date: Fri, 28 May 2010 12:34:55 -0400
To: aj...@alumni.iu.edu; php-general@lists.php.net
From: tedd.sperl...@gmail.com
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different
Forms

At 9:19 PM -0400 5/27/10, Alice Wei wrote:

I am not sure how to add to the page you have set up, but here is
the code with ther portion you have set up:

?php
$start = isset($_POST['start']) ? $_POST['start'] : null;
?
form action= method=post
p
Select the type of your starting point of interest:br
input type=text name=start value=?php
echo($start);? size=20 br /
Which Semster is this: select name=semester
option value=FallFall/option
option value=SpringSpring/option
option value=SummerSummer/option
/selectbr/
input type=submit name=submit value=Submit
/p
/form

Note, what I provided here does not include anything on the ajax.

Hope this answers your question.

Alice :

I didn't have a question, but here's my revision of your code:

http://www.webbytedd.com//alice1/

Please review the code and see how: 1) I captured the select value;
2) and how I used that value to focus the selected option.

You say:

Note, what I provided here does not include anything on the ajax.

I've never put anything on the ajax -- that doesn't make sense.

Ajax is simply a way to communicate from the browser to the server
and back again without requiring a browser refresh. As the user
triggers a client-side event (i.e., click, select, enter text, move a
mouse, whatever), a javascript routine then sends data to the server
to activate a server-side script, which may, or may not, return data.

For example -- with javascript turned ON please review:

http://www.webbytedd.com/a/ajax-site/

This is simply a one page template that uses an ajax routine to
retrieve data from the server to populate the page based upon what
the user triggers (i.e., the visitor clicks a navigational link).

If you will review the HTML source code, you will find a very basic
HTML template that will remain static for all three apparent pages.
If you use the FireFox browser you can review the generated HTML.

Now where did the generated HTML come from, you might ask? It came
from the server after a request was made from the client to the
server and the server responded with the correct data -- all without
requiring a browser refresh. That's an example of how ajax works.

Keep in mind that using best practices requires you to *first*
design forms to collect data WITHOUT requiring javascript and then
you can enhance the form to provide additional functionality to those
who have javascript turned on. Also keep in mind that you may not
need ajax to alter the form. You only need ajax if there is data on
the server that needs to be retrieved.

Now, please turn javascript OFF in your browser and review my page again:

http://www.webbytedd.com/a/ajax-site/

That's an example of NOT following best practices. The visitor is
provided nothing if they have javascript turned OFF.

Now considering such, what additional functionality do you want your
form to do that can't be done already?

Cheers,

tedd

Tedd,

What I am trying to find out is, when I have my form with a dependent select
menu, how can I pass the value of the select menu to another page? I have
mentioned in the initial email that if I just allow users to type stuff, it
passes the form back to itself and works. However, what I want
to do is to allow users click one radio button/checkbox, and use that value to
determine which select menu to bring up. However, the information I am only
interested in storing, is the value of the select menu and not the radio
button/checkbox.

Am I making sense here?

Alice
---
http://sperling.com http://ancientstones.com http://earthstones.com

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-28 Thread Ashley Sheridan

On Fri, 2010-05-28 at 15:00 -0400, Alice Wei wrote:

Date: Fri, 28 May 2010 12:34:55 -0400
To: aj...@alumni.iu.edu; php-general@lists.php.net
From: tedd.sperl...@gmail.com
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different
Forms

At 9:19 PM -0400 5/27/10, Alice Wei wrote:

I am not sure how to add to the page you have set up, but here is
the code with ther portion you have set up:

Note, what I provided here does not include anything on the ajax.

Hope this answers your question.

Alice :

I didn't have a question, but here's my revision of your code:

http://www.webbytedd.com//alice1/

Please review the code and see how: 1) I captured the select value;
2) and how I used that value to focus the selected option.

You say:

Note, what I provided here does not include anything on the ajax.

I've never put anything on the ajax -- that doesn't make sense.

For example -- with javascript turned ON please review:

http://www.webbytedd.com/a/ajax-site/

This is simply a one page template that uses an ajax routine to
retrieve data from the server to populate the page based upon what
the user triggers (i.e., the visitor clicks a navigational link).

Now, please turn javascript OFF in your browser and review my page again:

http://www.webbytedd.com/a/ajax-site/

That's an example of NOT following best practices. The visitor is
provided nothing if they have javascript turned OFF.

Now considering such, what additional functionality do you want your
form to do that can't be done already?

Cheers,

tedd

Tedd,

What I am trying to find out is, when I have my form with a dependent
select menu, how can I pass the value of the select menu to another page? I
have mentioned in the initial email that if I just allow users to type stuff,
it passes the form back to itself and works. However, what I want
to do is to allow users click one radio button/checkbox, and use that value
to determine which select menu to bring up. However, the information I am
only interested in storing, is the value of the select menu and not the radio
button/checkbox.

Am I making sense here?

Alice
---
http://sperling.com http://ancientstones.com http://earthstones.com

You could do this a couple of ways:

1) Have all the possible form elements you need and show the one the
user needs with Javascript
2) Use ajax to grab the select list you need based on the users
selection and add it in to the current form.

It doesn't matter if you submit more form elements than you need, just
don't use them when the form is submitted to the php script.

Thanks,
Ash
http://www.ashleysheridan.co.uk

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms
From: a...@ashleysheridan.co.uk
To: aj...@alumni.iu.edu
CC: tedd.sperl...@gmail.com; php-general@lists.php.net
Date: Fri, 28 May 2010 20:05:29 +0100

On Fri, 2010-05-28 at 15:00 -0400, Alice Wei wrote:

 Date: Fri, 28 May 2010 12:34:55 -0400
 To: aj...@alumni.iu.edu; php-general@lists.php.net
 From: tedd.sperl...@gmail.com
 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different 
 Forms

 At 9:19 PM -0400 5/27/10, Alice Wei wrote:

 I am not sure how to add to the page you have set up, but here is 
 the code with ther portion you have set up:

 ?php
$start = isset($_POST['start']) ? $_POST['start'] : null;
 ?
  form action= method=post
p
  Select the type of your starting point of interest:br
  input type=text name=start value=?php 
 echo($start);? size=20 br /
  Which Semster is this: select name=semester
  option value=FallFall/option
  option value=SpringSpring/option
  option value=SummerSummer/option
  /selectbr/
  input type=submit name=submit value=Submit 
/p
  /form

   Note, what I provided here does not include anything on the ajax.

 Hope this answers your question.

 Alice :

 I didn't have a question, but here's my revision of your code:

 http://www.webbytedd.com//alice1/

 Please review the code and see how: 1) I captured the select value; 
 2) and how I used that value to focus the selected option.

 You say:

   Note, what I provided here does not include anything on the ajax.

 I've never put anything on the ajax -- that doesn't make sense.

 Ajax is simply a way to communicate from the browser to the server 
 and back again without requiring a browser refresh. As the user 
 triggers a client-side event (i.e., click, select, enter text, move a 
 mouse, whatever), a javascript routine then sends data to the server 
 to activate a server-side script, which may, or may not, return data.

 For example -- with javascript turned ON please review:

 http://www.webbytedd.com/a/ajax-site/

 This is simply a one page template that uses an ajax routine to 
 retrieve data from the server to populate the page based upon what 
 the user triggers (i.e., the visitor clicks a navigational link).

 If you will review the HTML source code, you will find a very basic 
 HTML template that will remain static for all three apparent pages. 
 If you use the FireFox browser you can review the generated HTML.

 Now where did the generated HTML come from, you might ask? It came 
 from the server after a request was made from the client to the 
 server and the server responded with the correct data -- all without 
 requiring a browser refresh. That's an example of how ajax works.

 Keep in mind that using best practices requires you to *first* 
 design forms to collect data WITHOUT requiring javascript and then 
 you can enhance the form to provide additional functionality to those 
 who have javascript turned on. Also keep in mind that you may not 
 need ajax to alter the form. You only need ajax if there is data on 
 the server that needs to be retrieved.

 Now, please turn javascript OFF in your browser and review my page again:

 http://www.webbytedd.com/a/ajax-site/

 That's an example of NOT following best practices. The visitor is 
 provided nothing if they have javascript turned OFF.

 Now considering such, what additional functionality do you want your 
 form to do that can't be done already?

 Cheers,

 tedd

 -- 

Tedd,  

  What I am trying to find out is, when I have my form with a dependent select 
menu, how can I pass the value of the select menu to another page? I have 
mentioned in the initial email that if I just allow users to type stuff, it 
passes the form back to itself and works. However, what I want
 to do is to allow users click one radio button/checkbox, and use that value to 
determine which select menu to bring up. However, the information I am only 
interested in storing, is the value of the select menu and not the radio  
button/checkbox. 

Am I making sense here? 

Alice
 ---
 http://sperling.com  http://ancientstones.com  http://earthstones.com

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

You could do this a couple of ways:

1) Have all the possible form elements you need and show the one the user needs 
with Javascript

2) Use ajax to grab the select list you need based on the users selection and 
add it in to the current form.

It doesn't matter if you submit more form elements than you need, just don't 
use them

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-28 Thread Ashley Sheridan

On Fri, 2010-05-28 at 15:12 -0400, Alice Wei wrote:

 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two
 Different Forms
 From: a...@ashleysheridan.co.uk
 To: aj...@alumni.iu.edu
 CC: tedd.sperl...@gmail.com; php-general@lists.php.net
 Date: Fri, 28 May 2010 20:05:29 +0100

 On Fri, 2010-05-28 at 15:00 -0400, Alice Wei wrote: 

  Date: Fri, 28 May 2010 12:34:55 -0400
  To: aj...@alumni.iu.edu; php-general@lists.php.net
  From: tedd.sperl...@gmail.com
  Subject: RE: [PHP] Select Values Didn't Get Passed in From Two 
 Different Forms

  At 9:19 PM -0400 5/27/10, Alice Wei wrote:

  I am not sure how to add to the page you have set up, but here is 
  the code with ther portion you have set up:

  ?php
 $start = isset($_POST['start']) ? $_POST['start'] : null;
  ?
   form action= method=post
 p
   Select the type of your starting point of interest:br
   input type=text name=start value=?php 
  echo($start);? size=20 br /
   Which Semster is this: select name=semester
   option value=FallFall/option
   option value=SpringSpring/option
   option value=SummerSummer/option
   /selectbr/
   input type=submit name=submit value=Submit 
 /p
   /form

Note, what I provided here does not include anything on the ajax.

  Hope this answers your question.

  Alice :

  I didn't have a question, but here's my revision of your code:

  http://www.webbytedd.com//alice1/

  Please review the code and see how: 1) I captured the select value; 
  2) and how I used that value to focus the selected option.

  You say:

Note, what I provided here does not include anything on the ajax.

  I've never put anything on the ajax -- that doesn't make sense.

  Ajax is simply a way to communicate from the browser to the server 
  and back again without requiring a browser refresh. As the user 
  triggers a client-side event (i.e., click, select, enter text, move 
 a 
  mouse, whatever), a javascript routine then sends data to the 
 server 
  to activate a server-side script, which may, or may not, return 
 data.

  For example -- with javascript turned ON please review:

  http://www.webbytedd.com/a/ajax-site/

  This is simply a one page template that uses an ajax routine to 
  retrieve data from the server to populate the page based upon what 
  the user triggers (i.e., the visitor clicks a navigational link).

  If you will review the HTML source code, you will find a very basic 
  HTML template that will remain static for all three apparent 
 pages. 
  If you use the FireFox browser you can review the generated HTML.

  Now where did the generated HTML come from, you might ask? It came 
  from the server after a request was made from the client to the 
  server and the server responded with the correct data -- all 
 without 
  requiring a browser refresh. That's an example of how ajax works.

  Keep in mind that using best practices requires you to *first* 
  design forms to collect data WITHOUT requiring javascript and then 
  you can enhance the form to provide additional functionality to 
 those 
  who have javascript turned on. Also keep in mind that you may not 
  need ajax to alter the form. You only need ajax if there is data on 
  the server that needs to be retrieved.

  Now, please turn javascript OFF in your browser and review my page 
 again:

  http://www.webbytedd.com/a/ajax-site/

  That's an example of NOT following best practices. The visitor is 
  provided nothing if they have javascript turned OFF.

  Now considering such, what additional functionality do you want 
 your 
  form to do that can't be done already?

  Cheers,

  tedd

  -- 

 Tedd,  

   What I am trying to find out is, when I have my form with a 
 dependent select menu, how can I pass the value of the select menu to another 
 page? I have mentioned in the initial email that if I just allow users to 
 type stuff, it passes the form back to itself and works. However, what I want
  to do is to allow users click one radio button/checkbox, and use

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms
From: a...@ashleysheridan.co.uk
To: aj...@alumni.iu.edu
CC: tedd.sperl...@gmail.com; php-general@lists.php.net
Date: Fri, 28 May 2010 20:14:06 +0100

On Fri, 2010-05-28 at 15:12 -0400, Alice Wei wrote:

Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different 
Forms

From: a...@ashleysheridan.co.uk

To: aj...@alumni.iu.edu

CC: tedd.sperl...@gmail.com; php-general@lists.php.net

Date: Fri, 28 May 2010 20:05:29 +0100

On Fri, 2010-05-28 at 15:00 -0400, Alice Wei wrote: 

 Date: Fri, 28 May 2010 12:34:55 -0400
 To: aj...@alumni.iu.edu; php-general@lists.php.net
 From: tedd.sperl...@gmail.com
 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different 
 Forms

 At 9:19 PM -0400 5/27/10, Alice Wei wrote:

 I am not sure how to add to the page you have set up, but here is 
 the code with ther portion you have set up:

 ?php
$start = isset($_POST['start']) ? $_POST['start'] : null;
 ?
  form action= method=post
p
  Select the type of your starting point of interest:br
  input type=text name=start value=?php 
 echo($start);? size=20 br /
  Which Semster is this: select name=semester
  option value=FallFall/option
  option value=SpringSpring/option
  option value=SummerSummer/option
  /selectbr/
  input type=submit name=submit value=Submit 
/p
  /form

   Note, what I provided here does not include anything on the ajax.

 Hope this answers your question.

 Alice :

 I didn't have a question, but here's my revision of your code:

 http://www.webbytedd.com//alice1/

 Please review the code and see how: 1) I captured the select value; 
 2) and how I used that value to focus the selected option.

 You say:

   Note, what I provided here does not include anything on the ajax.

 I've never put anything on the ajax -- that doesn't make sense.

 Ajax is simply a way to communicate from the browser to the server 
 and back again without requiring a browser refresh. As the user 
 triggers a client-side event (i.e., click, select, enter text, move a 
 mouse, whatever), a javascript routine then sends data to the server 
 to activate a server-side script, which may, or may not, return data.

 For example -- with javascript turned ON please review:

 http://www.webbytedd.com/a/ajax-site/

 This is simply a one page template that uses an ajax routine to 
 retrieve data from the server to populate the page based upon what 
 the user triggers (i.e., the visitor clicks a navigational link).

 If you will review the HTML source code, you will find a very basic 
 HTML template that will remain static for all three apparent pages. 
 If you use the FireFox browser you can review the generated HTML.

 Now where did the generated HTML come from, you might ask? It came 
 from the server after a request was made from the client to the 
 server and the server responded with the correct data -- all without 
 requiring a browser refresh. That's an example of how ajax works.

 Keep in mind that using best practices requires you to *first* 
 design forms to collect data WITHOUT requiring javascript and then 
 you can enhance the form to provide additional functionality to those 
 who have javascript turned on. Also keep in mind that you may not 
 need ajax to alter the form. You only need ajax if there is data on 
 the server that needs to be retrieved.

 Now, please turn javascript OFF in your browser and review my page again:

 http://www.webbytedd.com/a/ajax-site/

 That's an example of NOT following best practices. The visitor is 
 provided nothing if they have javascript turned OFF.

 Now considering such, what additional functionality do you want your 
 form to do that can't be done already?

 Cheers,

 tedd

 -- 

Tedd,  

  What I am trying to find out is, when I have my form with a dependent select 
menu, how can I pass the value of the select menu to another page? I have 
mentioned in the initial email that if I just allow users to type stuff, it 
passes the form back to itself and works. However, what I want
 to do is to allow users click one radio button/checkbox, and use that value to 
determine which select menu to bring up. However, the information I am only 
interested in storing, is the value of the select menu and not the radio  
button/checkbox. 

Am I making sense here? 

Alice
 ---
 http://sperling.com  http://ancientstones.com  http://earthstones.com

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

You

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-28 Thread tedd


On Fri, 2010-05-28 at 15:12 -0400, Alice Wei wrote:
  What I am trying to find out is, when I have my form with a 
dependent select menu, how can I pass the value of the select menu 
to another page? I have mentioned in the initial email that if I 
just allow users to type stuff, it passes the form back to itself 
and works. However, what I want
 to do is to allow users click one radio button/checkbox, and use 
that value to determine which select menu to bring up. However, 
the information I am only interested in storing, is the value of the 
select menu and not the radio  button/checkbox.


Am I making sense here?


and

Maybe that is why I cannot pass the information on in the hidden 
value, but what have I missed here? Ajax? PHP? I am getting 
confused.


Alice


Alice:

That's the reason why I am taking this in steps instead of hitting 
you with all the buzz-words you were throwing around when we started.


If you don't know how to pass variables from one page to another, 
then why require ajax? That only complicates the process. There are 
several methods to pass variables from one page to another. You could 
have everything contained in a single page, but let's just solve your 
problem.


To pass things from one page to another has been demonstrated to you 
in the examples I provided, namely:


http://webbytedd.com//alice

and

http://webbytedd.com//alice1

Those forms are passing data as the user clicks submit.

Now, you want the user to pick a value and then pass that value to a 
different page to bring up a different select control, right?


Please review this:

http://www.webbytedd.com//alice2/index.php

That does everything you ask and it does it simply without ajax. From 
these examples you should be able to create just about anything you 
want.


Cheers,

tedd


--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

Date: Fri, 28 May 2010 17:18:21 -0400
To: aj...@alumni.iu.edu
From: tedd.sperl...@gmail.com
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different
Forms
CC: php-general@lists.php.net

On Fri, 2010-05-28 at 15:12 -0400, Alice Wei wrote:
What I am trying to find out is, when I have my form with a
dependent select menu, how can I pass the value of the select menu
to another page? I have mentioned in the initial email that if I
just allow users to type stuff, it passes the form back to itself
and works. However, what I want
to do is to allow users click one radio button/checkbox, and use
that value to determine which select menu to bring up. However,
the information I am only interested in storing, is the value of the
select menu and not the radio button/checkbox.

Am I making sense here?

and

Maybe that is why I cannot pass the information on in the hidden
value, but what have I missed here? Ajax? PHP? I am getting
confused.

Alice

Alice:

That's the reason why I am taking this in steps instead of hitting
you with all the buzz-words you were throwing around when we started.

If you don't know how to pass variables from one page to another,
then why require ajax? That only complicates the process. There are
several methods to pass variables from one page to another. You could
have everything contained in a single page, but let's just solve your
problem.

To pass things from one page to another has been demonstrated to you
in the examples I provided, namely:

http://webbytedd.com//alice

and

http://webbytedd.com//alice1/

Those forms are passing data as the user clicks submit.

Now, you want the user to pick a value and then pass that value to a
different page to bring up a different select control, right?

Please review this:

http://www.webbytedd.com//alice2/index.php

That does everything you ask and it does it simply without ajax. From
these examples you should be able to create just about anything you
want.

Cheers,

tedd

Anything I want?

Seriously, I do know how to pass a non-dynamic element from one page to
another page, but when I started researching on how to utilize dynamic menus
based on user input, I found Ajax, until this problem that I am running into
hits me.

Is there some way that I could generate dynamic select menus without
using Ajax? Or, is that asking too much?

Thanks for your help.

Alice

--
---
http://sperling.com http://ancientstones.com http://earthstones.com

_
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

From: aj...@alumni.iu.edu
To: tedd.sperl...@gmail.com
CC: php-general@lists.php.net
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different  Forms
Date: Fri, 28 May 2010 19:31:10 -0400

 Date: Fri, 28 May 2010 17:18:21 -0400
 To: aj...@alumni.iu.edu
 From: tedd.sperl...@gmail.com
 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different  
 Forms
 CC: php-general@lists.php.net

 On Fri, 2010-05-28 at 15:12 -0400, Alice Wei wrote:
What I am trying to find out is, when I have my form with a 
 dependent select menu, how can I pass the value of the select menu 
 to another page? I have mentioned in the initial email that if I 
 just allow users to type stuff, it passes the form back to itself 
 and works. However, what I want
   to do is to allow users click one radio button/checkbox, and use 
 that value to determine which select menu to bring up. However, 
 the information I am only interested in storing, is the value of the 
 select menu and not the radio  button/checkbox.

 Am I making sense here?

 and

 Maybe that is why I cannot pass the information on in the hidden 
 value, but what have I missed here? Ajax? PHP? I am getting 
 confused.

 Alice

 Alice:

 That's the reason why I am taking this in steps instead of hitting 
 you with all the buzz-words you were throwing around when we started.

 If you don't know how to pass variables from one page to another, 
 then why require ajax? That only complicates the process. There are 
 several methods to pass variables from one page to another. You could 
 have everything contained in a single page, but let's just solve your 
 problem.

 To pass things from one page to another has been demonstrated to you 
 in the examples I provided, namely:

 http://webbytedd.com//alice

 and

 http://webbytedd.com//alice1/ 

 Those forms are passing data as the user clicks submit.

 Now, you want the user to pick a value and then pass that value to a 
 different page to bring up a different select control, right?

 Please review this:

 http://www.webbytedd.com//alice2/index.php

 That does everything you ask and it does it simply without ajax. From 
 these examples you should be able to create just about anything you 
 want.

 Cheers,

 tedd

Anything I want? 

On a second note, after looking at your example again, is it possible to 
generate what is on form 4 without having to push submit button on form 3? Or, 
is that another topic in Javascript or something else?

Alice

 -- 
 ---
 http://sperling.com  http://ancientstones.com  http://earthstones.com

The New Busy is not the old busy. Search, chat and e-mail from your inbox. Get 
started.   
_
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2

Re: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-28 Thread Adam Richardson

On Fri, May 28, 2010 at 8:01 PM, Alice Wei aj...@alumni.iu.edu wrote:

From: aj...@alumni.iu.edu
To: tedd.sperl...@gmail.com
CC: php-general@lists.php.net
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different
Forms
Date: Fri, 28 May 2010 19:31:10 -0400

Am I making sense here?

and

Maybe that is why I cannot pass the information on in the hidden
value, but what have I missed here? Ajax? PHP? I am getting
confused.

Alice

Alice:

That's the reason why I am taking this in steps instead of hitting
you with all the buzz-words you were throwing around when we started.

To pass things from one page to another has been demonstrated to you
in the examples I provided, namely:

http://webbytedd.com//alice

and

http://webbytedd.com//alice1/

Those forms are passing data as the user clicks submit.

Now, you want the user to pick a value and then pass that value to a
different page to bring up a different select control, right?

Please review this:

http://www.webbytedd.com//alice2/index.php

That does everything you ask and it does it simply without ajax. From
these examples you should be able to create just about anything you
want.

Cheers,

tedd

Anything I want?

On a second note, after looking at your example again, is it possible to
generate what is on form 4 without having to push submit button on form 3?
Or, is that another topic in Javascript or something else?

Alice

--
---
http://sperling.com http://ancientstones.com http://earthstones.com

The New Busy is not the old busy. Search, chat and e-mail from your inbox.
Get started.
_
Hotmail is redefining busy with tools for the New Busy. Get more from your
inbox.

http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2

Alice,

I'm not really sure what you're looking for, but this page has examples of
forms that are dynamically generated using AJAX. Perhaps sifting through
the code (and using tools like the Web Developer plugin) will give you some
ideas:
http://nephtaliproject.com/nedit/

Adam

--
Nephtali: PHP web framework that functions beautifully
http://nephtaliproject.com

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-27 Thread tedd


At 3:50 PM -0400 5/26/10, Alice Wei wrote:


   My bad, I cannot imagine I sent that stuff. To answer your 
question, here it is,


form action= method=post
pSelect the type of your starting point of interest:br/
 input type=text name=start size=20 
maxlength=50/


   input type=submit value=submit name=submit/p
   /form


This is what is working now if I do it this way, but again, then I 
got to make sure everything is typed up properly before the form 
is submitted. Does this answer your questions by any chance?



Alice



Alice:

Okay, not bad -- here's my addition:

http://www.webbytedd.com//alice/

Please review the code. I removed the maxlength because that's 
something you should do server-side anyway. Never trust anything 
coming from the client-side.


Also note that closing the tags, such as br/ is optional -- IF -- 
you're not planning on using XML. Otherwise they will generate a W3C 
short-tags warning. However, that's not a fatal error.


Also note the Submit button statement has three attributes. Type 
states the type of input statement, value is what the button displays 
to the user (i.e., Submit) and name is the name of the variable that 
you can access via a POST/GET.


Also note how the form collects the start value from a POST and 
then repopulates the form after it has the data. This important to 
understand. Clicking the Submit button sends the form's data to the 
server which then sends it back to the browser via a refreshed form.


Also note the ternary operator I used, namely:

$start = isset($_POST['start']) ? $_POST['start'] : null;

The first time the page is viewed, POST is sampled for content. If 
there is no content, then checking for content will generate an error 
unless we first check to see if it has content, hence the isset(). If 
it doesn't have content, then the statement assigns NULL to $start. 
If it does have content, then it will assign that value to $start, 
understand?


Now, what's next? What other data do you want to collect? You 
mentioned a select control that derived its data from a database. But 
before we go to that, show me a select control working in a form 
with embedded values -- in other words, just a simple select control. 
Please add it to the form we have.


Cheers,


tedd

--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-27 Thread Alice Wei

Date: Thu, 27 May 2010 12:23:46 -0400
To: aj...@alumni.iu.edu; php-general@lists.php.net
From: tedd.sperl...@gmail.com
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

At 3:50 PM -0400 5/26/10, Alice Wei wrote:

My bad, I cannot imagine I sent that stuff. To answer your
question, here it is,

form action= method=post
pSelect the type of your starting point of interest:br/
input type=text name=start size=20
maxlength=50/

input type=submit value=submit name=submit/p
/form

This is what is working now if I do it this way, but again, then I
got to make sure everything is typed up properly before the form
is submitted. Does this answer your questions by any chance?

Alice

Alice:

Okay, not bad -- here's my addition:

http://www.webbytedd.com//alice/

Please review the code. I removed the maxlength because that's
something you should do server-side anyway. Never trust anything
coming from the client-side.

Also note that closing the tags, such as br/ is optional -- IF --
you're not planning on using XML. Otherwise they will generate a W3C
short-tags warning. However, that's not a fatal error.

Also note the Submit button statement has three attributes. Type
states the type of input statement, value is what the button displays
to the user (i.e., Submit) and name is the name of the variable that
you can access via a POST/GET.

Also note how the form collects the start value from a POST and
then repopulates the form after it has the data. This important to
understand. Clicking the Submit button sends the form's data to the
server which then sends it back to the browser via a refreshed form.

Also note the ternary operator I used, namely:

$start = isset($_POST['start']) ? $_POST['start'] : null;

The first time the page is viewed, POST is sampled for content. If
there is no content, then checking for content will generate an error
unless we first check to see if it has content, hence the isset(). If
it doesn't have content, then the statement assigns NULL to $start.
If it does have content, then it will assign that value to $start,
understand?

Now, what's next? What other data do you want to collect? You
mentioned a select control that derived its data from a database. But
before we go to that, show me a select control working in a form
with embedded values -- in other words, just a simple select control.
Please add it to the form we have.

Cheers,

tedd

I am not sure how to add to the page you have set up, but here is the code with
ther portion you have set up:

?php
$start = isset($_POST['start']) ? $_POST['start'] : null;
?
form action= method=post
p
Select the type of your starting point of interest:br
input type=text name=start value=?php echo($start);? size=20
br /
Which Semster is this: select name=semester
option value=FallFall/option
option value=SpringSpring/option
option value=SummerSummer/option
/selectbr/
input type=submit name=submit value=Submit
/p
/form

Note, what I provided here does not include anything on the ajax.

Hope this answers your question.

Alice

--
---
http://sperling.com http://ancientstones.com http://earthstones.com

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Alice Wei

On Tue, 2010-05-25 at 15:41 -0400, Alice Wei wrote:

 Date: Tue, 25 May 2010 13:40:44 -0400
 Subject: Re: [PHP] 
Select Values Didn't Get Passed in From Two Different Forms

From: marc.g...@gmail.com
 To: aj...@alumni.iu.edu

  I would like to take those values away into my third form, which 
is what you
  see with the hidden. If they are not populated,
 then how come I could see
  the drop down menus?

 So you're expecting the values selected in the first two forms to

 populate the values of the hidden fields in the third form?  Why not

 wrap the whole thing in a single form?  Do test_getrss.php and

test_getrss2.php perform anything useful or are they just hanging

 around?

No, the fields are populated in the first and second 
form, form1 and form2. What I want to do is to get the selections from 
both forms and pass them on to the third. Does this make sense? For some
 reason, the text input and the semester drop down menu result can be 
passed to process.php, but the results that I try to select from the 
first and second does not. So, the form is not passing the results of 
what I had from the radio button selections.

To illustrate, the 
second looks something like this:

echo select 
name='end_location';
while($nt=mysql_fetch_array($result)){//Array
 or records stored in $nt
echo option 
value=$nt[0]$nt[0]/option;
}
echo /select;

How
 can I pass the values of what I picked in end_location here to 
process.php?

Thanks for your help.

Alice

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

You can only pass results from both forms if you duplicate the results of one 
in the other and then submit that one. You can't submit two forms at the same 
time. Why do they have to be two forms anyway?

Well, two of them are created with Ajax that are passed through PHP, so you 
select one drop down menu are a time, as the drop down menu comes from what you 
select from a radio button. The results are dynamically. so I don't think they 
are even created at the same time. Does this help in explaining what I am 
trying to accomplish?

Thanks.

Thanks,

Ash

http://www.ashleysheridan.co.uk

You should get the Ajax to modify the first form. It's a lot easier than 
creating a second form that uses more Ajax to duplicate any selected values 
from the first. Have a look at the JQuery library, it makes a lot of the 
Javascript end a lot easier.

  I know this is not a PHP question, but could you direct me to something more 
specific on what I should do here? I am really new to Ajax. 

Thanks,

Ash

http://www.ashleysheridan.co.uk

_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Ashley Sheridan

On Wed, 2010-05-26 at 08:28 -0400, Alice Wei wrote:

On Tue, 2010-05-25 at 15:41 -0400, Alice Wei wrote:

Date: Tue, 25 May 2010 13:40:44 -0400
Subject: Re: [PHP]
Select Values Didn't Get Passed in From Two Different Forms

From: marc.g...@gmail.com
To: aj...@alumni.iu.edu

I would like to take those values away into my third form, which
is what you
see with the hidden. If they are not populated,
then how come I could see
the drop down menus?

So you're expecting the values selected in the first two forms to

populate the values of the hidden fields in the third form? Why not

wrap the whole thing in a single form? Do test_getrss.php and

test_getrss2.php perform anything useful or are they just hanging

around?

No, the fields are populated in the first and second
form, form1 and form2. What I want to do is to get the selections from
both forms and pass them on to the third. Does this make sense? For some
reason, the text input and the semester drop down menu result can be
passed to process.php, but the results that I try to select from the
first and second does not. So, the form is not passing the results of
what I had from the radio button selections.

To illustrate, the
second looks something like this:

echo select
name='end_location';
while($nt=mysql_fetch_array($result)){//Array
or records stored in $nt
echo option
value=$nt[0]$nt[0]/option;
}
echo /select;

How
can I pass the values of what I picked in end_location here to
process.php?

Thanks for your help.

Alice

You can only pass results from both forms if you duplicate the results of one
in the other and then submit that one. You can't submit two forms at the same
time. Why do they have to be two forms anyway?

Well, two of them are created with Ajax that are passed through PHP, so you
select one drop down menu are a time, as the drop down menu comes from what
you select from a radio button. The results are dynamically. so I don't think
they are even created at the same time. Does this help in explaining what I
am trying to accomplish?

Thanks.

Thanks,

Ash

http://www.ashleysheridan.co.uk

You should get the Ajax to modify the first form. It's a lot easier than
creating a second form that uses more Ajax to duplicate any selected values
from the first. Have a look at the JQuery library, it makes a lot of the
Javascript end a lot easier.

I know this is not a PHP question, but could you direct me to something
more specific on what I should do here? I am really new to Ajax.

Thanks,

Ash

http://www.ashleysheridan.co.uk

_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1

Try a google search for jquery. The first site that comes up contains
all the documentation and examples to get you started.

Thanks,
Ash
http://www.ashleysheridan.co.uk

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Bob McConnell

From: Alice Wei

 On Tue, 2010-05-25 at 15:41 -0400, Alice Wei wrote:

 Date: Tue, 25 May 2010 13:40:44 -0400
 Subject: Re: [PHP] 
 Select Values Didn't Get Passed in From Two Different Forms

 From: marc.g...@gmail.com
 To: aj...@alumni.iu.edu

  I would like to take those values away into my third form, which 
 is what you
  see with the hidden. If they are not populated,
  then how come I could see
  the drop down menus?

  So you're expecting the values selected in the first two forms to

  populate the values of the hidden fields in the third form?  Why not

  wrap the whole thing in a single form?  Do test_getrss.php and

 test_getrss2.php perform anything useful or are they just hanging

  around?

 No, the fields are populated in the first and second 
 form, form1 and form2. What I want to do is to get the selections from

 both forms and pass them on to the third. Does this make sense? For
some
  reason, the text input and the semester drop down menu result can be 
 passed to process.php, but the results that I try to select from the 
 first and second does not. So, the form is not passing the results of 
 what I had from the radio button selections.

Alice,

What you seem to be missing is that the browser, by design, will only
send the fields in the form that was submitted. If you want to change
that you need to either replace the browser with one you modified to act
the way you want, or change the page to combine all of the forms into
one. You can try to work around it using Javascript, but that will only
work for people that don't know enough to disable that primary infection
vector for malware.

Bob McConnell

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread tedd


At 9:17 PM -0400 5/25/10, Alice Wei wrote:

No, the fields are populated in the first and second
form, form1 and form2. What I want to do is to get the selections from
both forms and pass them on to the third. Does this make sense? For some
 reason, the text input and the semester drop down menu result can be
passed to process.php, but the results that I try to select from the
first and second does not. So, the form is not passing the results of
what I had from the radio button selections.

To illustrate, the
second looks something like this:


Alice:

No offense, but Looking like something isn't going to cut it.

I advise you to:

1. Show us the code. -- give us a url where your code is located.

2. Tell us what you *want* to do -- and don't show us with it looks 
something like this nonsense.


3. Get the simple stuff to work first before jumping into the harder stuff.

If you are willing to do the above, then I'll help you with your problem.

Please understand that forms are very simple with very simple rules 
to follow. Enhancing forms with javascript routines can become 
complicated very quickly. But if you can describe it, it can be done.


Cheers,

tedd

--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Alice Wei

 Date: Wed, 26 May 2010 09:19:26 -0400
 To: php-general@lists.php.net; aj...@alumni.iu.edu
 From: tedd.sperl...@gmail.com
 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different  
 Forms

 At 9:17 PM -0400 5/25/10, Alice Wei wrote:
 No, the fields are populated in the first and second
 form, form1 and form2. What I want to do is to get the selections from
 both forms and pass them on to the third. Does this make sense? For some
   reason, the text input and the semester drop down menu result can be
 passed to process.php, but the results that I try to select from the
 first and second does not. So, the form is not passing the results of
 what I had from the radio button selections.

 To illustrate, the
 second looks something like this:

 Alice:

 No offense, but Looking like something isn't going to cut it.

 I advise you to:

 1. Show us the code. -- give us a url where your code is located.

 2. Tell us what you *want* to do -- and don't show us with it looks 
 something like this nonsense.

 3. Get the simple stuff to work first before jumping into the harder stuff.

 If you are willing to do the above, then I'll help you with your problem.

 Please understand that forms are very simple with very simple rules 
 to follow. Enhancing forms with javascript routines can become 
 complicated very quickly. But if you can describe it, it can be done.

 Cheers,

 tedd

I thought I provided the whole code, but looks like it somehow got lost in the 
thread. 

Here is the main file I would like to use for my data entry:

Main:

?php
// Make a MySQL Connection
mysql_connect(localhost, xxx, xxx) or die(mysql_error());
mysql_select_db(yyy) or die(mysql_error());

//The variables posted from the PHP form
$start = $_POST[start];

?
 ul
form action= method=post
liSelect the type of your starting point of interest:br/
div id=start_menuform 
action=test_getrss.php name=form1 method=post
spaninput type=radio 
value=Apartment name=start

onclick=check(document.form1.start)/ Apartment /span
spaninput type=radio 
value=Grocery name=start

onclick=check(document.form1.start)/ Grocery /span 

/form/div/li  /ul   

  form action=process.php method=post

input type=hidden name=form1 value=?php echo 
$start?/
   input type=submit value=Submit name=submit/
input type=reset value=Reset name=reset/
/form

/body
/html

This is the script that I use to construct the drop down menu in test_getrss.php

?php
//get the q parameter from URL
// Make a MySQL Connection
mysql_connect(localhost, xxx, xxx) or die(mysql_error());
mysql_select_db(xxxe) or die(mysql_error());
$q=$_GET[q];

$query=SELECT name FROM start_from WHERE type=' . $q . ';
//find out which feed was selected
$result = mysql_query ($query);
echo select name='start_location';
// printing the list box select command

while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo option value=$nt[0]$nt[0]/option;
/* Option values are added by looping through the array */
}
echo /select;// Closing of list box 
? 

See, I am trying to get the users pick something from the select 
name=start_location and have the info in there to pass on to process.php

?php

//get the q parameter from URL

// Make a MySQL Connection

mysql_connect(localhost, xxx, xxx) or die(mysql_error());

mysql_select_db(yyy) or die(mysql_error());

$form1 = $_POST['form1'];

echo Start Location  . $form1 . br /;

?

Therefore, the radio button info. does not need to be recorded. This is not the 
only field I need to pass to process.php, which the data would be used to enter 
into a database. I am leaving what is not working in my code. I hope this helps 
in understanding what my problem may be. 

Thanks for your help. 

Alice

_
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread tedd


Alice:

You provide:


 ul
form action= method=post
liSelect the type of your starting point of interest:br/
div id=start_menuform 
action=test_getrss.php name=form1 method=post
spaninput type=radio 
value=Apartment name=start


onclick=check(document.form1.start)/ Apartment /span
spaninput type=radio 
value=Grocery name=start


onclick=check(document.form1.start)/ Grocery 
/span   
/form/div/li  /ul  


  form action=process.php method=post
 
input type=hidden name=form1 
value=?php echo $start?/

   input type=submit value=Submit name=submit/
input type=reset value=Reset name=reset/
/form

/body

/html



You also state:


 I hope this helps in understanding what my problem may be.


It's very apparent that your problem is multifold and to solve it we 
need to take the solution in steps.


First, the above HTML code is just plain horrible -- and that's just 
html part or the problem -- let alone the more complicated 
php/mysql/javascript coding.


If that is the best html code you can write, then I suggest that you 
go back to learn html before learning anything else.


So, your assignment (if you want me to continue to help) is to create 
a simple form to collect the data you want. Nothing fancy, just a 
simple form -- can you do that?


The assignment is in your court. If you can show you can do that, 
then we'll proceed to the next step.


Cheers,

tedd

--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Alice Wei

 Date: Wed, 26 May 2010 15:36:18 -0400
 To: php-general@lists.php.net; aj...@alumni.iu.edu
 From: tedd.sperl...@gmail.com
 Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

 Alice:

 You provide:

  ul
  form action= method=post
  liSelect the type of your starting point of interest:br/
  div id=start_menuform 
 action=test_getrss.php name=form1 method=post
  spaninput type=radio 
 value=Apartment name=start

 onclick=check(document.form1.start)/ Apartment /span
  spaninput type=radio 
 value=Grocery name=start

 onclick=check(document.form1.start)/ Grocery 
 /span 
  /form/div/li /ul 

  form action=process.php method=post

  input type=hidden name=form1 
 value=?php echo $start?/
  input type=submit value=Submit name=submit/
  input type=reset value=Reset name=reset/
  /form

 /body
 /html

   My bad, I cannot imagine I sent that stuff. To answer your question, here it 
is, 

form action= method=post
pSelect the type of your starting point of interest:br/
 input type=text name=start size=20 maxlength=50/

   input type=submit value=submit name=submit/p
   /form

This is what is working now if I do it this way, but again, then I got to make 
sure everything is typed up properly before the form is submitted. Does this 
answer your questions by any chance?

Thanks for your help.

Alice

 You also state:

  I hope this helps in understanding what my problem may be.

 It's very apparent that your problem is multifold and to solve it we 
 need to take the solution in steps.

 First, the above HTML code is just plain horrible -- and that's just 
 html part or the problem -- let alone the more complicated 
 php/mysql/javascript coding.

 If that is the best html code you can write, then I suggest that you 
 go back to learn html before learning anything else.

 So, your assignment (if you want me to continue to help) is to create 
 a simple form to collect the data you want. Nothing fancy, just a 
 simple form -- can you do that?

 The assignment is in your court. If you can show you can do that, 
 then we'll proceed to the next step.

 Cheers,

 tedd

 -- 
 ---
 http://sperling.com http://ancientstones.com http://earthstones.com

_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccountocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4

Re: [PHP] Select Values Didn't Get Passed in From Two DifferentForms

2010-05-26 Thread Al

On 5/26/2010 3:50 PM, Alice Wei wrote:

Date: Wed, 26 May 2010 15:36:18 -0400
To: php-general@lists.php.net; aj...@alumni.iu.edu
From: tedd.sperl...@gmail.com
Subject: RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

Alice:

You provide:

ul
form action= method=post
liSelect the type of your starting point of interest:br/
div id=start_menuform
action=test_getrss.php name=form1 method=post
spaninput type=radio
value=Apartment name=start

onclick=check(document.form1.start)/  Apartment/span
spaninput type=radio
value=Grocery name=start

onclick=check(document.form1.start)/  Grocery
/span
/form/div/li  /ul

form action=process.php method=post

input type=hidden name=form1
value=?php echo $start?/
input type=submit value=Submit name=submit/
input type=reset value=Reset name=reset/
/form

/body
/html

My bad, I cannot imagine I sent that stuff. To answer your question, here 
it is,

 form action= method=post
 pSelect the type of your starting point of interest:br/
  input type=text name=start size=20 maxlength=50/

input type=submit value=submit name=submit/p
/form

This is what is working now if I do it this way, but again, then I got to make sure 
everything is typed up properly before the form is submitted. Does this 
answer your questions by any chance?

Thanks for your help.

Alice

You also state:

I hope this helps in understanding what my problem may be.

It's very apparent that your problem is multifold and to solve it we
need to take the solution in steps.

First, the above HTML code is just plain horrible -- and that's just
html part or the problem -- let alone the more complicated
php/mysql/javascript coding.

If that is the best html code you can write, then I suggest that you
go back to learn html before learning anything else.

So, your assignment (if you want me to continue to help) is to create
a simple form to collect the data you want. Nothing fancy, just a
simple form -- can you do that?

The assignment is in your court. If you can show you can do that,
then we'll proceed to the next step.

Cheers,

tedd

--
---
http://sperling.com http://ancientstones.com http://earthstones.com

_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccountocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4

Alice:

First, always make certain your html code is perfect. Use W3C's validator. 
http://validator.w3.org/

I recommend html 1.1 It's really not much extra effort and helps greatly to 
insure compatibility with all modern browsers.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-26 Thread Nisse Engström

On Wed, 26 May 2010 11:02:10 -0400, Alice Wei wrote:

[De-indented to preserve sanity]

  ul
   form action= method=post

Bzzt. Only li elements can be children of ul.

   liSelect the type of your starting point of interest:br/
div id=start_menu
 form action=test_getrss.php name=form1 method=post

Bzzt. You didn't close the previous form. You can *not*
have nested form elements.

  spaninput type=radio value=Apartment name=start
   onclick=check(document.form1.start)/ Apartment /span
  spaninput type=radio value=Grocery name=start
   onclick=check(document.form1.start)/ Grocery /span 


Bzzt. Non-standard DOM references. Use

check(document.forms.form1.elements.start)
or
check(this.form.elements.start)
or
check(this)

Note that the first two will pass a collection of
elements because you have two controls with the
same name. The third will pass a single element.

 /form/div/li
  /ul   
 
  form action=process.php method=post
   
   input type=hidden name=form1 value=?php echo $start?/
   input type=submit value=Submit name=submit/
   input type=reset value=Reset name=reset/
  /form

Bzzt. An input control with the same name as one of the
  forms? Wasn't it confusing enough already?


/Nisse

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-25 Thread Alice Wei

 Date: Tue, 25 May 2010 13:40:44 -0400
 Subject: Re: [PHP] 
Select Values Didn't Get Passed in From Two Different Forms

From: marc.g...@gmail.com
 To: aj...@alumni.iu.edu

  I would like to take those values away into my third form, which 
is what you
  see with the hidden. If they are not populated,
 then how come I could see
  the drop down menus?

 So you're expecting the values selected in the first two forms to

 populate the values of the hidden fields in the third form?  Why not

 wrap the whole thing in a single form?  Do test_getrss.php and

test_getrss2.php perform anything useful or are they just hanging

 around?

No, the fields are populated in the first and second 
form, form1 and form2. What I want to do is to get the selections from 
both forms and pass them on to the third. Does this make sense? For some
 reason, the text input and the semester drop down menu result can be 
passed to process.php, but the results that I try to select from the 
first and second does not. So, the form is not passing the results of 
what I had from the radio button selections.

To illustrate, the 
second looks something like this:

echo select 
name='end_location';
while($nt=mysql_fetch_array($result)){//Array
 or records stored in $nt
echo option 
value=$nt[0]$nt[0]/option;
}
echo /select;

How
 can I pass the values of what I picked in end_location here to 
process.php?

Thanks for your help.

Alice

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

RE: [PHP] Select Values Didn't Get Passed in From Two Different Forms

2010-05-25 Thread Edwin

Hi Adam,
I am not sure this would help but does echo command end with semi colon ;
?. input type=hidden name=form2
 value=?php echo $end?/ 

Maybe the echo is having some issue? Else, you could try passing the
variables as method = get and view the variables in
Ur address bar

regards,
Edwin.

-Original Message-
From: Adam Richardson [mailto:simples...@gmail.com] 
Sent: Wednesday, May 26, 2010 1:31 AM
To: php-general@lists.php.net
Subject: Re: [PHP] Select Values Didn't Get Passed in From Two Different
Forms

On Tue, May 25, 2010 at 1:17 PM, Alice Wei aj...@alumni.iu.edu wrote:


 Hi,

  It is kind of difficult to explain what I am trying to do here, I will
 provide the form here to give a better idea.

  ul
liSelect the type of your starting point of
 interest:br/
div id=start_menuform
 action=test_getrss.php name=form1 method=post
spaninput type=radio
 value=Apartment name=start

  onclick=check(document.form1.start)/ Apartment /span
spaninput type=radio
 value=Grocery name=start

  onclick=check(document.form1.start)/ Grocery /span
spaninput type=radio
 value=Drugstore name=start

  onclick=check(document.form1.start)/ Drug Store /span
/form/div/li
liSelect the type of your ending point of
 interest:br/
div id=end_menuform
 action=test_getrss2.php name=form2 method=post
spaninput type=radio
 value=Apartment name=end

  onclick=check2(document.form2.end)/ Apartment /span
spaninput type=radio
 value=Grocery name=end

  onclick=check2(document.form2.end)/ Grocery /span
spaninput type=radio
 value=Drugstore name=end

  onclick=check2(document.form2.end)/ Drug Store /span
/form/div/li
   form action=process.php method=post
liStart Time: input type=text size=12
 name=start_time//li
liArrive Time: input type=text size=12
 name=end_time//li
liWhich Semster is this: select name=semester
option value=FallFall/option
option value=SpringSpring/option
option value=SummerSummer/option
/selectbr//li
input type=hidden name=form1 value=?php echo
 $start?/
input type=hidden name=form2
 value=?php echo $end?/
li style=list-style:noneinput type=submit
 value=Submit name=submit/
input type=reset value=Reset
 name=reset//form

/ul

 For some reason, when I pass in the output with process.php, the hidden
 input does not get passed in. Here is the process.php:

 ?php
 //get the q parameter from URL

 $start_time = $_POST['start_time'];
 $end_time = $_POST['end_time'];
 $semester = $_POST['semester'];
 $form1 = $_POST['form1'];
 $form2 = $_POST['form2'];

 echo Start Time  . $start_time . br /;
 echo End Time  . $end_time . br /;
 echo Semester  . $semester . br /;
 echo Start Location  . $form1 . br /;
 echo End Location  . $form2 . br /;

 ?

 I get values for start_time, end_time and semester, but not the last two
 values. What have I done wrong here?

 Thanks for your help.

 Alice


 _
 The New Busy is not the old busy. Search, chat and e-mail from your inbox.


http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:W
L:en-US:WM_HMP:042010_3


Where are you setting the variables $start and $end?

Adam

-- 
Nephtali:  PHP web framework that functions beautifully
http://nephtaliproject.com


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Phpster






On Jul 1, 2009, at 10:56 AM, Miller, Terion tmil...@springfi.gannett.com 
 wrote:



Why doesn't this work?


   $query = SELECT * FROM `restaurants` WHERE name ='$ucName' AND
address = '$ucAddress'   ;

$result = mysql_query($query) or die(mysql_error());


 echo $result;
$row = mysql_fetch_array ($result);



$sql = INSERT INTO `restaurants` (name, address, inDate, inType,  
notes,

critical, cviolations, noncritical)  VALUES ( ;
$sql .=  '$ucName',
'$ucAddress', '$inDate', '$inType', '$notes', '$critical',
'$cleanViolations', '$noncritical');



   $result = mysql_query($sql) or die(mysql_error());

The error I keep getting is:

You have an error in your SQL syntax; check the manual that  
corresponds to

your MySQL server version for the right syntax to use

And I have gone in the mySQL panel and let it make the query so  
I'm

really stumped why it hangs ...



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Try removing the backticks from the tablename, I have found that if  
you include the backticks around the table name and not the field  
names, mysql will throw the occassional fit.


Bastien

Sent from my iPod 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Andrew Ballard

On Wed, Jul 1, 2009 at 10:56 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
 Why doesn't this work?


    $query = SELECT * FROM `restaurants` WHERE name ='$ucName' AND
 address = '$ucAddress'   ;

 $result = mysql_query($query) or die(mysql_error());


  echo $result;
     $row = mysql_fetch_array ($result);



  $sql = INSERT INTO `restaurants` (name, address, inDate, inType, notes,
 critical, cviolations, noncritical)  VALUES ( ;
     $sql .=  '$ucName',
 '$ucAddress', '$inDate', '$inType', '$notes', '$critical',
 '$cleanViolations', '$noncritical');



        $result = mysql_query($sql) or die(mysql_error());

 The error I keep getting is:

 You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use

 And I have gone in the mySQL panel and let it make the query so I'm
 really stumped why it hangs ...




The last example you posted said:

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 's Roast Beef Restaurant #9459', ' 1833 W Republic Rd ',
'3/2/09', '' at line 1

This indicated that the value for $ucName contained an
apostrophe/single-quote character. (Perhaps it was supposed to be
Arby's Roast Beef Restaurant #9459?).

Try this:

?php

$data = array($ucName, $ucAddress, $inDate, $inType, $notes,
$critical, $cleanViolations, $noncritical);

$sql = vprintf(INSERT INTO `restaurants` (name, address, inDate,
inType, notes, critical, cviolations, noncritical) VALUES ('%s', '%s',
'%s', '%s', '%s', '%s', '%s', '%s'),
array_map('mysql_real_escape_string', $data));

$result = mysql_query($sql) or die(mysql_error());

?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion




On 7/1/09 10:06 AM, Phpster phps...@gmail.com wrote:






On Jul 1, 2009, at 10:56 AM, Miller, Terion tmil...@springfi.gannett.com
  wrote:

 Why doesn't this work?


$query = SELECT * FROM `restaurants` WHERE name ='$ucName' AND
 address = '$ucAddress'   ;

 $result = mysql_query($query) or die(mysql_error());


  echo $result;
 $row = mysql_fetch_array ($result);



 $sql = INSERT INTO `restaurants` (name, address, inDate, inType,
 notes,
 critical, cviolations, noncritical)  VALUES ( ;
 $sql .=  '$ucName',
 '$ucAddress', '$inDate', '$inType', '$notes', '$critical',
 '$cleanViolations', '$noncritical');



$result = mysql_query($sql) or die(mysql_error());

 The error I keep getting is:

 You have an error in your SQL syntax; check the manual that
 corresponds to
 your MySQL server version for the right syntax to use

 And I have gone in the mySQL panel and let it make the query so
 I'm
 really stumped why it hangs ...



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


Try removing the backticks from the tablename, I have found that if
you include the backticks around the table name and not the field
names, mysql will throw the occassional fit.

Bastien

Sent from my iPod

Removed them and still getting the same error
It returns one record then spits out the error...weird.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Andrew Ballard

On Wed, Jul 1, 2009 at 11:23 AM, Andrew Ballardaball...@gmail.com wrote:
 On Wed, Jul 1, 2009 at 10:56 AM, Miller,
 Teriontmil...@springfi.gannett.com wrote:
 Why doesn't this work?


    $query = SELECT * FROM `restaurants` WHERE name ='$ucName' AND
 address = '$ucAddress'   ;

 $result = mysql_query($query) or die(mysql_error());


  echo $result;
     $row = mysql_fetch_array ($result);



  $sql = INSERT INTO `restaurants` (name, address, inDate, inType, notes,
 critical, cviolations, noncritical)  VALUES ( ;
     $sql .=  '$ucName',
 '$ucAddress', '$inDate', '$inType', '$notes', '$critical',
 '$cleanViolations', '$noncritical');



        $result = mysql_query($sql) or die(mysql_error());

 The error I keep getting is:

 You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use

 And I have gone in the mySQL panel and let it make the query so I'm
 really stumped why it hangs ...




 The last example you posted said:

 You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use
 near 's Roast Beef Restaurant #9459', ' 1833 W Republic Rd ',
 '3/2/09', '' at line 1

 This indicated that the value for $ucName contained an
 apostrophe/single-quote character. (Perhaps it was supposed to be
 Arby's Roast Beef Restaurant #9459?).

 Try this:

 ?php

 $data = array($ucName, $ucAddress, $inDate, $inType, $notes,
 $critical, $cleanViolations, $noncritical);

 $sql = vprintf(INSERT INTO `restaurants` (name, address, inDate,
 inType, notes, critical, cviolations, noncritical) VALUES ('%s', '%s',
 '%s', '%s', '%s', '%s', '%s', '%s'),
 array_map('mysql_real_escape_string', $data));

 $result = mysql_query($sql) or die(mysql_error());

 ?


oops = make that vsprintf(), not vprintf();

Andrew

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select List/Menu

2009-04-17 Thread Richard Heyes

 in VBSCRIPT

In what?

Use [] at the end of your selects name:

select name=mySelect[]
   ...
/select

-- 
Richard Heyes

HTML5 Canvas graphing for Firefox, Chrome, Opera and Safari:
http://www.rgraph.net (Updated April 11th)

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Query with Multiple Optional Values

2009-03-22 Thread Robert Cummings

On Sun, 2009-03-22 at 09:22 +0800, Virgilio Quilario wrote:
  Trying to find best way to accomplish following scenario.  Looking to 
  search
  inventory through a POST form, have the following optional fields to search
  by: Product Name, Color, Size, and Status.  Search maybe for the Product
  Name and/or Color or they may search for just the Color or all 4 fields.  I
  am trying to find the most efficient way to do this without having 100
  different if statements.
 
  ?php
 
  $where = array( '1 = 1' );
 
  if( !empty( $_POST['name'] ) )
  {
 where[] = 'name = '.$db-quote( $_POST['name'] );
  }
 
  if( !empty( $_POST['colour'] ) )
  {
 where[] = 'colour = '.$db-quote( $_POST['colour'] );
  }
 
  if( !empty( $_POST['size'] ) )
  {
 where[] = 'size = '.$db-quote( $_POST['size'] );
  }
 
  if( !empty( $_POST['status'] ) )
  {
 where[] = 'status = '.$db-quote( $_POST['status'] );
  }
 
  $query =
 SELECT 
.* 
.FROM 
.inventory 
.WHERE 
.(.implode( ) AND (, $where ).);
 
  ?
 
  Cheers,
  Rob.
 
 Yep, that's the way to do it.
 Or you may do it this way.
 
 $fields = array('name','colour','size','status');
 foreach ($_POST as $name = $value) {
   if (empty($value)) continue;
   if (!in_array($name, $fields, TRUE)) continue;
   $where[] = $name . '=' . $db-quote($value);
 }
 
 which is more compact and useful when you have 100 different optional fields.

As long as your form field names are the same as your database field
names. Also as long as you don't need to post process the submitted
values in any way :)

Cheers,
Rob.
-- 
http://www.interjinn.com
Application and Templating Framework for PHP


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Query with Multiple Optional Values

2009-03-21 Thread Robert Cummings

On Sat, 2009-03-21 at 10:30 -0700, ben...@gmail.com wrote:
 Trying to find best way to accomplish following scenario.  Looking to search
 inventory through a POST form, have the following optional fields to search
 by: Product Name, Color, Size, and Status.  Search maybe for the Product
 Name and/or Color or they may search for just the Color or all 4 fields.  I
 am trying to find the most efficient way to do this without having 100
 different if statements.

?php

$where = array( '1 = 1' );

if( !empty( $_POST['name'] ) )
{
where[] = 'name = '.$db-quote( $_POST['name'] );
}

if( !empty( $_POST['colour'] ) )
{
where[] = 'colour = '.$db-quote( $_POST['colour'] );
}

if( !empty( $_POST['size'] ) )
{
where[] = 'size = '.$db-quote( $_POST['size'] );
}

if( !empty( $_POST['status'] ) )
{
where[] = 'status = '.$db-quote( $_POST['status'] );
}

$query =
SELECT 
   .* 
   .FROM 
   .inventory 
   .WHERE 
   .(.implode( ) AND (, $where ).);

?

Cheers,
Rob.
-- 
http://www.interjinn.com
Application and Templating Framework for PHP


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Query with Multiple Optional Values

2009-03-21 Thread Virgilio Quilario

 Trying to find best way to accomplish following scenario.  Looking to search
 inventory through a POST form, have the following optional fields to search
 by: Product Name, Color, Size, and Status.  Search maybe for the Product
 Name and/or Color or they may search for just the Color or all 4 fields.  I
 am trying to find the most efficient way to do this without having 100
 different if statements.

 ?php

 $where = array( '1 = 1' );

 if( !empty( $_POST['name'] ) )
 {
    where[] = 'name = '.$db-quote( $_POST['name'] );
 }

 if( !empty( $_POST['colour'] ) )
 {
    where[] = 'colour = '.$db-quote( $_POST['colour'] );
 }

 if( !empty( $_POST['size'] ) )
 {
    where[] = 'size = '.$db-quote( $_POST['size'] );
 }

 if( !empty( $_POST['status'] ) )
 {
    where[] = 'status = '.$db-quote( $_POST['status'] );
 }

 $query =
    SELECT 
   .    * 
   .FROM 
   .    inventory 
   .WHERE 
   .    (.implode( ) AND (, $where ).);

 ?

 Cheers,
 Rob.

Yep, that's the way to do it.
Or you may do it this way.

$fields = array('name','colour','size','status');
foreach ($_POST as $name = $value) {
  if (empty($value)) continue;
  if (!in_array($name, $fields, TRUE)) continue;
  $where[] = $name . '=' . $db-quote($value);
}

which is more compact and useful when you have 100 different optional fields.

Virgil
http://www.jampmark.com
Free tips, tutorials, innovative tools and techniques useful for
building and improving web sites.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SELECT into array of arrays

2008-12-03 Thread Yeti

 How should I proceed? Thanks in advance for any suggestions.

Since you are looping through the result already, why not do it this way ..

$combinedArray = array();
for ($i=0;$icount($myArray);$i++) {

$sql = SELECT study,symbol FROM test WHERE study IN ('$myArray[$i]');
$result = mysql_query($sql);

if(mysql_num_rows($result)  0) {
   while ($myrow = mysql_fetch_array($result)) {
   if (in_array($myrow['study'], $myArray))
$combinedArray[$myrow['study']][] = $myrow['symbol'];
   }
}
}

You should get an array like this ...
array(b2008 = array(A, B, C, D), b2005 = array(A, B, E))

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SELECT into array of arrays

2008-12-03 Thread Yeti

Correcting myself now ..

$myArray = array('b2005', 'b2008');
$sql = SELECT study,symbol FROM test WHERE study IN ('$myArray[$i]');
$result = mysql_query($sql);

if(mysql_num_rows($result)  0) {
  while ($myrow = mysql_fetch_array($result)) {
  if (in_array($myrow['study'], $myArray))
$combinedArray[$myrow['study']][] = $myrow['symbol'];
  }
}

Forgot to get rid of the first for loop

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SELECT into array of arrays

2008-12-03 Thread Andrej Kastrin


Thanks Yeti, it works.

Best, Andrej

Yeti wrote:

Correcting myself now ..

$myArray = array('b2005', 'b2008');
$sql = SELECT study,symbol FROM test WHERE study IN ('$myArray[$i]');
$result = mysql_query($sql);

if(mysql_num_rows($result)  0) {
  while ($myrow = mysql_fetch_array($result)) {
  if (in_array($myrow['study'], $myArray))
$combinedArray[$myrow['study']][] = $myrow['symbol'];
  }
}

Forgot to get rid of the first for loop


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SELECT into array of arrays

2008-12-03 Thread ceo


I actually would do more like:



$myArray[$study][$symbol] = true;



No need to call in_array.



Probably won't matter, really, but it's a good practice for when you end up 
doing the same kind of code for an array with thousands of elements.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SELECT into array of arrays

2008-12-03 Thread Yeti

And yet another thing i have overseen in my statement ..
If you remove the first for loop, also change the sql query. But I'm
sure you saw that already

NEW QUERY:
$sql = SELECT study,symbol FROM test WHERE study IN ('.implode(', ',
$myArray).');

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS

2007-12-18 Thread Stut


VamVan wrote:

Please apologize for sending this question to PHP forums.


If you know this already why ask the question here? Also, this is not a 
forum.



But I would appreciate it very much if some could please help me styling
select mutiple in HTMl with CSS?

I have .selectmulti { border: 1px solid #c9c9c9 } this code but it only
works in firefox How can I make this work in IE?

And also I want to change the selected color.


AFAIK this can't be done without some very nasty code due to the way IE 
renders select elements. Google has the answer if you really want it.


-Stut

--
http://stut.net/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS OT

2007-12-18 Thread Børge Holen

On Tuesday 18 December 2007 20:03:53 Stut wrote:
 VamVan wrote:
  Please apologize for sending this question to PHP forums.

 If you know this already why ask the question here? Also, this is not a
 forum.

  But I would appreciate it very much if some could please help me styling
  select mutiple in HTMl with CSS?
 
  I have .selectmulti { border: 1px solid #c9c9c9 } this code but it only
  works in firefox How can I make this work in IE?
 
  And also I want to change the selected color.

 AFAIK this can't be done without some very nasty code due to the way IE
 renders select elements. Google has the answer if you really want it.

Trinity renders shit, but for gods sake I would prefer if gecko would render 
atleast acid2 and keep up with the demands of the stylists, before they call 
themselves better than others. But then again, neither webkit or khtml is as 
versatile as the other two.
Anyone with thoughts on opera...


 -Stut

 --
 http://stut.net/



-- 
---
Børge Holen
http://www.arivene.net

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS OT

2007-12-18 Thread Dave Goodchild

Why not try a css list? css-discuss for example?

On Dec 18, 2007 8:06 PM, Børge Holen [EMAIL PROTECTED] wrote:

 On Tuesday 18 December 2007 20:03:53 Stut wrote:
  VamVan wrote:
   Please apologize for sending this question to PHP forums.
 
  If you know this already why ask the question here? Also, this is not a
  forum.
 
   But I would appreciate it very much if some could please help me
 styling
   select mutiple in HTMl with CSS?
  
   I have .selectmulti { border: 1px solid #c9c9c9 } this code but it
 only
   works in firefox How can I make this work in IE?
  
   And also I want to change the selected color.
 
  AFAIK this can't be done without some very nasty code due to the way IE
  renders select elements. Google has the answer if you really want it.

 Trinity renders shit, but for gods sake I would prefer if gecko would
 render
 atleast acid2 and keep up with the demands of the stylists, before they
 call
 themselves better than others. But then again, neither webkit or khtml is
 as
 versatile as the other two.
 Anyone with thoughts on opera...

 
  -Stut
 
  --
  http://stut.net/



 --
 ---
 Børge Holen
 http://www.arivene.net

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS OT

2007-12-18 Thread Børge Holen

On Tuesday 18 December 2007 21:16:46 you wrote:
 Why not try a css list? css-discuss for example?

Yes why not?


 On Dec 18, 2007 8:06 PM, Børge Holen [EMAIL PROTECTED] wrote:
  On Tuesday 18 December 2007 20:03:53 Stut wrote:
   VamVan wrote:
Please apologize for sending this question to PHP forums.
  
   If you know this already why ask the question here? Also, this is not a
   forum.
  
But I would appreciate it very much if some could please help me
 
  styling
 
select mutiple in HTMl with CSS?
   
I have .selectmulti { border: 1px solid #c9c9c9 } this code but it
 
  only
 
works in firefox How can I make this work in IE?
   
And also I want to change the selected color.
  
   AFAIK this can't be done without some very nasty code due to the way IE
   renders select elements. Google has the answer if you really want it.
 
  Trinity renders shit, but for gods sake I would prefer if gecko would
  render
  atleast acid2 and keep up with the demands of the stylists, before they
  call
  themselves better than others. But then again, neither webkit or khtml is
  as
  versatile as the other two.
  Anyone with thoughts on opera...
 
   -Stut
  
   --
   http://stut.net/
 
  --
  ---
  Børge Holen
  http://www.arivene.net
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php



-- 
---
Børge Holen
http://www.arivene.net

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS OT

2007-12-18 Thread Richard Lynch

On Tue, December 18, 2007 2:06 pm, Børge Holen wrote:
 On Tuesday 18 December 2007 20:03:53 Stut wrote:
 VamVan wrote:
  Please apologize for sending this question to PHP forums.

 If you know this already why ask the question here? Also, this is
 not a
 forum.

  But I would appreciate it very much if some could please help me
 styling
  select mutiple in HTMl with CSS?
 
  I have .selectmulti { border: 1px solid #c9c9c9 } this code but it
 only
  works in firefox How can I make this work in IE?
 
  And also I want to change the selected color.

 AFAIK this can't be done without some very nasty code due to the way
 IE
 renders select elements. Google has the answer if you really want
 it.

 Trinity renders shit, but for gods sake I would prefer if gecko would
 render
 atleast acid2 and keep up with the demands of the stylists, before
 they call
 themselves better than others. But then again, neither webkit or khtml
 is as
 versatile as the other two.
 Anyone with thoughts on opera...

All the browsers suck.

They are all rushing half-baked features to market instead of
focussing on quality user experience.

Opera just sucks in different ways.  No worse, no better.

ymmv

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select Box CSS OT

2007-12-18 Thread Børge Holen

On Wednesday 19 December 2007 03:59:11 Richard Lynch wrote:
 On Tue, December 18, 2007 2:06 pm, Børge Holen wrote:
  On Tuesday 18 December 2007 20:03:53 Stut wrote:
  VamVan wrote:
   Please apologize for sending this question to PHP forums.
 
  If you know this already why ask the question here? Also, this is
  not a
  forum.
 
   But I would appreciate it very much if some could please help me
 
  styling
 
   select mutiple in HTMl with CSS?
  
   I have .selectmulti { border: 1px solid #c9c9c9 } this code but it
 
  only
 
   works in firefox How can I make this work in IE?
  
   And also I want to change the selected color.
 
  AFAIK this can't be done without some very nasty code due to the way
  IE
  renders select elements. Google has the answer if you really want
  it.
 
  Trinity renders shit, but for gods sake I would prefer if gecko would
  render
  atleast acid2 and keep up with the demands of the stylists, before
  they call
  themselves better than others. But then again, neither webkit or khtml
  is as
  versatile as the other two.
  Anyone with thoughts on opera...

 All the browsers suck.

 They are all rushing half-baked features to market instead of
 focussing on quality user experience.

 Opera just sucks in different ways.  No worse, no better.

 ymmv

lol, the suckiness scale close to tips to the point where it almost f*s up on 
serverside ;D


 --
 Some people have a gift link here.
 Know what I want?
 I want you to buy a CD from some indie artist.
 http://cdbaby.com/from/lynch
 Yeah, I get a buck. So?



-- 
---
Børge Holen
http://www.arivene.net

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-31 Thread Richard Lynch

On Tue, January 30, 2007 4:14 pm, nitrox . wrote:
Richard, ive included your suggested code and now my php script is
working
properly. But I dont want to be a php copy/paste newb who has no clue
of how
things are working. If its not too much would you (or anybody) give a
brief
explanation of what this code is doing? Or are there any tutorials
online
that I can read that will educate me on this? Thanks again to all for
your
replies. Ive saved them all for future reference.

atleast this part: $user_id = mysql_real_escape_string((int)
$_GET['user_id']);

$_GET is an array which has all the values from the URL.

For example, this URL:
http://example.com/yourscript.php?user_id=42
would cause PHP to pre-build this for you:
$_GET['user_id'] = 42;

If you didn't care about SECURITY, you could just do:
$user_id = $_GET['user_id'];
and go on your merry way.

All the rest of the stuff is about SECURITY.

Bad Guys know that you are probably using that user_id in an SQL
query, and will do mean things like:
http://example.com/yourscript.php?user_id=NULL
http://example.com/yourscript.php?user_id=
http://example.com/yourscript.php?user_id[]=
http://example.com/yourscript.php?user_id=1
http://example.com/yourscript.php?user_id=reallylongstringtocauseabufferoverflowfollowedbynastyexecutablecode
http://example.com/yourscript.php?user_id=42 OR user_id IN (update
mysql.users set password = password('password') where user = 'root')
.
.
.
in attempts to break into your website/webserver or otherwise wreak
havoc.

I did not URL encode the value in that last URL for demonstrative
purposes. Plus most browsers fix that for you these days anyway. And
I don't know if any SQL engine would actually *DO* that, but it's sort
of the idea of much more complicated things that could work.

So, to tear apart the rest.

(int) in PHP will type-cast a value to an integer. This means that if
you do:
$user_id = (int) $_GET['user_id'];
you are immediately protected from most of the hacks above, since you
are forcing the $user_id variable to contain an INTEGER, such as 42,
0, 27, or -14.

You have thrown out the possibility that they are going to splice in
some nasty text SQL.

It's not perfect, as they could still perhaps manage to pretend to be
user #5 instead of user #42, if your script was silly enough to
implicitly trust GET input data.

The mysql_real_escape_string() part is a function provided by MySQL
which will make sure that the value you are providing is properly
escaped. It is a more mature solution to what
http://php.net/addslashes and Magic Quotes were trying to solve.

Specifically, suppose your user_id in the database was NOT a number,
but was just people's names:
'Richard Lynch'
'Nitrox'
'Kevin O'Brien'

Ooops. Look at that last name. The ' in O'Brien is going to confuse
the ' that MySQL uses to delimit a string.

mysql_real_escape_string() takes the 'Kevin O'Brien' and converts it
to 'Kevin O\'Brien' so that when the MySQL SQL parser reads it, it
*knows* that the \' in O'Brien is part of the name.

That way, MySQL can store the right thing down in the guts of its
storage: Kevin O'Brien

Calling mysql_real_escape_string() on an integer is probably a bit of
overkill -- There is NO WAY for anything other than [0-9-] to be in
the result of the (int) typecast.

However, recent attacks have been using very funky features of Unicode
character sets, for languages other than English, so that what looks
like a perfectly normal valid input in English turns into something
realy nasty (in computer science terms, not linguistics).

I don't *think* there are any character sets for which 0-9 and - are
anything other than 0-9 and -, but I'd rather be safe than sorry.

To understand more about why I added all this stuff, start reading here:
http://phpsec.org
and keep reading that site until it's second nature.

die (Could not perform query $query: .mysql_error().\n);

This is a Bad Thing to do on most newbie servers where php.ini has:
display_errors = On
because it will expose your exact query and all kinds of mysql stuff
to the Bad Guys, which just makes it easier for them to attack.

You should explore setting up your server with php.ini or .htaccess so
that you have display_errors OFF and log_errors ON, and then you can
use trigger_error(Could not perform query $query: . mysql_error(),
E_USER_ERROR);
or something similar to that.

A simpler short-term option would be to replace die(...) with:
die(An error has occured. . error_log(Could not perform query
$query: . mysql_error());

I'm not sure what error_log returns, but it probably won't be
particularly useful, nor dangerous to expose to the Bad Guys.

The Bad News is that you should count on spending about 3 X as much
time thinking about Security to write your application as you would
have spent if everybody in the world was Good People.

--
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.

Re: [PHP] Select record by ID

2007-01-31 Thread Richard Lynch

On Tue, January 30, 2007 7:23 pm, Craige Leeder wrote:
 atleast this part: $user_id = mysql_real_escape_string((int)
 $_GET['user_id']);

 I'm not sure who put this in there, but you don't need to use
 mysql_real_escape_string() on that value if you're type casting it. If
 you are forcing it to be an integer, there is nothing to escape.
 Integers are perfectly fine to be put into a query as they are.

Can you guarantee that in every character encoding, past, present, and
future?...

Before you answer, keep in mind that the '-' sign is part of an (int).

I'm not claiming that there is any real danger -- only that there is
the theoretical possibility, and skimping on a
mysql_real_escape_string() call is not the right thing to do.

Actually, all I really wanted to do with that was to be sure that the
OP did *something* to learn more about the security issues of user
input and SQL injection attacks...  Didn't expect it to engender this
much discussion, but there it is.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-30 Thread nitrox .

Thanks to all who have replied. As you probably have noticed im a total 
novice to php who is trying to achieve big things.


Richard, ive included your suggested code and now my php script is working 
properly. But I dont want to be a php copy/paste newb who has no clue of how 
things are working. If its not too much would you (or anybody) give a brief 
explanation of what this code is doing? Or are there any tutorials online 
that I can read that will educate me on this? Thanks again to all for your 
replies. Ive saved them all for future reference.


atleast this part: $user_id = mysql_real_escape_string((int) 
$_GET['user_id']);


I understand the rest.

?php
include db.php;
$user_id = mysql_real_escape_string((int) $_GET['user_id']);
$query = SELECT user_id, user_name FROM inf_member WHERE user_id=$user_id;
$result = mysql_query($query);
if ( ! $result ) {
die (Could not perform query $query: .mysql_error().\n);
}
while($myrow = mysql_fetch_assoc($result))
 {
echo br;
echo $myrow['user_name'];
echo br;
}
?

_
Invite your Hotmail contacts to join your friends list with Windows Live 
Spaces 
http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-30 Thread Paul Novitski


At 1/30/2007 02:14 PM, nitrox . wrote:
If its not too much would you (or anybody) give a brief explanation 
of what this code is doing? Or are there any tutorials online that I 
can read that will educate me on this? Thanks again to all for your 
replies. Ive saved them all for future reference.


atleast this part: $user_id = mysql_real_escape_string((int) 
$_GET['user_id']);



The querystring parameter user_id is interpreted as an integer and 
then escaped as needed to be safe in a querystring:


mysql_real_escape_string -- Escapes special characters in a string 
for use in a SQL statement

http://php.net/mysql_real_escape_string

(int) casts the subsequent value as an integer.  Type casting in PHP 
works much as it does in C: the name of the desired type is written 
in parentheses before the variable which is to be cast.

http://php.net/manual/en/language.types.type-juggling.php#language.types.typecasting

see also:
Converting to integer
http://php.net/manual/en/language.types.integer.php#language.types.integer.casting

HTTP GET variables: $_GET. An associative array of variables passed 
to the current script via the HTTP GET method.

http://php.net/manual/en/reserved.variables.php#reserved.variables.get

I recommend that you make the online PHP manual your resource of 
first resort.  It's got a built-in search engine: just enter 
php.net/searchterm into your browser address bar.


Regards,

Paul
__

Juniper Webcraft Ltd.
http://juniperwebcraft.com 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-30 Thread Craige Leeder


atleast this part: $user_id = mysql_real_escape_string((int)
$_GET['user_id']);


I'm not sure who put this in there, but you don't need to use
mysql_real_escape_string() on that value if you're type casting it. If
you are forcing it to be an integer, there is nothing to escape.
Integers are perfectly fine to be put into a query as they are.

- Craige

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-29 Thread Robert Cummings

On Sun, 2007-01-28 at 21:12 -0500, Craige Leeder wrote:
 As someone else already stated, my best guess according to that error
 is that $user_id has a null, or inappropriate value. The error occurs
 at the last character of the query, so it has to be something like
 hat. Echo the query and let us know what it outputs.

This is coding 101, echo your output and don't presume you know what
you're doing. My wager is that there's a 100% chance he has a null or
empty string value in the variable. A two second echo would have
presented the problem immediately. Given that he probably doesn't have a
clue what's in the variable, it's probably registered via register
globals or pulled directly from $_GET or $_POST and he's asking for
trouble by not escaping it.

Cheers,
Rob.
-- 
..
| InterJinn Application Framework - http://www.interjinn.com |
::
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for   |
| creating re-usable components quickly and easily.  |
`'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

On Sun, January 28, 2007 5:21 pm, nitrox . wrote:
 Im trying to display one record at a time by ID. Well im getting a
 blank
 page. Ive looked over my code and tried 20 different ways to get it to
 work
 to no avail. So any pointers on what Im doing wrong would be great.
 here is
 the code im working with so far.

First, be sure you are using View Source in your browser, so that
something like:

unclosed tag will HIDE ALL this content 

 ?php
 include(db.php);

include is not actually a function, and doesn't need parens, so the
()s here are just kinda silly...

 $result = mysql_query(SELECT * FROM inf_member WHERE
 user_id='$user_id' );

You need *SOME* kind of check here on whether your query succeeded.

The canonical example is:
$result = mysql_query(...) or die(mysql_error());

It would also be wise to get in the habit now of configuring your
web-server to NOT display_errors but to log_errors in your php.ini (or
in .htaccess with php_value) and then to read your error logs instead
of your web page.

The point being to not expose the internal workings of your
application to the Bad Guys who use such info to make it easier to
break into your machine.

Read this over and over until you understand all of it:
http://phpsec.org

 while($myrow = mysql_fetch_assoc($result))
   {
  echo b;
  echo $myrow['user_name'];
  echo /b;
  echo $myrow['rank'];
echo /b;
  echo $myrow['country'];
echo /b;
  echo $myrow['email'];
  echo /b;
  echo $myrow['quote'];
  echo /b;
  echo $myrow['config'];
echo /b;
echo $myrow['map'];
  echo /b;
  echo $myrow['gun'];
  echo /b;
  echo $myrow['brand'];
echo /b;
echo $myrow['cpu'];
echo /b;
  echo $myrow['ram'];
  echo /b;
  echo $myrow['video'];
  echo /b;
  echo $myrow['sound'];
echo /b;
echo $myrow['monitor'];
  echo /b;
  echo $myrow['mouse'];
  echo /b;
  echo $myrow['brand'];
echo /b;

Instead of a bunch of echo statements like this, you may want to
consider the 'heredoc' syntax, or at least fewer echo statements such
as:
echo b$myrow[brand]/bbr /\n;

Or, you could do like this:
foreach($myrow as $field = value){
  echo $field: b$value/bbr /\n;
}
instead of all those echo statements.

  }
 ?


-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

 January 28, 2007 6:20 pm, Larry Garfield wrote:
 On Sunday 28 January 2007 5:54 pm, Francisco M. Marzoa Alonso wrote:
 On dom, 2007-01-28 at 18:51 -0500, nitrox . wrote:
  I took the quotes off. I thought that quotes around numbers was
 wrong
  also.

 Quotes are no necessary around numeric values, but they aren't wrong
 neither, simply optional.

 Actually, I believe they are wrong in some database engines but not
 others.
 MySQL doesn't care.  Some others do.  Yes, it sucks. :-(

I believe it is now possible to *make* MySQL care by putting it into
strict mode when you start it...

MySQL is the *only* db engine that lets you get away with [bleep] like
apostrophes around numbers.

I think strict mode also stops MySQL from the annoying habit of
silently converting inadmissable date/time to '-00-00' [g]

It may even be possible to turn on strict mode with a query, and not
just from launch...

http://dev.mysql.com/ would tell you more about this.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

On Sun, January 28, 2007 6:20 pm, Larry Garfield wrote:
 On Sunday 28 January 2007 5:54 pm, Francisco M. Marzoa Alonso wrote:
 On dom, 2007-01-28 at 18:51 -0500, nitrox . wrote:
  I took the quotes off. I thought that quotes around numbers was
 wrong
  also.

 Quotes are no necessary around numeric values, but they aren't wrong
 neither, simply optional.

 Actually, I believe they are wrong in some database engines but not
 others.
 MySQL doesn't care.  Some others do.  Yes, it sucks. :-(

The sql_mode stuff requires MySQL 5.x :-(

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-29 Thread Roman Neuhauser

# [EMAIL PROTECTED] / 2007-01-29 17:54:03 -0600:
 MySQL is the *only* db engine that lets you get away with [bleep] like
 apostrophes around numbers.

Actually, these are examples of valid SQL: INTEGER '1', FLOAT '13.5'.

test=# select version();
 version
 
-
 PostgreSQL 8.1.3 on amd64-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 
[FreeBSD] 20050518
(1 row)

test=# select '13.5' * '30';
ERROR:  operator is not unique: unknown * unknown
test=# select float '13.5' * integer '10';
 ?column? 
--
  135
(1 row)

test=# create table t (f float, i integer);
CREATE TABLE
test=# insert into t values ('13.5', '10');
INSERT 0 1
test=# select * from t;
  f   | i  
--+
 13.5 | 10
(1 row)

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

On Mon, January 29, 2007 6:55 pm, Roman Neuhauser wrote:
 # [EMAIL PROTECTED] / 2007-01-29 17:54:03 -0600:
 MySQL is the *only* db engine that lets you get away with [bleep]
 like
 apostrophes around numbers.

 Actually, these are examples of valid SQL: INTEGER '1', FLOAT '13.5'.

 test=# select float '13.5' * integer '10';
  ?column?
 --
   135
 (1 row)

E.

Yes, you can TYPE-CAST string data into integer/float data...

But you are INPUTTING string data at that point, not numeric, and
forcing PostgreSQL to convert it internally.

It's the exact analog of:

?php
  $foo = '1';
  $foo = (int) $foo;
  echo gettype($foo);
  $bar = 1;
  echo gettype($bar);
?

 test=# create table t (f float, i integer);
 CREATE TABLE
 test=# insert into t values ('13.5', '10');
 INSERT 0 1
 test=# select * from t;
   f   | i
 --+
  13.5 | 10
 (1 row)

I'm amazed this worked and didn't error out...

It definitely USED to error out.

Looks like PostgreSQL caved in to the unwashed masses of MySQL users
who couldn't handle not putting apostrophes around everything to me...
[sigh]
:-) :-) :-)

Oh well.

I personally would prefer that the DB not accept bogus input like this.

Different strokes for different folks.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

2007-01-29 Thread Larry Garfield

On Monday 29 January 2007 7:19 pm, Richard Lynch wrote:

 Looks like PostgreSQL caved in to the unwashed masses of MySQL users
 who couldn't handle not putting apostrophes around everything to me...
 [sigh]

 :-) :-) :-)

 Oh well.

 I personally would prefer that the DB not accept bogus input like this.

 Different strokes for different folks.

Different strokes indeed.  Personally I'd much rather one be able to just 
say quote a literal, dagnabbit and not worry about whether it was a string 
or an int.  I'm sure there's some reason for it deep in the bowels of SQL 
engines as they existed in the early '80s, but for anyone trying to not 
hand-write every frickin' SQL query and automate common tasks it makes life 
considerably more annoying.

-- 
Larry Garfield  AIM: LOLG42
[EMAIL PROTECTED]   ICQ: 6817012

If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it.  -- Thomas 
Jefferson

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

On Mon, January 29, 2007 7:43 pm, Larry Garfield wrote:
 On Monday 29 January 2007 7:19 pm, Richard Lynch wrote:

 Looks like PostgreSQL caved in to the unwashed masses of MySQL users
 who couldn't handle not putting apostrophes around everything to
 me...
 [sigh]

 :-) :-) :-)

 Oh well.

 I personally would prefer that the DB not accept bogus input like
 this.

 Different strokes for different folks.

 Different strokes indeed.  Personally I'd much rather one be able to
 just
 say quote a literal, dagnabbit and not worry about whether it was a
 string
 or an int.  I'm sure there's some reason for it deep in the bowels of
 SQL
 engines as they existed in the early '80s, but for anyone trying to
 not
 hand-write every frickin' SQL query and automate common tasks it makes
 life
 considerably more annoying.

I can see where you are coming from, but if you don't know what data
type you have, and what data type you are using in SQL, you're already
screwed. :-)

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

The first thing that I probably do is to check for possible errors from
DB:

$result = mysql_query(SELECT * FROM inf_member WHERE
user_id='$user_id' );
if ( ! $result ) {
die (Could not perform query $query: .mysql_error().\n);
}

Regards,


On dom, 2007-01-28 at 18:21 -0500, nitrox . wrote:
 Before I ask my next question I just wanted to thank you all for being in 
 this mailing community and sharing your knowledge. Its communitys like this 
 that make life easier for all of us. Ok enough with the mushy stuff
 
 Im trying to display one record at a time by ID. Well im getting a blank 
 page. Ive looked over my code and tried 20 different ways to get it to work 
 to no avail. So any pointers on what Im doing wrong would be great. here is 
 the code im working with so far.
 
 ?php
 include(db.php);
 
 $result = mysql_query(SELECT * FROM inf_member WHERE 
 user_id='$user_id' );
 while($myrow = mysql_fetch_assoc($result))
   {
  echo b;
  echo $myrow['user_name'];
  echo /b;
  echo $myrow['rank'];
echo /b;
  echo $myrow['country'];
echo /b;
  echo $myrow['email'];
  echo /b;
  echo $myrow['quote'];
  echo /b;
  echo $myrow['config'];
echo /b;
echo $myrow['map'];
  echo /b;
  echo $myrow['gun'];
  echo /b;
  echo $myrow['brand'];
echo /b;
echo $myrow['cpu'];
echo /b;
  echo $myrow['ram'];
  echo /b;
  echo $myrow['video'];
  echo /b;
  echo $myrow['sound'];
echo /b;
echo $myrow['monitor'];
  echo /b;
  echo $myrow['mouse'];
  echo /b;
  echo $myrow['brand'];
echo /b;
 
  }
 ?
 
 _
 FREE online classifieds from Windows Live Expo – buy and sell with people 
 you know 
 http://clk.atdmt.com/MSN/go/msnnkwex001001msn/direct/01/?href=http://expo.live.com?s_cid=Hotmail_tagline_12/06
 


signature.asc
Description: This is a digitally signed message part

Re: [PHP] Select record by ID

2007-01-28 Thread nitrox .

I took the quotes off. I thought that quotes around numbers was wrong also. 
I added the error checking and this is the error:


Could not perform query : You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near '' at line 1


and this is the code again:

?php
include(db.php);
   $result = mysql_query(SELECT * FROM inf_member WHERE 
user_id=$user_id);

   if ( ! $result ) {
die (Could not perform query $query: .mysql_error().\n);
}

while($myrow = mysql_fetch_assoc($result))
 {
echo b;
echo $myrow['user_name'];
echo /b;
echo $myrow['rank'];
 echo /b;
echo $myrow['country'];
 echo /b;
echo $myrow['email'];
echo /b;
echo $myrow['quote'];
echo /b;
echo $myrow['config'];
 echo /b;
 echo $myrow['map'];
echo /b;
echo $myrow['gun'];
echo /b;
echo $myrow['brand'];
 echo /b;
 echo $myrow['cpu'];
 echo /b;
echo $myrow['ram'];
echo /b;
echo $myrow['video'];
echo /b;
echo $myrow['sound'];
 echo /b;
 echo $myrow['monitor'];
echo /b;
echo $myrow['mouse'];
echo /b;
echo $myrow['brand'];
 echo /b;

}
?

_
Laugh, share and connect with Windows Live Messenger 
http://clk.atdmt.com/MSN/go/msnnkwme002001msn/direct/01/?href=http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-ussource=hmtagline


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

Ops!, Better this one:

$query = SELECT inf_member WHERE user_id='$user_id' ;
$result = mysql_query($query);
if ( ! $result ) {
die (Could not perform query $query: .mysql_error().\n);
}

I did copy and paste from my own code and you've not $query defined on
your one. I prefer to store first the query on a string to show it
complete if there's an error late, because it may show also the point.



On lun, 2007-01-29 at 00:39 +0100, Francisco M. Marzoa Alonso wrote:
 The first thing that I probably do is to check for possible errors from
 DB:
 
 $result = mysql_query(SELECT  inf_member WHERE
 user_id='$user_id' );
   if ( ! $result ) {
   die (Could not perform query $query: .mysql_error().\n);
   }
 
 Regards,
 
 
 On dom, 2007-01-28 at 18:21 -0500, nitrox . wrote:
  Before I ask my next question I just wanted to thank you all for being in 
  this mailing community and sharing your knowledge. Its communitys like this 
  that make life easier for all of us. Ok enough with the mushy stuff
  
  Im trying to display one record at a time by ID. Well im getting a blank 
  page. Ive looked over my code and tried 20 different ways to get it to work 
  to no avail. So any pointers on what Im doing wrong would be great. here is 
  the code im working with so far.
  
  ?php
  include(db.php);
  
  $result = mysql_query(SELECT * FROM inf_member WHERE 
  user_id='$user_id' );
  while($myrow = mysql_fetch_assoc($result))
{
   echo b;
   echo $myrow['user_name'];
   echo /b;
   echo $myrow['rank'];
   echo /b;
   echo $myrow['country'];
   echo /b;
   echo $myrow['email'];
   echo /b;
   echo $myrow['quote'];
   echo /b;
   echo $myrow['config'];
   echo /b;
   echo $myrow['map'];
   echo /b;
   echo $myrow['gun'];
   echo /b;
   echo $myrow['brand'];
   echo /b;
   echo $myrow['cpu'];
   echo /b;
   echo $myrow['ram'];
   echo /b;
   echo $myrow['video'];
   echo /b;
   echo $myrow['sound'];
   echo /b;
   echo $myrow['monitor'];
   echo /b;
   echo $myrow['mouse'];
   echo /b;
   echo $myrow['brand'];
   echo /b;
  
   }
  ?
  
  _
  FREE online classifieds from Windows Live Expo – buy and sell with people 
  you know 
  http://clk.atdmt.com/MSN/go/msnnkwex001001msn/direct/01/?href=http://expo.live.com?s_cid=Hotmail_tagline_12/06
  


signature.asc
Description: This is a digitally signed message part

Re: [PHP] Select record by ID

2007-01-28 Thread Paul Novitski


At 1/28/2007 03:21 PM, nitrox . wrote:
Im trying to display one record at a time by ID. Well im getting a 
blank page. Ive looked over my code and tried 20 different ways to 
get it to work to no avail. So any pointers on what Im doing wrong 
would be great. here is the code im working with so far.


?php
include(db.php);

   $result = mysql_query(SELECT * FROM inf_member WHERE 
user_id='$user_id' );

   while($myrow = mysql_fetch_assoc($result))
 {
echo b;
echo $myrow['user_name'];

...

My off-hand guess is that your user_id might be a numeric value 
(auto-increment?) and that putting it in quotes makes for an invalid query.


What is the value of $result?  If $result === false then display 
mysql_error() to diagnose the problem.


Regards,

Paul
__

Juniper Webcraft Ltd.
http://juniperwebcraft.com 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID

On dom, 2007-01-28 at 18:51 -0500, nitrox . wrote:
 I took the quotes off. I thought that quotes around numbers was wrong also. 

Quotes are no necessary around numeric values, but they aren't wrong
neither, simply optional.

 I added the error checking and this is the error:
 
 Could not perform query : You have an error in your SQL syntax; check the 
 manual that corresponds to your MySQL server version for the right syntax to 
 use near '' at line 1

Try with the new code I sent you too see the query you're sending,
probably -but not sure- $user_id is void and you're doing:

SELECT * FROM inf_member WHERE user_id=

Anyway if you can see the query, you'll see the source of the error.

 
 and this is the code again:
 
 ?php
 include(db.php);
 $result = mysql_query(SELECT * FROM inf_member WHERE 
 user_id=$user_id);
 if ( ! $result ) {
   die (Could not perform query $query: .mysql_error().\n);
   }
 
   while($myrow = mysql_fetch_assoc($result))
   {
  echo b;
  echo $myrow['user_name'];
  echo /b;
  echo $myrow['rank'];
echo /b;
  echo $myrow['country'];
echo /b;
  echo $myrow['email'];
  echo /b;
  echo $myrow['quote'];
  echo /b;
  echo $myrow['config'];
echo /b;
echo $myrow['map'];
  echo /b;
  echo $myrow['gun'];
  echo /b;
  echo $myrow['brand'];
echo /b;
echo $myrow['cpu'];
echo /b;
  echo $myrow['ram'];
  echo /b;
  echo $myrow['video'];
  echo /b;
  echo $myrow['sound'];
echo /b;
echo $myrow['monitor'];
  echo /b;
  echo $myrow['mouse'];
  echo /b;
  echo $myrow['brand'];
echo /b;
 
  }
 ?
 
 _
 Laugh, share and connect with Windows Live Messenger 
 http://clk.atdmt.com/MSN/go/msnnkwme002001msn/direct/01/?href=http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-ussource=hmtagline
 


signature.asc
Description: This is a digitally signed message part

Re: [PHP] Select record by ID

2007-01-28 Thread Larry Garfield

On Sunday 28 January 2007 5:54 pm, Francisco M. Marzoa Alonso wrote:
 On dom, 2007-01-28 at 18:51 -0500, nitrox . wrote:
  I took the quotes off. I thought that quotes around numbers was wrong
  also.

 Quotes are no necessary around numeric values, but they aren't wrong
 neither, simply optional.

Actually, I believe they are wrong in some database engines but not others.  
MySQL doesn't care.  Some others do.  Yes, it sucks. :-(

-- 
Larry Garfield  AIM: LOLG42
[EMAIL PROTECTED]   ICQ: 6817012

If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it.  -- Thomas 
Jefferson

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Select record by ID