Beginner's Question about accessing mysql using OOP

Question

I am reading the PHP and mySQL web development book and so far been doing all the PHP and mysql using procedural. But then it talks about accessing mysql with objects.

This works for me:
//I define $db so can connect
$query="select * FROM testing";
$result=mysqli_query($db,$query);
while($row=mysqli_fetch_array($result)){
  //echo the data
}

But when I try to do it with classes, it doesn't
@ $db=new mysqli('localhost','root','','test');
if(mysqli_connect_errno()){
echo "ERROR:";
exit;
}
$query="select * FROM testing";
$result=$db->query($query);
$row=$result->fetch_assoc();

Do I have to write my own class so it defines what query and fetch_assoc does? Or what?

Yes and could you show us how you are setting up $db?

Greg Olmstead
– Greg Olmstead

2010-05-20 03:34:01 +00:00
Commented May 20, 2010 at 3:34 — Greg Olmstead
– Greg Olmstead, Commented May 20, 2010 at 3:34

John Rasch · Accepted Answer · 2010-05-20 03:38:32Z

1

You should be setting up $db something like this:

$db = new mysqli("db_server", "db_username", "db_password", "db_name");

answered May 20, 2010 at 3:38

John Rasch

63.6k19 gold badges109 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jpjp Over a year ago

doing it OOP doesn't require me to write a class does it? Am I to assume that $result=$db->query($query); will know what -> does?

John Rasch Over a year ago

The mysqli class should already exist, and it should connect when constructed. It looks like your syntax is correct, which version of PHP are you running?

jpjp Over a year ago

I'm running 5.3.1. It seems when I use fetch_row($result) it throws an error, but when I use fetch_assoc() it works. Btw, thanks for your help!

Collectives™ on Stack Overflow

Beginner's Question about accessing mysql using OOP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related