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;

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


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