Creating multiple unique html elements inside a php for loop

Question

I'm trying to create a website in my scenario I need to retrieve many rows of data from my database. Each row displayed should have a button next to it with a unique name. The only problem is getting the button to have a unique name.

<?php
        require_once 'php/login.php';
        $conn = new mysqli($hn, $un, $pw, $db);
        if ($conn->connect_error) die($conn->connect_error);

        $query = "SELECT * FROM Bets_info WHERE BetGroup = '1'";
        $result = $conn->query($query);
        if(!result) die($conn->error);

        $rows = $result->num_rows;

        for ($j = 0; $j < $rows ; ++$j)
        {
          $result->data_seek($j);
          $row = $result->fetch_array(MYSQLI_ASSOC);

          echo '<button id="myBtn">Bet</button>  ';
          echo ' '  .$row['BetWin'] . '/';
          echo ' '  .$row['BetLose']  . ' : ';
          echo ' '  .$row['BetDescription'] . '<br><br>'; 

        }
        $result->close();
        $conn->close();
      ?>

I have tried to do the following

for ($j = 0; $j < $rows ; ++$j)
        {
          $result->data_seek($j);
          $row = $result->fetch_array(MYSQLI_ASSOC);

          echo '<button id="myBtn<? $j ?>">Bet</button>  ';
          echo ' '  .$row['BetWin'] . '/';
          echo ' '  .$row['BetLose']  . ' : ';
          echo ' '  .$row['BetDescription'] . '<br><br>'; 

        }

This does not make the buttons called btn1, btn2, btn3 but instead it just calls all the buttons "myBtn<? $j ?>".

what you posted is erroring out – Funk Forty Niner Oct 26 '17 at 21:40 — Funk Forty Niner, Oct 26 '17 at 21:40

score 3 · Accepted Answer · answered Oct 26 '17 at 21:38

3

for ($j = 0; $j < $rows ; ++$j)
    {
      $result->data_seek($j);
      $row = $result->fetch_array(MYSQLI_ASSOC);

      echo '<button id="myBtn'.$j.'">Bet</button>  ';
      echo ' '  .$row['BetWin'] . '/';
      echo ' '  .$row['BetLose']  . ' : ';
      echo ' '  .$row['BetDescription'] . '<br><br>'; 

    }

You can not put <? $j ?> inside echo

You want to put '.$j.' rather than it, And the code will work fine, :)

I hope its helps you :)

answered Oct 26 '17 at 21:38

Mohammed Alhanafi

886
1
9
22

Cheers i got it working :) !!! – Hack_Hut Oct 26 '17 at 21:41
Click in Accept this answer to make your question as solved question :), And i'm very happy to help you :) – Mohammed Alhanafi Oct 26 '17 at 21:43
Yeah it would'nt let me until 15mins had gone past – Hack_Hut Oct 26 '17 at 21:59
My pleasure to help you :) – Mohammed Alhanafi Oct 26 '17 at 22:04

score 2 · Answer 2 · edited Oct 26 '17 at 21:46

2

Concatenate the row number with the . operator, like this:

echo '<button id="myBtn' . $j . '">Bet</button>  ';

edited Oct 26 '17 at 21:46

Jay Blanchard

34,243
16
77
119

answered Oct 26 '17 at 21:42

Chris H.

41
2

score 0 · Answer 3 · answered Oct 26 '17 at 21:39

you should do like this :

for ($j = 0; $j < $rows ; ++$j)
    {
      $result->data_seek($j);
      $row = $result->fetch_array(MYSQLI_ASSOC);

      echo '<button id="myBtn'.$j.'">Bet</button>  ';
      echo ' '  .$row['BetWin'] . '/';
      echo ' '  .$row['BetLose']  . ' : ';
      echo ' '  .$row['BetDescription'] . '<br><br>'; 

    }

Creating multiple unique html elements inside a php for loop

3 Answers3