News classification entry and display system

This system can enter titles, content, pictures, and related software. When displaying, it will determine whether to display the content based on whether there are pictures and related software. When opening the page, the latest article will be displayed. Clicking on the directory will display previous articles.
Create the channelimages and channelsoft directories and set the permissions to 777.
*********************************
news表结构
*********************************
# Host: localhost Database : yourdb
# --------------------------------------------------------
#
# Table structure for table 'yourtable'
#
CREATE TABLE news(
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   kind varchar(16),
   title varchar(60),
   content text,
   pic varchar(30),
   timer datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   soft varchar(30),
   PRIMARY KEY (id),
   KEY timer (timer)
);
*********************************
新闻录入文件：insert.htm
*********************************

  
      
      
      
    
      
      
      
    
      
      
      
    
      
      
      
    
      
      
      
    
      
      
      
    
  

标题：
类别：	类型1                    类型2                  类型3                  类型4
内容：
图片：
软件：

  
  
*********************************
end of insert.htm
*********************************
*********************************
insert.php
*********************************
$day=date("md");
If($pic != "none"){
$picname=$day.$pic_name;
copy($pic,"channelimages/$picname");
unlink($pic);
}
If($soft!= "none"){
copy($soft,"channelsoft/$soft_name");
unlink($soft);
}
$dbh =  mysql_connect('localhost','uesrname','passward');
mysql_select_db('yourtable');  
$dat=date("Y-m-d h:i:s");
$query="insert into news(title,kind,content,pic,timer,soft) values('$title','$kind','$content','$picname',now(),'$soft_name')";
$res = mysql_query($query,$dbh);  
$err = mysql_error();
if($err){echo $err;exit();}
echo "

";
echo "

录入成功

";
?>
*********************************
end of insert.php
*********************************
*********************************
新闻显示文件：news.php
*********************************






$db=mysql_connect("localhost","username","passward");
mysql_select_db("yourtable",$db);
$result=mysql_query("select id,title from news where kind='类型1' order by timer desc");
for($a=0;$a<10;$a++)
{if(!($ahrow=mysql_fetch_row($result)))break;
$id=mysql_result($result,$a,"id");
$title=mysql_result($result,$a,"title");
echo "".$title."
";
}
if (!isset($id)) $id=mysql_result($result1,0,"id");
$result=mysql_query("select * from news where id=$id order by timer desc");
$rows=mysql_fetch_row($result);
echo "
";
print $rows[2];
echo "
$rows[5]";
if (strlen($rows[4])>0) echo "

";
echo str_replace("r","
",str_replace(" "," ",$rows[3]));
if (strlen($rows[6])>0) echo "

>>点击下载

";
?>


*********************************
end of news.php
*********************************
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】    

以上就介绍了 新闻分类录入、显示系统，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。