Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #15151

Re: Why do I get error when same code works elsewhere?

Show all headers | View raw

On 3/29/2015 9:47 PM, richard wrote:
> 																																																
> $num=count($numone);
> 																																																
> shuffle($numone);
> $x=0; $y=0;
> while($x<$num){
>
> $mp=$numone[$x];
> $mp=substr($mp,0,6);
> $sql = "SELECT * FROM sixty where sid='$mp'";
> $result = $mysqli->query($sql);<<<<<<<<<<< error here
> $row = $result->fetch_assoc();
>
> echo$mp;
> echo "<div style='width:300px; height:60px; border:solid 1px #00f;
> overflow:hidden;';>";
> $y=$x+1;
> echo $y.") ".$row['title'];
> echo "<br>";
> $x++;
>
> echo "</div>";
> }
>
> Fatal error: Call to a member function query() on a non-object
>

Let me (uncharacteristically) defend richard this time.
He is being polite
He posted actual code

He is still copying and pasting without understanding, but that 
might be repairable.

Richard,
before one can invoke a method of an object, one must create the 
object (usually using the "new" constructor or an explicit 
constructor)
Now, your task is to read the introductory chapters about PDO
http://us1.php.net/manual/en/class.pdo.php

-bill

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Why do I get error when same code works elsewhere? richard <noreply@example.com> - 2015-03-29 21:47 -0400
  Re: Why do I get error when same code works elsewhere? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-03-30 02:14 +0000
  Re: Why do I get error when same code works elsewhere? Denis McMahon <denismfmcmahon@gmail.com> - 2015-03-30 03:21 +0000
  Re: Why do I get error when same code works elsewhere? Richard Yates <richard@yatesguitar.com> - 2015-03-29 20:35 -0700
    Re: Why do I get error when same code works elsewhere? richard <noreply@example.com> - 2015-03-29 23:53 -0400
      Re: Why do I get error when same code works elsewhere? Richard Yates <richard@yatesguitar.com> - 2015-03-29 21:12 -0700
        Re: Why do I get error when same code works elsewhere? richard <noreply@example.com> - 2015-03-31 12:01 -0400
    Re: Why do I get error when same code works elsewhere? Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-30 08:21 -0400
      Re: Why do I get error when same code works elsewhere? "Beauregard T. Shagnasty" <a.nony.mous@example.invalid> - 2015-03-30 13:17 +0000
      Re: Why do I get error when same code works elsewhere? Denis McMahon <denismfmcmahon@gmail.com> - 2015-03-30 17:06 +0000
      Re: Why do I get error when same code works elsewhere? richard <noreply@example.com> - 2015-03-31 12:02 -0400
  Re: Why do I get error when same code works elsewhere? bill <william@TechServSys.com> - 2015-03-31 08:11 -0400
    Re: Why do I get error when same code works elsewhere? "Christoph M. Becker" <cmbecker69@arcor.de> - 2015-03-31 14:24 +0200
      Re: Why do I get error when same code works elsewhere? bill <william@TechServSys.com> - 2015-04-01 08:27 -0400
        Re: Why do I get error when same code works elsewhere? ꧁꧂ <vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvva@hotmail.com> - 2023-05-14 08:53 -0700
    Re: Why do I get error when same code works elsewhere? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-03-31 22:38 +0200
      Re: Why do I get error when same code works elsewhere? "Christoph M. Becker" <cmbecker69@arcor.de> - 2015-03-31 22:55 +0200
        Re: Why do I get error when same code works elsewhere? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-03-31 23:23 +0200

csiph-web