PHP - Script Working Manually But Not As Cron Job

Hi    I've been stuck trying to execute a script for a few weeks now and I really need help.   The script is supposed to schedule social media posts via functions.php and wp-load.php but I get errors.   Can someone do me a favour?   Drop your email and I'll send you the details to connect to my database.   Thanks

Hi,

I am trying to make some adjustments to uploadify.php which comes with the latest version of uploadify (3.0 beta), so that it works with a session variable that stores the login username and adds it to the path for uploads.  Here is uploadify.php as it currently looks:

Code: [Select]
<?php
session_name("MyLogin");
session_start();

$targetFolder = '/songs/' . $_SESSION['name']; // Relative to the root

if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $targetFolder;
$targetFile = rtrim($targetPath,'/') .'/'. $_FILES['Filedata']['name'];

// Validate the file type
$fileTypes = array('m4a','mp3','flac','ogg'); // File extensions
$fileParts = pathinfo($_FILES['Filedata']['name']);

if (in_array($fileParts['extension'],$fileTypes)) {
move_uploaded_file($tempFile,$targetFile);
echo '1';
} else {
echo 'Invalid file type.';
}
}

echo $targetFolder;

?>
I added Code: [Select]
echo $targetFolder; at the bottom so that I could make sure that the string returned was correct, and it is, i.e. '/songs/nick'.  For some reason though, uploads are not going to the correct folder, i.e. the username folder, but instead are going to the parent folder 'songs'.  The folder for username exists, with correct permissions, and when I manually enter Code: [Select]
$targetFolder = '/songs/nick';all works fine.  Which strikes me as rather strange.  I have limited experience of using php, but wonder how if the correct string is returned by the session variable, the upload works differently than with the manually entered string.

Any help would be much appreciated.  It's the last issue with a website that was due to go live 2 days ago!

Thanks,

Nick

Code: [Select]
$sql="SELECT * FROM $tbl_name3 WHERE review_show='n'";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
if($num_results > 1){
$message="You have ".$num_results." reviews unapproved.";
mail('example@example.com','GHP Reviews', $message, 'From: example@example.com');
}

$sql2="SELECT * FROM $tbl_name4 WHERE rma_issued='n'";
$result2=mysql_query($sql2);
$num_results2=mysql_num_rows($result2);
if($num_results2 > 1){
$message="You have ".$num_results2." RMA Numbers Requested.";
mail('example@example.com','GHP RMA Number Requests', $message, 'From: example@example.com');
}

The reviews email is being sent, however, the RMA email is not.

EDIT: Nevermind, $num_results and $num_results2 should have been > 0 not > 1.

i was working on modifying a code written by a previous user.
i have field called adid in the ads table which should have been a primary key and autoincremented.
But since we already have lot of data across different sites we cannot modify the table structure.
The problem is i want to check if the following code is adding adid manually.is there some problem with this code?



Code: [Select]
   $get_ad_id = mysql_query("SELECT adid FROM ads ORDER BY adid DESC LIMIT 1", $con) or die("Error Getting AD ID: ".mysql_error());
    while($get_ad_id_results = mysql_fetch_assoc($get_ad_id)) { $adid=$get_ad_id_results['adid']; }
    if($adid!="") { $adid=$adid+1; }
    else { $adid="1"; }
    if($bannertype=="120x60" || $bannertype=="468x60")
     {
      $New_URL = $_POST['URL'];
      $active='Y';
      $insert_image_banner_query="INSERT INTO ads (adid, URL, image_path, date, userid, active, size) VALUES ('".$adid."','$New_URL', '$newname', '$Date', '$loggedinuserid','".$active."','".$bannertype."')";
      mysql_query($insert_image_banner_query, $con) or die("Inserting Image Ad Failed: ".mysql_error());
      $update_banner_cache="YES";
     }

Is it possible to manually edit a SESSION (not cookie) from client side? Sort of how a user can easily edit a cookie's value.

I have a strange problem. When a guest visits my contact-user.php page, they get a message telling them the must login before viewing the page.

After the guest logs in, they view the same page and it tells them they have to login again (keeps on looping). But if they manually refresh that page with the "you must be logged in" message, it recognizes the login and lets them in.

How can I get this page to immediately recognize that the user is logged in and not require them to refresh the page manually?

Here is my code for contact-user.php

<?php 
session_start();
header("Cache-Control: private, max-age=10800, pre-check=10800");
header("Pragma: private");
header("Expires: " . date(DATE_RFC822,strtotime("+2 day")));
include("connection.php"); 
mysql_select_db("database");


if (isset($_SESSION['username'])) { 
********    MY HTML PAGE CONTENT     ********
 }


