How to use mysql_result with Mysqli?

Question

How to use mysql_result with Mysqli?

Asked 8 years, 6 months ago

Viewed 1,572 times

2

I’d like to know how to use the mysql_result in the mysqli I’m not getting it, I was looking at the site php.net and the only thing I saw was a mysqli_data_seek if anyone can help me...

Code I’d like to pass to mysqli:

$sql = mysqli_query($link, "SELECT * FROM produtos WHERE id_produto = $id");
if($id!=""){
     $descricao = mysql_result($sql,0,"descricao");
     $nome = mysql_result($sql,0,"nome");
     $preco = mysql_result($sql,0,"preco");
     $img = mysql_result($sql,0,"img");
}

It is impossible! this function does not exist, needs to work differently

– rray

2015/12/18 at 01:02
I saw this mysli_data_seek rray but n intendi very well it

– Leonardo Costa

2015/12/18 at 01:03
this would be the new method that is equal to mysql_result?

– Leonardo Costa

2015/12/18 at 01:03
You can use it like this => Select with Prepared statements Mysqli

– rray

2015/12/18 at 01:04
in my case then I would have to use the bind that Voce spoke on the topic?

– Leonardo Costa

2015/12/18 at 01:06
Yes, this avoids sql Injection

– rray

2015/12/18 at 01:07
Would it look like this in mine? $list = array(); $i = 0; while($query->fetch()){ $list[$i]['Description'] = $Description; $list[$i]['name'] = $name; $list[$i]['price'] = $price; $list[$i]['img'] = $img; $i++; Here would enter the print that has inside my if? and also I forget my if? }

– Leonardo Costa

2015/12/18 at 01:10

Show 2 more comments

1 answer

Browser other questions tagged php mysql mysqli

You are not signed in. Login or sign up in order to post.

by rray • **66,288** points · Answer 1 · 2015-12-18T01:13:09+00:00

There is no function called mysqli_result(), utilize mysqli_fetch_*() instead, this eliminates all these variable assignments. Avoid sql injections using Prepared statements.

With Prepared statements you need to define the parameters types sent in the query, mysqli_stmt_bind_param() does that, mysqli_stmt_execute() executes the query in the bank, mysqli_stmt_get_result() get the seat reset and mysqli_fetch_assoc() takes this infomation and returns in the form of an associative array, this code is in the procedural style.

$sql = "SELECT * FROM produtos WHERE id_produto = ?";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_bind_param($stmt, 'i', $id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_assoc($result)){
    echo $row['nome'] .' - '. $row['descricao'] .' - '. $row['preco']. '<br>';
}