php实现blog

最新推荐文章于 2024-06-11 15:21:03 发布

diqiejian1788

最新推荐文章于 2024-06-11 15:21:03 发布

阅读量161

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/Abby2017/p/7100888.html

版权

1.建立表单

2.连接数据库，测试其功能

/怎样给按钮加连接？
//<input type="submit" name="add post" value="add post">
<a href="http://phpblog.local/test.php?" target="_blank">add post</a>

//<input type="submit" οnclick="http://phpblog.local/test.php?">

3.实现index.php页面

 1 <!DOCTYPE HTML>
 2 <html>
 3     <body>
 4         <?php $TitleErr = $BodyErr = "";
 5         $Title = $Body = "";
 6         
 7         <h4>Add post:</h4>
 8         <p><span class="error">* Required</span></p>
 9         <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> 
10 
11         <label>Title<span class="error">*<?php echo $TitleErr;?>:</span></label>
12         <br>
13         <input type="text" maxlength="50" name="Title" value="<?php echo $Title;?>">
14         <br>
15        
16         <label>Body<span class="error">* <?php echo $BodyErr;?>: </span></label><br>
17         <textarea name="Body" rows="5" cols="40"><?php echo $Body;?></textarea>*
18         <br><br>
19 
20         <input type="submit" name="save post" value="save post"> 
21      
22         </form>
23         
24         //$dbc = mysqli_connect("localhost","root","root","cakephp2");
25         $servername = "localhost";
26         $username = "root";
27         $password = "root";
28         $dbname = "cakephp2";
29 
30         // 创建连接
31         $conn = new mysqli($servername, $username, $password, $dbname);
32         // 检测连接
33         if ($conn->connect_error) {
34             die("连接失败: " . $conn->connect_error);
35         }
36 
37         $sql = "INSERT INTO posts (title, body,created,modified) VALUES ($Title, $Body, NOW(),NOW())";
38 
39         if ($conn->query($sql) === TRUE) {
40             echo "新记录插入成功";
41         } else {
42             echo "Error: " . $sql . "<br>" . $conn->error;
43         }
44 
45         $conn->close();
46 
47         function test_input($data)
48         {
49             $data = trim($data);
50             $data = stripslashes($data);
51             $data = htmlspecialchars($data);
52             return $data;
53             
54         }
55         var_dump($_SERVER["REQUEST_METHOD"]);
56         if ($_SERVER["REQUEST_METHOD"] == "POST"){
57             if (empty($_POST["Title"])){
58                 $nameErr = "Title is required";
59                 
60             }else{
61                 $name = test_input($_POST["Title"]);     
62                 
63             }
64             if (empty($_POST["Body"])){
65                 $BodyErr = "Body is required";
66                 
67             }
68             else{
69                 $Body = test_input($_POST["Body"]);    
70                 }
71         }
72         //var_dump($_POST['Title']);
73     
74         ?>
75 
76         <?php
77         echo $Title;
78         echo "<br>";
79         echo $Body;
80         echo "<br>";
81         ?>
82     </body>
83 </html>

updat.php

<!DOCTYPE HTML>
<html>
    <body>
        <?php $TitleErr = $BodyErr = "";
        $Title = $Body = "";
        
        <h4>Add post:</h4>//显示出错，但没找出来。
        <p><span class="error">* Required</span></p>
        <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> 

        <label>Title<span class="error">*<?php echo $TitleErr;?>:</span></label>
        <br>
        <input type="text" maxlength="50" name="Title" value="<?php echo $Title;?>">
        <br>
       
        <label>Body<span class="error">* <?php echo $BodyErr;?>: </span></label><br>
        <textarea name="Body" rows="5" cols="40"><?php echo $Body;?></textarea>*
        <br><br>

        <input type="submit" name="save post" value="save post"> 
     
        </form>
        
        //$dbc = mysqli_connect("localhost","root","root","cakephp2");
        $servername = "localhost";
        $username = "root";
        $password = "root";
        $dbname = "cakephp2";

        // 创建连接
        $conn = new mysqli($servername, $username, $password, $dbname);
        // 检测连接
        if ($conn->connect_error) {
            die("连接失败: " . $conn->connect_error);
        }

        $sql = "INSERT INTO posts (title, body,created,modified) VALUES ($Title, $Body, NOW(),NOW())";

        if ($conn->query($sql) === TRUE) {
            echo "新记录插入成功";
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

        $conn->close();

        function test_input($data)
        {
            $data = trim($data);
            $data = stripslashes($data);
            $data = htmlspecialchars($data);
            return $data;
            
        }
        var_dump($_SERVER["REQUEST_METHOD"]);
        if ($_SERVER["REQUEST_METHOD"] == "POST"){
            if (empty($_POST["Title"])){
                $nameErr = "Title is required";
                
            }else{
                $name = test_input($_POST["Title"]);     
                
            }
            if (empty($_POST["Body"])){
                $BodyErr = "Body is required";
                
            }
            else{
                $Body = test_input($_POST["Body"]);    
                }
        }
        //var_dump($_POST['Title']);
    echo $Title;
        echo "<br>";
        echo $Body;
        echo "<br>";
  
    </body>
</html>

title.php

<?php
echo "<table style='border: solid 1px black;'>";
echo "<tr><th>Id</th><th>Title</th><th>Body</th><th>Update</th><th>created</th></tr>";

class TableRows extends RecursiveIteratorIterator {
    function __construct($it) { 
        parent::__construct($it, self::LEAVES_ONLY); 
    }

    function current() {
        return "<td style='width: 150px; border: 1px solid black;'>" . parent::current(). "</td>";
    }

    function beginChildren() { 
        echo "<tr>"; 
    } 

    function endChildren() { 
        echo "</tr>" . "\n";
    } 
} 

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "cakephp2";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT * FROM posts"); 
    $stmt->execute();

    // 设置结果集为关联数组
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC); 

    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) { 
        echo $v;
    }
    $dsn = null;
}
catch(PDOException $e)
{
    echo "Error: " . $e->getMessage();
}
$conn = null;
echo "</table>";
?>

转载于:https://www.cnblogs.com/Abby2017/p/7100888.html

diqiejian1788

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php实现blog

1.建立表单2.连接数据库，测试其功能/怎样给按钮加连接？ //<input type="submit" name="add post" value="add post"> <a href="http://phpblog.local/test.php?" target="_blank">add post</a> //&l...
复制链接

扫一扫