[SOLVED] will my array search the database yes no?

[redarrow]

I made this all up and want to no would it be possable to use this kind of

search with the arrary values?

 

<?php

$db=mysql_connect("localhost","username","password");

mysql_select_db("my_database",$db);

  if($_POST['submit']){

   $key=($_POST['key']);

    for ($i=0; $i<count($key); $i++){

       $query="select * from users where name like "%'".key[0]."'%" and age like "%'".key[1]."'%" ";
      
      $result=mysql_query($query);


while($x=mysql_fetch_assoc($result)){


  echo " Username: ".$x['name']."  Age: ".$rec['age']." ";
   
}
   }
     }

$x=array("name","age");


  echo"<form action='test_array.php' method='POST'>";

   foreach($x as $key){

     echo"<input type='text' name='key[]' >$key<br>";
    
      }

     echo"<br>";

         echo"<input type='submit' name='submit' value='Search'>";

            echo"</form>";

?>

[genericnumber1]

yes, but your syntax is wrong

 

$query="select * from users where name like "%'".key[0]."'%" and age like "%'".key[1]."'%" ";

 

probably should be

 

$query="select * from users where name like '%$key[0]%' and age like '%$key[1]%'";

[redarrow]

please give a textual example ok cheers.

 

 

<?php

$db=mysql_connect("localhost","username","password");

mysql_select_db("my_database",$db);

  if($_POST['submit']){

   $key=($_POST['key']);

    for ($i=0; $i<count($key); $i++){

$query="select * from users where name like '%$key[0]%' and age like '%$key[1]%' ";
      
      $result=mysql_query($query);


while($x=mysql_fetch_assoc($result)){


  echo " Username: ".$x['name']."  Age: ".$rec['age']." ";
   
}
   }
     }

$x=array("name","age");


  echo"<form action='test_array.php' method='POST'>";

   foreach($x as $key){

     echo"<input type='text' name='key[]' >$key<br>";
    
      }

     echo"<br>";

         echo"<input type='submit' name='submit' value='Search'>";

            echo"</form>";

?>

[redarrow]

this is the correct way becouse you dont have the data or querys in the loop but cheers?

<?php

$db=mysql_connect("localhost","username","password");

mysql_select_db("my_database",$db);

if($_POST['submit']){

$key=($_POST['key']);

for($i=0; $i<count($key); $i++){
 
$a=$key[0];
 
$b=$key[1];

}

$query="select * from users where name like '%$a%' and age like '%$b%' ";
      
$result=mysql_query($query);

while($x=mysql_fetch_assoc($result)){

echo " Username: ".$x['name']."  Age: ".$rec['age']." ";
   
}

}
   
$p=array("name","age");

echo"<form action='test_array.php' method='POST'>";

foreach($p as $key){

echo"<input type='text' name='key[]' >$key<br>";
    
}

echo"<br>";

echo"<input type='submit' name='submit' value='Search'>";

echo"</form>";

?>

[Barand]

Can you explain why this bit is "correct" ?

 

for($i=0; $i<count($key); $i++){

 

$a=$key[0];

 

$b=$key[1];

 

}

[redarrow]

becouse i have assign the varable a  to name and b to age and therefore

name and age will search within the query from the array form.

 

 

am i wrong ? dont no?

[Barand]

But why the the for() loop. All it does is make the same assignments several times.

 

$a=$key[0];
$b=$key[1];

 

is all you need

[redarrow]

i thort you needed to use a loop to get the array from the key[] but you dont?

[Barand]

You don't use the loop to extract the key, you just use it to repeat the code. All it does is

 

$a=$key[0];
$b=$key[1];

$a=$key[0];
$b=$key[1];

[redarrow]

i got this now but becouse i am assigning the array key singlely is that why i dont need a loop?

 

 

Ok i understand but brushing up so any help is good for coding cheers.

 

<?php

$db=mysql_connect("localhost","username","password");

mysql_select_db("my_database",$db);

if($_POST['submit']){

$key=($_POST['a']);
$key=($_POST['b']);

$a=$key[0];
$b=$key[1];

$query="select * from users where name like '%$a%' and age like '%$b%' ";
     
$result=mysql_query($query);


while($x=mysql_fetch_assoc($result)){


echo " Username: ".$x['name']."  Age: ".$rec['age']." ";
  }
}

$x=array("name","age");

echo"<form action='test_array.php' method='POST'>";

foreach($x as $key){

echo"<input type='text' name='key[]' >$key<br>";
   
}

echo"<br>";

echo"<input type='submit' name='submit' value='Search'>";

echo"</form>";

?>

[Barand]

i got this now but becouse i am assigning the array key singlely is that why i dont need a loop?

 

Yes.

 

But this code won't work. The assignment of $_POST['b'] to $key overwrites the previous assignment. The second 2 lines of code won't work because $key isn't an array.

<?php
$key=($_POST['a']);
$key=($_POST['b']);

$a=$key[0];
$b=$key[1];
?>

 

You would need this (note the "[]")

 

<?php
$key[]=($_POST['a']);
$key[]=($_POST['b']);

$a=$key[0];
$b=$key[1];
?>

 

but you might just as well do

 

<?php
$a=($_POST['a']);
$b=($_POST['b']);
?>

[redarrow]

Thank you barand for you grate help cheers m8.