<?php
$rss = new DOMDocument();
$rss->load('https://rss.art19.com/the-take');
$feed = array();
foreach ($rss->getElementsByTagName('item') as $node) 
{
    foreach($node->childNodes as $childNode) 
    {
        if($childNode->tagName == 'media:content') 
        {
            var_dump($childNode->getAttribute('url'));
        }
    }
}

?>



<?php
// https://stackoverflow.com/questions/61712228/i-am-trying-to-retrieve-the-image-url-from-mediacontent-tag-rss-feed-and-storin

       $rss = new DOMDocument();
        $rss->load('https://rss.art19.com/the-take/');
        $feed = array();
        foreach ($rss->getElementsByTagName('item') as $node) 
        {
            $item = array ( 
                'title' => $node->getElementsByTagName('title')->item(0)->nodeValue,
                'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue,
                'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
                'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue,
                //'dcUri' => $rss->lookupNamespaceUri('dc'),
                //'authors' => $node->getElementsByTagNameNS($item[dcUri], 'creator'),
                //'cre' => $item[authors]->item(0)->nodeValue,
                );
            array_push($feed, $item);
        } 


You have created a MariaDB/MySQL database named “dobrogea_rssitems”.
3H*=JLp(szWh
Aţi creat cu succes un utilizator MySQL numit „dobrogea_urssitems”.
Pasul 3: Adăugare utilizator la baza de date.
Utilizator: dobrogea_urssitems
Bază de date: dobrogea_rssitems
Utilizatorul „dobrogea_urssitems” a fost adăugat în baza de date „dobrogea_rssitems”.


CREATE TABLE `rss_items` (
  `rssid` int(6) NOT NULL,
  `rsstitle` text NOT NULL,
  `rssdescription` text NOT NULL,
  `rsslink` text NOT NULL,
  `rsspublidate` text NOT NULL,
  `rsscreator` text NOT NULL,
  `rssfoto` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_romanian_ci;




// code for store array content in mysql database and i am successfully saved (title,des,date)

    $mysqli = new mysqli("localhost","root","","hmsdb");

    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    $stmt = $mysqli->prepare("INSERT INTO `rss_items` (`title`, `description`, `link`, `pubDate`) VALUES (?, ?, ?, ?)");

    $stmt->bind_param('ssss', $title, $description, $link, $pubDate);

    foreach( $feed as $RssItem){
        $title = $RssItem["title"];
        $description = $RssItem["desc"];
        $link = $RssItem["link"];
        $pubDate = $RssItem["date"];
        //$creator= $RssItem["cre"];

        $stmt->execute();
    }
    
    
?>