<?php 

 

$sql = "SELECT * FROM data ORDER BY id";

 

require_once ('connect.php');

$r = mysqli_query($conn,$sql);

 

$result = array();

 

while($row = mysqli_fetch_array($r)){

    array_push($result,array(

	    'id'=>$row['id'],

	    'vardas'=>$row['vardas'],

		'pavarde'=>$row['pavarde'],

        'amzius'=>$row['amzius'],

		'lytis'=>$row['lytis']

 

    ));

}

 

echo json_encode(array('result'=>$result));

 

mysqli_close($conn);

?>

<?php

$servername = "localhost";

$username = "phpfusion";

$password = "phpfusion";

$db = "phpfusion";

 

// Create connection

$conn = new mysqli($servername, $username, $password, $db);

 

// Check connection

if ($conn->connect_error) {

    die("Neprisijungta prie duomenų bazės: " . $conn->connect_error);

} 

 

 

?>

 header('Content-Type: application/json;charset=utf-8');  

 

mysql_set_charset("UTF8", $conn);

mysql_query("SET NAMES UTF8")

mysqli_query($conn,"SET CHARACTER SET 'utf8'");

mysqli_query($conn,"SET SESSION collation_connection ='utf8_unicode_ci'");