PHP - How To Compare Two Dateintervals

I have this code that compares date times but im not sure if its correct.

if("2008-08-10 00:00:00.0" > strtotime("now")) {
        echo "here";
    }


The code echo's here, but it shouldn't because the time is less than the current time. Any ideas?

Hi, I am trying to write an SQL to XML converter, so so far I have all the records inputted into the db tables, and now I want to append a child, but I don't know how to compare current row's field value with the next row below it, specifically I want to check if a current row is parent of the next row. I have already got the XML to SQL function working (some bugs but for the most part it's working)

So for eg:
<?php
$query=mysql_query("SELECT * FROM edge");
while($row=mysql_fetch_assoc($query) ) {
     if($row['target'] is parent of the next row),  then
                append the next row as child of current row
}

?>

Table edge is one of the tables that hold target node/source(aka: parent) nodes.

Any help much appreciated!

Hi!

What should the code be if I get an IP address to a postback url and I want to find that member in my database who has that IP-address?
The postback comes like this http://yoursite.com/postback.php?ip=xxx

Please help

I run an article directory. I was wondering how I could check an article that is currently pending review against published articles in our database. What I am looking to do is to place the content of the body in the pending article into a variable. That much is easy and I know how to do that. Then I would like to use that variable to compare against other content in our database and have it output a percentage of how close it is to any other article already published in our database. Any direction our guidance with this would be so greatly appreciated.   


Thanks!

Hi everyone!
I've been looking for a solution, but i just can't find it anywhere...

Ok, so the problem is:
i have a database which looks something like this:

user_id product_id score
14 . 235 . 79
23 . 235 . 32
53 . 665 . 21
14 . 235 . 90
5 . 675 . 45


This is step-by-step of what i need to do:

1. Select user - user_id =343

2. For user_id =343 select all products that he gave score to:
product_id = 43 - score = 99
product_id = 12 - score = 56
product_id = 68 - score = 32
product_id = 124 - score = 67

3. Find all users that voted for the same products e.g.:
for product_id = 43:
user_id = 125 voted 93 points,
user_id = 23 voted 56 points.


4. Calculate the difference between the score of user, so:
for product_id = 43:
user_id = 125 voted 93 points (99 - 93 =6 points of diff.)
user_id = 23 voted 56 points (99 - 56 =43 points of diff.)
return the results....


That's basically what i need to do. I still don't know the number of the users, or product, but it doesn't really matter - i just need to make it work.
Ok, hope someone can help!

Hi!
I have a table called "Categories"

Here is the structu
id | Categories               |  ParentCategories
1  | Rings                        | Parent Category
2  | Pendants                  | Parent Category
3  | Ladies Rings             | Rings
4  | Ladies Pendants       | Rings
5  | Gents Rings              | Gents
6  | Necklaces                 | Parent Category

But Necklaces is one of those who is not going to have any subcategories or you can say, it is going to be a category by itself.

So how can I construct a php statement to get data out of MySQL to determine that Necklaces is a Category which does not have subcategories.

Please help !

Thank you !

- Xeirus.

I need to compare several arrays...to narrow down a bunch of mysql selects.

I can't figure out which of the array_diff, array_unique, array_merge options there are.

I need to get an array of umpires (baseball), then compare that to the array of umpires that can work a given level, then compare that to the array of umpires that can work at that school, and finally compare that to the array of umpires who have asked for the day off.

In the code below, all of the selects work...the echo's that are commented out printed out what I expected them to.

I'm having a problem with the array comparisons at the end of this code:

Code: [Select]
<?php
//connect to database
$dbc = mysql_pconnect($host, $username, $password);  
mysql_select_db($db,$dbc);  


//get info of game
$sql = "SELECT sport,home,day FROM games WHERE `game_id` = $_GET[game]"; 
$rs = mysql_query($sql,$dbc);  
 while($row = mysql_fetch_array($rs))
            {
              $game_array = $row['sport'];
      $home_team_array = $row['home'];
  $game_day_array = $row['day'];
}


//list of all umpires in association
$sql = "SELECT ump_id FROM ump_names WHERE '$_SESSION[association_id]' = `association_id`"; 
$rs = mysql_query($sql,$dbc);    
 while($row = mysql_fetch_array($rs))
            {
                        $name_array[] = $row['ump_id'];
//  echo "<br /><br />All Ump ID's Array = "; 
//  foreach($name_array as $name_array_final) {
//                         echo $name_array_final . "<br />";
//                         }
            }


//get bad schools list
$sql = "SELECT ump_id FROM bad_school WHERE '$_SESSION[association_id]' = `association_id` AND `school` = '$home_team_array' and `sport` = '$game_array'"; 
$rs = mysql_query($sql,$dbc);  
 while($row = mysql_fetch_array($rs))
            {
                        $bad_school_array[] = $row['ump_id'];
//  echo "<br /><br />Bad School Array = "; 
//  foreach($bad_school_array as $bad_school_array_final) {
//                         echo $bad_school_array_final . ",&nbsp;";
//                         }

            }
//get official list at this game's level
$sql = "SELECT ump_id FROM ump_names WHERE `association_id` = '$_SESSION[association_id]' AND `$game_array` = '1'"; 
$rs = mysql_query($sql,$dbc);  
 while($row = mysql_fetch_array($rs))
            {
                        $official_level_array[] = $row['ump_id'];

//  echo "<br /><br />Officials that can work this level of game = "; 
//  foreach($official_level_array as $official_level_array_final) {
//                         echo $official_level_array_final . ",&nbsp;";
//                         }

            }

//get vacation list
$sql = "SELECT ump_id FROM days_off WHERE '$_SESSION[association_id]' = `association_id` AND `day` = '$game_day_array'"; 
$rs = mysql_query($sql,$dbc);  
 while($row = mysql_fetch_array($rs))
            {
                        $days_off_array[] = $row['ump_id'];
//  echo "<br /><br />Officials that are on vacation this day = "; 
//  foreach($days_off_array as $days_off_array_final) {
//                         echo $days_off_array_final . ",&nbsp;";
//                         }
            }



//$first_step = array_merge($official_level_array, $name_array);
$first_step = array_merge($official_level_array, $name_array);
$first_step_part_2=array_unique($first_step); 

//$second_step = array_merge($bad_school_array, $first_step);
$second_step = array_merge($bad_school_array, $first_step_part_2);
$second_step_part_2=array_unique($second_step); 

//$third_step = array_merge($days_off_array, $second_step);
$third_step = array_merge($days_off_array, $second_step_part_2);
$third_step_part_2=array_unique($third_step); 

echo "These umpires are available for this game:<br />";
foreach ($third_step as $iamavailable) {
echo "$iamavailable<br />";

}

?>

This prints out:

Quote

2
1
2
4
5
6
10
14
15
3
7
8
9
11
12
13
16
17



It should only print out 4, 5, 6, 10, 14, 15.

What I want to do is:  compare $official_level_array and $name_array...only keep those that are in $official_level_array.

Then, compare that result with $bad_school_array...removing those in the $bad_school_array...and keeping the ones that are left.

Then, compare that result, with $days_off_array...removing those in the $days_off_array...and keeping the ones that are left.

Print out what's left...


Where am I going wrong?

hi
i am am making a leave calendar ...i want to compare dates and if the matches the background will be changed .
i am try to do is i got two loops first for  12 months and seconds for numbers of days in that month and i am using $num = cal_days_in_month(CAL_GREGORIAN, $Month, $cYear)
 this will give be numbers of days in that month...
 then there is a my sql query which will select that dates and other data from database ..
now problem i am have is that numbers of days are not increment  it show date like 2011-1-1 ,2011-1-1 and so on instead of 2011-1-1, 2011-1-2....
please help me ..here

<<pre lang="xml">table >
<?php for($Month=01;$Month <= 12;) { ?>
    <tr>
        <td  width="18%"  colspan="2"><strong><?php echo $monthNames[$Month-1]; ?></strong></td>
        <td  width="12%"  colspan="2"><strong>Division</strong></td>
        <?php
        $num = cal_days_in_month(CAL_GREGORIAN, $Month, $cYear); // 31
        //$dates = date("$cYear-$Month-1");
            $sql ="SELECT leave_date,leave_status,leave_comments,leave_type_id FROM `hs_hr_leave` WHERE employee_id = $emplid ";
            $res = mysql_query($sql);

        for($i=1;$i<=$num;$i++)
        {   $dates = date("$cYear-$Month-$i");
                //echo $dates."<br/>";
            while ($row = mysql_fetch_row($res, MYSQL_NUM)) {
                 $time2=date("Y-n-j",strtotime ($row[0])).'<br/>';
                echo    "<td bgcolor='red'>".$dates."--".$time2."</td>";
                //echo  "<td>".$row[1]."</td><br/>";
                //echo  "<td>".$row[1]."</td><br/>";
                //echo  "<td>".$row[2]."</td><br/>";
                                }
            echo "<td width='26' height='20px' align='center' valign='middle' >".$i."</td>";
        }
        //echo "<br/>";
        $Month++;
    }
?>
    </tr>
</tabl

Hello Guys,

I am trying to figure this out..

I have a page that has several check boxes that when checked the values ends up as an array
Like this

1, 3, 9, 6,

That's what it looks like in the database.

I want to compare the values (numbers) submitted with the values in my database table called benefits

Here is the function

I wrote this function and I want to check the values of the submitted values but I am just not sure how to compare the values, especially with a comma in the array.

Code: [Select]

$benefits2 = $_POST['benefits'];

function check_benefits ($benefits2,$member_id,$description,$ip){
$queryb = mysql_query("SELECT * FROM benefits WHERE b_id = $benefits2");
while ($row = mysql_fetch_array($queryb)) {
$benefit_list = $row['b_id'];
}

 if (isset($benefits2)&&( $benefit_list!== $benefits2)) {
 
  Do something here!
 }
 
 }


Thanks for your help!

Hi there im not quite sure where im going wrong here.

I have 2 queries; the first selects all records in a table == Session username. The second selects all records in a table <> Session username

Both work independently but when i try to compare a field in each table (The: PlanetName) it doesnt work. Im trying to make it so that if the same PlanetName is in  the first query and the second in any of the records it will output an ID.

Code: [Select]
<?php $colname_Fleet = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Fleet = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Fleet = sprintf("SELECT FleetName, PlanetName FROM fleet WHERE PlayerName = %s", GetSQLValueString($colname_Fleet, "text"));
$Fleet = mysql_query($query_Fleet, $swb) or die(mysql_error());
$totalRows_Fleet = mysql_num_rows($Fleet);

$colname_FleetE = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_FleetE = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_FleetE = sprintf("SELECT FleetName, PlanetName FROM fleet WHERE PlayerName <> %s", GetSQLValueString($colname_FleetE, "text"));
$FleetE = mysql_query($query_FleetE, $swb) or die(mysql_error());
$totalRows_FleetE = mysql_num_rows($FleetE);



while ($row_FleetE = mysql_fetch_assoc($FleetE) && $row_Fleet = mysql_fetch_assoc($Fleet)){

if($row_Fleet['PlanetName'] == $row_FleetE['PlanetName']){
echo $row_Fleet['FleetName'];
echo' ';
}}
?>
Any help would be appreciated.

Thanks

I am able to run and display two queries I need for my program but having issues comparing the two result sets. If they are identical, means both tables are also identical (the query is for the table's schemas in MS-SQL)

Here's the relevant part ...

Code: [Select]
//Variables


$table_name=$_POST['table_name'];


// Connect via Windows authentication
$server = 'win1\i01';

//Connection info for PRO
$connectionInfoPRO = array(

'Database' => 'adventureworks',
'CharacterSet' => 'UTF-8'
);
$dbPRO = sqlsrv_connect($server, $connectionInfoPRO);
if ($dbPRO === false) {
    exitWithSQLError('Database connection to PRO failed');
}


//Connection info for ITG
$connectionInfoITG = array(

'Database' => 'adventureworksCOPY',
'CharacterSet' => 'UTF-8'
);
$dbITG = sqlsrv_connect($server, $connectionInfoITG);
if ($dbITG === false) {
    exitWithSQLError('Database connection to ITG failed');
}



/* Set up and execute the query. */

$query1 = "SELECT COLUMN_NAME, DATA_TYPE, ORDINAL_POSITION, COLUMN_DEFAULT, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME='$table_name'";
 
// Run PRO query

$qresult1 = sqlsrv_query($dbPRO, $query1);
if ($qresult1 === false) {
    exitWithSQLError('Query of product data failed.');
}

echo '<tr><th>NAME</th><th>TYPE</th><th>POSITION</th><th>DEFAULT</th><th>LENGHT</th><th>IS NULLABLE</th></tr>';

// Retrieve individual rows from the result
while ($row1 = sqlsrv_fetch_array($qresult1)) {

    echo '<tr><td>', htmlspecialchars($row1['COLUMN_NAME']),
         '</td><td>', htmlspecialchars($row1['DATA_TYPE']),
         '</td><td>', htmlspecialchars($row1['ORDINAL_POSITION']),
         '</td><td>', htmlspecialchars($row1['COLUMN_DEFAULT']),
         '</td><td>', htmlspecialchars($row1['CHARACTER_MAXIMUM_LENGTH']),
  '</td><td>', htmlspecialchars($row1['IS_NULLABLE']),
         "</td></tr>\n";
}


// null == no further rows, false == error
if ($row1 === false) {
    exitWithSQLError('Retrieving schema failed.');
}



//Run ITG query

$query2 = "SELECT COLUMN_NAME, DATA_TYPE, ORDINAL_POSITION, COLUMN_DEFAULT, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME='$table_name'";



$qresult2 = sqlsrv_query($dbITG, $query2);
if ($qresult2 === false) {
    exitWithSQLError('Query of product data failed.');
}


echo '<tr><th>NAME</th><th>TYPE</th><th>POSITION</th><th>DEFAULT</th><th>LENGHT</th><th>IS NULLABLE</th></tr>';

// Retrieve individual rows from the result
while ($row2 = sqlsrv_fetch_array($qresult2)) {
    echo '<tr><td>', htmlspecialchars($row2['COLUMN_NAME']),
         '</td><td>', htmlspecialchars($row2['DATA_TYPE']),
         '</td><td>', htmlspecialchars($row2['ORDINAL_POSITION']),
         '</td><td>', htmlspecialchars($row2['COLUMN_DEFAULT']),
         '</td><td>', htmlspecialchars($row2['CHARACTER_MAXIMUM_LENGTH']),
  '</td><td>', htmlspecialchars($row2['IS_NULLABLE']),
         "</td></tr>\n";
}


// null == no further rows, false == error
if ($row2 === false) {
    exitWithSQLError('Retrieving schema failed.');
}


How can I compare $row1 and $row2 here (the query results for each one) and validate if they both have same results, each and all columns.

Any help is highly appreciated!

Hello dear friends,

okay here is the story

i've 2 incoming entries

Code: [Select]
$name = "Manal Nor";
$comment = "Hello lovely world";
and i've stored into database table some bad words to be banned

my_table (id,word)


My objective
Is to compare if $name and/or $comment have any of the banned words in my_table


I can apply for $name only , i mean i can compare $name and know if it have any banned words or not using the following code

Code: [Select]
$name = "Manal Nor"; // Example .. no bad words

$sql    = "SELECT * FROM my_table";
$result = mysql_query($sql);

$nameArray = explode(" ", $name);
$countname = count($nameArray);
$checkname = 0;

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

for ($i == 0; $i < $countname; $i++) {

if (strcasecmp($nameArray[$i], $row['word'])) {
$checkname = 1;
}

}

}

if ($checkname == 1) {
echo "banned";
exit;
}else {
echo "passed";
}
it works perfect 

but now the question how to apply it like cheese burger i mean for both $name and $comment so that i can use

  any help please

Hi again everyone,

I am trying to compare a php variable to the value of a row in mysql, but keep getting the following error:

Code: [Select]
Wrong perameter count for mysql_result()

What syntax would I use to accomplish this?

Here is my code:


// connects to server and selects database.
include ("../includes/dbconnect.inc.php");

// table name
$table_name = "availability";

// split up date into 3 separate fields
$date = "12/25/2010";
$date_split = explode("/", $date);
$month = $date_split[0];
$day = $date_split[1];
$year = $date_split[2];

// check if earth room is already reserved
$taken = "Reserved";
$sql = "SELECT earth_room FROM $table_name WHERE month='$month' AND day='$day' AND year='$year' LIMIT 1";
$result = mysql_query($sql) or trigger_error("A mysql error has occurred!");
$row = mysql_result($result);

if($row == $taken){
echo "Room Already Reserved";
}
else{
echo "Room Available";
}


Thanks for the help,

kaiman

Hello! I've been stuck with this for a while now. First I want to say that this is a school project and not something illegal bet site.

The first MySQL table have results from games and the other table contains users bets on different games..
My problem is that I don't know how to make the two tables compare and then by that change some numbers in MySQL table.

So I want the code to look if the team1 and team2 on both tables are the same. Then look if the bets (1,X or 2) are the same. If they are, change (in table "Bets") w to 1 and if now change (in table "Bets") l to w.

I think my problem might be that i don't know how to make the while loop...

This is my code:


$tbl_name="Bets";

$tbl_name2="results";

//connect to MySQL and chose database
mysql_connect("$host", "$username", "$password")or die("Connection could not be Established");
mysql_select_db("$db_name")or die("Could not select DB");

$loginusername=$_SESSION['loginusername'];

$sql="SELECT * FROM $tbl_name WHERE user='$loginusername'";
$r=mysql_query($sql);
$i=0;
$betarray=array(array());
while($rows=mysql_fetch_array($r))
{
   $betarray[$i]=$rows;
   $i++;
}



foreach($betarray as $insidearray)
foreach($betarray2 as $insidearray1)
{
      while($rows=mysql_fetch_array($r))
      {
         $team1 = $insidearray['team1'];
         $team2 = $insidearray['team2'];      
      if($team1 == $insidearray1['team1'] && $team2 == $insidearray1['team2'])
         {
         $team1 = $insidearray['team1'];
         $team2 = $insidearray['team2'];
         $x12 = $insidearray['1x2real']
         
            if($x12 == $insidearray1['1x2'])
               {
                  $update="UPDATE $tbl_name SET w='1' WHERE user='$loginusername' AND team1='$team1' AND team2='$team2'";
                  mysql_query($update);
               }
               else
               {
                  $update="UPDATE $tbl_name SET l='1' WHERE user='$loginusername' AND team1='$team1' AND team2='$team2'";
                  mysql_query($update);               
               }

         }
         

      }
}
}




Thanks in Advance!

I am building a site that needs to update member accounts on a weekly basis.  At the moment I have a cron job set for 12:01 am on Monday, that resets five database fields for all of my members. The first field is the current week, the second field is the previous week, the third field is from two weeks ago, the fourth field is from three weeks ago, and the fifth field is from four weeks ago.  Obviously the cron job resets the first field to 0, and the data from this field is moved to field two (last week), and so on and so forth, and the data from the fifth field is just removed altogether.  However, this is really not preferred, because if/when I get 1000+ users, the cron job will take up a crapload of CPU as many mysql queries need to be executed for each account.

So, I am trying to implement a script that checks the last login date for a user, and if they have have not logged in since before the latest Monday, the Monday before that, the Monday before that, or the Monday before that, etc.

I have never really worked with dates, so I don't even know how to begin.

The last user login is stored as a DATA datatype in a mysql database, and is in the following format: YYYY-MM-DD.

Thanks in advance!