PHP - Login Script Not Running?

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.

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

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

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?.

I am writing a script which will be dependent on the client's public ip address. e.g.   if the client is using ip address 203.122.55.124 script A should run and if else then script B should run. Now I know that the If and else will be used but cant guess how will the public ip be captured.   Please help  

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

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 ? 

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

?>

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

    

Hello everyone,

The last few weeks I've asked a few questions. From the answers given, I've finished my login script.
But, I am a noob at oop php and I have also no clue if there are any security holes.

So my question to you guys is:

What have i done wrong? What can i do better? And what's missing?
I also have a one basic question:

I have't declared any variable to public, protected or private. Is it better to declare every variabe? or only a few?
Here is my code:

Index.php:

<?php

if ($_SERVER['REQUEST_METHOD'] == 'POST')

{

require('classes/class_lib.php');

if(isset($_POST['username'])){

$username = $_POST['username'];
}
if(isset($_POST['password'])){

$password = $_POST['password'];
}

try{

$user = new User;

$user->login($username, $password);
}
catch(MysqlException $error){

echo $error->getError();
}

catch(LoginException $error){

echo $error->getError();
}

}

?>

// form etc.

And my class_lib.php:

<?php

class MysqlException extends Exception{

public function getError(){

$errorMessage = 'Er is een fout opgetreden in '.$this->getFile().' op regel '.$this->getLine().'<br />';

$errorMessage .= 'Foutmelding: <i>'.$this->getMessage().'</i><br />';

return $errorMessage;

}
}

class LoginException extends Exception{

public function getError(){

$errorMessage = $this->getMessage();

return $errorMessage;

}
}

class Mysql{

public function __construct(){

$this->db = new mysqli('localhost','root','','login');

if($this->db->connect_error){

throw new MysqlException('Kan geen verbinding maken.');

}

}

public function escapeString($string){

$this->string = $this->db->real_escape_string($string);

return $string;

}
}

class Query extends Mysql{

public function runQuery($query){

$this->result = $this->db->query($query);

if(!$this->result){

throw new MysqlException('Er is iets fout gegaan tijdens het uitvoeren van de query.');

}

}

public function returnQuery(){

return $this->result->num_rows;

if(!$this->result){

throw new MysqlException('Er is iets fout gegaan tijdens het ophalen van de resultaten.');

}

}
}

class User{

public function __construct(){

$this->mysql = new Mysql;

$this->query = new Query;

}

public function login($username, $password){

$this->username = $this->mysql->escapeString($username);

$this->password = $this->mysql->escapeString($password);

$this->setQuery = "SELECT gebruikerid FROM gebruikers WHERE gebruikersnaam='" . $this->username . "' AND wachtwoord='" . $this->password . "'";

$this->query->runQuery($this->setQuery);

if($this->query->returnQuery() > 0){

return true;

}else{

if(empty($username) || empty($password)){

throw new LoginException('U moet alle velden invullen.');

}else{

throw new LoginException('Uw logingegevens kloppen niet.');

}

}

}
}

?>

Hey ppl

I have a login script that I found in a PHP MySQL book. And yesterday I realized that it is easy to hack this script as it use session variables and it can use cookies.

DOes anyone have login script for me that is secure and easy to implement?

It would really help!

Thanks

I have a login script that isn't rejecting non-users. For whatever reason, it's passing them on to the welcome page where an actual user sees user specific information. I'm newer to php, but can't for the life of me understand why the script doesn't seem to ever utilize the 'else' portion of the 'if' statement. So in short it works as expected for actual users, but non-users are not getting rejected. Below is my code. Any help is appreciated.

Code: [Select]
$sqla = "SELECT count(*) FROM authorize WHERE username='$_POST[username]' and password='$_POST[password]'";
$result = mysql_query($sqla) or die ("Error: ". mysql_error(). " with query ". $query);
$count = mysql_num_rows($result);

if($count==1) {
//start session for user

session_start();

//get company id and user first and last name
$query = mysql_query("SELECT comp_id FROM authorize WHERE username='$_POST[username]'") or die ("Error: ". mysql_error(). " with query ". $query);
$query2 = mysql_query("SELECT firstname, lastname FROM authorize WHERE username='$_POST[username]'") or die ("Error: ". mysql_error(). " with query ". $query);


$resultb = mysql_fetch_assoc($query);
$resultc = mysql_fetch_array($query2);


$_SESSION['coid'] = $resultb['comp_id'];
$_SESSION['firstn'] = $resultc['firstname'];
$_SESSION['lastn'] = $resultc['lastname'];


//get company name
$query3 = mysql_query("SELECT comp_name FROM companies WHERE comp_id='$resultb[comp_id]'") or die ("Error: ". mysql_error(). " with query ". $query);
$resultd = mysql_fetch_assoc($query3);

$_SESSION['conm'] = $resultd['comp_name'];

header("location: overview.php");

} Else {

echo "That user does not exist.";
header("location: login.html");
}

Hi all again,

This script was working perfectly but I have not got a clue what changed in it or how and can not seem to find the problem.

The connection works, email and password variables match the mysql databases so must be my Syntax.

appreciate if you can help.


<?php

include("../cxn.php");

$sql = "SELECT password FROM Members WHERE email='$_POST[email]'";
$result = mysqli_query($cxn,$sql)
or die ("Couldn't execute query1");

$num = mysqli_num_rows($result);
if ($num >0) // Login Name found 
{
$sql = "SELECT * FROM Members WHERE email='$_POST[email]' AND password=md5('$_POST[password]')";
$result2 = mysqli_query($cxn,$sql)
or die ("Couldn't execute query2");
$num2 = mysqli_num_rows($result2);
if ($num2 > 0) // password correct
{
session_start();
$_SESSION['auth']="yes";
$_SESSION['logname'] = $_POST['email'];
$logname = $_SESSION['logname'];
$today = date("Y-m-d h:i:s");
$sql = "INSERT INTO Login (email,loginTime)
VALUES ('$logname', '$today')";
$result = mysqli_query($cxn,$sql)
or die ("Can't execute insert query");
echo "you have logged in!";
header("Location: ../$_POST[page]");
}
else 
{
$message = "The email address, '$_POST[email]' is registered, but you have not entered the correct password! Please try again.<br>";
include("../login.html");
}
}

?>

Okay, a few of you have been helping me with a login script problem. I have changed it quite a bit again, but I am still running into a little bit of a problem.

When I click the submit button it just clears the form fields and stays on the login page. Also, I have used error_reporting(E_ALL) to help me out with debugging. I took care of three bugs on my own but I cant seem to clear the two remaining bugs and the fact that it is not forwarding me to any page with my header statement. 

Thanks for your help in advance!

Here is my code from my 'login.php' file.


<?php
session_start();
error_reporting (E_ALL);
include("config.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{
// username and password sent from form 
$myusername=addslashes($_POST['username']); 
$mypassword=addslashes($_POST['password']); 

$sql="SELECT id FROM admin WHERE username='$myusername' and passcode='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row['active'];
$count=mysql_num_rows($result);


// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
session_register("myusername");
$_SESSION['login_user']=$myusername;
header("location: main_interface.php");
}
else 
{
$error="The username or password you entered is invalid, please check your credentials and try again";
}
}
?>
<form action="" method="post">
<label>Username :</label>
<input type="text" name="username"/><br />
<label>Password :</label>
<input type="password" name="password"/><br/>
<input type="submit" value=" Submit "/><br />
</form>


Here are the error messages on the page

Notice: Undefined index: active in login.php on line 20

Warning: Cannot modify header information - headers already sent by (output started at login.php:1) in login.php on line 29



Thanks in advance for your help!