Menu
Community /Pin to ProfileBookmark
@NogDogSep 07.2014 — #It's probably best fixed wherever you define $params so that it stores references to variables instead of values, but a quick work-around would be something like:
@NogDogSep 07.2014 — #
Yeah, I think you could just change the last line of that snippet to:
parameters error I think
Hi, now I know next to nothing about PHP so I apologise now for anything I say that is rubbish, but I have been tasked to attempt to fix a website that I think has stopped working since the hosting company upgraded to PHP 5.3 on their servers. The website has not changed at all in 2 yrs? So I know its not the code itself although this may not need to change!!
I am getting the below error on all the menu items for the website, below that I have put the code relevant to the file referenced and line 54.
I would be extremely grateful for any help on this as I have no clue about PHP, but do have a decent IT head ?
Warning: Parameter 2 to mysqli_stmt::bind_param() expected to be a reference, value given in /home/korfball/public_html/bristoluni/system/system_files/database/mysqli.php on line 54
Query execution failed! (No data supplied for parameters in prepared statement)
Line 54 in the file has this – call_user_func_array(array($this->stmt, ‘bind_param’), $params);
If needed I can post up the whole file if this helps. The hosting server is running PHP 5.3.28
Many thanks in advance for any help on this
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogSep 07.2014 — #It's probably best fixed wherever you define $params so that it stores references to variables instead of values, but a quick work-around would be something like:[code=php]
$tmp = array();
foreach($params as $key => $val) {
$tmp[$key] =& $params[$key];
}
call_user_func_array(array($this->stmt, 'bind_param'), $tmp);
[/code]0
@NogDogSep 07.2014 — #NogDog, you are a genius ? The work around has worked, so for now that's absolutely brilliant for me. Looking at the file I only see $params = array () would this be where you mean $params being defined? I've put it below:
[code=php]
$params = array();
$params[] = "";
foreach ($args as $arg)
{
$params[0] .= "s";
$params[] = $arg;
[/code]
Is this where you mean.. Not that I am that bothered now as it seems to be working fine, couple of pictures don't display but I don't really care about those, they may not have worked before!!
Thanks again for the help on this, that's brill, thanks.[/QUOTE]
Yeah, I think you could just change the last line of that snippet to:
<i>
</i> $params[] =[B][COLOR="#B22222"]&[/COLOR][/B] $arg;