else {
echo "<meta http-equiv='REFRESH' content='2;url=http://www.mysite.com/login.php'>
<center><font color='#EE0000'><p>You must be logged in before negotiating. You will now be redirect to the login page.</p></font></center>";
}
?>



Here is my code for login.php script:

<?php
include("connection.php"); 
mysql_select_db("database");
session_start();
if(isset($_POST['login'])){
       $username = mysql_real_escape_string($_POST['username']);
       $password = mysql_real_escape_string($_POST['password']);
   $tUnixTime = time();
       $sGMTMySqlString = gmdate("Y-m-d H:i:s", $tUnixTime);
       if (!$username || !$password) {
          print "Please fill out all fields.";
          exit;
       }
       $logres = mysql_num_rows(mysql_query("SELECT * FROM members WHERE username = '$username' and password = '$password'"));
       if ($logres <= 0) {
          print "Login failed. If you have not already, please signup. Otherwise, check your spelling and login again.";
          exit;
       } 
       else {
       $_SESSION['username'] = $username;
       if (isset($_SESSION)) {
         echo'You are now logging in'; mysql_query("UPDATE members SET activity = '$sGMTMySqlString' WHERE username = '$username'");
       }
       else {
         echo "You are not logged in!";
       }  
       echo'<html><head><meta http-equiv="REFRESH" content="1;url=http://www.mysite.com/members/' . $_SESSION['username'] . '/"></head><body></body></html>';
       exit;
       }
}
?>

Ok, I've been trying to figure this out for about 4 hours now. What I am trying to do is update log information from one table to another every 30 minutes. Am I doing this correct?


<?php
$cron = true;

$userinfo = $db->query( "SELECT * FROM users" );

while ( $pulluserinfo = $db->fetch( $userinfo ) ) {

$one .= "" . $pulluserinfo['uID'] . ""; //uID is from the users table

$two .= "" .$pulluserinfo['Amount=Amount+1000+(TotalAmount*10)']. ""; //Amount & TotalAmount is from the users table

$three .= date("F j, Y, g:i a"); //Putting a date

$db->query( "INSERT INTO systemlog (`User`,`Amount`,`Time`) VALUES ('$one', '$two', '$three')" );
}

$db->close();
?>

I am trying to set up a Cron Job. When I run it says that it is inserted. However when I enter my database nothing is in there.

Does each part column of a cron job need to be correct for it all to work? For example if I have the code for column corrrect but one wrong will it now work at all?

I am a bit lost as to why it says inserted but nothing actually goes into my database.

I can manually enter information into the database I can echo it. But I cant Cron Job it in there.

I am having my internship, and i was asked to automate the uploading of file and store the data to MySQL every 8:00am. i've read a lot of articles about crontab/cronjob/php:cron. but i am wondering what is a cron.php and what codes/scripts in that file. i also want to know what is .BAT for. do you have any steps and scripts for my problem? thanks alot.. 

I am trying to do two cron jobs:
I have a program that is set to do a cron job every 15mins to check for imported list staged in the que.

But I keep getting an error message:??

sh: line 1: /home/username/sitename.com/8/crons/processimports.php: Permission denied
sh: line 2:
: command not found
this is what I have:

Code: [Select]
/usr/local/php5/bin/php -q
/home/username/sitename.com/8/crons/processimports.php > /dev/null


The second one is a scheduler to send out an email, but I get this error message:
sh: line 1: /home/username/sitename.com/8/crons/scheduler.php: Permission denied

from this out put:
Code: [Select]
/usr/local/php5/bin/php -q
/home/username/sitename.com/8/crons/scheduler.php > /dev/nullPlease Help??

Thanks,

TRUSTINWEB

Is it possible to have a cron job merely by php ? not by OS (like linux cron). I mean having a php code to repeat a process on with a timer (e.g. every 5min).

I have some cron jobs that pull xml and some webcam images from their respective source sites (NOAA, DOT) and saved to the local server.  This is done to ease the strain on the external sites in the event of a user spike on our website. 

Now, the code works most of the time, but you can see that I dont have any error handling.  Sometimes, one of the webcam images will fail to load, and other times I have seen the weather xml feed fail producing some unaestetic php error codes on the site until a half hour later when the cron job runs again.

My questions:
-Whats the best way to make it try again if it fails?

-Are the set time limit statements necessary?  I did it as a keep alive.

-I also put the sleep statements there to space things out, since there are 6 webcam scripts that run.

Anyway, I would appreciate any suggestions.

Thanks
-Chris

Does anyone know how to write the php for a cron job (delete date from a db) this is what I have but it is not doing anything...the cron on my server site runs the code fine but the code does not do anything.

