Ideas for using PHP to create a news system_PHP tutorial

We can use the news system to store news, and we can add and delete news. This reduces everyone's workload. Why not experiment with it.

First, create a table.
create table news (
n_id int(255) not null auto_increment,
n_date datetime not null,
news text not null,
primary key(n_id)
);

The second step is to set your login information
$database_user_name="root"; 🎜>$database_name="news";                                   ";

The third step, let us make the things used in the subsequent program into functions to save space!

function connect_db()
    {
    // connects to the database

    global $database_user_name, $database_password;
    $db=mysql_connect("localhost",$database_user_name,$database_password);

    return $db;

    }


function db_name()
    {
    // returns the name of the database

    global $database_name;
    $db_name=$database_name;

    return $db_name;

    }

     

function get_now()
    {
    // gets current date and time

    $db=connect_db();
    $db_name=db_name();
    mysql_select_db($db_name,$db);
    $sql="select now() as now";
    $result=mysql_query($sql,$db);
    $myrow=mysql_fetch_array($result);
    $now=$myrow["now"];

    return $now;

    }
第四步，让我们考虑如何将新闻显示出来


//上面已经定义的函数库...
//表格的定义......

$title ";
if ($admin==1)
    {

    echo " Admin ";
    }  

echo " - News

";


$db=connect_db();
$db_name=db_name();
mysql_select_db($db_name,$db);

if ($show_news_sub)
    {
     $show_news = $show_news_sub;
    }


if (!ereg("([0-9]{".strlen($show_news)."})",$show_news))
    {
    $show_news="ALL";
    }

if (strtoupper($show_news)=="ALL")
    {

    $sql="select date_format(n_date,'%m/%d/%Y') as n_date, date_format(n_date,'%H:%i') as n_time ,news , n_date as date from news order by date desc";

    }
else  
    {

    $link="All news";

     
    $sql="select date_format(n_date,'%m/%d/%Y') as n_date, date_format(n_date,'%H:%i') as n_time , news , n_date as date from news order by n_date desc limit $show_news";
    }
$result=mysql_query($sql,$db);
$num_rows=mysql_num_rows($result);
if($num_rows!=0)
    {
echo "


";

    while($myrow=mysql_fetch_array($result))
        {
        $date=$myrow["n_date"];     
        $time=$myrow["n_time"];         
        $news=$myrow["news"];
        $n_id=$myrow["n_id"];
        if (strtoupper($show_date)=="Y" && strtoupper($show_time)=="Y")
            {
            $show=$date." ".$time;

            }
        else if (strtoupper($show_date)=="Y" && strtoupper($show_time)!="Y")     
            {
            $show=$date;

            }
if (strtoupper($show_date)!="Y" && strtoupper($show_time)=="Y")
{
$show=$time;

}

$cleannews=(nl2br($news));


$show
$cleannews



";
}
echo " 

";

                                                                                                                                                  .php>Return
";
}

if ($link)
 {
 echo "

$link";

 }
Note: The format tag is omitted to make the idea clearer. You can add it


[The copyright of this article is jointly owned by the author and Oso.com. If you need to reprint, please Indicate the author and source]




http://www.bkjia.com/PHPjc/314136.html

www.bkjia.com

true

http: //www.bkjia.com/PHPjc/314136.htmlTechArticleWe can use the news system to store news, and we can add, delete and other operations to the news, which reduces the number of people workload, why not experiment. First, create a...