/** * {@inheritDoc} */ public function rowCount() { return $this->statement->num_rows(); }
<?php require_once "../resources/templates/menu.php"; ?> <?php $id = $_GET['id']; $stmt = new mysqli_stmt($mysqli, "SELECT first_name, last_name, description, country, dob, file_ext FROM users WHERE id = ?"); $stmt1 = new mysqli_stmt($mysqli, "SELECT COUNT(user_id)FROM adventures WHERE user_id = ?"); if ($stmt1) { $stmt1->bind_param("i", $id); $stmt1->execute(); $stmt1->bind_result($adventure_no); $stmt1->store_result(); if ($stmt1->num_rows() == 1) { while ($stmt1->fetch()) { if ($stmt) { $stmt->bind_param("i", $id); if ($stmt->execute()) { $stmt->bind_result($first_name, $last_name, $description, $country, $dob, $ext); $stmt->store_result(); if ($stmt->num_rows() == 1) { while ($stmt->fetch()) { ?> <body> <div class="container"> <div class="row"> <div id="Author" class="container"> <!-- Example row of columns -->
public function numRecords() { return $this->statement->num_rows(); }
} } } ?> <?php $commentArray[] = array(); $sql = "SELECT * FROM comments WHERE adv_id = {$adv_id}"; $res = $mysqli->query($sql) or trigger_error($mysqli->error . "[{$sql}]"); while ($row = $res->fetch_assoc()) { $stmt3 = new mysqli_stmt($mysqli, "SELECT first_name, last_name FROM users WHERE id = ?"); $stmt3->bind_param("i", $row['user_id']); $stmt3->execute(); $stmt3->bind_result($commentFirstName, $commentLastName); $stmt3->store_result(); if ($stmt3->num_rows() == 1) { while ($stmt3->fetch()) { ?> <div class="row"> <div class="col-md-6 col-md-offset-1 comments-section"> <section> <div class=""> <label class=""><?php echo $commentFirstName; echo " ";