\n"; // Let's define an "object" ot type "array" to be returned to the calling program $data = array(); // Initialize some useful elements $data['status'] = 0; $data['errmsg'] = ''; $data['nrows'] = 0; // Wite the query $data['qry'] = $qry; // Open the connection to the DB server $link = new mysqli( $host, $utente, $password, $nomedb ); // Verify that it is OK, otherwise stop here if ( $link->connect_errno ) { $data['status'] = -1; $data['errmsg'] = 'Error: Error: could not connect to the MySQL server: ('. $link->connect_errno .') '. $link->connect_error; echo json_encode( $data ); return; } // Execute the query $result = $link->query( $qry ); // Verify that the query gave a result, otherwise close the connection to the DB and exit if ( ! $result ) { $data['status'] = -2; $data['errmsg'] = 'Error: invalid query: '. $link->error; // If OK the write, for each star, the information into the array of data identified by "objs" } else { $data['nrows'] = mysqli_num_rows($result); while ( $row = $result->fetch_assoc() ) $data['objs'][] = $row; } // Close the connection to the server if ($result) $result->free(); mysqli_close($link); // Encode the object data in JSON format and print it (it will be read by the calling program!) echo json_encode( $data ); ?>