<?php
	$mysqli=new mysqli("localhost", "root", "123456", "xsphpdb");

	$stmt=$mysqli->prepare("select id, name, price, num, desn from shops where id>?");

	$stmt->bind_param("i", $id);

	$stmt->bind_result($id, $name, $price, $num, $desn);

	$id=99;

	$stmt->execute();
	
	$stmt->store_result(); //1Â÷·Î °ªÀ»¸ðµÎ °¡Á®¿È ¾ÆÁÖ Áß¿äÇÔ

	//±â·ÏµÈÁ¤º¸	
	//$stmt->data_seek(2); 
	while($stmt->fetch()){
		echo "$id--$name---$price---$num---$desn <br>";
	}

	echo "ÃÑ±â·Ï£º".$stmt->num_rows;

	$stmt->free_result();

	$stmt->close();

?>