PHP - Msql_fetch_array And In_array?

I have a section in one of my scripts that checks for a value in array and the value doesn't exist in the array then it add it.  This works fine for single array but not for mulit-dimensional arrays.  Has anyone had a similar problem and knows a good solution?

Code: [Select]
if(in_array($words[$i], $searchWords)){
    //Do nothing
}else{
    $searchWords[] = $words[$i];
}

I am trying to pull the username for everyone who appears within an array. How would i go about this?

something like this maybe?

SELECT * FROM users WHERE username (in_array($users))

I can't seem to understand why in_array is NOT finding the 'needle'.

php file:
Code: [Select]
<?PHP
$search = "WS11";
$valid_codes = file("outcode2.txt");
if(in_array($search, $valid_codes)){
echo "yes";
}else{
echo "No";
}
echo $search . "<hr>";
echo "<PRE>";
print_r($valid_codes);
echo "</pre>";
?>

outcode2.txt:
Code: [Select]
WS10
WS11
WS12
WS13
WS14
WS15

WS11 is in the outcode2.txt
It is not an issue of case.
Perhaps my old eyes just keep missing the problem.
Any help is appreciated.

Hello:

I'm trying to compare two mySQL result sets (for determining when to check a checkbox in an input form).

$dataList['listname'] is my needle. (only the checkboxes I want to check)
$data['listname'] is my haystack (the list of all checkboxes)


Code: [Select]
while($dataList = mysql_fetch_array($runListQuery))
{
$checked = '';
echo $data['listname'].'<br /><br />';
echo $dataList['listname'].' :: ' .  $data['listname'] . '::' . (string)array_search ($dataList['listname'],$data['listname'],false) .'<br>';
echo in_array($dataList['listname'],$data['listname']);
echo '<br>----------------------<br>';
var_dump($data['listname']);
echo '<br>----------------------<br>';
var_dump ($dataList['listname']);
echo '<br>----------------------<br>';
if(in_array($dataList['listname'],$data['listname'],false)) {
echo 'found!!!!!!!!!!!';
$checked = 'CHECKED';
}
echo '<tr>';
echo '<td>' . $dataList['listname'] . '</td>';
echo '<td><input type="checkbox" '. $checked . ' name="'.$dataList['listname'].'" />';
echo '</tr>';
}
I never hit the 'found!!!!!!!!' string.  My output is below:

Code: [Select]
list-charter

halwasiya :: list-charter::

----------------------
string(12) "list-charter"
----------------------
string(9) "halwasiya"
----------------------
list-charter

halwits :: list-charter::

----------------------
string(12) "list-charter"
----------------------
string(7) "halwits"
----------------------
list-charter

list-charter :: list-charter::

----------------------
string(12) "list-charter"
----------------------
string(12) "list-charter"
----------------------

Hey guys,

I have this super simple code which will not work and I'm very confused as to why.

Here is the code

Code: [Select]
// read the file into an array called $users
$users= file('users.txt');

if (in_array("joe", $users)) {
    echo "Got Joe";
}

When I print_r($users) everyone looks fine like this but it never returns true, Why?

Code: [Select]
Array
(
    [0] => joe

    [1] => bob

    [2] => mike

    [3] => ted

    [4] => fred
)

Okay, this is my loop to show the birthday for Years.
Code: [Select]
<?php
    for ($i=2006; $i>=1900; $i=$i-1)
    {
     echo "<option value='$i'>$i</option>";
    }
   ?>
It will show 2012 to 1900 as a dropdown menu.. in my select form.


Now I want to check the user input against this loop.

The form is:

Code: [Select]
<select name="BirthDay[]">
   <?php
    for ($i=2012; $i>=1900; $i=$i-1)
    {
     echo "<option value='$i'>$i</option>";
    }
   ?>
   </select>
Now, I want to use in_array function to check if it equals any of the values I looped, if it doesn't echo out "Hacker!"


Here is my in_array




Code: [Select]
$bday = array( NEED TO PUT THIS LOOP HERE SOMEHOW?!?!
);
if (!in_array($_POST['BirthDay'], $bday)) {
message("Please select a Correct Birthday, or u trying to hack");
}

Thanks if u can help!

I have the following simple code to test against collision on a primary key I am creating:

Code: [Select]
        $machine_ids = array();
for($i = 0; $i < 100000; $i++) {
//Generate machine id returns a 15 character alphanumeric string
                $mid = Functions::generate_machine_id();

if(in_array($mid, $machine_ids)) {
die("Collision!");
} else {
$machine_ids[] = $mid;
}
}

die("Success!");

Any idea why this is taking minutes to run? Anyway to speed it up?

Can someone please help me figure this out:

I have a normal text file with 3 lines in it, every line contain one date i.e 12112011 (12.11-2011). I put the content of that file in an array, and want to compair the dates in the text file against the date generated from the loop. Problem is, i can only get a match for the last date listed in the text file no matter what.. If i have 4 dates in the file, it only style the last date.

Thanks!

--- CODE SNIPPET ---

$day_num = 1;
$days_in_month = 30;
$month = 11;
$year = 2011;

//Access the file containing already taken dates and load them in an array:
$date_array = file("test.txt");

