basically want assign value of field in database variable. can done in effective way? thinking like:
$sql2 = mysql_query("select * rom idrom = 101"); while ($row = mysql_fetch_array($sql2)) { $rom1 = $row['idrom']; $status = $row['status']; echo $rom1; echo $status; } but doesn't echo anything.
edit:
i have gotten bit longer on way, looking simpler way assign values variables. speak need 4 values, still doesn't way accomplish want. better suggestions?
heres got now:
$conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } $sql = "select * rom idrom = 101"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $room101 = $row["idrom"]; $status101 = $row["status"]; echo "this roomnumber ". $room101 . "!<br >"; echo "and status of roomnumber ". $room101 ." ". $status101 ."<br><br>"; } } else { echo "0 results"; } $sql2 = "select * rom idrom = 102"; $result2 = $conn->query($sql2); if ($result2->num_rows > 0) { // output data of each row while($row = $result2->fetch_assoc()) { $room102 = $row["idrom"]; $status102 = $row["status"]; echo "this roomnumber ". $room102 . "!<br >"; echo "and status of roomnumber ". $room102 ." ". $status102 ."<br><br>"; } } else { echo "0 results"; }
you can use bind_result that.
please try simple example, hope run :
$mysqli = mysqli_connect('host', 'user', 'pass','dbase')or die('could not connect: ' . mysqli_error()); if ($mysqli->connect_error) { die("connection failed: " . $mysqli->connect_error); } // because provide id in clause, can use new variable $output = array(); $id = 101; $sql = "select idrom,status rom idrom=?"; $stmt = $mysqli->prepare($sql); $stmt->bind_param('i',$id); $stmt->execute(); if ($stmt->errno == 0) { $stmt->store_result(); // $stmt->bind_result($idrom,$status); // way 1 $stmt->bind_result($output[$id],$output["status".$id]); // way 2 while ($stmt->fetch()) { echo $output[$id]." -> ".$output["status".$id]."<br />"; // so, output variable $output[101] way 2 // or defined here : // $output[$idrom] = $idrom; // $output["status".$idrom] = $status; // way 1 } } else { return "error: " . $sql . "<br>" . $stmt->error; } $stmt->close(); $mysqli->close(); 