News classification entry and display system_PHP tutorial

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 the page is opened, the latest article will be displayed. Clicking on the directory will display the 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
*********************************


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

http://www.bkjia.com/PHPjc/316418.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/316418.htmlTechArticle本系统可以录入标题、内容、图片、相关软件，显示时会根据是否有有图片和相关软件来判断是否显示该项内容，打开页面显示的是最新的...