如何获取输入/选择信息,然后从那里打印数据库信息。这可能吗?

所以没有代码我只是想知道在我开始之前是否可以这样做。所以我打算制作一个 php 页面。所以没有提交表单到另一个 php 页面。

在该页面上,它将显示用户类型或选择登录信息(ID、通行证、姓名等)。在登录信息下方,我从上面的部分获取信息,以确定他们可以访问哪个数据库,并在 html/php 表中打印他们可以访问的数据库列表。

那么这是否可以在一页中完成。或者我是否需要制作表格(以获取他们的信息)。然后从那里打印用户有权访问的数据库列表。如果可能的话,我对刚刚完成 HS 的编程还很陌生。你们能指导/指出我正确的方向吗?很多帮助将不胜感激


守候你守候我
浏览 142回答 1
1回答

幕布斯6054654

你需要连接到页面顶部的数据库(或者更好的是在另一个文件中并需要它)这样你就可以像db.ph那样做某事:<?php$host = '';$dbuser = '';$paswrd = '';$dbname = '';$dns = 'mysql:host=' . $host .'; dbname=' . $dbname;try&nbsp;{&nbsp; &nbsp; $pdo = new PDO($dns, $dbuser, $paswrd);&nbsp; &nbsp; $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);&nbsp; &nbsp; $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);&nbsp; //&nbsp; echo "polaczono z mysql";}catch(PDOException $e){&nbsp; &nbsp;// echo "nie udało się połączenie: " . $e->getMessage();}?>接下来在登录页面你做:require('db.php');if(isset( $_POST['login'])){&nbsp; &nbsp; require('./config/db.php');&nbsp; &nbsp; /*&nbsp; &nbsp; $userName = $_POST['userName'];&nbsp; &nbsp; $userEmail = $_POST['password'];&nbsp; &nbsp; */&nbsp; &nbsp; $userName = filter_var( $_POST['userName'], FILTER_SANITIZE_STRING);&nbsp;&nbsp; &nbsp; $userPassword = filter_var( $_POST['userPassword'], FILTER_SANITIZE_STRING);&nbsp;&nbsp;&nbsp; &nbsp; $stmt = $pdo -> prepare('SELECT * FROM Users WHERE name =?');&nbsp; &nbsp; $stmt -> execute([$userName]);&nbsp; &nbsp; $user = $stmt ->fetch();}你可以检查它是否正确,例如 if($user->password==$userPassword)在 html 中:<form action="login.php" method="POST">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="form-group">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <label for="userName">Name</label>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input required type="text" name="userName" ">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="form-group">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <label for="userPassword">Password</label>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input required type="password" name="userPassword"/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <button name="login" type="submit" >Login</button>
打开App,查看更多内容
随时随地看视频慕课网APP