PHP - Running Php Offline

Hi,

actually the problem is i have been modifying a website, which has been already built and working. so i have all the code and everything, i need to keep it running to make changes. But i m facing problems like above

Warning: require_once(../../global-inc.php) [function.require-once]: failed to open stream: No such file or directory in C:\\Apache2.2\htdocs\login.php on line 2

Fatal error: require_once() [function.require]: Failed opening required '../../global-inc.php' (include_path='.;C:\php5\pear') in C:\\Apache2.2\htdocs\login.php on line 2


please let me know what to do ...

and the other thing is i need to execute the entire file of code at a time .....can u please tell me the process of doing it ..........


thanks in advance

shiva

shiva

ok.  this may make now sense at all, I will try to explain as best as I can.  anyways, what I need is for a mysql query to run that will pull all data from table payment between certain days.  Then all the rows will show, but I want only one row with each cart_id(there will be multiple) to show.  After it does that, in a new column on a table, all the payment types with the amount will show with a slash between each one. 
I want all of this in a table generated from a php loop.

maybe a visual represenation will be better.
 I hope the picture I attached makes a bit more sense.

Hi,

I have a PHP script which I want to run from a different IP on my server.

Example of what I want to do:
My main ip: 4.5.6.7
Have several IP's on server.
I want my PHP script (running from CLI) to use cURL with another IP, ay 4.5.6.9

Is this possible to do?

Help would be greatly appreciated!

I want to run a php file which contains a long process and takes time. If I simply run the file on browsers, the process will be interrupted by any perturbation in the internet connection or closing the browser. How I can force the php process to continue running without connection to my local PC (server side controlling)? I am looking for something like what cron job does (but only one time, not periodically).

Hey Guys,

I have a DB with two tables, one is field names, the other is the data.

So for example, I log in and I am user ID 1..... I need to query the DB to show all fields where user_id = 1

Field1 - Data1
Field2 - Data2

etc etc...

This is what I have so far, but I dont get any output...

    $sql = "SELECT * FROM ".WPSC_TABLE_DATA." WHERE `user_id` == .$cu. ORDER BY id DESC";
    $user= $wpdb->get_row($sql);

while($user) {

echo $user->name .' : '. $user->value .'<br />';

}

Can you help please?

Hey guys,

I dont know if you can do this in PHP due to it only running when the page loads but I would like to make it so at the end of everyday "24:00" some code will run that will reset all users "Mana" and "Health".

My guess would be JQuery or somthing like that?

If anyone knows would be great for a reply.

Cheers guys,
Ruddy

I'm experimenting with the shell_exec function to gain shell capability on a Linux host that doesn't provide it otherwise. I've found that I can see what is in different directories by entering a command line like:

Code: [Select]
cd ..; ls

but if I enter two consecutive command lines:

Code: [Select]
cd ..
ls
The cd command has no effect. Apparently shell_exec is using a new shell every time I call it.

Is there a way to start a shell in a PHP script and keep it active while I pass it multiple commands, so that this won't happen?

Okay I want to run some code every 24 hours, what would be the best way to do this? Also I don't have root to the server or anything.

Hi
I've got a qry that selects 100 questions one at a time from tblquestions.
When the users have answered q100 I want them to be able to come out of the post-process-post loop that has taken them through the survey.

My idea is that I could put an IF requirement in before the qry runs each time it selects the next question

i.e.


if $nextq <101
  $result = mysql_query("SELECT oid,psc9 FROM tblquestions WHERE oid = $nextq");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
};
else echo "thanks you've finished now";

Two Questions:
Is this the way I should be going about this problem? Have I got the syntax right?
Many thanks!
Nick

I have made a script that allows a user to change their email address. It works BUT if the email address they have chosen is already registered the script does not cut off - it continues to the next if statement and changes the email address anyway.

I am trying to put a stop to it using exit() and exit; but it does not work.

Any tips?


<?php
//////////////////// checking new email is not already registered /////////////////
if ($_POST['newemail'] && $_POST['newemail1'] !="") {

if ($_POST['newemail'] == $_POST['newemail1']) {
$sql2 = "SELECT email FROM Members WHERE email='$_POST[newemail]'";
$result2 = mysqli_query($cxn,$sql)
or die ("Couldn't execute query 2");

$num2 = mysqli_num_rows($result2);

if ($num2 > 0) { $updateerror = "The email address you have chosen is already registered.";
 include("my-account.php")
 exit();  // TRYING TO STOP THE SCRIPT HERE (IF $num2 > 0)
 exit;
}
else { echo "You can have this new email address";}
}
else { echo "Your email addresses do not match. Please try again."; }
}
else {}

// THIS SCRIPT CONTINUES TO CHANGE THE EMAIL ADDRESS DESPITE IT ALREADY BEING REGISTERED.
if ($_POST['newemail'] == "") { $newemail = $_POST['currentemail']; }
else { $newemail = $_POST['newemail']; }
$newemail1 = $_POST['newemail1'];
?>

Hey everyone,

I have an SQL file called "Cype.sql" and I was wanting to have it run when the install feature is going on. However I can't seem to figure out why exactly the code is not working.

is it possible to have it run without getting too in depth the PHP coding?  I'm not OOP Literate yet.


//Connection is opened
//While in installation file


$sqlFile = "Cype.sql";

if(!file_exists($sqlFile)){
echo "File not found";
}
else{
$openFile = fopen($sqlFile, "r");
$tryQuery = mysql_query($openFile);
}


Now obviously, I'm not the best coder. I've been out of the works of PHP for quite some time now as well.
However, I have researched it and found no answers to my issue.


Any help would be greatly appreciate. Thank you.

Its the

