PHP - Running Script Depending On Client Public Ip

I've written a script thats going to take a really long time to execute... Whats the best way to do this as far as the server not timing out?

My script is calculating some statistics based on other tables in the database and then storing them in another table. The results are going to be hundreds of thousands or maybe even millions of rows.

So I have a php script in public_html on my apache server, and it runs a global economy code for my browser game.
If I open firefox and go to:
http://localhost/Economy.php
it runs the code, and it changes all the values in the database properly.
How do I get that to run automatically, say every 6 minutes?

I have windows so no cron jobs.
I went to task scheduler and created a task which I thought would work, and it lists the task as running.
But it gives me an error.

Event Views:
Code: [Select]
Log Name:      Microsoft-Windows-TaskScheduler/Operational
Source:        Microsoft-Windows-TaskScheduler
Date:          9/28/2011 5:02:37 PM
Event ID:      101
Task Category: Task Start Failed
Level:         Error
Keywords:      (1)
User:          SYSTEM
Computer:      Matt-PC
Description:
Task Scheduler failed to start "\Economy" task for user "Matt-PC\Matt". Additional Data: Error Value: 2147750687.Event Xml:
Code: [Select]
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-Windows-TaskScheduler" Guid="{DE7B24EA-73C8-4A09-985D-5BDADCFA9017}" />
    <EventID>101</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>101</Task>
    <Opcode>101</Opcode>
    <Keywords>0x8000000000000001</Keywords>
    <TimeCreated SystemTime="2011-09-28T22:02:37.967669800Z" />
    <EventRecordID>18</EventRecordID>
    <Correlation />
    <Execution ProcessID="1012" ThreadID="1484" />
    <Channel>Microsoft-Windows-TaskScheduler/Operational</Channel>
    <Computer>Matt-PC</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData Name="TaskStartFailedEvent">
    <Data Name="TaskName">\Economy</Data>
    <Data Name="UserContext">Matt-PC\Matt</Data>
    <Data Name="ResultCode">2147750687</Data>
  </EventData>
</Event>
EDITed for code tags

Hi   I inserted javascript to track google ad conversions inside finalpage.htm which is parte of a major site I which I don’t have access to.   The site manager only allows uploading some .htm pages for customization purposes.   But the scripts are not running anymore.   When I use google label checker plugin to analyse the page, I  got the message below:   <script> tag must not be included in a <span>   But the finalpage.htm is a blank page, so there is not <span> Maybe <span> are coming from a higher level of the website.   Is there I way to prevent this and guarantee my seeing as a real blank page ?   Moises

Hi, i need some help with my script to take data from mysql database to be used for a login.

Created table, with registration, checked passwords and such but the login button when clicked does nothing? please help


<?php      $username = $_POST['username'];
         $password = $_POST['upassword'];
         $self = $_SERVER['PHP_SELF'];
         $referer = $_SERVER['HTTP_REFERER'];
         
#if either form field is empty return to the log-in page
if( (!$username ) or (!$password ) )
   { header(  "Location:$referer" ); exit(); }
