PHP - Session Expiry/times

Hello guys, I am new to PHP. I need some help.

I am trying to build a web app, in which I have login functionality. I want to keep the logged in user session active for around 3-4 months. But in my case as soon as I close the browser, session data is lost and I need to login again.

Can anyone help me with this.

Hello,

I am struggling here. Basically I have integrated a Google Maps API with a website to show the location of the next session.

This script will take the next session and return its location, so the lat and long can be fetched from another table and fed into the API.

Here is the timetable in a MySQL table:



I am trying to do/say the following:

* Show current session (if in progress)
* Show next session. (Only to be fetched from db when the previous session has expired)
* If there are no sessions left on today's date, show next session on next day with sessions.

How could I write this as a PHP query in order to the fetch the location data?

Thanks,
George.

I'm trying to get an expiry date to work on my project.... but at the moment... it doesnt seem to be working.

Heres the code for the main news submission form:

Code: [Select]
<form action='newsubmit.php' method='POST'>
   Title: <input type='text' name='title' /><br />
   Story: <input type='text' name='story' /><br />
   Upload Image:
   <a href="#" onclick="window.open('fileuploadprocess.php','mywindow','width=450,height=300,toolbar=no,location=no,directories=no,s tatus=no,menubar=no,scrollbars=yes,copyhistory=yes,resizable=yes')"> Click here</a>
   
   <?php
require_once('../../../2740/recaptcha/recaptchalib.php'); 
$publickey = "6Ldbd8ASAAAAAL96lIWHSDRmoaVJhgQJuKQwXNbd"; 
echo recaptcha_get_html($publickey);
?>
   
   <input type='submit' name='submit' value='Submit' />
   <input name='reset' type='reset' value='Reset' />
   </form>


Heres the code for the submission page:

Code: [Select]

<?php
  include_once("functions.php");
  session_start();
  
  $submit = clean_string($_POST['submit']);
  $title = clean_string($_POST['title']);
  $story = clean_string($_POST['story']);
  $datetoday = date('Y-m-d', $expires);
  $daystoexpire = '7';
  $expires = time() + (86400 * $daystoexpire);
  $userid = $_SESSION['userID'];
  $newsimage = $_SESSION['imagelocation'];
  
  $message = '';
  
  
  
  
  require_once('../../../2740/recaptcha/recaptchalib.php');
  $privatekey = "6Ldbd8ASAAAAAFz8VT29H5w4WLNjsbI-mFY2QkaC";
  $resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
  $message = "";
  
  if ($submit == 'Submit') {
      if (!$resp->is_valid) {
          // What happens when the CAPTCHA was entered incorrectly
          $errMessage = $resp->error;
          $message = "<strong>The reCAPTCHA wasn't entered correctly. Please try again.</strong><br />" . "(reCAPTCHA said: $errMessage)<br />";
      } else {
    
          
        
          // Process valid submission data here 
          if ($title && $story) {
              //process details here
              if (strlen($title) > 80) {
                  $message = "The title you have provided is too long. Please <a href='news_entry.php'>try again</a>";
              } else {
                  if (strlen($story) > 300) {
                      $message = "The news story you have provided is too long. Please <a href='news_entry.php'>try again</a>";
                              } else {
                                  require_once("db_connect.php");
                                  
                                  if ($db_server) {
                                      mysql_select_db("a200458721");
                                      
                                      
                  //Insert news story into news table  
    
                                          
                                          $query = "INSERT INTO news (usersID, title, story, image, datetoday, expires) VALUES ('$userid', '$title', '$story', '$image', '$datetoday', '$expires')";
                                          mysql_query($query) or die("User insert failed. " . mysql_error() . "<br />" . $query);
 
                                          $message = "News Story Successfully Submitted! Return to <a href='index.php'>homepage</a>";
  }
  
  }
  
  }
                                  } else {
                                      $message = "Failed to connect to database";
                                  }
  
 if ($expires < time()) {
    // Expired!
} 
                                  require_once("db_close.php");
                              }
              } else {
              $message = "please fill in all the required fields";
          }
      echo $message;

mysql_close($db_server);




?>


At the moment, this is the error its throwing up:
I'm not sure why its saying about the 1970 date either...

User insert failed. Incorrect datetime value: '1303391514' for column 'expires' at row 1
INSERT INTO news (usersID, title, story, image, datetoday, expires) VALUES ('13', 'NEWS TITLE GOES HERE', 'NEWS STORY', '', '1970-01-01', '1303391514')


Any ideas on why its throwing me up the error?

We are working on a new student application system. Due to privacy laws,
everything will be done behind https. However, this is one of many systems
looked after by the system administrators. I would like to safeguard against
the situation several years down the road when the certificate expires.
There are several administration pages that will be checked frequently by
the graduate admin assistant. While this person has no technical background,
a warning several months before the certificate expires would allow her
to remind the technical staff to renew the certificate.

I know I can use curl to connect to my own server, but that seems like
a long way to do it (and an extra https connection). Is there any way to
get the certificate information for the current https connection from
the server or from the php runtime?