php--mysqli操作

最新推荐文章于 2024-03-25 13:06:39 发布

虾米大王

最新推荐文章于 2024-03-25 13:06:39 发布

阅读量336

点赞数

分类专栏： php 文章标签： mysqli

本文链接：https://blog.csdn.net/modern358/article/details/90382492

版权

php 专栏收录该内容

177 篇文章 19 订阅

订阅专栏

<?php
/**
 * Created by PhpStorm.
 */

$conn = mysqli_connect('localhost','test_user','123456','testDB');
if(mysqli_connect_errno())
{
    echo "connect failed:".mysqli_connect_error()."<br>";
    exit();
}
else
{
    echo "Host information:".mysqli_get_host_info($conn);
    mysqli_close($conn);
}

<?php
/**
 * Created by PhpStorm.
 */

$conn = mysqli_connect('localhost','test_user','123456','testDB');

if(mysqli_connect_errno())
{
    echo "connect failed:".mysqli_connect_error()."<br>";
    exit();
}
else
{
    $sql = "create table tb_test(id int auto_increment primary key,testfield varchar(75) not null)";
    $result = mysqli_query($conn,$sql);
    if($result === true)
    {
        echo "Talbe tb_test is created."."<br>";
    }
    else
    {
        echo "could not create table:".mysqli_error($conn);
    }

    mysqli_close($conn);
}

<?php
/**
 * Created by PhpStorm.
 */

$conn = mysqli_connect('localhost','test_user','123456','testDB');
if(mysqli_connect_errno())
{
    echo 'Connect failed:'.mysqli_connect_error()."<br>";
    exit();
}
else
{
    $sql = "insert into tb_test(testfield) values('some value')";
    $result = mysqli_query($conn,$sql);
    if($result === true)
    {
        echo " a record has been inserted."."<br>";
    }
    else
    {
        echo "could not insert record.".mysqli_error($conn)."<br>";
    }
    mysqli_close($conn);
}

<html>
<head>
    <title>Record Insertion Form</title>
</head>
<body>
    <form action="" method="post">
        <p><label for="testfield">Text to Add:</label><br>
        <input type="text" id="testfield" name="testfield" size="30"></p>
        <button type="submit" name="submit" value="insert">Insert Record</button>
    </form>
</body>
</html>

<?php
    $conn = mysqli_connect('localhost','test_user','123456','testDB');
    if(mysqli_connect_errno())
    {
        echo 'connect faild:'.mysqli_connect_error()."<br>";
        exit();
    }
    else
    {
        if(empty($_POST['testfield']))
        {
            echo 'please fill right words.'."<br>";
            return;
        }
        $clean_text =@mysqli_real_escape_string($conn,$_POST['testfield']);
        $sql = "insert into tb_test(testfield) values('$clean_text')";
        $result = mysqli_query($conn,$sql);
        if($result === true)
        {
            echo 'insert ok.'."<br>";
        }
        else
        {
            echo "could not insert record.".mysqli_error($conn);
        }

        mysqli_close($conn);
    }

?>

虾米大王

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
打赏
0
评论
php--mysqli操作

<?php/** * Created by PhpStorm. */$conn = mysqli_connect('localhost','test_user','123456','testDB');if(mysqli_connect_errno()){ echo "connect failed:".mysqli_connect_error()."<br>...
复制链接

扫一扫