RedCandy 0 Posted April 8, 2019 Report Share Posted April 8, 2019 Bom dia, eu quero que no seguinte código o SQL retorna da base de dados os valores "id_Admin", "username_Admin", "password_Admin", mas não retorna nada apesar de não dar quaisquer erros. <?php $servername = "localhost"; $username = "root"; $password = ""; $db = "aeac"; // Create connection $conn = mysqli_connect($servername, $username, $password, $db); // Check connection if(mysqli_connect_errno()){ die("connection failed: " . mysqli_connect_error() . " (" . mysqli_connect_errno() . ")"); } //get results from database $result = mysqli_query($conn, "SELECT * FROM admin"); echo "<table id='tableId' align='center' style='width:60%; height:5%'> <tr> <th>ID</th> <th>Nome</th> <th>Password</th> </tr>"; while ($property = mysqli_fetch_array($result)); { echo "<tr>"; echo "<td onclick='redirect()'>" . $property['id_Admin'] . "</td>"; echo "<td onclick='redirect()'>" . $property['username_Admin'] . "</td>"; echo "<td onclick='redirect()'>" . $property['password_Admin'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> Já fiz várias pesquisas e troquei várias vezes o código para ver se algo funcionava mas nada. Tenho a certeza que todos os campos estão iguais aos da base de dados. Desde já obrigado, RedCandy. Link to post Share on other sites
HappyHippyHippo 1,162 Posted April 9, 2019 Report Share Posted April 9, 2019 mysql_fetch_assoc? IRC : sim, é algo que ainda existe >> #p@p Portugol Plus Link to post Share on other sites
RedCandy 0 Posted April 10, 2019 Author Report Share Posted April 10, 2019 15 horas atrás, HappyHippyHippo disse: mysql_fetch_assoc? não resultou. Link to post Share on other sites
HappyHippyHippo 1,162 Posted April 10, 2019 Report Share Posted April 10, 2019 Não resultou é uma resposta sem qualquer conteúdo informativo IRC : sim, é algo que ainda existe >> #p@p Portugol Plus Link to post Share on other sites
RedCandy 0 Posted April 11, 2019 Author Report Share Posted April 11, 2019 Já está resolvido, quando fecho o while nao devia ter um " ; " Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now