Simple blog tutorial in PHP

In the process of learning PHP, I believe that many people try to develop various functions by themselves. Have you ever used PHP to write a blog? In this article, we will teach you step by step how to use PHP to implement a blog. We hope that through learning, you can write a PHP blog yourself.

First create a blog table through phpMyAdmin.

Pure interface operation, the process is relatively simple. It should be noted that id is the primary key, and the auto_increnent option is set to indicate that Increments when the field is empty. Other fields are more casual, just pay attention to the type and length.

Create data connection                                                                                                                                                                                                                                         .

<?php
@mysql_connect("127.0.0.1:3306","root","") or die("mysql数据库连接失败");
@mysql_select_db("test")or die("db连接失败");mysql_query("set names &#39;gbk&#39;");
?>

Mysql default user name is root and the password is empty. The blog created here is in the test library, so it needs to be connected to the test library.

Add blog

                            

Create the add.php file in the ./wamp/www/blog/ directory.

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>
<?phpinclude("conn.php"); //引入连接数据库if (!empty($_POST[&#39;sub&#39;])) {    $title = $_POST[&#39;title&#39;];  //获取title表单内容
    $con = $_POST[&#39;con&#39;];      //获取contents表单内容
    $sql= "insert into blog values(null,&#39;0&#39;,&#39;$title&#39;,now(),&#39;$con&#39;)";    mysql_query($sql);   
     echo "insert success!";
}
?>

<form action="add.php" method="post">
    title   :<br>
    <input type="text" name="title"><br><br>
    contents:<br>
    <textarea rows="5" cols="50" name="con"></textarea><br><br>
    <input type="submit"  name="sub" value="submit">
    
</form>

This code is divided into two parts. The upper part is the PHP code. The include (or require) statement will get all the text/code/marks that exist in the specified file and copy them to use include statement in the file.

Then, if it is judged that the content of name='sub' in the form is not empty, the content of the form will be obtained, and then the $sql statement will be executed. null means that the id is empty (incremented), now() It means taking the current date, $title and $con take the content submitted by the user in the form. Finally, eche prompts that the insertion is successful.

The lower part is a simple HTML code, used to implement a function that can submit a blog form.

Create the homepage of the blog

               

Create the index.php file in the ./wamp/www/blog/ directory.

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<br><br>
<form action="" method="get" style=&#39;align:"right"&#39;>
    <input type="text" name="keys" >
    <input type="submit" name="subs" >
</form>
<hr>
<?phpinclude("conn.php"); //引入连接数据库
    
    if (!empty($_GET[&#39;keys&#39;])) {        $key = $_GET[&#39;keys&#39;];        $w = " title like &#39;%$key%&#39;";
    }else{        $w=1;
    }    $sql ="select * from blog where $w order by id desc limit 5";    $query = mysql_query($sql);    
    while ($rs = mysql_fetch_array($query)) {?>
<h2>title: <a href="view.php?id=<?php echo $rs[&#39;id&#39;]; ?>"><?php echo $rs[&#39;title&#39;]; ?></a>
    | <a href="edit.php?id=<?php echo $rs[&#39;id&#39;]; ?>">edit</a> 
    | <a href="del.php?id=<?php echo $rs[&#39;id&#39;]; ?>">delete</a> |
</h2>
<li>date: <?php echo $rs[&#39;data&#39;]; ?></li>
<!--截取内容展示长度-->
<p>contents:<?php echo iconv_substr($rs[&#39;contents&#39;],0,30,"gbk"); ?>...</p>  
<hr>
<?php
};?>

This page contains quite a few functions.

The first is a search form. Use if to determine whether the content of the search form is empty. If it is not empty, match the title of the article by entering the keyword and display the result; if it is empty, query all blog content and loop. Display the title, date, and text of each article. Clicking on the title will link to the detailed page of the blog. Each article provides "edit" and "delete" functions.

mysql_query() is used to execute sql statements. mysql_fetch_arry() generates an array from the returned data, so that every piece of data in the database can be operated like an array.

View blog                                                  

Create the view.php file in the ./wamp/www/blog/ directory.

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>
<?phpinclude("conn.php"); //引入连接数据库
    if (!empty($_GET[&#39;id&#39;])) {        $id = $_GET[&#39;id&#39;];        $sql ="select * from blog  where id=&#39;$id&#39; ";    
        $query = mysql_query($sql);        $rs = mysql_fetch_array($query);        
        $sqlup = "update blog set hits=hits+1 where id=&#39;$id&#39;";        mysql_query($sqlup);
    }?>
<h2>title: <?php echo $rs[&#39;title&#39;]; ?> </h1>
<h3>date: <?php echo $rs[&#39;data&#39;]; ?>  click number: <?php echo $rs[&#39;hits&#39;]; ?></h3>
<hr>
<p>contents:<?php echo $rs[&#39;contents&#39;]; ?></p>

The implementation of blog text is relatively simple. Get the blog id through a get request, and then query and display the title, date and text corresponding to the id through a sql statement.

An additional small function is to display a simple counter. Every time the page is refreshed, the number of clicks is incremented by 1.

Edit blog

                                            #Create the edit.php file in the ./wamp/www/blog/ directory.

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>
<?phpinclude("conn.php"); //引入连接数据库
//获取数据库表数据if (!empty($_GET[&#39;id&#39;])) {    $edit = $_GET[&#39;id&#39;];    $sql = "select * from blog where id=&#39;$edit&#39;";    $query = mysql_query($sql);    $rs = mysql_fetch_array($query);
}//更新数据库表数据if (!empty($_POST[&#39;sub&#39;])) {    $title = $_POST[&#39;title&#39;];  //获取title表单内容
    $con = $_POST[&#39;con&#39;];      //获取contents表单内容
    $hid = $_POST[&#39;hid&#39;]; 
    $sql= "update blog set title=&#39;$title&#39;, contents=&#39;$con&#39; where id=&#39;$hid&#39; ";    mysql_query($sql);    echo "<script>alert(&#39;update success.&#39;);location.href=&#39;index.php&#39;</script>";
}?>

<form action="edit.php" method="post">
    <input type="hidden" name="hid" value="<?php echo $rs[&#39;id&#39;];?>">
    title   :<br>
    <input type="text" name="title" value="<?php echo $rs[&#39;title&#39;];?>">
    <br><br>
    contents:<br>
    <textarea rows="5" cols="50" name="con" ><?php echo $rs[&#39;contents&#39;];?></textarea><br><br>
    <input type="submit"  name="sub" value="submit">
    
</form>

The function of editing blog is relatively complicated. The operation is divided into two steps. The first step is to query the title and text of the blog and display them in the input box. The second step is to update the edited content to the database.

Delete blog

                                                   Create the del.php file in the /www/blog/ directory.

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>

rrree

Finally, the blog deletion function is implemented, and the blog is queried and displayed through the ID.

Okay, this is how a blog is completed. Although the interface is not very beautiful, its functions are still complete. Friends who are interested should hurry up and practice it.

Related recommendations:

php blog website development example tutorial (1/8)_PHP tutorial

php blog

php blog website development example tutorial (1/8)

The above is the detailed content of Simple blog tutorial in PHP. For more information, please follow other related articles on the PHP Chinese website!