English 中文(简体)
URL 进入数据库
原标题:URL Parsing into Database

我有用户能够输入URL的一种形式。 如今,他们显然将放入www.example.com/path或例如.com/path或。 http://example.com/path"rel=“nofollow”http://example.com/path

我想做的是抽取整个URL的东道方和通道,并将它列入我的数据库。 因此,不管其格式如何,它们在数据库中都有同样的格式。

因此,投入到以下产出:

www.example.com/path -> http://www.example.com/path
example.com/path -> http://www.example.com/path
http://www.example.com/path -> http://www.example.com/path
http://example.com/path ->http://www.example.com/path
最佳回答
问题回答

下面的例子:

function updateUrl($url) {  
    if (strpos($url,  :// )=== false && strpos($url,  www. )=== false) {
        $url =  http://www.  . $url;
    }
    else if(strpos($url,  :// )=== false) {
        $url =  http://  . $url;
    }
    else if(strpos($url,  www. )=== false) {
        $url = str_replace( http:// , http://www. ,$url);
    }
    else {
        $url = $url;
    }
    return $url;
}
$url = "http://example.com/path";
echo updateUrl($url);




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签