链接保存与mysql数据库中的其他数据分开

Question

我想将网站中的数据保存到mysql数据库中。我能够挽救大部分我想要拯救的东西，但我有一个特殊的问题。我提取的链接是保存，但我想链接在相同的行其他attributes.Below是我的CURL和MySQL查询提取和保存到数据库中的信息。

$target_url = "http://www.ucc.ie/modules/descriptions/BM.html"; 
$codeS = "BM"; 
$html = file_get_contents("http://www.ucc.ie/modules/descriptions/BM.html"); 
@$doc = new DomDocument(); 
@$doc->loadHtml($html); 
//discard white space 
@$doc->preserveWhiteSpace = false; 
$xpath = new DomXPath($doc); 

//Read through dd tags 
$options = $doc->getElementsByTagName('dd'); 

//Go into dd tags and look for all the links with class modnav 
$links = $xpath->query('//dd //a[@class = "modnav"]'); 

//Loop through and display the results for links 
foreach($links as $link){  
echo $link->getAttribute('href'), '<br><br>'; 
} 

foreach ($options as $option) { 

    $option->nodeValue; 
    echo "Node Value (Module name/title)= $option->nodeValue <br /><br /> <br />"; 

     // save both for each results into database 
$query3 = sprintf("INSERT INTO all_modulenames(code,module_name,description_link,gathered_from) 
    VALUES ('%s','%s','%s','%s')", 
    mysql_real_escape_string ($codeS), 
    mysql_real_escape_string($option->nodeValue), 
    mysql_real_escape_string($link->getAttribute('href')), 
    mysql_real_escape_string($target_url)); 
    mysql_query($query3) or die(mysql_error()."<br />".$query3); 

    } 
    echo "<br /> <br /> <br />"; 


Here is the table 
-- ---------------------------- 
-- Table structure for `all_modulenames` 
-- ---------------------------- 
DROP TABLE IF EXISTS `all_modulenames`; 
CREATE TABLE `all_modulenames_copy` (
`code` varchar(255) NOT NULL, 
`module_name` varchar(255) NOT NULL, 
`description_link` varchar(255) NOT NULL, 
`gathered_from` varchar(255) NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

-- ---------------------------- 
-- Records of all_modulenames 
-- ---------------------------- 

所以，问题是“$链路>的getAttribute（‘href’属性）”分别从其他内容保存在尝试save.The链接保存，然后再接着是数据的保留其余有些行是空的，但我试图一次保存所有内容，即填充每行，然后移动到第二行，直到每个语句完成。我怎么能这样做？任何帮助，将不胜感激 ！！

Answer 1

未经测试的（所以需要调试），但我想办法是这样的：

...etc 
@$doc->preserveWhiteSpace = false; 

//Read through dd tags 
$options = $doc->getElementsByTagName('dd'); 

foreach ($options as $option) { 

    // Get the links and find the one with the right class 
    $href = ''; 
    $links = $option->getElementsByTagName('a'); 
    foreach ($link as $link) { 
     if ($link->hasAttribute('class') && $link->hasAttribute('href')) { 
      $aClasses = explode(' ', $link->getAttribute('class')); 
      if (in_array('modnav', $aClasses)) { 
        $href=$link->getAttribute('href'); 
      } 
     } 
    } 

    Insert in to SQL etc, $href is the link text belonging to the dd ...