PHP - How Can I Make Rdata Variable Global

Hey,

I've been developing a browsergame. In this you are able to produce something ("weed"). Now I've got some kind of trouble with the function that is responsible for updating the "weed" on the user accounts.

Im going to explain, how my script is working

First step:

Loading the datas from "worlds". In this case id, weed_factor, weed_basis. What this is required for you will see in the next steps 


<?php

include 'includes/settings/mysql.php';
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbbase);

$time = time();

$update_weed_world_data_sql = "SELECT id, weed_factor, weed_basis FROM worlds";
$update_weed_world_data_res = mysql_query($update_weed_world_data_sql) OR DIE (mysql_error());
while($update_weed_world_data_while = mysql_fetch_assoc($update_weed_world_data_res)){
$update_weed_world_id = $update_weed_world_data_while['id'];
$update_weed_world_basis[$update_weed_world_id] = $update_weed_world_data_while['weed_basis'];
$update_weed_world_factor[$update_weed_world_id] = $update_weed_world_data_while['weed_factor'];
global $update_weed_world_basis;
}


Second step:

This is the function which is editing each account by the data given as parameters.


function do_update_weed($profile_id,$world,$update,$level,$time){
$update_weed_period = $time - $update;
$update_weed_add = ($update_weed_period / 3600 * $update_weed_world_basis[$world] * pow($update_weed_world_factor[$world],$level)) +1;
echo $update_weed_world_basis[$world];
echo "<br>";
mysql_query("UPDATE profiles SET weed = weed +$update_weed_add, weed_update = $time WHERE id = $profile_id LIMIT 1");
}


Note:


echo $update_weed_world_basis[$world];


doesnt result an output.

In step three, the accounts are loaded:


function todo_update_weed($time){
$todo_update_weed_sql = "SELECT * FROM profiles WHERE weed_update < $time";
$todo_update_weed_res = mysql_query($todo_update_weed_sql) or die (mysql_error());
while($todo_update_weed_while = mysql_fetch_assoc($todo_update_weed_res)){
do_update_weed( $todo_update_weed_while['id'],
$todo_update_weed_while['world_id'],
$todo_update_weed_while['weed_update'],
$todo_update_weed_while['level_farm'],
$time
);
}
}


And the last step is calling function "todo_update_weed" with the time.


todo_update_weed($time);


I script calculate the time between the last update and the current time. This make a difference in time. With this value I calculate something else. And then the update time has to be saved.

The script has just working fine, when I set the variable "$update_weed_add" with a fix value. But by now the script doesn't work, because I don't know how to make the array available inside functions.

I considered whether I put the database-function for the world_data inside the function that updates the profiles. But if I do this, the database will be called thousands of times...

Hope anybody has a nice idea to fix the problem 

Hiya!

I was wondering if this is possible. Here is my example.

This is a example class;

<?php
class a {

public function __construct() {

}

public function returnValue() {
include 'files/lang.php';
$this->lang = new lang();
return $this->lang->displayLang('10');
}
}
?>


This is the second class file;

<?php
class b {

public function __construct() {

}

public function returnValue() {
include 'files/lang.php';
$this->lang = new lang();
return $this->lang->displayLang('10');
}
}
?>


This is the main file;

<?php
include 'test/a.php';
$test = new a();
$test->returnValue();

include 'test/a.php';
$test2 = new b();
$test2->returnValue();
?>


With this I'm getting an error stating I cannot redeclare the function lang. I have found a way around this by using require_once but I was wondering if remove the include and $this->lang var from class 2 and I put this as the $this->lang var declaration in class 1;


global $this->lang = new lang();


will class 1 and class 2 be able to use it from only the one declaration made in class 1. If so, would this be the way to do it or is there a better/working way to do it?

Many many thanks,

James.

I need $row['con_id'] outside the function so I can put it into a query, but simply putting global in front of it won't work. What would be the right way to do?

This portion of code is INSIDE a function:

//Loop through the array of data

while ($row = mysqli_fetch_array ($data)) 

{

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<input type='hidden' name='con_id' value='<?php echo " . $row['con_id'] . "; ?>' />";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='$avatar_path' alt='avatar' /></td><td class='knuffix_username'><strong>" . $user_name;

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<input type='submit' name='plusVote' value='Y' />

<input type='submit' name='minusVote' value='N' />

</form></td><td class='votes'>Y[ - ] | N[ - ]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";



The PHP documentation does not show any examples how to GLOBALIZE a mysqli function. I'd need a way to use $row['con_id'] outside the function for the voting script I'm writing.

Thanks for the suggestions.

Hi,

As the title suggests I am unsure on how to first run a query which stores values into an array. I then need to run a function multiple times but use the array within the function. How is this possible? I have had no luck figuring it out yet.

1. RUN QUERY
2. BUILD ARRAY USING QUERY RESULTS
3. RUN FUNCTION MULTIPLE TIMES
4. WITHIN FUNCTION I NEED TO USE ARRAY

Many thanks
Simon

Sorry, this will be a simple question.  Say you define two global variables in your functions.php file as:
GLOBAL  $salesTax = .07;
GLOBAL $shipping = 5.00;

Those variables would be accessiible in the checkout.php page, right?