Answers for "how to query value in php ini"

query-data-from mysql and php

<?php 
                            $sql = "SELECT * FROM `users`";
                            $result = mysqli_query($conn, $sql);
                            // fetch all users
                            $users = mysqli_fetch_all($result, MYSQLI_ASSOC);
                            ?>
                            <!-- A single user -->
                            <?php foreach ($users as $user): ?>
                                <tr>
                                    <td><?php echo $user['id'] ?></td>
                                    <td><?php echo $user['Name'] ?></td>
                                    <td><?php echo $user['Email'] ?></td>
                                    <td> <span id="user_current_status"></span></td>
                                </tr>
                            <?php endforeach; ?>
                            <!-- A single user -->

query php

<?php 
// MySqli connection
$mysqli = new mysqli("localhost", "my_username", "my_password", "my_database");

// Errors
if($mysqli->connect_error) {
  echo "<b>Failed to connect to MySQL: </b>" . $mysqli->connect_error;
}

// Query
$selectQuery = $mysqli->prepare("SELECT * FROM my_table");
$selectQuery->execute();
$selectQueryResult = $selectQuery->get_result();

// Loop 
while($selectQueryRow = $selectQueryResult->fetch_array()) {
  echo $selectQueryRow['my_column'];
}

// Example
$selectUsername = $mysqli->prepare("SELECT * FROM users");
$selectUsername->execute();
$selectUsernameResult = $selectUsername->get_result();
while($selectUsernameRow = $selectUsernameResult->fetch_array()) {
  echo $selectUsernameRow['username'];
}