retrieve data from mysql database
Hi, I'm trying to retrieve data from Mysql:
- <script>
- $(function(){
- $(".btn-reparto").click(function(){
- var reparto = $(this).text();
- $.ajax({
- url: "dbscript/getArticoloComanda.php",
- data: "",
- dataType: 'json',
- success: function(data) {
-
- for (var i in data) {
- var articolo = data[i];
- $('#articoli').append('<input id="' + articolo[0] + '" type="button" class="btn item-button btn-primary" value="' + articolo[1] + '"/>');
- } // fine ciclo
-
- var idArt;
- $('.item-button').click(function() {
- idArt = $(this).attr("id");
- setArticoloComanda(idArt);
- });
-
- } // fine funzione (data)
- });
-
- });
- });
- </script>
My php file:
- <?php
- //$reparto = $_POST['reparto'];
-
- include "./connection/conn_admin.php";
- $sql="select * from articoli order by ordine";
-
- $res = $mysqli->query($sql);
-
- while ( $row = mysql_fetch_row($res) )
- {
- $data[] = $row;
- }
- echo json_encode( $data );
I can't retrieve data :(