Code: [Select]
$query = "INSERT INTO hitlist
 hit_id = ($addIDs_str), player_id = '$playerID'";
Thats the issue, my codes below i cannot figure out how to insert the results, any help would be appreciated Thanks

Code: [Select]
if (isset($_POST["submit"]) && $_POST["submit"] == "Recall Selected Informants")
{
//Force POST values to be INTs
$addIDs_ary = array_map('intval', $_POST['chkInv']);
//Remove any 'false' value
$addIDs_ary = array_filter($addIDs_ary);
//Check that there was at least one valid value
if(count($addIDs_ary))
{
//Create comma separated string of the IDs
$addIDs_str = implode(',', $addIDs_ary);
//Create and run one query to perform all the adds (of the user)
$query = "INSERT INTO hitlist
 hit_id = ($addIDs_str), player_id = '$playerID'";
$sql = "UPDATE players SET Informants = Informants - 1 WHERE id = '$playerID'";
mysql_query($sql) or die(mysql_error());
if(mysql_query($query))
{
$selectedCount = count($addIDs_ary);
$adddCount  = mysql_affected_rows();
echo "{$adddCount} of {$selectedCount} Investigated player(s) were successfully Removed.";
if($adddCount != $selectedCount)
{
echo " You do not have rights to the others.";
}
}else{
echo "There was a problem running the query.<br>" . mysql_error();
}
}else{
echo "Invalid ID data passed.";
}
}

Hi,

I have written some code however when I echo the query it runs it twice...

Quote

SELECT `description`, `fulldescription` FROM `productdbase` WHERE `keywords` LIKE '%table%'something found.SELECT `description`, `fulldescription` FROM `productdbase` WHERE `keywords` LIKE '%table%'something found.


I only have the query once in my code. Any suggesions?

Code: [Select]
<?php
if (isset($_POST['keywords'])){
 $keywords = mysql_real_escape_string (htmlentities(trim($_POST['keywords'])));
}

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search must be three or more characters';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results';
}

if (empty($errors)) {

search_results ($keywords);

} else{
foreach($errors as $error) {
echo $error, '</br>';
}
}


    ?>


<?php
function search_results ($keywords) {
$returned_results = array();
$where = "";

$keywords = preg_split('/[\s]+/', $keywords);
$total_keywords = count($keywords);

foreach($keywords as $key=>$keyword) {
$where .= "`keywords` LIKE '%$keyword%'";
if ($key != ($total_keywords - 1)) {
$where .= " AND ";

}
}

$query_string = "SELECT `description`, `fulldescription`  FROM `productdbase` WHERE $where";
echo $query_string;
$query = mysql_query($query_string);



if ($results_num === 0) {
return false;
}else{
echo 'something found.';
}




}
?>

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.

Hello there,

I have a problem where the following code is running the query before it should.


    private function isAccountRegistered($AccountUsername, $AccountEmail)
    {
        global $Class;

        if($Class['MySQL']->currentRows("SELECT * FROM xhost_accounts WHERE account_username = '".$Class['MySQL']->parseClientInput($AccountUsername)."'") == 1)
        {
            return USERNAME_REGISTERED;
        }
        else if($Class['MySQL']->currentRows("SELECT * FROM xhost_accounts WHERE account_email = '".$Class['MySQL']->parseClientInput($AccountEmail)."'") == 1)
        {
            return EMAIL_REGISTERED;
        }
    }
    
    public function createClientAccount($AccountUsername, $AccountPassword, $AccountEmail, $AccountRealname)
    {
        global $Class;

        if($this->isAccountRegistered($AccountUsername, $AccountEmail) == USERNAME_REGISTERED)
        {
            echo("<div class=\"warning\">Unfortunately this username is in use by another member!, please select another!.</div>");
        }
        else if($this->isAccountRegistered($AccountUsername, $AccountEmail) == EMAIL_REGISTERED)
        {
            echo("<div class=\"warning\">Unfortunately this email address is in use by another member!, please select another!.</div>");
        }
        else
        {
            if($Class['MySQL']->Query("INSERT INTO xhost_accounts (account_username, account_password, account_email, account_realname, account_regdate, account_regtime, account_level, account_balance, account_notifications) VALUES('".$Class['MySQL']->parseClientInput($AccountUsername)."', '".md5($Class['MySQL']->parseClientInput($AccountPassword))."', '".$Class['MySQL']->parseClientInput($AccountEmail)."', '".$Class['MySQL']->parseClientInput($AccountRealname)."', '".date("d/m/y")."', '".time()."', '0', '0.00', 'Enabled')"))
            {
                $Class['Core']->refresh('index.php');
            }
            else
            {
               echo("<div class=\"warning\">Unfortunately something went wrong there, please try again!.</div>");
            }
        }
    }


For some reason when the code above is run it executes


            if($Class['MySQL']->Query("INSERT INTO xhost_accounts (account_username, account_password, account_email, account_realname, account_regdate, account_regtime, account_level, account_balance, account_notifications) VALUES('".$Class['MySQL']->parseClientInput($AccountUsername)."', '".md5($Class['MySQL']->parseClientInput($AccountPassword))."', '".$Class['MySQL']->parseClientInput($AccountEmail)."', '".$Class['MySQL']->parseClientInput($AccountRealname)."', '".date("d/m/y")."', '".time()."', '0', '0.00', 'Enabled')"))


Before it runs:


      if($this->isAccountRegistered($AccountUsername, $AccountEmail) == USERNAME_REGISTERED)
        {
            echo("<div class=\"warning\">Unfortunately this username is in use by another member!, please select another!.</div>");
        }


Causing it to say that the username is registered every time yet still inserting the account into the database, its returning that its registered because it inserts it before doing the check, does anybody have any idea why, this really has confused me, thanks for your time.