两个目录指向一个子目录,其中mySQL数据库存储URL

I have two directories pointing to one sub-directory. One is a student directory and the other is the teacher, the teacher has the ability to add projects to the database where the student does not. Currently the database stores the URLs for the project pages sitting in teacher, and when the student clicks the button that directs them to the teacher folder (does the same for the teacher if I link the student folder projects). My issue is if I were to take it out of either folder I would not be sure on how to direct back to the student/teacher directory depending on which one the viewer was in.

Database connection:

<?php
$db_host = 'localhost'; // Server Name
$db_user = 'root'; // Username
$db_pass = ''; // Password
$db_name = 'database'; // Database Name
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if (!$conn) {
    die ('Failed to connect to MySQL: ' . mysqli_connect_error());  
}

$sql = 'SELECT * FROM tbl_example';
$query = mysqli_query($conn, $sql);

if (!$query) {
    die ('SQL Error: ' . mysqli_error($conn));

}
?>

Go to project:

<a href="<?php echo $row['link'] ?>"><button class="button" >Go To Project</button></a>

Return to directory from project:

<a href="../index.php">Home</a>
<a href="../projects.php">Projects</a>
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