允许用户使用Laravel和mysql在bio中发布url链接(Allow users to post url link in bio with Laravel and mysql)

 问题是如何安全地允许用户在他们的bio中提交url链接或几个url链接，然后将其输出到视图，类似于Instagram允许他们的bios。 我正在考虑做一些正则表达式，搜索生物文本和输出来查看，但不知道如何安全地做到这一点而不影响我的网站的安全性： 
 
 我将bio表中的bio保存为varchar，长度为255 
 
 我正在验证然后保存到我的数据库，如下所示： 
 
$this->validate($request, [
        'name' => 'regex:/^[\pL\s]+$/u|max:20', //change to allow numbers also July 14/16
        'bio' => 'max:1000',
    ]);
 
 然后保存到db 
 
if ($request->has('bio')) {
        $user->bio= $request->input('bio');
        $user->save();
    }

Question is How do I safely allow users to submit a url link or several url links in their bio,then output it to the view, similar to how Instagram allows in their bios. I'm thinking of maybe doing some sort of regular expression , search the bio text and output to view, but don't know how to safely do it without compromising my site's security:
 
I'm saving the bio in my users table as varchar with a length of 255
 
I'm validating then saving to my database like so :
 
$this->validate($request, [
        'name' => 'regex:/^[\pL\s]+$/u|max:20', //change to allow numbers also July 14/16
        'bio' => 'max:1000',
    ]);
 
then saving to db
 
if ($request->has('bio')) {
        $user->bio= $request->input('bio');
        $user->save();
    }

原文：https://stackoverflow.com/questions/39155873