#connect to mysql
$conn = @mysql_connect( "server", "username", "password )
      or die( "Could not connect" );
#select database
$rs = @mysql_select_db( "removalspacelogin", $conn )   
      or die ( "Could not select db" );
#create query
$sql="select * from users where username=\"$username\" and password = password( \$password\" )";
#execute query
$rs = mysql_query( $sql, $conn )
      or die( "Could not execute query" );


#get number of rows that match username and password
$num = mysql_numrows( $rs );
#if there is a match the log-in in done
if( $num != 0 )
{ $msg = "Welcome $username - your log-in was successfull!"; }
else #or return to: login.php
{ header( "Location:www.removalspace.com/wrong.html" ); exit(); }

?>

<html> <head><title>Check-login</title></head>
<body> <?php echo( $msg ); ?> </body> </html>

I am running some php via a cron and I was after the best way to achieve this. Currently I am doing it as follows:-

Code: [Select]
0 * * * * lynx -dump http://www.domain.com/script.php
This works fine but I don't want anybody being able to run the script by pointing their browser to the file.

Any advice on the best method? Cheers.

I have a php script that calls another script. It seems that the 2nd script times out or something. I have tried setting max_execution_time to 120 seconds. how can I fix this? I open to anything.

Thanks

My website is being overrun with spam and I am trying to install a php captcha script. I have installed php 5 on my website askthephysicist.com which is hosted on a 1&1 Windows server, but I think the problem is that I do not know where to point my script to find the lib. I have very little fluency with any scripting languages. Anyhow, the beginning of the script reads:

<?php

require 'CaptchasDotNet.php';

// Required Parameters
// Replace the values you receive upon registration at http://captchas.net.
//
// client: 'demo'
//
// secret: 'secret'
//

and when I run it I get the message:


Fatal error: require(): Failed opening required 'CaptchasDotNet.php' (include_path='.:/usr/lib/php5.5') in /homepages/29/d191906528/htdocs/askthephysicist/query.php on line 4


The whole code may be found at http://captchas.net/sample/php/ if that is helpful, but the error occurs with the first statement require 'CaptchasDotNet.php';

I have a script there download a lot of images from a website it crawls, but when ever i started a crawler, it will keep downloading images.
Even if i close firefox, it will continue to download images from the site.

How can i stop it?.

Hey y'all.

Probably a dumb question here but I'm at a loss. I've got a PHP service script that has an include, written as so:

$config = new Config('config/config.json');

The config directory is next to the PHP script and does contain the config.json file, so when I run this from the CLI everything works great. However, I've got about 17 PHP services I need to start and really don't feel like typing them all out, so I've written a shell script that does this:

#!bin/bash


cd /path/to/my/script

/usr/local/bin/php ./my-script.php

This does start the service, but it bombs out because it can't find the config.json file.

If I change the PHP to 

$config = new Config('./config/config.json');

it works as expected from the shell script. Updating the files is technically possible, but fraught right now for reasons I can't really get into (sorry). Anybody know what the difference is, or have any ideas on how to get around this?

Edited September 5, 2020 by maxxd

im testing the following script and it wont send 1 2 3 until the script has finished executing.

What can i do to flush the buffer after every echo statement??

<?php 

echo "1";
ob_flush();flush();
sleep(5);
echo "2";
ob_flush();flush();
sleep(5);
echo "3";
ob_flush();flush();

?>

Hello !   How I can make a script of my PHP code to work even if my website is not running   Can I make this with php ? 

I have a php script that I've been running that seems to have been working but now I'm wondering if some of my logic is potentially off.

I select records from a db table within a date range which I put into an array called ```$validCount```

If that array is not empty, that means I have valid records to update with my values, and if it's empty I just insert. The trick with the insert is that if the ```STORES```  is less than the ```Quantity``` then it only inserts as many as the ```STORES``` otherwise it inserts as many as ```Quantity```.

So if a record being inserted with had 

    Stores: 14 Quantity:12

Then it would only insert 12 records but if it had
  
    Stores:1  Quantity:20

It would only insert 1 record.

In short, for each customer I should only ever have as many valid records (within a valid date range) as they have stores. If they have 20 stores, I can have 1 or 2 records but should never have 30.

It seems like updating works fine but I'm not sure if it's updating the proper records, though it seems like in some instances it's just inserting too many and not accounting for past updated records.

This is the logic I have been working with:

 

  if(!empty($validCount)){
            for($i=0; $i<$row2['QUANTITY']; $i++){
                try{
                    $updateRslt = $update->execute($updateParams);
                }catch(PDOException $ex){
                    $out[] = $failedUpdate;
                }
            }
    }else{    
        if($row2["QUANTITY"] >= $row2["STORES"]){
            for($i=0; $i<$row2["STORES"]; $i++){     
                try{
                    $insertRslt = $insert->execute($insertParams);
                }catch(PDOException $ex){
                    $out[] = $failedInsertStore;
                }
            }
        }elseif($row2["QUANTITY"] < $row2["STORES"]){
            for($i=0; $i<$row2["QUANTITY"]; $i++){     
                try{
                    $insertRslt = $insert->execute($insertParams);
                }catch(PDOException $ex){
                    $out[] = $failedInsertQuantity;
                }
            }
        }
    }

 

Let's say customer 123 bought 4 of product A and they have 10 locations

    customerNumber  |  product  |  category  |  startDate  |  expireDate  | stores
    ----------------------------------------------------------------------------------
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10

Because they purchased less than their store count, I insert 4 records. Now if my ```$validCheck``` query selects all 4 of those records (since they fall in a valid date range) and my loop sees that the array isn't empty, it knows it needs to update those or insert. Let's say they bought 15 this time. Then I would need to insert 6 records, and then update the expiration date of the other 9 records. 

    customerNumber  |  product  |  category  |  startDate  |  expireDate  | stores
    ----------------------------------------------------------------------------------
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10

There can only ever be a maximum of 10 (store count) records for that customer and product within the valid date range. As soon as the row count for that customer/product reaches the equivalent of stores, it needs to now go through and update equal to the quantity

so now I'm running this but it's not running and no errors, but it just returns back to the command line   

$total = $row2['QUANTITY'] + $validCheck;
    if ($total < $row2['STORES']) {
        $insert_count = $row2['QUANTITY'];
        $update_count = 0;
    } else {
        $insert_count = $row2['STORES'] - $validCheck; // insert enough to fill all stores
        $update_count = ($total - $insert_count); // update remainder
    }

        
    for($i=0; $i<$row2['QUANTITY']; $i++){
        try{
            $updateRslt = $update->execute($updateParams);
        }catch(PDOException $ex){
            $failedUpdate = "UPDATE_FAILED";
            print_r($failedUpdate);
            $out[] = $failedUpdate;
        }
    }
    
        
    for($i=0; $i<$insert_count; $i++){
        try{
            $insertRslt = $insert->execute($insertParams);
        }catch(PDOException $ex){
            $failedInsertStore = "INSERT_STORE_FAILED!!!: " . $ex->getMessage();
            print_r($failedInsertStore);
            $out[] = $failedInsertStore;
        }
    }```

    

How can I call a public function inside of another public function?  The get_primary_edge() says it's undefined, but it's just another public function in the class so shouldn't this work?

Code: [Select]
public function get_dynamic_edge($uid)
{
$uid = (int)$uid;

$sql = "(
SELECT
`users`.`id`
FROM partners
INNER JOIN `users`
ON `partners`.`user_id` = `users`.`id`
WHERE partners.friend_id = '${uid}'
AND `approved` = 1
)
UNION ALL
(
SELECT
`users`.`id`
FROM `partners`
INNER JOIN `users`
ON `partners`.`friend_id` = `users`.`id`
WHERE `partners`.`user_id` = '${uid}'
AND `approved` = 1
)";

$result = mysql_query($sql) or die(mysql_error());

$i = 0;

while (($row = mysql_fetch_assoc($result)) !== false)
{
$dynamic[$i] = array(
'uid' => $row['id'],
'score' => get_primary_edge($row['id']),
);

$i++;
}

print_array($dynamic);
}

I wish to create validation rules once which are used both on the client and on the server.   For instance, I will start off with the following PHP object:

stdClass Object
(
    [rules] => stdClass Object
        (
            [email] => stdClass Object
                (
                    [required] => 1
                    [email] => 1
                    [remote] => stdClass Object
                        (
                            [url] => check-email.php
                            [type] => post
                            [data] => stdClass Object
                                (
                                    [username] => function() {return $( '#username' ).val();}
                                )
                        )
                )
        )

    [messages] => stdClass Object
        (
            [email] => stdClass Object
                (
                    [required] => an email is required
                )
        )
)

When the edit page is downloaded to the client, I will include this object in some format suitable to the client.   The client will then use the jQuery Validation plugin (http://jqueryvalidation.org/) along with the validation object, and client side validate the page.   When the form passes client side validation and is uploaded, PHP will use the same validation object to serverside validate the form (I have this part working as desired).   My question is how should I pass this data to the client?  Originally, I would just use PHP to write some JavaScript.

exit('var myObj='.json_encode($myObj));

Note that when I json_encode the object, the value of $myObj->rules->email->remote->data->username is a string with quotes around it, however, I can easily use PHP to strip these tags before sending it to the client.   As Jacques1 pointed out in http://forums.phpfre...ascript-client/, I should never ever use PHP to generate JavaScript, and should use AJAX to download the JSON directly.  I tried doing the later, but found that a callback function could not be included in the JSON.     Please advise on the best way to accomplish this.   Thank you

Visitors to my website will upload file to a simple upload.html:

Code: [Select]
<form action="execute.php" method="post" enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file" /><br />
<input type="submit" name="submit" value="Submit"" />
</form>

As you can see, the arguments are posted to execute.php. In this, I have lines that look like this:

Code: [Select]

$ob_file = fopen("../../log.txt",'w') or die ("cannot create log.txt");

function ob_file_callback($buffer)
{
global $ob_file;
fwrite($ob_file,$buffer);
}


ob_start('ob_file_callback');
system ("../../sourceShell") or die ("sourceShell fail") ;
 
ob_end_flush();
execute.php runs a shell script called 'sourceShell', which runs a fortran program on the server. execute.php outputs the 'log' of this program (that typically would appear on the terminal) on log.txt. I use the ob_file_callback function to do this.

When a visitor clicks 'submit' (or upon the completion of uploading), I need execute.php to echo "Your job is running..please wait". And then I want to refresh the page every 5 mins until the job finishes and the result will be shown. My problem is that, when a visitor clicks 'submit', it waits until the fortran program completely finishes (which takes a long time) before it outputs the "Your job is running..please wait". I suspect this is because of the ob_file_callback function. If I don't use that function, it seems like the log prints in real time to my browser as the program runs.

I do hope this make sense... and I've spent days on this wanting to tear off my hair, so it's not like I haven't googled hard. I'm completely new to web programming, so I hope you guys understand and can be patient if I don't understand.