This mysqli_query will not execute

Question

This is my code using OO style:

$query = "SELECT * FROM articles LIMIT 1";
$result=mysqli_query($db, $query) or die("Could Not execute query.");
$row = $result->fetch_assoc()
echo $row;

Code using Procedural:

$query = "SELECT * FROM articles LIMIT 1";
$result=mysqli_query($db, $query) or die("Couldn't execute query.");
$row = mysqli_fetch_row($result);
echo $row;

I have tried various different ways of getting this to work and the query never seems to execute.

I am new to mysqli from mysql and am struggling with some of the differences. Apologies if there is an obvious answer to this question.

Any Help much appreciated.

You're mixing functional and OOP code – John Conde Jan 29 '13 at 21:53 — John Conde, Jan 29 '13 at 21:53
Ok thanks. Which pieces of code are out of place? – user2023307 Jan 29 '13 at 21:55 — user2023307, Jan 29 '13 at 21:55

score 0 · Answer 1 · answered Jan 29 '13 at 22:08

0

Try:

$query  = "SELECT * FROM articles LIMIT 1";
$mysqli = mysqli_connect("example.com", "user", "password", "database");
$res = mysqli_query($mysqli, $query);
$row = mysqli_fetch_assoc($res);

or:

$mysqli = new mysqli("example.com", "user", "password", "database");
$res = $mysqli->query($query);
$row = $res->fetch_assoc();

answered Jan 29 '13 at 22:08

John Conde

217,595
99
455
496

So the result has to be an object for it to work? Ill give this a try. Thanks a lot for the help. – user2023307 Jan 30 '13 at 09:10

score 0 · Answer 2 · edited Oct 10 '15 at 11:31

0

Assuming your

 $db = mysqli_connect("localhost", "user", "password", "database");

then you can have

$query  = "SELECT * FROM articles LIMIT 1";
$res = $db->query($query);
$row = $res->fetch_assoc();

edited Oct 10 '15 at 11:31

Niranjan N Raju

12,047
4
22
41

answered Oct 10 '15 at 11:30

Tim Chosen

41
8

This mysqli_query will not execute

2 Answers2