<?php

$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "isvykstu";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);

if(isset($_GET['query'])) { $query = $_GET['query']; } else { $query = ""; }
if(isset($_GET['type'])) { $type = $_GET['type']; } else { $query = "count"; }

if($type == "count")
{
    $sql = mysql_query("SELECT count(ID) FROM registered_cvs WHERE MATCH(name,surname)AGAINST('$query' IN BOOLEAN MODE)");
    $total = mysql_fetch_array($sql);
    $num = $total[0];

    echo $num;

}

if($type == "results")
{
    $sql = mysql_query("SELECT name,surname FROM registered_cvs WHERE MATCH(name,surname) AGAINST('$query' IN BOOLEAN MODE)");
    while($array = mysql_fetch_array($sql)) {



        echo "<div class=\"url-holder\"><a href=\"" . $array[name]. "\" class=\"url-surname\" target=\"_blank\">" . $array[surname] . "</a>

    <div class=\"url-desc\">DESCRIPTION</div></div>";

    }

}

mysql_close($conn);

?>