Merhaba arkadaşlar aşağıda kodlarını verdiğim KOD 2 de yer alan
$file = "http://www.haberturk.com/haberturk.xml"; kısmına KOD 1 deki veri tabanınından çekilen
'.$row_sql['adresi'].' verisini, yine KOD 2 de bununan
<div class="stil2" id="sondakika1_baslik"> HABER TÜRK</div> kısmına ise yine KOD 1 deki veri tabanınından çekilen
'.$row_sql['adi.' verisinin çekilmesini istiyorum ama ne yaptıysam işin içinden çıkamadım yardımcı olursanız sevinirim...
KOD 1
<?php
include("vt.php");
$sql = mysql_query("SELECT * FROM sondakika WHERE yeri='ust1' ORDER BY RAND() limit 1", $baglanti) or die("Sorgu hatasi olustu !");
$row_sql = mysql_fetch_assoc($sql);
do {
echo ''.$row_sql['adi'].'
'.$row_sql['adresi'].'';
} while($row_sql = mysql_fetch_assoc($sql));
?>KOD 2
<?php
$file = "http://www.haberturk.com/haberturk.xml";
$rss_channel = array();
$currently_writing = "";
$main = "";
$item_counter = 1;
function startElement($parser, $name, $attrs) {
global $rss_channel, $currently_writing, $main;
switch($name) {
case "RSS":
case "RDF:RDF":
case "ITEMS":
$currently_writing = "";
break;
case "CHANNEL":
$main = "CHANNEL";
break;
case "ITEM":
$main = "ITEMS";
break;
default:
$currently_writing = $name;
break;
}
}
function endElement($parser, $name) {
global $rss_channel, $currently_writing, $item_counter;
$currently_writing = "";
if ($name == "ITEM") {
$item_counter++;
}
}
function characterData($parser, $data) {
global $rss_channel, $currently_writing, $main, $item_counter;
if ($currently_writing != "") {
switch($main) {
case "CHANNEL":
if (isset($rss_channel[$currently_writing])) {
$rss_channel[$currently_writing] .= $data;
} else {
$rss_channel[$currently_writing] = $data;
}
break;
case "ITEMS":
if (isset($rss_channel[$main][$item_counter][$currently_writing])) {
$rss_channel[$main][$item_counter][$currently_writing] .= $data;
} else {
$rss_channel[$main][$item_counter][$currently_writing] = $data;
}
break;
}
}
}
$xml_parser = xml_parser_create();
xml_set_element_handler($xml_parser, "startElement", "endElement");
xml_set_character_data_handler($xml_parser, "characterData");
if (!($fp = fopen($file, "r"))) {
die("could not open XML input");
}
while ($data = fread($fp, 4096)) {
if (!xml_parse($xml_parser, $data, feof($fp))) {
die(sprintf("XML error: %s at line %d",
xml_error_string(xml_get_error_code($xml_parser)),
xml_get_current_line_number($xml_parser)));
}
}
xml_parser_free($xml_parser);
print ("<title>PHP RSS Reader</title><span class='li'><body>");
if (isset($rss_channel["ITEMS"])) {
if (count($rss_channel["ITEMS"]) > 1) {
for($i = 1;$i < count($rss_channel["ITEMS"]);$i++) {
print ("\n<li><a href=\"" . $rss_channel["ITEMS"][$i]["LINK"] . "\" target=\"_blank\" style=\"text-decoration: none\"><span class='title'>" . $rss_channel["ITEMS"][$i]["TITLE"] . "</span></br></a></li></b>");
}
} else {
print ("<b>There are no articles in this feed.</b>");
}
}
print ("</span></body></html>");
?>
</div>
<div class="stil2" id="sondakika1_baslik"> HABER TÜRK</div>
<img height="115" src="http://www.realmedya.com/images/rss_bck.png" width="258" border="0" />
</div>