PHP loading twice

[samja]

 

What can be the reason when my index-page is loaded twice?

[flyhoney]

Post some code or we can't really help you

[samja]

in index.php:

 

include('code/incs.php');
include('main.php');

 

then after call of $var = func() (in incs.php) from main.php causes all loading twice.

 

if func() returns simple number like 5, all works. But if it returns an array, the code is run again.

 

???

[Maq]

Please post ALL the code.

[samja]

 

index.php:

 

include('code/incs.php');
include('code/main.php');

 

code/incs.php:

 

function getRec($taulu, $kentat, $lopuke = '') {
  $qstr = "SELECT $kentat FROM $taulu $lopuke";
  $qres = mysql_query($qstr);
  if ($qres === false) return false;
  $t = mysql_fetch_array($qres, MYSQL_ASSOC);
  mysql_free_result($qres);
  return $t;
}

function func() {
  global $arr;
  $arr = getRec('versiot', '*', "WHERE active=1"); }
}

 

 

code/main.php:

 

func();

 

if in function func() i comment the global line, the code is not loaded twice.

[samja]

 

if from getRec I return a record from database,

Array
(
    [id] => 32
    [sitename] => sp1
    [logo] => 
    [valikot] => valikot_sp1
    [active] => 0
    [onwork] => 1
    [teema] => perus
    [naytalogo] => 0
    [naytasitename] => 0
    [kanta] => sp1
)

 

then all are loaded twice. If I return an array: array(1,2,3), that does not happen.

 

?

[samja]

 

This is very annoying, since all tables in sql-database can be renamed silly when names are constructed with emtpy $_POST variable (on second run).

[samja]

Srange: If I use MYSQL_NUM insted of MSQL_ASSOC, all works properly. Nothing is loaded again.

 

function getRec($taulu, $kentat, $lopuke = '') {
  $qstr = "SELECT $kentat FROM $taulu $lopuke";
  $qres = mysql_query($qstr);
  if ($qres === false) return false;
  $t = mysql_fetch_array($qres, MYSQL_NUM);
  mysql_free_result($qres);
  return $t;
}

[samja]

 

Yess.

 

All works fine. This goes over my level to understand. Thanks for listening!

[Maq]

Srange: If I use MYSQL_NUM insted of MSQL_ASSOC, all works properly. Nothing is loaded again.

 

function getRec($taulu, $kentat, $lopuke = '') {
  $qstr = "SELECT $kentat FROM $taulu $lopuke";
  $qres = mysql_query($qstr);
  if ($qres === false) return false;
  $t = mysql_fetch_array($qres, MYSQL_NUM);
  mysql_free_result($qres);
  return $t;
}

 

MSQL_ASSOC?  Do you mean MYSQL_ASSOC?  I don't even see where you use this in the first place...

[samja]

MSQL_ASSOC?  Do you mean MYSQL_ASSOC?  I don't even see where you use this in the first place...

 

Sorry, I wrote it wrong.

[iversonm]

just change all your includes or requires to require_once() and nothing will be repeated

[samja]

 

just change all your includes or requires to require_once() and nothing will be repeated

 

But the whole index-file also gets loaded twice. Not only the included files. I cut some code and that fixed the problem.

 

There might be a bug in PHP somewhere?