PHP - In_array Always Returning False, When It Should Be True?

Hey Everyone, I want to start out by saying thanks in advance for reading this. Since I started working with the XAMPP package this community has been a great resource, though this is my first post.  most of my work has been modifying existing stuff in our network, this is my first project from scratch.

I am working on an access control project where I am storing site names and RFID tags in a table, and using PHP to check for existing records. Basically, I want to submit 2 credentials from a host (site and RFID), check if they exist together in the table, if so return TRUE or 1, if not return FALSE or 0. I am new to both PHP and MySQL (although I took a course years ago) so I am looking here for help.

On this server I have XAMPP installed and everything I need running. I have a table and created a few records for testing. My current trouble is getting PHP to return the proper values for the SQL query. The SQL query works fine, I think - it returns the number of rows that match and that record.  I'm not sure this is the result I need to be able to deal with the way I want.  Using other resources my current PHP statement looks like this:
Code: [Select]
if(mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE 'site_name' LIKE 'berland' AND 'card_id' LIKE '290093C84E' LIMIT 0 , 30"))>0){echo '1';}
   else
   {echo '0';} So, my table has the entry as noted in this query above. Final one will be dynamic where the host will be sending those values - I will likely need help with that as well, but small steps first.;-) Anyway, I was playing around with the end statement >0{echo '1';} but wasn't able to make it do what I want.
Any help is appreciated. Thank you.

Aaron

I have a statement

$account = $_SESSION['account_id'];
$postedby = $account_id;

/*both echo out to the same number*/

if($account == $postedby){
 echo "DELETE BUTTON";
}

i echo'ed out both $account and $postedby and both return 1 but the if statement fails to read as true.

HELP!!!

thanks in advance!

   private function _authenticate()
   {
      // if there's already an auth error
      if ( $this->_checkForMessageType('auth') )
      {
         $this->_addMessage('auth', 3);
         self::__destruct();
         return false;
      }
      $stmt = $this->_dbh->prepare("SELECT shopID FROM api_users WHERE shopID = ? AND API_key = ? LIMIT 1");
      
      var_dump($stmt->execute(array($this->_shopID, $this->_key)));
      echo $stmt->rowCount();
      // authenticate key / shop id
      if ( !$stmt->rowCount() )
      {
         $this->_addMessage('auth', 3);
         self::__destruct();
         return false;
      }
      $this->_addMessage('auth', 4);
   }


I am using PDO with MySQL driver and ATTR_EMULATE_PREPARES => true, however, when I run this code I get the output: Code: [Select]
bool(false) 0{"auth":{"3":""}}

Any ideas why PDOStatement::execute is returning false? I get no connection errors, no PDOExceptions, the db structure is correct, and there is valid data in the database.

Any help appreciated, thanks.

I had some code that I'm pretty sure used to work, basically something like the below.

Code: [Select]
if (preg_match("/[a-zA-Z0-9]+/", $_POST['title'])) {
   echo $_POST['title'];exit();
}
Now i just don't get why it always returns true, even when entering special characters like "!#%?"..

The only thing which comes to mind, is that i recently made a move to UTF-8..

I have an IF statement that is constantly returning TRUE, even when it shouldn't be. Basically it checks if an array is empty.

Code: [Select]
<?php

      $error = array();
      

      //No blanks
      if ($street_addr == "" || $city == "" || $state == "" || $zip == "" || $phone1 == "" || 
            $phone2 == "" || $phone3 == "" || $county == "")
               $error[] = "You left something blank!";
      
      //validate zip
      if(!preg_match("/^[0-9]{5}$/", $zip)) 
          $error[] = "The ZIP code must be a 5-digit number.";
          
      //validate phone number
      if (!is_numeric($phone1) || !is_numeric($phone2) || !is_numeric($phone3))
         $error[] = "Phone can only contain digits";
         
      if (strlen($phone1) < 3 || strlen($phone2) < 3 || strlen($phone3) < 4)
         $error[] = "Invalid phone number";

      $count_errors = count($error);
         
      if ($count_errors > 0){
      
         echo "ERROR:<br />";
         
         foreach ($error as $err){
         
            echo "-$err<br />";
         
         }
         
      } else { 
         
          //Other code
      }

?>

So the first part of the IF statement is always executing.

