PHP - Search For Number Lost In Array

http://content.screencast.com/users/DeviousDan/folders/Jing/media/a563187c-93fe-4ec7-b496-41e50554b639/2011-01-02_2220.png

As you can see, I print_r the results array and it has a key of aim, I then try to access the aim value on line 44 and as you can see, it's an undefined Index.

I've officially forgotten all basics of PHP, any fresh eyes wanna give some insight? Thanks.

Well, In my DB i have user items as follows:
Code: [Select]
13,12,11,9,27,15,16,22,21,23,24,26,29,30,31,32,33
Each ID is a user item that has been imploded to be sent to the DB. Well, I', trying to take them out of the DB now, and I'm having a small problem turning them back into integers.  Here's what I've done.

Code: [Select]
$items = explode(",", $row['user_item_id']);So I get:
Code: [Select]
  0 => string '13' (length=2)
  1 => string '12' (length=2)
  2 => string '11' (length=2)
  3 => string '9' (length=1)
  4 => string '27' (length=2)
  5 => string '15' (length=2)
  6 => string '16' (length=2)
  7 => string '22' (length=2)
  8 => string '21' (length=2)
  9 => string '23' (length=2)
  10 => string '24' (length=2)
  11 => string '26' (length=2)
  12 => string '29' (length=2)
  13 => string '30' (length=2)
  14 => string '31' (length=2)
  15 => string '32' (length=2)
  16 => string '33' (length=2)
Then I do this:
Code: [Select]
foreach($items as $item){
var_dump($item);
$sql = 'SELECT *
FROM `MYTABLE`
WHERE item_tab = '.$tab_id.'
AND item_id = '.$item.'
AND item_pose =0';
}
and get this:
Code: [Select]
string '13' (length=2)

string '12' (length=2)

string '11' (length=2)

string '9' (length=1)

string '27' (length=2)

string '15' (length=2)

string '16' (length=2)

string '22' (length=2)

string '21' (length=2)

string '23' (length=2)

string '24' (length=2)

string '26' (length=2)

string '29' (length=2)

string '30' (length=2)

string '31' (length=2)

string '32' (length=2)

string '33' (length=2)

Now, this works how I want it to except, I want a integer value not a string. What would be the best way to approach this?

Hey forum!

I am currently developing a number search and I need some help creating a way to show similar results...

For example if someone searches "2009" and there is no result for "2009" is there a way for me to query the database with "2007", "2008", "2010", "2011", etc. until I find a result?

Any help would be greatly appreciated.

Hello,

I had 8 select boxes(dropdowns) in a form. Its like a search kind of implementation in the website. I don't know what the user selects, he may choose different select boxes, any number of select boxes.

So, based upon the user selection, I need to generate the data. The data fields to be generated would be almost same.

So, How would I know what the user selection is and how many select boxes has been selected and how could I generate different data based upon selected boxes.

I had to make a small note abt this, that the data generation fields may change for some of the user select combinations, but most of the result fields would be same.

so, can you please help me out, how to do, how to make different combination data generations, because, i had 8 fields, i had to make 8! combinations, that would result in a big code.

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?