首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >根据登录nodejs ajax jquery的用户过滤数据

问根据登录nodejs ajax jquery的用户过滤数据
EN

Stack Overflow用户
提问于 2018-12-17 21:34:05
回答 1查看 562关注 0票数 0

我的问题是关于根据jquery数据表上的用户登录来过滤数据。我已经设法使用jquery ajax从jquery datatable上的数据库中检索数据。现在,当我使用用户登录时,用户看到的是所有的表格,而不是他/她自己的表格。(换句话说,我只想转到包含股票数据的用户个人资料页面)我登录时没有得到任何错误,我可以在服务器控制台上看到用户信息,但在HTML端,我猜有些东西是不完整的。我的数据库包含2个表( users,stock),我可以从stok表的'id‘列访问users表(Id)。

login.js

代码语言:javascript
复制
router.post('/', function(request, response) {
    var username = request.body.user_name;
    var password = request.body.pass;
    console.log(username);
    console.log(password);

        connection.query('SELECT * FROM users WHERE user_name=?', [username, password], function(error, results) {
                        console.log(results);
                        if(error){throw error;}
                if(results.length>0){
                                if(results[0].pass == password){
                                response.sendFile(path.join(__dirname +'/secondPage.html')); } else{
                                response.sendFile(path.join(__dirname + '/error.html'));
                             }
                            }else{
                                response.sendFile(path.join(__dirname + '/error.html'));                            
                             } });});

secondPage.js

代码语言:javascript
复制
 /*mysql connection and requirements*/
router.use(bodyParser.urlencoded({extended : true}));
router.use(bodyParser.json());

//list of the stocks
router.get('/',(req,res)=>{ 

    connection.query('SELECT * FROM stok s, users u WHERE s.id= u.id',(err,rows,fields)=>{
    /*I know I should add "AND u.id=?" to this query but my pages cannot handle id between pages" */

        if(!err){
            console.log(rows);

        var objs = [];

    for (var i = 0;i < rows.length; i++) {
            objs.push(rows[i]); 
    }
    var ret={"data":objs};
        res.end(JSON.stringify(ret));
        console.log(JSON.stringify(ret));
        }
        else{
            console.log(err);

        }
    });
});

HTML-第二页

代码语言:javascript
复制
    <html>
    <head>
    <link rel="stylesheet" type="text/css" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/dataTables.jqueryui.min.css">
    <script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
        <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
        <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.19/js/dataTables.jqueryui.min.js"></script>
    <!--    <script type="text/javascript" charset="utf-8" src="js/dataTables.editor.min.js"></script>-->

        </head>
        <body>
    <script>
        $(document).ready(function (){

           $('#stockManager').DataTable({
              responsive: true,

             ajax : {
                url : "http://localhost:3000/secondPage",

             },
              columns: [
                  {data : "urun_adi"}, 
                  {data : "barkod"}, 
                  {data : "stok_sayi"}, 
                  {data : "satis_fiyati"}, 
                  {data : "maliyet"},
                  {data : "firma_adi"}
              ],
             select: true
           });
        });
    </script>
    <table id="stockManager" class="display" style="width:100%">
        <thead>
            <tr>

                <th>Adı</th>
                <th>Kod</th>
                <th>Miktar</th>
                <th>Satış Fiyatı</th>
                <th>Maliyet</th>
                <th>Tedarikçi</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
    </script>
    </body>
    </html>

LOGIN HTML 

   <body>

    <div class="limiter">
        <div class="container-login100" style="background-image: url('images/bg-01.jpg');">
            <div class="wrap-login100 p-l-55 p-r-55 p-t-65 p-b-54">
                <form action="http://localhost:3000/login" method="POST" class="login100-form validate-form">
                    <span class="login100-form-title p-b-49">
                        Login
                    </span>

                    <div class="wrap-input100 validate-input m-b-23" data-validate = "Username is reauired">
                        <span class="label-input100">Username</span>
                        <input id="username" class="input100" type="username" name="user_name" placeholder="Username" required>
                        <span class="focus-input100" data-symbol="&#xf206;"></span>
                    </div>

                    <div class="wrap-input100 validate-input" data-validate="Password is required">
                        <span class="label-input100">Password</span>
                        <input id="password" class="input100" type="password" name="pass" placeholder="Password" required>
                        <span class="focus-input100" data-symbol="&#xf190;"></span>
                    </div>

                    <div class="text-right p-t-8 p-b-31">
                        <a href="#">
                            Forgot password?
                        </a>
                    </div>
                    <div class="text-right p-t-8 p-b-31">
                        <a href="#">
                            Change password(recommended for first loggers)
                        </a>
                    </div>

                    <div class="container-login100-form-btn">
                        <div class="wrap-login100-form-btn">
                            <div class="login100-form-bgbtn"></div>
                            <button id="records" type="submit" class="login100-form-btn">
                                Login
                            </button>
                        </div>
                    </div>

                </form>
            </div>  
        </div>
    </div>
</body>
</html>

app.js

代码语言:javascript
复制
const express = require('express');
const app = express();

const loginRoutes = require('./login');
const stockRoutes = require('./secondPage');

// Routes which should handle requests
app.use('/login', loginRoutes);
app.use('/secondPage', stockRoutes);

//bodyparser for posts

module.exports = app;
EN

回答 1

Stack Overflow用户

发布于 2018-12-17 21:42:36

后台需要传递用户名

代码语言:javascript
复制
 ajax : {
            url : "http://localhost:3000/secondPage/johndoe",

         },

获取querystring参数,并修复SQL:

代码语言:javascript
复制
router.get('/:username',(req,res)=>{ 
    connection.query('SELECT * FROM stok s, users u WHERE s.id= u.id and username=?',[req.params.username],(err,rows,fields)=>{
        if(!err){
        var objs = [];
    for (var i = 0;i < rows.length; i++) {
            objs.push(rows[i]); 
    }
    var ret={"data":objs};
        res.end(JSON.stringify(ret));
        console.log(JSON.stringify(ret));
        }else{
            console.log(err);}  });});
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/53816341

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档