$count_errors DOES return 0 when printed out.

Any help would be greatly appreciated. Thanks!

I find it a bit buggy that strpos returns false instead of -1.   The equivalent C implementation returns -1:

int strpos(char s[], char t[])
{
    int i, j, k;

    for (i = 0; s[i] != '\0'; i++) {
        for (j=i, k=0; t[k]!='\0' && s[j]==t[k]; j++, k++)
            ;

        if (k > 0 && t[k] == '\0')
            return i;
    }

    return -1;
}

The problem with returning false is that false can also evaluate to 0 which can also happen to be the first index of a match. Therefore, you have a hard to find bug. I know that you can use the identity operator to check for falseness: ===. But wouldn't it be a better design for the function to just return -1?

Does anyone see anything wrong with the SQL?  This function keeps returning false.

Thank you for your time.

Code: [Select]
function insert_survey1($survey1_anwers) {
  // extract order_details out as variables
  extract($survey1_anwers);
 
  $username = $_SESSION['valid_user'];
  $conn = db_connect();

  // select user_id based on the entered data
  $query = "SELECT user_id FROM user WHERE
gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
username = '".$username."'";

  $result = $conn->query($query);

  //if the resulting user_id exists (AND has the POST data just entered, since the query must match those to return a row) ,
  if($result->num_rows>0) {
    //return the current row of the result set as an object and place it into user variable
    $user = $result->fetch_object();
//set variable for user_id to the fetched user object data representing the user_id int he db( because it was fetched from the sql select result)
    $user_id = $user->user_id;
//update the fields since the user exists already.
$query = "UPDATE user
SET gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
WHERE user_id = '".$user_id."'";

// $query = "UPDATE `alumni_survey`.`user`
// SET `gender` = '".$gender."',
// `birth_range` = '".$birth_range."',
// `degree_year` = '".$degree_year."'
// WHERE `user`.`user_id` = '".$user_id"'";
  } else {
//otherwise, if the user doesn't exist already insert this new data.
    $query = "INSERT INTO user (gender, birth_range, degree_year)
VALUES('".$gender."','".$birth_range."','".$degree_year."')
WHERE user_id = '".$user_id."'";
    $result = $conn->query($query);

    if (!$result) {
       return false;
    }
  }
 
  return $user_id;
}

*delurk! It had to happen sooner or later!*

OK, I am totally and utterly stumped. I have this script:

$this->clear_cache ($this->cache_dir, $this->cache_time);

if ($this->cache_time > 0) {
$current_page = $_SERVER ['REQUEST_URI'];
$current_page_encoded = base64_encode($current_page);
$current_page_path = $this->cache_dir . $current_page_encoded;

 if (file_exists($current_page_path)) { // see if there is still a file with the name of the current request URI after cache cleared
                $content = file_get_contents ($current_page_path);

return $content;
                } 
         }

