<?php
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASSWORD',''); #for security reasons :-)
define('DB_DATABASE','redwood_new');

$con = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);


echo "Bad bitchez";

$skill = $_POST['skill'];
$sql = "select first_name, last_name, id_number, skill, phone, email from service_provider where skill = '$skill'";
/*$sql = "SELECT first_name, last_name, id_number, skill, phone, email FROM `service_provider`
        WHERE skill = '$skill'";*/

$result = mysqli_query($con, $sql);

// $result = array();

if(mysqli_num_rows($result)==0){

   $response["success"] = false;
   $response["message"] = "No data";
   echo json_encode($response);
}
else{
    $emparray = array();
    while($row =mysqli_fetch_assoc($result))
    {
        $emparray[] = $row;
    }
    echo json_encode($emparray);
}

mysqli_close($con);
/*while ($row = mysli_fetch_array($res)) {
    array_push($result, array('first_name'=>$row[0],
        'last_name'=>$row[1],
        'id_number'=>$row[2],
        'skill'=>$row[3],
        'phone'=>$row[4],
        'email'=>$row[5]));
}

echo json_encode(array("result"=>$result));*/