Code: [Select]
<?php

$date = ('Y-m-d');

//Auto delete

// Connect to MySQL
$connect = mysql_connect("db","username","password") or die("Not connected");
mysql_select_db("name") or die("could not log in");

// Delete entry  where date equals today from the "example" MySQL table
mysql_query("DELETE FROM boox WHERE date='$date'") 
or die(mysql_error());  


//
?>

I'm trying to generate a cron job to run the below script, but can't get it to work for the life of me.

Code: [Select]
#!/usr/local/bin/php -q
<?php
if($_GET['key']=="a"){

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$sql="SELECT * FROM $tbl_name3 WHERE review_show='n'";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
if($num_results > 0){
if($num_results==1){
$message="You have ".$num_results." review unapproved.";
}
else{
$message="You have ".$num_results." reviews unapproved.";
}
mail('webmaster@ghosthuntersportal.com','GHP Reviews', $message, 'From: sales@ghosthuntersportal.com');
}

$sql2="SELECT * FROM $tbl_name4 WHERE rma_issued='n'";
$result2=mysql_query($sql2);
$num_results2=mysql_num_rows($result2);
if($num_results2 > 0){
if($num_results2==1){
$message="You have ".$num_results2." RMA Number Requested.";
}
else{
$message="You have ".$num_results2." RMA Numbers Requested.";
}
mail('webmaster@ghosthuntersportal.com','GHP RMA Number Requests', $message, 'From: sales@ghosthuntersportal.com');
}
echo "Emails Sent.";
}
?>


Cron Job Command:
Code: [Select]
php -f /home/zyquo/public_html/ghosthuntersportal.com/cj_run.php?key=a

I set the time to run every minute, just to try to get this to work... And in the end I get no emails in my inbox.

The following script doesn't seem to work?

I re-used a registration script that I have which works fine, just changing the details where necessary but it doesn't work and shows no errors, when I fill out the form and click submit it just displays the form again, no success message, no error message and it doesn't add the info into the database, however when I run the same query through phpmyadmin it works...


<?php 
include ('header.php');
?></center>
<div class=content>
<?php  
if(!empty($_POST['username']) && !empty($_POST['password']))  
{  
    $fname = mysql_real_escape_string($_POST['first']);
    $lname = mysql_real_escape_string($_POST['last']);    
    $email = mysql_real_escape_string($_POST['email']);
    $sia = mysql_real_escape_string($_POST['sia']);
    $no = mysql_real_escape_string($_POST['number']);
  
     $checknumber = mysql_query("SELECT * FROM staff WHERE no = '".$no."'");  
  
     if(mysql_num_rows($checknumber) == 1)  
     {  
        echo "<b>Error</b>";  
        echo "Mobile number in use by another employee!";  
     }  
     else  
     {  
        $addstaff = mysql_query("INSERT INTO staff (fname, lname, email, no, sia) VALUES('".$fname."', '".$lname."', '".$email."', '".$no."', '".$sia."')");  
        if($addstaff)  
        {  
            echo "<b>Success!</b>";  
            echo "Employee added to the database, click <span class=1><a href=stafflist.php>here</a></span> to view employee's";  
        }  
        else  
        {  
            echo "<b>Error</b>";  
            echo "<p>There was a problem adding the employee, please try again.</p>";                
} 
     }  
}  
else  
{  
    ?>  
   <b>Add an Employee</b>  
  <br><br>
   Please enter the details below to add an employee to the database.  
  <br><br>
    <form method="post" action="addstaff.php" name="addstaffform" id="addstaffform"> 
    <table width=700px border=0 cellspacing=10><tr><td valign=top><table border=0>
<b>Required Information:</b><br><br>
<tr><td>  
        <b>First Name:</b>
</td><td>
        <input type="text" name="first" id="first" />
</td></tr><tr><td>
        <b>Last Name:</b>
</td><td>
        <input type="text" name="last" id="last" />
</td></tr><tr><td>  
        <b>Email Address:</b>
</td><td>
        <input type="text" name="email" id="email" />
</td></tr></table></td><td valign=top>
<table border=0>
<b>More Information:</b><br><br>
<tr><td>
     <b>SIA License Number:</b>
</td><td>
     <input type="text" name="sia" id="sia">
</td></tr><tr><td>
     <b>Contact Number:</b>
</td><td>
     <input type="text" name="no" id="no">
</tr></td></td>
</table> </td></tr> </table>
        <input type="submit" name="add" id="add" value="Add Employee" class=btn />  
    </form>  
  
    <?php  
}  
?>  </div>
<?php
include ('footer.php'); 
?>


I don't understand it? Whats wrong with it?