PHP - Running An Automatic Schedule Task In Php.

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 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()";

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>";
}

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

hi.
i want to send an email with php, but i need this email should be a task invitation in outlook.
i searched at google, but i couldn't find anything that solves my problem.
any ideas?
thanks in advance....

EDIT: It would seem i placed this in the wrong section. Can we have a mod move this?
I'm gonna go ahead and admit that this is a task that my school left me for my course in PHP and mySQL but i won't just ask for someone to construct the code for me but just to give me advice and assistance in my code.
What i'm trying to do is request a number from a user and generate random integers between 1 to 100 as many as the user specified.
The task told me to place all the numbers in an array and that i can use a foreach loop to go through and indicate what numbers are lower than 50 and what is higher than 50.

The output should be similar to this:

All your numbers:
45
23
14
79
99
22
56

Numbers lower than 50:
45
23
14
22

Numbers higher than 50:
79
99
56


This is my code:
Code: [Select]
<!DOCTYPE html PUBLIC "-//w3c//DTD XHTMLm 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmnlns="http://www.w3.org/1999/xhtml" xml:lang="sv" lang="sv">
<head>
<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
<title>Task</title>
</head>

<body>


<?php
$Nummer=$_REQUEST['nummer'];
 for ($count=1;$count <= $Nummer; $count++){
$testSlump = rand(1, 100);
echo $testSlump . "</br>";
}

$testArray = array($testSlump);
foreach ($testArray as $n) {
if ($testArray > 50){
echo $testArray . echo 'this number is lesser than 50';
}
}
?>

</body>
</html>


I've googled, read through the litterature but none seem to help me. I thought to myself that one solution might be placing all values generated in a for loop in an array and then using the foreach loop to confirm what is what. Class notes and our schools PHP help site doesnt have anything that would help me finish this task.

How do you place for loop values in an array? (if i'm on the right track)

Any help etc is greatly appreciated.

wanting to take a variable and use that variable to search my sql table for another variable   example : (from outside prog XXX is sent in as 'killacct')   $killacct = $_GET['killacct'];   now take 'killacct' and search table 'blahblah' for the row 'variable'   so if the table was killacct = XXX | blahblah = YYY   so then i can pull a second variable from my first one XXX is associated with YYY           sorry this was probably really hard to understand im very exhaused lol

I have a client that has a youtube video on his page that he changes everyday.

I have been wrestling with being able to allow him to login to an admin page, that returns a simple form for him to input the new video id from his youtube link which then posts to a txt file. This text file is then included in the html for to supply the correct youtube video.

Basically the way it is now the html page has

Code: [Select]
<iframe class="youtube-player" type="text/html" width="566" height="266" src="http://www.youtube.com/embed/Video Id Here" frameborder="0">
</iframe>
Now I have been completely unsuccessful just creating a form that will let him change just the "Video Id" so we have been working on copying and pasting the entire iframe code in the form.

My first attempt created backslashes in the txt file where quotes are, I then added stripslashes to fwrite and that posted nothing to my txt file.

So I'm not sure if the code I have is worth a spit or if I should restart with some assistance.

My main goal (if achievable) is to remove the iframe code from the html page and use a php include to include the text file that has the iframe in it. Then create a page for my client to login to to paste either the video url or just the video id and have this change on the fly.

Any help would greatly be appreciated!

Hi my name is Alexander and i am new to coding. i am in need for tommorow for this task , but i cant figure out how to make it. Can anyone explain where is my mistake and how the code should look? I have some code but its full with errors....
Write down a program that uses the given electricity units and calculates the current electricity bill under the conditions:
For the first 50 units - 0.10 
For the next 100 - 0.15 
For the next 100 - 0.25 
For the next - 0.35 
20% VAT is added to the general account.
Input Output
150 24 
155 25,50 
201 39,30 
302 75,84 

 

 

 

Hello,

I have come to a dead end. What I'm trying to do is simple: have a dynamic title for my php page (something that would be executed by, for example, Code: [Select]
<title><?php echo $title; ?></title>).

I'm not an experienced coder. I've tried about 15 different variations to try to achieve the result I want, and none of them have worked.

I'm using a dynamic web template (DWT), which has editable regions for the Code: [Select]
<title> section and for the main body of the webpage. I'm also using a Smarty template, called display_post.tpl, which, along the php file that is attached to the DWT, called display_post.php, are provided below as originally written:

Smarty template:

Code: [Select]
<table cellpadding="8">
<tr>
<td valign="top">

{section name=mysec loop=$posts}
<h2>{$posts[mysec].title}</h2><br>
{$posts[mysec].body|nl2br}
<br>
{/section}
</td>
</tr>
</table>
display_post.php:

Code: [Select]
<?php
require_once('db_login.php');
require_once('config.php');

$conn = mysqli_connect($db_host, $db_username, $db_password, $db_database) or die    ('Error connecting to MySQL');

$post_id = $_GET['post_id'];

$query = "SELECT * FROM posts WHERE post_id=$post_id";
$result = mysqli_query($conn, $query);

while($row = $result->fetch_array()){
$test[] = $row;
}

$smarty->assign('posts', $test);
$smarty->display('display_post.tpl');

mysqli_close($conn);

?>
Everything works as is. Part of the problem is that I don't know whether to do this through the DWT/php file or through Smarty. I've tried variations on both approaches, which I can provide for food-for-thought if need be. For now, I would love to read any possible solutions that you can come up with.

Thanks bunches! 
Maat

I am using JWT for an API authentication and like them.  Previously, I would query both some GUID and the user's ID (which wasn't their PK but a unique key per GUID), but now I just include both the account and user's DB PK in the token.  Also, including something regarding the user's permissions, however, I still haven't bought into this approach as I don't know how to deal with changing permissions and still having some JWT with different permissions floating around.  I suppose I could save the JWT's timestamp in the DB, but that seems to eliminate the benefit of token expirations...  Sorry, back to the question at hand.

I now have a need to provide emails with a reduced subset of endpoints to either view some resource or update some status.  I don't want to make the user first go to some website and then include the JWT in the header, but instead just a single click action.  Problem is now I have their JWT which is effectively their password in some email which isn't ideal, and their is no way to ensure that the specific user was the individual that viewed the resource or performed some action.  Then I thought maybe I would make some common low access JWT and use the exact same GET routes as I would do so normally and create some new GET routes to emulate main application POST/PUT/PATCH routes.

Before going down that path, I would like to investigate other solutions.  Often single use tokens are used to reset passwords and other actions which should only performed once and this is not my need but maybe close.  I am thinking of creating a token that includes the actual resource path with URL parameters along with the HTTP method.  Since everything is in the token, I wouldn't need a typical REST path to identify the resource but would have a single endpoint to retrieve them.

I searched for related information and didn't find anything which makes me concerned I am going down a rabbit hole.  Any thoughts on how to implement this?  Thanks