Basically, it is for checking if there is a cached version of the page before running the rest of the script, using the REQUEST_URI as the identifier. So it calls a function to clear the cache, which works fine (and I've tried just deleting the cache files manually anyway).

Then it checks if we are even caching, i.e. if cache time is greater than 0. Then it uses the BASE64-encoded REQUEST_URI (under which name the file would have been cached previously) to check if a file with that name still exists in the cache dir, and if so loads it. Now, this works perfectly with a url like:

mysite/myscript/mysubpage

But when the page has parameters, like:

mysite/myscript/mysubpage?search=widgets

the file_exists function returns TRUE, even though the directory is empty. I did do a clearstatcache(); but it made no difference and anyway, it wouldn't explain why the URI with query string would fail while the regular one would not. And even if something is wrong with my code elsewhere, the fact is it is returning TRUE for a non-existent file.

Can someone prevent my slide into insanity?!

Hi I am new to php,  I am trying to capture the url and place into a variable but I only get the 1st digit to show,  I just cant see what I am doing wrong. 

Sorry to ask such a basic question but I just can't work it out,  I have attached a screen shot of all me code, your help would be very very much appreciated.

hi there,

is there a difference between if($var == false) and if(false == $var)

thankyou!

$looponce = 1;
foreach ($this->info as $k => $v) {
if ( (($k == 'subject') && ($v['required'])) && (!$this->settings['customSubject'])) {
for ($i = 0; $i <= 0; $i++) {
$output[] = $this->display_errors('error_system_subject');
}
}
if ( (($k == 'name') && (!$v['required'])) || ((!array_key_exists("name", $this->info)) && ($looponce == 1)) ) {
$output[] = $this->display_errors('error_system_name');
$looponce++;
}
}

That is my loop that i check things in. What i'm more interested in is the name if statement.

If currently checks for a name key in an array(below) and makes sure that it is set to required. If it's not set to required, print out a system error and die()'s.

I'm looking for ways to remove the need for program errors and just change them to what is needed to run.

What i know how to do is, get into the inner array, what i don't know is how to edit the data and put it back exactly as it was given to me. The inner array data can be put back in any order, but the outer array must be in exact order as it was given.


above code $this->info = $formdata;

$formdata = array(
'name' => array('name'=>"Full Name", 'required'=>false, 'type'=>'text'), # This needs to be required=>true, but i can't trust the user, which is why i have the error.
'telephone' => array('name'=>"Telephone", 'required'=>false, 'type'=>'phone'),
);


Any help is greatly appreciated, also am i doing the foreach loop in the code above in an efficient manner or is there another way?

I can't access an array value in a multidimensional array.  The if should be echoing true.  $news['companyid'] is equal to 1, but I must not be using in_array correctly.

Code: [Select]
echo '<pre>';
print_r($own_company);

if (in_array($news['companyid'], $own_company))
{
echo "true";
}

Output
Array
(
    => Array
        (
            [companyid] => 1
            [companyname] => Oaysus
            [companytag] =>
            [companywebsite] => http://oaysus.com
            [country] => 1
            [state] => 0
            [city] =>
            [industry] => 4
            [stage] => 2
            [capitalrequested] =>
            [guestviews] => 0
            [iviews] => 3
            [eviews] => 3
        )

)

hi i wants to skip few categories from xml feed but have problem, here is my code which is working:

foreach ($xml->channel->item as $item) { 

                foreach ($item->children() as $child) {
                    if ($child->getName() == 'category') {
                        $categories[] = (string) $child;
                    }
                }
if((in_array("one",$categorie) || in_array("two",$categorie)  in_array("three",$categorie))  {
continue;
}
// other code here
}


and here is what i wants to separate categories in $skipcats but its not working.

$skipcats = array("one","two","three");
foreach ($xml->channel->item as $item) { 

                foreach ($item->children() as $child) {
                    if ($child->getName() == 'category') {
                        $categories[] = (string) $child;
                    }
                }
foreach ($skipcats as $skip) {
if(in_array($skip,$categorie)) {
continue;
}
}
// other code here
}

please what i am missing.
thanks for any guidance .

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 know this works and that's why I'm puzzled. I'm bringing in data from a textarea and trying to compare it.

index.php
Code: [Select]
<form name"fruit-farm" action="fruit-check.php" method="POST">
<textarea name="fruit-list">
Apples
Bananas
Oranges
Pickles
Hamburgers
Grapes
</textarea>
<input type"submit" name="submit" value="Check The Fruit">
</form>

fruit-check.php
Code: [Select]
if (isset($_POST['submit'])) {

//Bring in the data
$fruit-list = explode("\n", $_POST['fruit-list']);

//Search for Hamburgers
$hamburgers = "Hamburgers";

 if (in_array($hamburgers,$fruit-list)){
echo "That is not a fruit";
 }

}

What's puzzling me is that it's not working. It must be something blantently obvious. It has something to do with the '$fruit-list' array and how it is being brought into the form. It posts fine. The reason I think this is the case is because if I simply create an array that is identical to the form coming in it works:

Code: [Select]
if (isset($_POST['Submit'])) {

//Bring in the data
$fruit-list = explode("\n", $_POST['fruit-list']);

//Search for Hamburgers
$hamburders = "Hamburgers";

$fruit-list = array('Apples', 'Bananas', 'Oranges', 'Pickles', 'Hamburgers', 'Grapes);

 if (in_array($hamburders,$fruit-list)){
echo "That is not a fruit";
 }

}

When I 'print_r' both arrays they both look identical. What is wrong and/or different with the way I'm bringing in the textarea that's causing this not to work?