PHP - How To Set Up A Nightly Batch Process?

Hi Guys,

how to execute batch file in wamp server php code.

Could you please help on that.

 

Hi guys,

I want my application to run a triggered process based on time to execute some tasks, what is the best approach?

Thanks

I have been trying to figure out how this is done?  One php file and all that changes is the name of the brand and the logo.  This has to be clickable from a menu and also if a user changes the brand name it changes to the appropriate name and logo.  Any ideas as to how this is done?  If you can guide me in the right direction or give me an example of how this is done would be greatly appreciated.  Thanks.


http://www.drivermanager.com/en/download-confirmation.php?brand=compaq&logo=

This may spill over into java, just not quite sure yet!

Basically what I am trying to do, is fill a box with text, click a button which runs a function which send the text in the box via a JSON request to an external server.

The JSON works fine, I just want a way of submitting the string which hopefully doesnt involve a form, but its the only way I can think of!

Any other ideas?

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}

I have a full working order form in PHP.  I process it and display it with a process page called "process.php."  Whenever this information is displayed on the web page "process.php" I also want it to send me an e-mail with all of the information that it just processed.  i.e. Checked checkboxes, text entered, etc. Whenever I try to send the contents of "process.php" to an email $message = include 'process.php';  the process page just goes through an infinite loop displaying itself over and over again instead of sending itself in an email.
Edited by AP_King7, 20 August 2014 - 10:51 AM.

i have a form for which the data is sent to a process page via jquery like so:

