在 php 中使用 csv

发布于 2024-09-24 02:25:12 字数 222 浏览 5 评论 0原文

我有一个要求，我需要使用 csv 文件来处理我的登录表单逻辑。 csv 文件中的“A”列包含所有用户名，“T”列包含网站名称。现在，用户通过输入他们的用户名来登录，根据情况，我必须将他们重定向到 T 列中输入的网站。我将如何使用 php 来实现这一点？

A           T
ABC        www.test.com
DEF        www.test1.com

原文

I have a requirement where I need to work my login form logic using a csv file. 'A' column in csv file has all Usernames and 'T' column has website names. Now the user logs in by typing in their usernames, and depending on that I have to redirect them to the website entered in column T. How will I use php to accompalish this?

A           T
ABC        www.test.com
DEF        www.test1.com

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

提笔书几行 2024-10-01 02:25:12

您需要使用 fgetcsv() 来读取一行一个 csv 文件。看一下下面的代码，它应该涵盖您的情况：

$user = "test";
$file = fopen('file.csv', 'r');
$lines = explode("\n", $file);
while(($csv = fgetcsv($line, "\t")) !== FALSE) {
    // Assuming that string are separated by TAB instead comma
    if($csv[0] == $user) {
        header('Location: '.$csv[1]);
        exit();
    }
}

编辑：代码已修复。无法工作，因为 fgetcsv 需要读取文件句柄。

You need to use fgetcsv() in order to read a line from a csv file. Have a look at the code below, it should cover your case:

$user = "test";
$file = fopen('file.csv', 'r');
$lines = explode("\n", $file);
while(($csv = fgetcsv($line, "\t")) !== FALSE) {
    // Assuming that string are separated by TAB instead comma
    if($csv[0] == $user) {
        header('Location: '.$csv[1]);
        exit();
    }
}

Edit: Code fixed. Wasn't working as fgetcsv requires a file handle to read from.

回复收藏 0 原文

比忠 2024-10-01 02:25:12


$userSites = array();
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $userSites[$data[0]] = $data[1];
    }
    fclose($handle);
}

应该创建一个用户及其应该访问的站点的关联数组。


$userSites = array();
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $userSites[$data[0]] = $data[1];
    }
    fclose($handle);
}

Should create an associative array of users and the sites they should go to.

回复收藏 0 原文

~没有更多了~