mustafa05deniz / nodejs-ajax-search-bar Goto Github PK

#tutorial is here : http://kodizim.com nodejs ajax search bar with javascript ,juquery and mysql database you can firstly look this project cause this project contain other project

module.exports = {
    'connection': {
        'host': '127.0.0.1', 
        'user': 'root', // username
        'password': 'pass', // password 
        'database': 'dbname'// database name
    },
	'database': 'dbname',
};

Do you want to insert row your database click this link and run querys

example

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `surname` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

insert into users(name,surname,username) values("Jamie","Lannister","JamieLannister");
insert into users(name,surname,username) values("Cercei","Lannister","CerceiLannister");
insert into users(name,surname,username) values("Bronn","Bronn","Bronn");
insert into users(name,surname,username) values("John","Snow","JohnSnow");
insert into users(name,surname,username) values("Daenerys","Targaryen","DaenerysTargaryen");
insert into users(name,surname,username) values("Ramsay","Bolton","JamieLannister")

for security

  var corsOptions = {
        origin: 'http://localhost:3000',
        optionsSuccessStatus: 200 
    }

var $modal = $('div.load');
    $('#search').click(function () {
        console.log("search click");
        $modal.fadeIn();
    });
    $(document).mouseup(function (e) {
        if (!$(e.target).is('#search *, #search')) {
            console.log("normal click");
            $("#user").removeClass("deneme");
            $modal.fadeOut(100);
        }
    });