PHP - How To Make Fetch_array Inside A Function Global?

When I put this chunk of code into it's own function:


function fetch_all ($dbc, $query) {

include ('knuffix_list_func.php');

pagination_start ($dbc, $query);

$offset = $pag_array[0];

$rows_per_page = $pag_array[1];

$query = $query . " LIMIT $offset, $rows_per_page";

echo "test query: " . $query;

knuffix_list ($query, $dbc);

pagination_end ($pag_array);
}


And when I echo out the query as you can see in the example, then I notice that the variables $offset and $rows_per_page never get appended.
I set the variable $pag_array to a global inside the function pagination_start(). It usually works when I DON'T wrap a function around this chunk of code, but if I do wrap a function around everything then the global suddenly won't work anymore.

Btw, this also won't work if I wrap a function around the function DECLARATIONS.

Any ideas, how I could make it work?

Hi guys. I need some help, because i'm stuck 

I'm getting this error and cand figure out what im doin wrong.

Fatal error: Call to a member function fetch_array() on a non-object in C:\xampp\htdocs\cms\webklex\theme\admin\edit_content.php on line 16.

The Code around it:
Code: [Select]
include "../config/config.php";
$host = htmlspecialchars($_SERVER["HTTP_HOST"]);
$uri  = rtrim(dirname(htmlspecialchars($_SERVER["PHP_SELF"])), "/\\");
$extra = "show_content.php";
if (empty($_POST["titel"])) {
  $id = (isset($_GET["id"])) ? (int)$_GET["id"] : false;
  $result = $db->query("SELECT * FROM `content` WHERE `id` = ".$db->real_escape_string($id)."");
  $row = $result->fetch_array(MYSQLI_ASSOC);
  $db->free_result;
  unset($result);
  }
 
  $ide = (isset($_GET["id"])) ? (int)$_GET["id"] : false;
  $result = $db->query("SELECT `id_position` FROM `content` WHERE `id` = ".$db->real_escape_string($ide)."");
  $zeile = $result->fetch_array(MYSQLI_ASSOC); ---->This is line 16
  $db->free_result;
  unset($result);
 
  $id_position_real = $zeile['id_position'];
  if ($id_position_real == 1) {
    $id_position_real = 1;
  }else{
    $id_position_real= 0;
  }
  if ($id_position_real == 1) {
    $id_position_real_none = 0;
  }else{
    $id_position_real_none = 1;
  }
?>
thanks ThatMSG

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.

Hi All,
For the last post,I m very happy that i found out so many great mind who are watching my problem and solving online.
anyway great thanks for all,
just now i m making a project and i m facing problem in the below code
"i need to know how can make this code easy or how can i make rdata variable accessible for the download button"
generatecv.php file
<?php
if(isset($_REQUEST['submit']))
{
$name=$_REQUEST['pname'];
$pin=$_REQUEST['pin'];
$mnumb=$_REQUEST['mnumber'];
$tnumb=$_REQUEST['telenumber'];
$email=$_REQUEST['email'];
$obj=$_REQUEST['obj'];
$title=$_REQUEST['jobt'];
$activity=$_REQUEST['activity'];
//$file=fopen('test.doc','a+');
//echo @fwrite($file,$name);
//fclose($file);
$rdata="";
$rdata.="<table id='cvtbl' border='0' align='center' >
<th>Resume</th>
<tr><td>".$name.":</td></tr><tr><td>Objective:</td></tr>";
$rdata.="<tr><td>".$obj."</td></tr>";
$rdata.="<tr><td>Email:".$email."</td></tr>";
$rdata.="</table>";
echo $rdata;

echo "<style>#cv{display:none;}</style>";
echo "<form><input type='submit' name='dwnld' id='dwnld' value='Download'/></form>";
}
if(isset($_REQUEST['dwnld']))
{
header("Content-type:application/msword");
header("Content-disposition:attachment;filename=test.doc");
$fp=fopen("test.doc","r") or die("try again");
$data=fread($fp,filesize('test.doc'));
fwrite($fp,$rdata);
echo $data;
fclose($fp);
//echo $rdata."<br />".$rdata;
}
?>

this is the html file

<html>
<title>User details</title>
<body>
<form name='cv' id='cv' method="post" enctype="multipart/form-data" action='generatecv.php'>
    Enter your name<input type=text name=pname id=pname />
    Zip Code<input type=text name=pin id=pin />
    Mobile number<input type=text name=mnumber id=mnumber />
    <br />Telephone number <input type=text name=telenumber id=telenumber />
    Email address<input type=text name=email id=email />
    <br />Enter your objective<br /><textarea name=obj id=obj cols=30 rows=5 ></textarea>
<!--University Name <input type=text name=university id=university /> -->
    <br /><!--uni, city ,state ,type of degree ,full degree name,date-->
    <br /><!--Experience<br /><textarea name=exp id=exp cols=30 rows=5 ></textarea> -->
   Select type of resume
   <select name='type' id='type' onChange=''>
   <option value='0'>Graduate</option>
   <option value='1'>Post Graduate</option>
   <option value='2'>Non Graguate</option>
   <option value='3'>Other</option>
   </select>
    Job title<input type='text' name='jobt' id='jobt' />
    <br /><!--company name,city ,state ,office number ,job description ,date of employment-->
    <br />Activity <input type=text name=activity id=activity size=100 />
    <br />Honors/Awards<input type=text name=honor id=honor size=100 />
   <input type='submit' name='submit' id='submit' value='Generate CV' />
   <input type='reset' name='Reset' id='submit' value='Reset' />
   
</form>
</body>
</html>

Many thanks in advance