How to create a database for loop in php

Question

I have been given a .php file and I would like to code a for loop that loops through database entries and populates a div for each entry. I am a total php noob, and every for loop I've found online doesn't seem to work with the code I have. Any help to get me started would be greatly appreciated.

My php code to connect to the database is as follows:

<?php
    require 'mysqliconnection.php';
    require 'top_bottom_functions.php';

    $id = $_GET['id'];
    $stmt_get_details = mysqli_prepare($connect, "SELECT name, nickname, birth_day, birth_place, age, division, fighter_record, stance, height, reach, directory, biography, flag, record FROM fighters_details WHERE id=?");
    if ($stmt_get_details) {
        mysqli_stmt_bind_param($stmt_get_details, "s", $id);
        mysqli_stmt_execute($stmt_get_details);
        mysqli_stmt_bind_result($stmt_get_details, $name, $nickname, $birth_day, $birth_place, $age, $division, $fighter_record, $distance, $height, $reach, $directory, $biography, $flag, $record);
}

    mysqli_stmt_fetch($stmt_get_details);

    $height = html_entity_decode($height);

    $reach = html_entity_decode($reach);

    mysqli_stmt_close($stmt_get_details);
?>

Thank you!

GeorgeQ · Accepted Answer · 2015-03-02 06:09:57Z

2

Consider this object oriented (OOP) approach:

$mysqli = mysqli_connect('localhost', 'username', 'password', 'db_name');

$stmt = $mysqli->prepare("SELECT name, nickname, birth_day, birth_place, age, division, fighter_record, stance, height, reach, directory, biography, flag, record FROM fighters_details WHERE id=?");
if ($stmt) {
    $stmt->bind_param("s", $_GET['id']);
    $stmt->execute();
    $stmt->bind_result($name, $nickname, $birth_day, $birth_place, $age, $division, $fighter_record, $stance, $height, $reach, $directory, $biography, $flag, $record);

    while ($stmt->fetch()) {
        echo '<div>Name'.$name.', Nickname'.$nickname.', etc...</div>';
    }

    $stmt->close();
}

$mysqli->close();

answered Mar 2, 2015 at 6:09

GeorgeQ

1,38210 silver badges8 bronze badges

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

Comments

Abhishek Patel · Accepted Answer · 2015-03-02 06:06:46Z

0

Hope this helps.

while(mysqli_stmt_fetch($stmt_get_details))
{
  echo "<div> name:"$name."</div>";
  .
  .
  //so on for other columns
}

answered Mar 2, 2015 at 6:06

Abhishek Patel

8147 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to create a database for loop in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related