ansaurus

Question

How to get value from elements and add to array with specific names using loop

Answer 1

A:

for the html why dont you put the form method to GET .. and submit the form with AJAX. Why does it bother you the default values ?

You can do verifications on the php side and decide there witch filters are active

$price = (isset($_GET['price'])) ? $_GET['price'] : false;

solomongaby 2009-10-13 12:10:25

i am submitting my form with ajax get method, but there are many forms in one page, so thats why i want to use a loop to get the element ids and then if the values are NOT 1, then add them to an array with which I then send to the php file with GET...

pesar 2009-10-13 12:15:35

currently i have thought of this...Elem=getelementbyid(FORM).elements...For (i=0; i<Elem; i++) do something, which i dont know what!

pesar 2009-10-13 12:17:01

Answer 2

A:

<html>
 <?php
     $where = '';
     foreach($_GET as $key => $value) {
        if($value!='001') {
            $where .= ' AND ' . $key . '="' . $value . '"';
        }
     }
     $where = substr($where,4);//get rid of left 'AND'
     $sql = 'SELECT * FROM my_table WHERE ' . $where . ' ORDER BY id ASC';
 ?>
</html>

Cory Dee 2009-10-13 12:25:25

this makes sense... but how would you insert each key value to a query which check a mysql database for it?

pesar 2009-10-13 12:33:05

Gimme a sec to edit it.

Cory Dee 2009-10-13 13:14:00

Please don't forget to escape the values submitted (never trust a user)! Also having the name of the database field as the key for the `$_GET` might turn out to be a security risk.And remember that the `$_GET`-variable might contain other keys, for example a session id or something else. This would then be sent to the database and your results would be erroneous at least.

Cassy 2009-10-13 13:26:49

I agree, I was just writing the basics and letting him fill in the blanks. I would assume there would be error checking on at least some of the fields to double check for SQL injection and valid variable types, as well as the every trusty mysql_real_escape_string (and trim).

Cory Dee 2009-10-13 13:43:32

Pesar: Any luck?

Cory Dee 2009-10-16 14:05:27

Answer 3

A:

This is a javascript question (you will need to grab the form values and determine if it is set via javascript). Using a js library like jQuery would make this process quite easy. That said, I will answer your question using PHP:

foreach ($_GET as $k => $v) {

 if ($v) {

  $uri[] = $k.'='.$v;

 }

}

$url = 'http://url.com/submit.php?'.implode('+', $uri);

jusunlee 2009-10-13 12:29:42

Answer 4

A:

$url = $_SERVER['SCRIPT_NAME'] . '?';

foreach ($_GET as $key => $value)
{
    $url .= $key . '=' . $value . '&';
}

Cesar 2009-10-13 12:38:11

Answer 5

A:

     <html> 
     <?php 

      foreach($_GET as $key => $value) { 
      if($value!='001') { 
            echo $key . ' has a value of ' . $value . '<br>'; 
      } 
      } 

       ?> 
      </html>

how can i implement a loop into this that takes all values of keys and adds to a query and then checks mysql database for it?

pesar 2009-10-13 12:42:11

The commend on this post was fine, you don't need to repost the question :D

Cory Dee 2009-10-13 13:21:45

ansaurus

tags:

views:

answers:

How to get value from elements and add to array with specific names using loop

related questions