How load data from mySql in an HTML button?

Question

I want to load data from my MySql database and put one field of this database into the text of a button :

<?php
  $servername = "localhost";
  $username   = "prova";
  $password   = "";
  $dbname     = "prova";

  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  }

  $sql    = "SELECT nomeCantiere,codiceCommessa,indirizzoCantiere FROM Cantiere";
  $result = $conn->query($sql);

  if ($result->num_rows > 0) {
      // output data of each row
      while ($row = $result->fetch_assoc()) {
          echo "nomeCantiere: " . $row["nomeCantiere"] . " - codieCommessa: " . $row["codieCommessa"] . " - indirizzoCantiere" . $row["indirizzoCantiere"] . "<br>";
      }
  } else {
      echo "0 results";
  }
  $conn->close();
?>
<input type="button" value="button" />

I'm a beginner with this type of programming.

For now I have managed to do is generate a simple "echo".

How can I automatically generate buttons with a value="nomeCantiere"?

Praveen Kumar Purushothaman · Accepted Answer · 2018-09-28 09:35:30Z

2

You are almost done with the code. You just need to add the value here:

if ($result->num_rows > 0) {
  // output data of each row
  while ($row = $result->fetch_assoc()) {
    //// Look at this line ////
    echo '<input type="button" value="' . $row["nomeCantiere"] . '" />';
  }
} else {
  echo "0 results";
}
$conn->close();

The above will generate a few rows of buttons. If that's what you would need. :)

answered Sep 28, 2018 at 9:35

Praveen Kumar Purushothaman

167k27 gold badges215 silver badges261 bronze badges

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

2 Comments

Praveen Kumar Purushothaman Over a year ago

Ha ha... Is that helpful? @NarcosZTK_10

Praveen Kumar Purushothaman Over a year ago

@NarcosZTK_10 Glad that you got it solved. Have a nice day. Will wait for 5 mins... :)

RiggsFolly · Accepted Answer · 2018-09-28 09:54:51Z

0

You can echo html tags in php ie.

echo "<button>". $row["nomeCantiere"] ."</button>"

or

echo "<input type='button' value='". $row["nomeCantiere"] ."'/>"

edited Sep 28, 2018 at 9:54

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Sep 28, 2018 at 9:36

Sarath Mohan

1671 silver badge6 bronze badges

4 Comments

RiggsFolly Over a year ago

<input type="button"> not a <button>!

vieroli Over a year ago

@RiggsFolly isn't it the same ? Or this is because NarcosZTK_10's code was an <input type="button"> ?

RiggsFolly Over a year ago

Because the OP's code uses an <input type="button">

Sarath Mohan Over a year ago

@RiggsFolly is it because of the submit issue? we can specify type=button in <button> right

Collectives™ on Stack Overflow

How load data from mySql in an HTML button?

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related