Weblabor

<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

/* //
mysql_query("
CREATE TABLE IF NOT EXISTS `dailynews` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`header` text NOT NULL default '',
`content` text NOT NULL default '',
`script` text NOT NULL default '',
`image` varchar(40) NOT NULL default '',
`ins_date` date NOT NULL default '0000-00-00',
`status` enum('on','off') NOT NULL default 'on',
`show_date` date NOT NULL default '0000-00-00',
PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
*/ //

$tday_date=date('Y-m-d');

function select_id($id){
$result = mysql_query("SELECT id FROM dailynews WHERE id>='$id' AND status !='off' LIMIT 0,1");
if (mysql_num_rows($result)==0) {
return null;
} else {
return mysql_fetch_assoc( $result );
}
}

$result = mysql_query("SELECT id,name,header,content,script,image,status,show_date FROM dailynews WHERE show_date != '0000-00-00' AND status !='off'");
$row = mysql_fetch_assoc($result);
if (mysql_num_rows($result)==0) {
mysql_query("UPDATE dailynews SET show_date='$tday_date' WHERE id='1'");
}

$arow=$row['show_date'];
if ($arow!=$tday_date) {
$aid=select_id($row['id']);
print_r('['.$aid.']');
    mysql_query("UPDATE dailynews SET show_date='0000-00-00' WHERE show_date='$arow' LIMIT 1");
mysql_query("UPDATE dailynews SET show_date='$tday_date' WHERE id='$aid' LIMIT 1");
}

echo "<center><h2> asd </h2></center><p>";
if($row['image']){
echo "<img src=\"".$row['image']."\" align=right>";
}
echo $row['header'];
echo "<center><strong>$row[name]</strong></center><p>";
echo "<table width=\"99%\" cellspacing=0 cellpadding=0 align=center>";
echo "<tbody><tr valign=middle><td valign=top align=left>";
echo $row['content'];
echo "</td><td width=5 align=center></td><td align=center width=90 height=90>";
echo $row['script'];
echo "</td></tr></tbody></table>";
?>

<?php
include("config.php");
@mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db($dbname);

if ($_GET['edit']) {
$result = mysql_query("select * from dailynews where id='$_GET[edit]'");
$row = mysql_fetch_assoc($result);

} else unset($row);

$header="ritkabban valtozo headertext";
$tday_date=date('Y-m-d');
?>
<form method=post action="./">
<input type=hidden name=editid value="<?=$_GET['edit']?>">
<table>
<tr><td>header</td><td><textarea name=header cols=50 rows=5><?=$_GET['edit']?$row['header']:$header?></textarea></td></tr>
<tr><td>submitted date</td><td><input type=text name=ins_date value=<?=$_GET['edit']?$row['ins_date']:date('Y-m-d')?>></td></tr>
<tr><td>title</td><td><input type=text size=60 name=name value="<?=htmlentities($row['name'])?>"></td></tr>
<tr><td>content</td><td><textarea name=content cols=50 rows=5><?=$row['content']?></textarea></td></tr>
<tr><td>script</td><td><textarea name=script cols=50 rows=5><?=$row['script']?></textarea></td></tr>
<tr><td>image</td><td><input type=text size=60 name=image value="<?=htmlentities($row['image'])?>"></td></tr>
<? if($_GET['edit'] && $row['show_date']=='$tday_date') {?>
<? } else {?>
<tr><td>status</td><td><input type=radio name=status value="on" <? if($row['status']=='on') echo "checked"?>>on<input type=radio name=status value="off" <? if($row['status']=='off') echo "checked"?>>off</td></tr>
<? }?>
<tr><td colspan=2 align=center><input type=submit name=<?=$_GET['edit']?"editold":"addnew"?> value="submit"></td></tr>
</table>
</form>
<a href="index.php">clear text</a><br><br><hr><br>
<?
if ($_POST['addnew']) {
mysql_query("insert into dailynews (ins_date,name,header,content,script,image,status) values('$_POST[ins_date]','$_POST[name]','$_POST[header]','$_POST[content]','$_POST[script]','$_POST[image]','$_POST[status]')");
}
if ($_POST['editold']) {
mysql_query("update dailynews set ins_date='$_POST[ins_date]',name='$_POST[name]',header='$_POST[header]',content='$_POST[content]',script='$_POST[script]',image='$_POST[image]',status='$_POST[status]' where id='$_POST[editid]'");
}
if ($_GET['del']) {
mysql_query("delete from dailynews where id='$_GET[del]'");
}
if ($_GET['edit']) {
echo "";
} else if ($_GET['show']) {
$result = mysql_query("select * from dailynews ORDER BY id DESC");
} else {
$result = mysql_query("select * from dailynews ORDER BY id DESC LIMIT 1");
}
if ($_GET['show']=="current") {
$result = mysql_query("select * from dailynews ORDER BY show_date DESC LIMIT 1");
} else {
$result = mysql_query("select * from dailynews ORDER BY id DESC LIMIT 1");
}

while ($row = mysql_fetch_assoc($result)) {

echo "<center><h2> asd </h2></center><p>";
if($row['image']){
echo "<img src=\"".$row['image']."\" align=right>";
}
echo $row['header'];
echo "<center><strong>$row[name]</strong></center><p>";
echo "<table width=\"99%\" cellspacing=0 cellpadding=0 align=center>";
echo "<tbody><tr valign=middle><td valign=top align=left>";
echo $row['content'];
echo "</td><td width=5 align=center></td><td align=center width=90 height=90>";
echo $row['script'];
echo "</td></tr></tbody></table>";
echo "<br><hr>";
echo $row[id]." | ";
echo "<a href=index.php?edit=$row[id]>edit</a> | ";
echo "<a href=index.php?del=$row[id]>delete</a> | ";
if ($row['status']!='off') {
echo "status: <b>on</b> | ";
} else {
echo "status: <b>off</b> | ";
}
echo "included date: $row[ins_date]";
if ($row['show_date']==$tday_date) {
echo " | <b>shown</b>";
}
}

if (!$_GET['show']) {
echo "<form method=post action=\"./?show=all\"><p><input type=submit value=showall></form>
 <form method=post action=\"./?show=current\"><p><input type=submit value=\"show current\"></form>";
}
if ($_GET['edit']) {
$result = mysql_query("select * from dailynews where id='$_GET[edit]'");
$row = mysql_fetch_assoc($result);

} else unset($row);
?>