//count up the days, untill we've done all of them in the month and check them against the dates in the text file:
while ($day_num <= $days_in_month) {

   // Set the variable $date to be checked against the content of the array:
   $date = $day_num . $month . $year;
   
   if (in_array($date, $date_array)) {
               echo "<td class='color_green'>$day_num</td>";
      //print_r($date_array);
   }
   else {
      echo "<td>$day_num</td><br />";
   }
   
   $day_num++;
}

I have something like below

Code: [Select]
$j = explode("-", $ROW['options']);
if(array_search("src_str", $j) == false) echo '_no';      // This doesn't work
Also i tried
Code: [Select]
$j = explode("-", $ROW['options']);
if(!in_array("src_str", $j)) echo '_no';      // This also doesn't work
Is this bug or am i doing something wrong?

Hi there, I am currently using the in_array() function to check the user's country with the country in the ShippingProfile table.

I have a function that returns the shipment profile info from the table.

$myshipProfile = filter_shippingprofile(array(......)); 

And in the $myshipProfile I get the profile info with the countryID. Now I can check the user's country in the array:

 if(in_array($_SESSION['userCountryId'], $myshipProfile))

      {

        print "yes country is found";

      } 

I works fine so far. But there is a slight problem to it.

I did a quick:

print_r($myshipProfile); 

And the output was:

Array ( [shippingprofileID] => 14 [supplierId] => 66 [shippingprofilename] => ProfName1 [shippingto] => CustomCountries [ShipRegionCountries] => 66 [shippingcost] => 10

Notice the supplierId and the ShipRegionCountries has the same value. And now when I try to perform in_array() it will return true every time even if the ShipRegionCountries is not 66 because as supplierID is 66.

You see the conflict.

Therefore, can we write like this:

 if(in_array($_SESSION['userCountryId'], $myshipProfile['ShipRegionCountries']))

                    {

                        print "yes country is found";

                    } 



I get no ouput for this. Whats the correct way to check only the 'ShipRegionCountries' in the array?

Thank you

Hi There, I have the following code:
two arrays:
$user_body_group & $DB_Seconday_muscles

I want to look up the "$DB_Seconday_muscles" Array and search for the elements in the "$user_body_group" array

The result would be displaying a checkbox list with only the items in the "$user_body_group" array checked:


foreach($DB_Seconday_muscles as $value) {
   

      echo "<input name=\"colors[]\" type=\"checkbox\" value=\"$value\"";
      
         if (in_array($value,$user_body_group))
         {
         echo "CHECKED";
         }
      
      
      echo "> $value ";

}

BUT... When i run thi script i only get the first element in the searched array ticked.

Can anyone help!

Many Thanks!

Leatfield

I have checkboxes (one for each day of the week) that I want to mark checked if the value is in an array. The value of $row['specialDaily'] could be something like 1,2,0 or 1 or 2,3,6 etc.

Code: [Select]
<?php $weekdays = array($row['specialDaily']);?>
          <input name="monday" type="checkbox" id="monday" value="1" class="weekday" <?php if (in_array("1", $weekdays)) {
    echo "checked='checked'";
}?> /><input name="tuesday" type="checkbox" id="tuesday" value="2" class="weekday" <?php if (in_array("2", $weekdays)) {
    echo "checked='checked'";
}?> />
If the array only contains one value, the proper checkbox is checked.  However, if it contains more than 1 value no checkboxes are checked.  I just found the in_array() function and assumed it was exactly what I'm looking for.  I assumed that since $row['specialDaily']'s value is like an array I could just plug it in.  Unfortunately, (unless I'm missing something simple) I'm thinking it doesn't work the way I hoped.

Thanks in advance,
Twitch

Hello,

I've been curious why the following won't work. Could anyone show me what I am doing wrong. The code is to find the TLD in a URL.

Code: [Select]
$a[] = parse_url( 'www.example.com' );
$tld_arr = array ( 'com', 'net', etc...);


for ($i=0; $i<count($this->a); $i++)
{
      if (in_array ( $this->a[$i]['host'], $tld_arr) ) < This is what I'm curious about
     {
            //do something
     }
// do something else
}


Thank you

Hello everyone,

I am trying to see if a term, sent from a form, is in an array that has been pulled from the database.

The problem I am having is that while the terms look the same the one from the database is using an Ascii character for a forward slash. & # 047 ;

I have tried adding the Ascii to the form value but it just rendered as a forward slash (no surprises there I suppose)

So the main reason for asking is that for all the other items in the form I can use in_array. This keeps things really tidy and easy to use.

Any ideas how I can still use in_array and get around the Ascii problem?

Cheers

Ian

while ($div=mysql_fetch_array($query4, MYSQL_ASSOC)) {
    //$div - shows all the entries    

$row22=mysql_fetch_array($query2, MYSQL_ASSOC);
//row22 - shows all the entries that should be checked
$name= array($div['date_id']);
$datess=$row22['date_id'];

if (in_array($datess, $name, true)) {

echo '<input type="checkbox" value="' . $div[date_id] .'" checked>' . $div[date] . '</option>';

}else{

echo '<input type="checkbox" value="' . $div[date_id] .'">' . $div[date] . '</option>';

}  

1. when echo $row22 shows only the entries that should be checked - working good
2. checkboxes show checked if only the first checkbox is selected or all 3 - if a combination is selected, it is all blank.


Any ideas?
Thank you