PHP - Php Question About Using Dates With If Statements

I have a table where a filed called "recruitment" can either be "0" or "1"  Why does my below code not work?

Code: [Select]
$sql_rec = ("SELECT * FROM teams WHERE team_id=".$_GET['t']." ");
$rsrec = mysql_fetch_array($sql_rec);
if($rsrec['recruitment'] == 1){
echo "Your team is <b>OPEN</b> for all members to join <br>
<a href='changemode0.php?t=".$_GET['t']."&r=".$_GET['r']." '>(click here to change mod)</a>";}
elseif($rsrec['recruitment'] == 0){
echo "Your team is <b>CLOSED</b> for all members to join <br>
<a href='changemode1.php?t=".$_GET['t']."&r=".$_GET['r']." '>(click here to change mod)</a>";}
to ask in another way: how do I make the if statement to check if the value is "1" or "0"?

Hey guys,

What I'm trying to do is set 2 dates.  Today's date and then a date 14 days from now.  However, I want it to increase the month if by adding 14 days will bring me to the next month, same with the year.

I have this, but it doesn't increment the month or year.

$week = mktime(11, 59, 59, date("m"), date("d")+14, date("y"));
$date =  date("Y-m-d H:i:s", $week);

Hey, I have just recently coded a forum and my topics are ordered by date. This means if there is a topic at 4pm and then there is another topic made at 4:01pm the topic which was posted at 4:01pm will be listed at the top.

I know how to add timezones but there is bit of a problem,  if  person from the UK posts a topic and his/hers timezone is set to:

date_default_timezone_set('Europe/London');()

this means the time at which the topic was posted will be 20:36pm (Just a randome time example).

However if someone posted a topic from america/los_angeles one hour before the one above his/her time will be 11:36 am. Even though this topic was posted one hour before the UK post. The UK topic will override it because it is 8:36pm. In fact, all UK topics will show up at the top and all the america/los_angeles topics will show bellow.

How do I slove this problem? I just don't get it even tough I looked online.

Please help, thanks.

i want to created a case like the following need help with the syntax:
Code: [Select]
switch (true)
{
case($fromdate-$todate==17-04-2001-25-04-2011):
echo $finalprice = $result;
        break;
}

Hi guys,

I am trying to create a program which manages campaigns.
each campaign has a start date and and end date.
a user has to enter data releated to the campaign everyday

example
start date: 10-1-2011
end date: 17-1-2011

now all this information is stored in 2 tables
1st table is "campaigns" this stores the campaign name, start date and end date
and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered

my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long?


table:
campaigns
fields:
id | campaign_name | start_date | end_date

table:
campaign_data
fields:
id | campaign_id | date | page

Thank you

Hi,
So I only want my users to be able to perform certain tasks each 12 hours.
This is the code I use:
Code: [Select]
function canVote($ip, $vote_id, $updateTimer = true){
$time = date("Y-m-d H:i:s");

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->from('votes_voters');
$count =  $this->CI->db->count_all_results();
/*$count = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->from('votes_voters')
-count_all_results();*/

$row = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->get('votes_voters')
->row();

if($count == 0){
$data = array(
   'vote_id' => $vote_id,
   'user_ip' => $ip,
   'last_vote' => $time
);

$this->CI->db->insert('votes_voters', $data);
return true;
}
else{
$last_vote = $row->last_vote;
if($last_vote + strtotime("12 hours") < $time){
return false;
}
else{
if($updateTimer = true){
$data = array(
               'last_vote' => $time,
            );

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->update('votes_voters', $data);
}
return true;
}
}
}
Apparently the failing bit is this:
Code: [Select]
if($last_vote + strtotime("12 hours") < $time){
return false;
}
I believe you can guess what I'm trying to do here, if variable 1 + 12 hours is smaller than variable 2, then return false.
Any help is much appreciated.

How to write 2 "if" statements together?

if($userResult==$myResult) and ($userResult<0)
{

Hey Guys,

I am creating an array and I have a need to put a if statement inside it. Is this even possible?

Here is where I am at so far, its just not working.


 function load_permissions($gid)
    {
     $data = array();
     $this->db->select('`groups`.`name` AS `permission_name`, `permissions`.``');
$query = $this->db->get('`groups`,`permissions`');
if ($query->num_rows() > 0){
foreach ($query->result_array() as $row){
  $data[] = array(
  "name" => $row['permission_name'],
  "read" => if($row['level'] >= 1)
   { 
    img("img/true.gif")
   } else { 
    img("img/false.gif")
   },
 
  );
  }
 }
 
 $query->free_result();
return $data;



Thanks,
Peter

I am trying to write an if statement that checks to make sure the information put in the text box is an imbedded file. Does anyone know how to do that?

Hi Guys,
Newbie trying to understand PHP conditionals.
In the below Code: [Select]
[[*id]] is a global variable which equates to my current page id so it could have the value of 1 for example. I tested it using echo and the correct values pass to it in the cms I'm using. What I cant achieve is for the conditionals below to work correctly so perhaps you can see a syntax error or show me away of doing the same using an array or something perhaps? THANKS

Code: [Select]
<?php
$id='[[*id]]'

if ($id=="1" || $id=="2")
  echo "we are in 1 or 2";
elseif ($id=="3" || $id=="4")
  echo "we are in 3 or 4";
else
  echo "not in 1 to 4";
?>

The below is constantly loading the password page no matter what is enter in the password input on the form (on another page). I have checked the $login variable by echoing it and it is carrying the value from the field.


<?php
$off="yes";
$login=$_POST['login'];
if($off=="yes" && (!isset($_SESSION['login']) || $_SESSION['login']!="pass")){
    if($login=="" || $_SESSION['login']!="pass"){
    header('Location: ./index2.html');
    exit();
    }
    elseif(!isset($_SESSION['login'])){
    session_start();
    $_SESSION['login']=$login;
    header('Location: ./index.php');
    exit();
    }
}
elseif($off=="no" || $_SESSION['login']=="pass"){
content goes here.
}
?> 

Hey guys,

is there any way to have a LIKE condition on an IF statement?
Something like:
Code: [Select]
if $GET_['WTV'] LIKE %LOVE% {
$category=romance
Any clues?
Thanks in advance.

Hello, I am learning PDO SQL statements, I have mananged to connect using PDO:


Code: [Select]
try
{
$this->link = $dbh = new PDO('mysql:host='.$this->dbhost.';dbname='.$this->dbname.'', $this->dbuser, $this->dbpass);
}
catch (PDOException $e)
{
echo 'Connection failed: ' . $e->getMessage();
}


I am not getting any error, so I guess that is a good start. I then tried the PDO SQL statement out. My old mySQL query is commented out in the


Code: [Select]
if (isset($_SESSION['id']) && isset($_SESSION['password']))
{
$_SESSION['id'] = ( isset( $_SESSION['id'] ) ) ? $_SESSION['id'] : FALSE;
$_SESSION['password'] = ( isset( $_SESSION['password'] ) ) ? $_SESSION['password'] : FALSE;


//$logged = mysql_query("SELECT * FROM `db_members` WHERE `id`='".$_SESSION['id']."' AND `password` = '".$_SESSION['password']."'");
//$logged = mysql_fetch_array( $logged );

// the new pdo statement
$ff = $dbh->prepare('SELECT * FROM db_members WHERE id = '.$_SESSION['id'].' AND password = '.$_SESSION['password'].'');

$ff->execute();
$logged = $ff->fetchAll();

echo $logged['username'];
}

I am trying to assign the session to logged variable. So all I am asking is go into db_members and check the id and password that is the same as session id and password and collect the rows data such as username.

My login script and everything works perfectly, even session id and password is valid when echo'd but I cannot assign it to the logged variable like my old sql statements.


Code: [Select]
$logged = mysql_query("SELECT * FROM `db_members` WHERE `id`='".$_SESSION['id']."' AND `password` = '".$_SESSION['password']."'");
$logged = mysql_fetch_array( $logged );

I used other PDO statements and it works perfectly but I just don't understand why this is not working.... can I please get some help if you have any solution to this?

Anything wrong with this because I got a parse error ONLY after adding to create this.

<?php
                            $visible = array('Yes', 'No');
                            foreach($visible as $visible):
                            $visible2 = array('yes', 'no');
                            foreach($visible2 as $visible2):
                        ?>