News release with multiple data tables sharing one page_PHP tutorial

In order to keep this article simple and explain the main content, some secondary HTML content is relatively simple.
When the website has multiple contents to be displayed on a certain page, one display and submission can be shared in the web page.
In this example, there are two data tables (news, ctm); a homepage (index.php);
a submission page (index_pub.php; and a package page (index_view.php)
a Subpage (view_d.php).
----news,ctm---
increate table news(id int(80) not null auto_increment,title char(100),detail text,primay key(id ));
increate table ctm(id int(80) not null auto_increment,title char(100),detail text,primay key(id));


----index_view. php---
$query="select * from ".$name." order by id desc limit 0,5;
$result=mysql_query($query,$db) ;
if ($result){
while($myrow=msyql_fetch_array($result)){
?>
$myrow[title]< ;/tr>
}
}
else{
echo "There is no new content here.";}
?>


----index.php---
$id=mysql_connect("localhost","username","password");
$db=mysql_select_db("your_db",$id);
?>

---

Yourname Online

---

你现在的位置-->首页

---

  

    

    
  

      
                   $name=news;
           include("index_view.php");
        ?>
      
    

      
                   $name=ctm;
           include("index_view.php");
        ?>
      
    

---

Copyrignt 1999…

----index_pub.php---
$id=mysql_connect("localhost","username","password");
$db=mysql_select_db("your_db",$id);
?>

  

请选择数据库：

  
    news
    ctm
  

  

标题：

  

  

内容：

  

  

switch ($db_name){
   case news:$name=news;
   break;
   case ctm:$name=ctm;
   break;
}
$query="insert into ".$name."(title,detail) values('$title','$detail');
$result=mysql_query($query,$db);
if ($result){echo "ok";}
else{echo "failed";}
?>



----view_d.php---
$id=mysql_connect("localhost","username","password");
$db=mysql_select_db("your_db",$id);
?>


if ($recod){
   $query="select * from ".$name." where id=".$recod;
   $result=mysql_query($query,$db);
   $title=mysql_result($result,0,title);
   $detail=mysql_result($result,0,detail);
   echo "

标题：".$title."

";
   echo "

内容：".$detail."

";
}
else{echo "此文件已被删除！";}

 

http://www.bkjia.com/PHPjc/315359.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315359.htmlTechArticleIn order to be simple and able to explain the main content, some secondary html content is relatively simple in this article. When the website has multiple contents to be displayed on a certain page, one display and submission can be shared in the web page. ...