<?php
class RSS{
public static function dbread() { //liest XML aus
echo 'Hallo wer da?';
$objXML = simplexml_load_file('xml.php');
echo 'Hallo wer da2?';
foreach($objXML->item as $myfeed){
echo 'Item geholt';
echo $myfeed->title;
}
}
//schreibt Daten in die Datenbank
public function dbinsert($dbhost , $dbuser, $dbpass, $dbname, $connect, $autor, $titel, $text){
$sql = 'INSERT INTO `rss` (`autor`, `title`, `text`) VALUES (? ,? ,? )';
$kommando = $connect->prepare($sql);
$kommando->bind_param('sss', $autor, $titel, $text);
$kommando->execute();
}
}
if(isset($_POST['rsssubmit']) && isset($_POST['autor']) && !empty($_POST['autor']) && isset($_POST['titel']) && !empty($_POST['titel']) && isset($_POST['rsstext']) && !empty($_POST['rsstext'])) {
$dbhost = 'localhost';
//$dbuser = "s12int_11137"; //für FH Server
//$dbpass = "sd6vd5"; //------""------
$dbuser = 'root';
$dbpass = '';
$dbname = 's12int_11137';
$connect = @new mysqli($dbhost , $dbuser, $dbpass, $dbname);
if(mysqli_connect_errno() == 0){
echo 'Verbindung offen';
} else {
echo 'Die Datenbank konnte nicht erreicht werden!' .mysqli_connect_errno(). ' : ' .mysqli_connect_error();
}
$autor = $_POST['autor'];
$titel = $_POST['titel'];
$text = $_POST['rsstext'];
$feed = new RSS();
/* $feed->setAutor($autor);
// echo $feed->getAutor();
$feed->setTitel($titel);
// echo $feed->getTitel();
$feed->setText($text);
// echo $feed->getText();
*/
$feed->dbinsert($dbhost , $dbuser, $dbpass, $dbname, $connect, $autor, $titel, $text);
$connect->close();
echo 'Verbindung zu.';
}
?>
<div class="window" id="noteapplet" align="left"
style="left: <?php echo $_SESSION['noteapplet']['posX'];?>px; top: <?php echo $_SESSION['noteapplet']['posY'];?>px; display: <?php echo $_SESSION['noteapplet']['vis'];?>">
<span class="x" onClick="funcicon('noteapplet')">[x]</span>
<?php
if(isset($_GET['feed']) && ($_GET['feed'])==1){
include "feedform.php";
} else {
echo '<span>';
echo "<a href='index.php?feed=1' id='register'> Neuen Feed veröffentlichen</a>";
echo '<br/><br/>';
RSS::dbread();
echo '</span>';
}
?>
</div>