PHP - Compare Two Columns?

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 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?

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!

I know the forum is supposed to be used to help with any code I have come up with but here's to taking a shot anyway:

I am in need of creating a php script that will allow me to input two different XML files and upon pressing "go" will compare these two files and save only the differences to a new xml file.

Thing is, I have no idea where to start. Are there any php functions that exist that I can use to do this? If not, cn someone help me create one? Would this be better handled in javascript? If so, how can I do so using a method similar to the above?

Any kind of help would be greatly appreciated.

I thought I was able to determine which DateInterval is greater the same as done with DateTime, however, either this is not true or I am doing something wrong.  Please advise.  Thanks!

    private function compareDateInterval(\DateInterval $dateInterval1, \DateInterval $dateInterval2):bool
    {
        $greaterThan = $dateInterval1 > $dateInterval2?'true':'false';
        echo("test1: dateInterval1 > dateInterval2: $greaterThan\n");

        $dateTimeNow = new \DateTimeImmutable;
        $dateTime1 = $dateTimeNow->add($dateInterval1);
        $dateTime2 = $dateTimeNow->add($dateInterval2);
        $greaterThan = $dateTime1 > $dateTime2?'true':'false';
        echo("test2: dateTime1 > dateTime2: $greaterThan\n");

        $timestampNow = $dateTimeNow->getTimestamp();
        $timestamp1 = $dateTime1->getTimestamp();
        $timestamp2 = $dateTime2->getTimestamp();
        $greaterThan = $timestamp1 > $timestamp2?'true':'false';
        echo("test3: timestamp1 > timestamp2: $greaterThan\n");
        
        echo('$dateTimeNow => '.json_encode($dateTimeNow).PHP_EOL);
        echo('$dateInterval1 => '.json_encode($dateInterval1).PHP_EOL);
        echo('$dateInterval2 => '.json_encode($dateInterval2).PHP_EOL);
        echo("timestampNow: $timestampNow, timestamp1: $timestamp1, timestamp2: $timestamp2\n");
    }

<b>Warning</b>:  Cannot compare DateInterval objects in <b>/var/www/app/src/Tools/PointTransitionHistory.php</b> on line <b>136</b><br />
test1: dateInterval1 > dateInterval2: false
test2: dateTime1 > dateTime2: true
test3: timestamp1 > timestamp2: true
$dateTimeNow => {"date":"2020-08-23 15:06:24.454702","timezone_type":3,"timezone":"UTC"}
$dateInterval1 => {"y":0,"m":0,"d":2,"h":14,"i":0,"s":0,"f":0,"weekday":0,"weekday_behavior":0,"first_last_day_of":0,"invert":1,"days":2,"special_type":0,"special_amount":0,"have_weekday_relative":0,"have_special_relative":0}
$dateInterval2 => {"y":0,"m":0,"d":11,"h":15,"i":0,"s":0,"f":0,"weekday":0,"weekday_behavior":0,"first_last_day_of":0,"invert":1,"days":11,"special_type":0,"special_amount":0,"have_weekday_relative":0,"have_special_relative":0}
timestampNow: 1598195184, timestamp1: 1597971984, timestamp2: 1597190784

 

how to compare date with current date
let say $date="2010-10-08 2:00 PM"
how can i compare $date with current date and get the result in days, hours, minutes and seconds

thanks

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

I typically only use the first two solutions.  Is there anything wrong with the third?  Is there any more streamlined way to do it?

function f1($x){return $x*1;}
function f2($x){return $x*1;}

$x=2;$y=1;

if(f1($x)>f2($y)){echo(f2($y)."\n");}

// or

$f2_y=f2($y);
if(f1($x)>$f2_y){echo($f2_y."\n");}

// or

if(f1($x)>$f2_y=f2($y)){echo($f2_y."\n");}

Let's say for example I have 3 ID's in ONE database row like this:
       
name: values: page ids 17 23 32
And I have a list of page titles with the ID's of the pages inserted into the value field of a checkbox.

[] page title 1
[] page title 2
[] page title 3
[] page title 4
[] page title 5
[] page title 6

What I Want to Do!
I want to fetch the page ID's from the database and I want a way to see if there match any page ID's from the list with the page ID's from the database row. Based on that I want to run an if statement. How can I do that?

The string of ID's from the database would be the haystack, and the ID's from the list would be the needles, and every time one ID from the haystack matches with an ID from the list then that page title should be automatically marked as checked with the help of an if statement.


This is how the list gets listed, with a foreach loop:


 <?php 
  $pages = get_pages(); 
  foreach ($pages as $pagg) {
  

$option = '<input type="checkbox" name="exclude[]" value="'. $pagg->ID .'">';

$option .= $pagg->post_title . "<br />";

echo $option;
  }
 ?>


Now I need to compare the ID in the value field with the ID string (separated by spaces) in the database row, and when a match occurs then execute a case.

I know there are functions like str_replace and similar, but I'm not sure if I can do that with them, what would be a fitting function for my case?

Hi Everyone,

I am working on developing a blog/comment system for my website. I have 3 tables, the first a blog post table with a row/primary key of id that is auto incremented as each new article is created via a form. The second table is a comments table with a row of article_id and the third table is a category table with an article_id row as well.

From the main blog page I have links that will take users to each individual blog post using $_GET like so:

Code: [Select]
http://www.mydomain.com/blog/article/?id={$row['id']}
From here I would like to be able to display the comment for that particular article below the article and also have a sidebar with links to blog categories which will then display each post according to whether they are in that category or not.

My question is two-fold:

First, what is the best way to pull the id field from the blog/post table, form, or url and enter it into the article_id rows of the second two tables? Should I use a hidden field, the URL id via $_GET, using a join, or what?

Secondly:

What is the best way to compare and display those rows so that the appropriate comments are being shown for the correct article, etc.

This is my first time doing this so I am grateful for any help or suggestions.

Thanks,

kaiman

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. 

Assuming that I have two variables:


$exURL=@$HTTP_REFERER;

$goodURL = 'http://www.SomeSite/login/';


How can I check if the two URLs match each other?

Regards

Hi!
I have two similar  tables on two different databases and i need to check if there are any entries on the table1, for example, that there aren't on the second table and print if there are i need to print them.
Any suggestions?
Thank you...

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!