Code: [Select]
jQuery.post('<?php echo $this->site_root; ?>/modules/new_post_process.php',{
        message:jQuery("#message_contents").val() } ,function(data)
        {etc...

new_post_process checks the contents of message like so:


if (empty($message) && empty($error))
    {
        $is_error = true;
        $error = 'Please Enter A Message';
    }


the problem is that it always throws this message even when the textarea isnt empty. however after the error has appeared if i submit again it goes through fine. I suppressed the error and tried and the database gets populated with an empty value which means it is indeed empty. so why does it work on the second time around? I am using CKEditor for the textarea. everything else gets submitted normally but this textarea. heres the full code:


the textarea:

Code: [Select]
<textarea cols="80" rows="10" id="message_contents"></textarea> Code: [Select]
jQuery("#new_post_form").submit(function()
    {
jQuery.post('<?php echo $this->site_root; ?>/modules/new_post_process.php',{
        user_name:jQuery("#user_name").val(),
        redirect_url:jQuery("#redirect_url").val(),
        subject:jQuery("#subject_field").val(),
        forum_id:jQuery("#fid").val(),
        topic_id:jQuery("#tid").val(),
        method:jQuery("#method").val(),
        message:jQuery("#message_contents").val() } ,function(data)
        {
            if (data == 1)
                {
                    jQuery("#process_info").removeClass().addClass("subject_okay").html("<img src=\"<?php echo $this->template_path; ?>icons/small_tick.png\" alt=\"icon\" />Redirecting...").fadeIn("slow");
                    var URL = jQuery("#redirect_url").val();
                    document.location = URL;
                }
                else
                {
                    jQuery("#reply_btn").css("visibility", "visible");
                    jQuery("#draft_btn").css("visibility", "visible");
                    jQuery("#process_info").removeClass().addClass("subject_error").html('<img src="<?php echo $this->template_path; ?>icons/small_error.png" alt="icon" /> ' + data).fadeIn("slow");
                }
        });

and the process page:


if (isset($_POST['subject']))
{
$message = $_POST['message'];

if (empty($message) && empty($error))
    {
        $is_error = true;
        $error = 'Please Enter A Message';
    }
if (empty($error) && $is_error == false)
    {
        $query = $link->prepare("INSERT INTO 
                ".TBL_PREFIX."posts
                (p_fid, p_tid, p_poster, p_name,
                p_content, p_time_posted)
                VALUES
                ('$forum_id', '$topic_id', '$user_name',
                '$subject', '$message', '".$config['time_now']."')
                ") or die(print_link_error());

echo "1";
    }
    else
    {
        echo $error.'-'.$message;
    }

Hey guys, I've hit a huge obstacle in my coding process of a script I am writing.

It is basically an uploading interface script and it works like this. I have files on my server and I want a user to click a button which fires a php script which in turn fires a bash script which IN TURN fires the uploading program (plowshare).

So to make it simple: user logs in, sees upload button. Clicks it, file starts uploading. I then want the user to see "upload initiated" and that's it. The problem is that with what I have now, the script just won't finish loading until the file has been uploaded and as a matter of fact I don't even think it is uploading anything :S

Here are the scripts:

PHP interface to call the bash script:
Code: [Select]
<?php

error_reporting(E_ALL);

function run_in_background($Command, $Priority = 0) {
if ($Priority)
$PID = shell_exec("nohup nice -n $Priority $Command 2> /dev/null & echo $!");
else
$PID = shell_exec("nohup $Command 2> /dev/null & echo $!");
return($PID);
}

function is_process_running($PID) {
exec("ps $PID", $ProcessState);
return(count($ProcessState) >= 2);
}

$file = $_GET['file'];
// Location of file relative to the index
$where = $_GET['where'];
// Absolute index location
$absolute = '/var/www/vhosts/animekyun.com/httpdocs/icarus/';
$where = $absolute . $where;
//$outfile ='log';
echo $where . $file . '<br>';

echo "<h2>The upload has been initiated!</h2>";

$ps = run_in_background("/bin/sh uploadparser.sh $file $where > $outfile");
while(is_process_running($ps))
//echo $output;
?>

Bash script to call uploading program:
Code: [Select]
#!/bin/sh
{
FILE=$1
WHERE=$2
FILENAME="/var/www/vhosts/animekyun.com/httpdocs/icarus/debug/debug_mu_$FILE"
FILENAME2="/var/www/vhosts/animekyun.com/httpdocs/icarus/debug/debug_multi_$FILE"
/usr/local/bin/plowup megaupload "$WHERE$FILE" >> "$FILENAME".txt 2>&1
/usr/local/bin/plowup multiupload "$WHERE$FILE" >> "$FILENAME2".txt 2>&1
} &

this works fine when I pass the variables as arguments in CLI

I hope i have been clear enough, it does seem rather confusing

I have this code:
$shell = new COM('WScript.Shell');
$shell->Run("C:\WINDOWS\system32\cmd.exe /K ".$ini['indexer']['command'], 0, false);

When it runs, it opens the command line, but then when it is done, it leaves the process open. How can I close it when the process is complete?

This topic has been moved to Apache HTTP Server.

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

this retrieves data from a webservice at Library of Congress
for example this here
http://www.loc.gov/standards/sru/simple.html

What I want to do is process the XML? into a string of usable text to put in a mysql database
Am I getting XML back or what?
save it and run it to see. In firefox, it shows xml headers, in chrome just the text elements.
<?PHP
//from here http://www.devshed.com/c/a/PHP/Fetching-Search-Results-as-Serialized-Arrays-with-Yahoo-Web-Services-and-PHP-5/1/
//http://php.net/manual/en/book.simplexml.php
// example using LOC SRU Search Web Service - search results are displayed in raw XML format

try{

$request='http://z3950.loc.gov:7090/voyager?version=1.1&operation=searchRetrieve&query=dinosaur&startRecord=2&maximumRecords=5';

// trigger the http request

if(!$results=file_get_contents($request)){throw new Exception('Error requesting LOC SRU Web service');}

// display the results in XML format

header('Content-type:text/xml;charset=iso-8859-1');
echo $results;

}//end of try

catch(Exception $e){echo $e->getMessage();exit();}

$xml = simplexml_load_string($result);

print_r($xml);
//print_r ($xmlarray);

?>

I have this 3 tables users (id_user) music_styles (id_style, style) ex. (1) - (Blues) user_styles (id_user, id_style) I'm trying to create a form in which the user ($user = $_SESSION['id_user']) chooses through a multiple select the styles of preference to store them in the database using mysqli statements. If the styles prefered are selected they should be displayed in the select input later, how can i accomplish this? Thanks.

hi there,

I have a chained combo boxes. I manage to get the values for the sub process using onchange event.My problem here is how can I retain the values in the sub process combo box after the page is loaded?

main.php
Code: [Select]
<?php
require_once 'connectDB.php';

$sub_id = $_GET['sub_id'];
$id = $_SESSION['process_id'];

$sql = " SELECT * FROM tb_process ORDER BY pro_id ASC";
$result = mysql_query($sql) or die(mysql_error());

$sql = "SELECT tb_record.rec_tpcd, tb_record.rec_part, tb_record.rec_code, tb_record.rec_vendor, tb_record.rec_location, tb_record.rec_remark,
tb_sub_process.sub_name, tb_process.pro_name
FROM tb_record
LEFT JOIN tb_sub_process
ON tb_record.sub_id=tb_sub_process.sub_id
LEFT JOIN tb_process
ON tb_sub_process.pro_id=tb_process.pro_id
WHERE tb_sub_process.sub_id = '$sub_id'";
$result2 = mysql_query($sql);
$row = mysql_fetch_assoc($result2);
$pro_name = $row['pro_name'];
$sub_name = $row['sub_name'];
?>
<html>
<head>
<script type="text/javascript" src="js/ajax.js"></script>
<script type="text/javascript" src="js/jquery-1.2.3.min.js"></script>
<script type="text/javascript">

$(document).ready(function() {
$("#selectProcess").change(function() {
var processID = $(this).val();
if(processID > 0)
{
$("#txtID").val(processID);
$("#selectSubProcess").load('getSub.php?processID='+processID);
}
});

$("#selectSubProcess").change(function() {
var subProcessID = $(this).val();
if(subProcessID > 0)
{
window.location = 'main.php?sub_id='+subProcessID;
}
});
});
</script>

</head>
<body>
<form action="" method="post">
<table>
<tr>
<td>Process: </td>
<td>
<select id="selectProcess" name="selectProcess">
      <option value="0" selected="selected">---SELECT PROCESS---</option>
      <?php 
while ($row = mysql_fetch_array($result)) 
{
$process_id = $row['pro_id'];
$process_name = $row['pro_name'];
$select = ($id == $process_id) ? 'selected="selected"' : NULL;  
echo "<option value='$process_id' $select>$process_name</option>";
        }
        ?>
</select>
</td>
</tr>
<tr>
<td>Sub Process: </td>
<td>
<select id="selectSubProcess" name="selectSubProcess" >
<option>SELECT PROCESS FIRST</option>
</select>
</td>
</tr>
</table>
</form>
<table border=1>
<?php 
while($row = mysql_fetch_assoc($result2))
{
extract($row);
$imageDir1="images/".$rec_tpcd.".jpg";
$info = @getimagesize($imageDir1);

if((bool)$info)
{
$imageDir="images/".$rec_tpcd.".jpg";
}
else
{
$imageDir="images/NoPhoto.jpg";
} 

if ($col == 0)
{
$display .= "<tr>";
}

$col++;
if ($col == 1)
{
$col = 0;
$display .= "</td>";
}

echo "<tr>
<td>
<img src=$imageDir width='220' height='170' onClick=\"window.open('$imageDir', 'popup','height=500,width=800,scrollbars=yes,resizeable=yes status=yes'); return false\" target=\"_blank\"> 
</td>
<td>
<table style='overflow:auto; width:325px;'>
<tr>
<td width='80' valign='top'>Name</td>
<td valign='top'>:</td>
<td valign='top' colspan='2'>$rec_part</td>
</tr>
<tr>
<td valign='top'>Code</td>
<td valign='top'>:</td>
<td valign='top' colspan='2'>$rec_code</td>
</tr>
<tr>
<td>TPCD</td>
<td>:</td>
<td colspan='2'>$rec_tpcd</td>
</tr>
<tr class='style15'>
<td>Vendor</td>
<td>:</td>
<td colspan='2'>$rec_vendor</td>
</tr>  
<tr>
<td>Location</td>
<td>:</td>
<td colspan='2'>$rec_location</td>
</tr>
<tr>
<td>Remarks</td>
<td>:</td>
<td>$rec_remark</td>
<td align='right'>
<input type='image' name='change[$rec_tpcd]' src='library/cart add.png' width='20' height='20' value='Add To Order List &gt;'/>
</td>
</tr> 
</table>
</td>
  </tr>";
}
?>
</table>
</body>
</html>

getSub.php
Code: [Select]
<?php
require_once 'connectDB.php';

if(isset($_GET['processID']))
{
$process_id = $_GET['processID'];
$sql = " SELECT * FROM tb_sub_process WHERE pro_id = '$process_id' ORDER BY sub_id ASC";
$result = mysql_query($sql) or die(mysql_error());
$_SESSION['process_id'] = $process_id;
echo "<option>---------------------SELECTION--------------------</option>"; 
while($row = mysql_fetch_assoc($result))
{
$sub_process_id = strtoupper($row['sub_id']);
$sub_process_name = strtoupper($row['sub_name']); 
echo "<option value='$sub_process_id'>$sub_process_name</option>";
}
}
?>

Hi,

I need to rack some peoples brains! 

I have here a script that allows a GSM/ Remote receipt printer to poll for data in a specific format. The issue is that I will be deploying a few 100 of these damn things and need to know what ones are on or off! I can get the time I polls the file and have it writing to a DB table. The only issue is that even with only two printers running its filling up the table fast! Over 600 rows in 30 mins for only two printers!  I need to find out a better way to do this but have the same flexibility in knowing what exact times it was on and off and then to take this data and put into a nice viewable format! This should be safe with a few hundred printers at once. 

Hope someone can help me with this as I am totally stumped! =/