php bind_result

Question

I have this sequence of code:

$connection = new mysqli('localhost','root','','db-name');
$query = "SELECT * from users where Id = ?"; 
$stmt = $connection->prepare($query); 
$stmt->bind_param("i",$id); 
$stmt->execute();
$stmt->bind_result($this->id,$this->cols);
$stmt->fetch(); 
$stmt->close(); 
$connection->close();

The problem is that the "SELECT" might give a variable number of columns, which i retain in $this->cols. Is there any possibility to use bind_result with a variable number of parameters?...or any alternative to the solution.

You could bind to an array. Have a read at http://php.net/manual/en/mysqli-stmt.bind-result.php#92505 — Kurt
– Kurt, Commented Feb 24, 2012 at 13:36

Your Common Sense · Accepted Answer · 2012-02-24 13:56:44Z

2

if you are lucky enough to run PHP 5.3+, mysqli_get_result seems what you want.

$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_array();

edited Feb 24, 2012 at 13:56

answered Feb 24, 2012 at 13:29

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Collectives™ on Stack Overflow

php bind_result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related