PHP - Meeting Schedule

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=342882.0

hello guys.
          i need to run a script automatically at scheduled date and time. i am sending bulk emails . i need to setup an email campaign, in such a way that i can schedule like daily, monthly or quarterly..
can u guys give few tips to get it done..

I need help to get flight schedule from http://www.sriwijayaair.co.id/id but always error using curl to access ssl.

here are my code:

<?php
$headers = array(   
"User-Agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 GTB7.1 (.NET CLR 3.5.30729)",
"Accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8",
"Accept-Language=en-us,en;q=0.5",
"Accept-Encoding=gzip,deflate",
"Accept-Charset=ISO-8859-1,utf-8;q=0.7,*;q=0.7",
"Keep-Alive=1150",
"Connection=keep-alive",
"Referer=http://www.sriwijayaair.co.id/id",
"Cookie=language=in; location=id; dest=home; __utma=260465999.1394002812.1293106375.1293106375.1293106375.1; __utmb=260465999.1.10.1293106375; __utmc=260465999; __utmz=260465999.1293106375.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)",
"Content-Type=application/x-www-form-urlencoded",
"Content-Length=121",
"POSTDATA=isReturn=false&from=CGK&to=MES&departDate1=30-&departDate2=11-2010&adult=1&child=0&infant=0&returndaterange=0&Submit=Cari"
        );

 // do access to sriwijaya air
  $curl = curl_init();
  curl_setopt($curl, CURLOPT_URL, "https://booking.sriwijayaair.co.id/b2c/AvailabilityServlet");
  curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
  curl_setopt($curl, CURLOPT_HEADER, 1);
  curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($curl, CURLOPT_POST, 1);
  curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
  curl_setopt($curl, CURLOPT_VERBOSE, 1);
  curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
  curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0);
  curl_setopt($curl, CURLOPT_COOKIEJAR, "cookie.txt");

  //curl_setopt($curl, CURLOPT_POSTFIELDS, "isReturn=false&from=CGK&to=MES&departDate1=22&departDate2=01-2011&adult=1&child=0&infant=0&returndaterange=0&Submit=Cari");
  $curlData = curl_exec($curl);


  print_r($curlData);

  curl_close($curl);
?>

any help will be appreciate, thanks

I've got a class schedule that spans two years and I would like to have the years as headers. startDate is unix date field.

Here is existing code:

$sql = "SELECT *
        FROM classOfferings, classes, instructors   
   WHERE classes.classId = classOfferings.classId
   AND classOfferings.instructorId = instructors.instructorId
   AND classOfferings.startDate >= CURDATE()
   
   ORDER BY classOfferings.startDate";
   

if(! $retval )
{
  die('Could not get schedule: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
   echo "{$row['dates']}";
   if ($row['hours'] != 0){
           echo "</td> ";
      }
   else {
      echo "CANCELLED</td>";
      }
   echo "<td class='cell2'>".
      "<a href='classDetail.php?seq={$row['seq']}'>{$row['title']}</a>".
      "{$row['days']}".
            "{$row['times']}".
            "<a href='instructorDetail.php?instructorId={$row['instructorId']}'>{$row['fName']} "." ".
    "{$row['lName']}</a></td>}
     echo "</td></tr></table></div>";
}

I have database "raj" with table "pagination" In table pagination have "id", "actualtime" and "created" field id - auto_increment actualtime- varchar created- datetime that looks like this CREATE TABLE pagination( id int auto_increment, actualtime varchar(55), created datetime ) I want to display all rows which are created on todays date and will display from today upto yesterday at 06:00 pm. after that the content will be refreshed based on based on a DATETIME field called 'created' that holds the date and time of each record's creation. this is my query to fetch rows but it display value after 06:00 pm on yesterday but i want to display all data before 06:00 pm from currentdate. After 06:00 pm data will be refreshed and clear. plz help me...... SELECT actualtime FROM pagination WHERE created BETWEEN date_add(date_sub(curdate(), INTERVAL 1 day), INTERVAL 18 hour) AND curdate()";

Hi there,

I am working on a php project on my WAMP server where I have access to XML datafeed from xe.com once a day to get the Exchange rates. This xml datafeed is saved on my localhost as an archived copy.

Now I would like to automatically access the fresh xml datafeed file from xe.com once a day and replace (or update) the xml file on my localhost to have the updated information (rates).

How can I schedule this task automatically and make php access the updated xml file once a day.

All comments and feedbacks are always welcomed

Thank you!

Hi Folks,

I'm creating an equipment reservation system for a client.  Every reservation has an equipmentID, ReservationDate, StartTime, EndTime.  So, basically my script searches existing records for a given date and EquipmentID.  I'm having trouble with how best to approach validation on new reservations to ensure there are no conflicts. 

Lets say two existing reservations for a given date/equipment are found.  One reservation has a startTime of 8AM and endTime of 9AM.  The second has a startTime of 12PM and endTime of 3PM.  Is there a simple way to check if the user's submitted values for StartTime and EndTime conflict with existing reservations? 

Any input would be greatly appreciated!  Thanks!

-John

Hi all, I am wondering what the best way to do this is...

Take GoDaddy for example, if your domain is about to expire you will get an automatic email.

I am wanting to do something similar, If someone orders a Soap Dispenser, I want to send an email (if they accept to receiving emails on the order) each month asking/reminding them to top up on soap.

I have been reading but cant find anything adequate, I have seen something about Cron Jobs, but never heard of this before, please could you point me in the right direction.

Thanks in advance.

Peter