Untitled

    nNEW RECORD.PHP


<!DOCTYPE html >
<html>
<head>
    <title>Search results</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">

        body{
            font-family: Arail, sans-serif;
        }
        /* Formatting search box */
        .search-box{
            width: 300px;
            position: relative;
            display: inline-block;
            font-size: 14px;
        }
        .search-box input[type="text"]{
            height: 32px;
            padding: 5px 10px;
            border: 1px solid #CCCCCC;
            font-size: 14px;
        }
        .result{
            position: absolute;
            z-index: 999;
            top: 100%;
            left: 0;
        }
        .search-box input[type="text"], .result{
            width: 100%;
            box-sizing: border-box;
        }
        /* Formatting result items */
        .result p{
            margin: 0;
            padding: 7px 10px;
            border: 1px solid #CCCCCC;
            border-top: none;
            cursor: pointer;
        }
        .result p:hover{
            background: #f2f2f2;
        }
    </style>
    <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
    <script type="text/javascript">

        $(document).ready(function(){
            $('.search-box input[type="text"]').on("keyup input", function(){
                /* Get input value on change */
                var inputVal = $(this).val();
                var resultDropdown = $(this).siblings(".result");
                if(inputVal.length){
                    $.get("asd.php", {term: inputVal}).done(function(data){
                        // Display the returned data in browser
                        resultDropdown.html(data);
                    });
                } else{
                    resultDropdown.empty();
                }
            });
            $(document).on("click", ".result p", function(){
                $(this).parents(".search-box").find('input[type="text"]').val($(this).text());
                $(this).parent(".result").empty();
            });
        });

    </script>
</head>
<body>
<div class="search-box">

    <input type="text" autocomplete="off" placeholder="Search ..." /><div id="button"><a href="delete.php"><button>Add employee</button></a></div>

    <div class="result"></div>

</div>
</body>
</html>
<!--INSERT INTO `employees`(`EmployeeID`, `FirstName`, `LastName`, `DepartmentName`, `Age`, `Phone`, `Email`, `Address`, `SocialSecurity`) VALUES-->
<!--(1"Caryn"," Graff","Sales"2343,"(923) 049-3023","cgraff@example.com","434 Fremont Ave Fremont, CA",323334334),-->
<!--(2,"Ward"," Nichols","Product Management",433,"(909) 293-1223","wardnichols@example.com","15 Baker Way San Francisco, CA",489342392),-->
<!--(3,"Daniel"," Hantz-Smith","Engineering",32452,"(415) 858-9898","dhantzsmith@example.com","192 Kingsbury Lane Palo Alto, CA 94323",739945790),-->
<!--(4,"Roxanne"," Durousseau","Engineering",234,"(489) 342-3033","rdurousseau@example.com","1900 Blue Tree Way Mountain View, Ca",212849908),-->
<!--(5,"Keith"," Birza","Sales",35634,"(919) 202-3938","keithbirza@example.com","12 Cesar Chavez San Francisco, CA",504382930),-->
<!--(6,"Dora"," Burket","Business Development",644,"(333) 333-3333","dora@example.com","16 Oak Street Ney York, NY",323233432),-->
<!--(7,"Erik"," Lasch","Product Management",75423,"(234) 134-2232","eriklasch@example.com","9 Fell StreetSan Francisco, CA",324345498),-->
<!--(8,"Sharolyn"," Singh","Design",7568,"(459) 439-3484","sharolyn@example.com","13 Amphitheatre Pkwy Mountain View, CA",986349585),-->
<!--(9,"Ina"," Langenfeld","Business Development",9785,"(234) 234-2342","ina@example.com","12 California Street San Francisco, CA",909487768),-->
<!--(10,"Eugene"," Sun","Engineering",6456,"(858) 373-2299","eugenesun@example.com","595 Westfell Street New York, NY",940281265),-->
<!--(11,"Neha"," Cooper","Design",0768,"(492) 349-3204","ncooper@example.com","16 Walnut Avenue Palo Alto, CA",982344958)-->
<!---->
<!--CREATE TABLE employees (-->
<!--EmployeeID int AUTO_INCREMENT NOT NULL PRIMARY KEY,-->
<!--FirstName varchar(20) NOT NULL,-->
<!--LastName varchar(30) NOT NULL,-->
<!--DepartmentName varchar(20),-->
<!--Age int,-->
<!--Phone varchar(20),-->
<!--Email varchar(30),-->
<!--Address varchar(60),-->
<!--SocialSecurity int NOT NULL)-->
<!---->
<!--Department names:-->
<!--"Sales",-->
<!--"Design",-->
<!--"Engineering",-->
<!--"Product Management",-->
<!--"Business Development",-->
<!---->
<!--CRATE TABLE departments (-->
<!--DepartmentID int AUTO_INCREMENT NOT NULL PRIMARY KEY,-->
<!--DepartmentName varchar(25))-->
da napravq opciq za izbirane na tursene po departament s dropdown menu (vsi4ki ili nqkoj specifi4en)
da opravq edita(su6to da ima opciq za vru6tane na na4alnata stranica)
da napravq deleta da ne te pra6ta na dryga stranica
da napravq fynkciq za tursene
da napravq tablica koqto da izkarva opredelen broj rezyltat[imax 30]{da moje da se podrejda po vsqka ot kolnite}(s bytoni za sledva6ta stranica koito ne te premestvat na dryga)