<?php
	header("Access-Control-Allow-Origin: *");
	
    // create connection to database
        $host = "webdev.iyaserver.com"; // database server address
        $userid = "dent_student"; // database user account name
        $userpw = "code4Studentuse"; // database user password
        $db = "dent_EVdata"; // database name
    
    // create db connection
    $mysql = new mysqli(
        $host,
        $userid,
        $userpw,
        $db);
            
    // database query
    $sql =      "SELECT * 
                FROM dent_EVdata.MakeModelVehicleTotals
                WHERE make in ('Audio', 'Hyundai', 'Rivian', 'Tesla');";
    
    // submit query to db, receive as $results
    $results = $mysql->query($sql);
    
    // loop through results one row at a time
    while( $currentrow = $results->fetch_assoc() ) { 
        $json_array[] = $currentrow; 
        // add each row through the loop to the json_array variable
    }
    
// print_r($json_array);

	echo json_encode($json_array, JSON_UNESCAPED_UNICODE);