php【基础练习一】DB

最新推荐文章于 2023-10-20 15:03:04 发布

沈纵情

最新推荐文章于 2023-10-20 15:03:04 发布

阅读量659

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/jianguo_liao19840726/article/details/50388913

版权

PHP 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

<?php
/**
 * Created by PhpStorm.
 * User: dell
 * Date: 2015/12/23
 * Time: 17:18
 */

define('LOCALHOST','localhost');
define('MY_SQL_USER','root');

echo 'config';

<?php
/**
 * Created by PhpStorm.
 * User: dell
 * Date: 2015/12/23
 * Time: 17:22
 */
require_once 'config.php';

function getDB()
{
    return @mysqli_connect(LOCALHOST, MY_SQL_USER, '');
}

<?php
require_once 'open_db.php';
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Title</title>
</head>
<body>
<?php

$conn = getDB();

if(!mysqli_connect_errno())
{
    echo '连接数据库成功' . '<br>';
}

if ($conn) {

    mysqli_select_db($conn,'myapp');

    $result = mysqli_query($conn,"SELECT name,age FROM users ORDER BY id DESC ");
//    $result = mysqli_query($conn,"SELECT name,age FROM users WHERE id = 1");
    $data_count = mysqli_num_rows($result);
    for($index = 0 ;$index < $data_count ;$index++)
    {
       $result_arr = mysqli_fetch_assoc($result);
        echo $result_arr['age'];
    }

    $insert = mysqli_query($conn,"INSERT INTO `users` (`id`, `name`, `age`) VALUES (NULL, 'zhaoliu', '24') , (NULL, 'qianwu', '25')");
    if(mysqli_errno($conn))
    {
        echo '插入数据有错误' . mysqli_error();
    }
    $update = mysqli_query($conn,"UPDATE `users` SET `age` = '29' WHERE `users`.`id` = 2");
    if(mysqli_errno($conn))
    {
        echo '更新数据有错误' . mysqli_error();
    }

    $delete = mysqli_query($conn,"DELETE FROM `users` WHERE `users`.`id` = 1");

//    $result = mysqli_query($conn,"SELECT COUNT(*) FROM users WHERE id = 1");
//    $result_arr = mysqli_fetch_array($result);
//    echo '表中的数据个数：' . $result_arr[0];

    mysqli_free_result($result);
    mysqli_close($conn);

    header("Location:../main.php");

} else {
    echo '连接数据库失败';
}

?>
</body>
</html>

沈纵情

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php【基础练习一】DB

<?phprequire_once 'open_db.php';?> Title<?php$conn = getDB();if(!mysqli_connect_errno()){ echo '连接数据库成功' . '';}if ($conn) { mysqli_select_db($conn,'myapp'); $re
复制链接

扫一扫

专栏目录