Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- app.post('/SearchDoner', function(request, response) {
- var store;
- console.log('here');
- console.log(request.body);
- console.log(request.body.bg);
- console.log(request.body.c);
- var bg = request.body.bg;
- var city = request.body.c;
- response.setHeader('Content-Type', 'application/json');
- console.log('select txtFullname,gender,email,address,bgp,mno from information where bgp =' +"'"+ bg + "'" + "and city =" + "'" + city +"';");
- connection.query('select txtFullname,gender,email,address,bgp,mno from information where bgp =' +"'"+ bg + "'" + "and city =" + "'" + city +"';", function(err, rows) {
- response.json(rows);
- console.log(rows);
- });
- });
- function fetchDoner()
- {
- var BloodGroup = $("#dpBloodGroup").children("option").filter(":selected").val();
- var City = $("#dpCity").children("option").filter(":selected").val();
- console.log(BloodGroup);
- console.log(City);
- $.ajax({
- url:"http://127.0.0.1:5000/SearchDoner",
- type: "post",
- dataType: 'json',
- data:({bg:BloodGroup,c:City}),
- crossDomain: "true",
- success: function (result) {
- $.each(result,function(index,obj){
- console.log(obj.txtFullname);
- $("#DonerInfo_5").append("<tr><td style='color:;background: #FDC68F;''><span>" + obj.txtFullname + "</span></td>" + "<td style='color:;background: #FDC68F;''><span>" + obj.address + "</span></td>" + "<td style='color:;background: #FDC68F;''><span>" + obj.gender + "</span></td>" +"<td style='color:;background: #FDC68F;''><span>" + obj.mno + "</span></td>" +"<td style='color:;background: #FDC68F;''><span>" + obj.email + "</span></td></tr>");
- });
- var newUrl = 'http://localhost/Blood%20Donation%20Site_1/donerinfo.html';
- document.location.href = newUrl;
- },error: function (obj, txtStatus, error) {
- }
- });
- }
- .....
- connection.query('select txtFullname,gender,email,address,bgp,mno from information where bgp =' +"'"+ bg + "'" + "and city =" + "'" + city +"';", function(err, rows) {
- if (err) {
- res.json({type: false, data: err});
- } else {
- res.json({type: true, data: JSON.stringify(rows)});
- }
- });
- });
- ....
- ......
- $.ajax({
- url:"http://127.0.0.1:5000/SearchDoner",
- type: "post",
- dataType: 'json',
- data:({bg:BloodGroup,c:City}),
- crossDomain: "true",
- success: function (result) {
- if (result.type == false) {
- alert("Error occured:" + result.data);
- return false;
- }
- $.each(JSON.parse(result.data),function(index,obj){
- console.log(obj.txtFullname);
- $("#DonerInfo_5").append("<tr><td style='color:;background: #FDC68F;''><span>" + obj.txtFullname + "</span></td>" + "<td style='color:;background: #FDC68F;''><span>" + obj.address + "</span></td>" + "<td style='color:;background: #FDC68F;''><span>" + obj.gender + "</span></td>" +"<td style='color:;background: #FDC68F;''><span>" + obj.mno + "</span></td>" +"<td style='color:;background: #FDC68F;''><span>" + obj.email + "</span></td></tr>");
- });
- ......
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement