php_mysql: dlt - 数据库操作

php_mysql:    dlt - 数据库操作

 

 

 

 

一、数据库的建立和数据插入

 

　　1、数据库建立

DROP DATABASE `tmp`;


CREATE DATABASE IF NOT EXISTS `tmp`;


USE tmp;


CREATE TABLE IF NOT EXISTS `dlt2023` (
    `uid` INT NOT NULL,
    `udate` DATE NOT NULL,
    `f1` INT,
    `f2` INT,
    `f3` INT,
    `f4` INT,
    `f5` INT,
    `f6` INT,
    `f7` INT,
    `f8` INT,
    `f9` INT,
    `f10` INT,
    `f11` INT,
    `f12` INT,
    `f13` INT,
    `f14` INT,
    `f15` INT,
    `f16` INT,
    `f17` INT,
    `f18` INT,
    `f19` INT,
    `f20` INT,
    `f21` INT,
    `f22` INT,
    `f23` INT,
    `f24` INT,
    `f25` INT,
    `f26` INT,
    `f27` INT,
    `f28` INT,
    `f29` INT,
    `f30` INT,
    `f31` INT,
    `f32` INT,
    `f33` INT,
    `f34` INT,
    `f35` INT,
    `b1` INT,
    `b2` INT,
    `b3` INT,
    `b4` INT,
    `b5` INT,
    `b6` INT,
    `b7` INT,
    `b8` INT,
    `b9` INT,
    `b10` INT,
    `b11` INT,
    `b12` INT
);

 

 

　　2、数据插入数据库

INSERT INTO dlt2023 VALUES(2023000, "2023-01-01", 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,1,2,3,4,5,6,7,8,9,10,11,12);


INSERT INTO dlt2023(uid, udate, f18, f19, f24, f27, f34, b11, b12) VALUES(2023001, "2023-01-02", 18, 19, 24, 27, 34, 11, 12);

INSERT INTO dlt2023(uid, udate, f11, f14, f21, f26, f27, b2, b7) VALUES(2023002, "2023-01-04", 11, 14, 21, 26, 27, 2, 7);

INSERT INTO dlt2023(uid, udate, f5, f6, f14, f21, f22, b2, b9) VALUES(2023003, "2023-01-07", 5, 6, 14, 21, 22, 2, 9);

 

 

 

二、PHP 格式化输出dlt数据

 

　　1、PHP 源程序

[wit@fedora mysql]$ cat  php_mysql 
#!/usr/bin/php


<?php




// filename = php_mysql




function test()
{
        echo "hello, php!\n";
}


function php_mysql()
{

        $server = "localhost";
        $user = "user";
        $passwd = "mima";
        $dbname = "tmp";


        try
        {
                $dbh = new PDO("mysql:host=$server;dbname=$dbname", $user, $passwd);
                $dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

                $icount = 0;
                echo "\n\n";
                foreach ( $dbh->query('select * from dlt2023') as $row)
                {
                        // echo "\n\t----  [tmp:$icount]  ----\t\n";
                        // print_r($row);

                        // zhong dian
                        // gongji 4 ge kong ge
                        // row[i] != 0, row[i] = "1 kongge" + row[i];    row[i] == NULL, row[i] = "2 kongge".
                        for($i=0; $i<49; $i++)
                        {
                                if ( ($row[$i] != 0) and ($row[$i] < 10) )
                                {
                                        // 1 ge kongge
                                        $row[$i] = " "  . $row[$i];
                                }
                                else if ( $row[$i] == NULL )
                                {
                                        // 2 ge kongge
                                        $row[$i] = "  ";
                                }
                        }

                        echo "$row[0]  $row[1]  $row[2]  $row[3]  $row[4]  $row[5]  $row[6]  $row[7]  $row[8]  $row[9]";
                        echo "  $row[10]  $row[11]  $row[12]  $row[13]  $row[14]  $row[15]  $row[16]  $row[17]  $row[18]  $row[19]";
                        echo "  $row[20]  $row[21]  $row[22]  $row[23]  $row[24]  $row[25]  $row[26]  $row[27]  $row[28]  $row[29]";
                        echo "  $row[30]  $row[31]  $row[32]  $row[33]  $row[34]  $row[35]  $row[36]  --  $row[37]  $row[38]  $row[39]";
                        echo "  $row[40]  $row[41]  $row[42]  $row[43]  $row[44]  $row[45]  $row[46]  $row[47]  $row[48]";
                        $icount = $icount + 1;
                        echo "\n";
                        echo "\n";
                }
                echo "\n\n";

                $icount = 0;
                $dbh = null;

        }
        catch(PDOException $e)
        {
                die( "Error!: " . $e->getMessage() . "<br/>");
        }

}






// test php_mysql
php_mysql();


?>
[wit@fedora mysql]$ 
[wit@fedora mysql]$ 

 

 

 

　　2、PHP 输出内容

[wit@fedora mysql]$   ./php_mysql 




2023000  2023-01-01   1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  --   1   2   3   4   5   6   7   8   9  10  11  12

2023001  2023-01-02                                                                      18  19                  24          27                          34      --                                          11  12

2023002  2023-01-04                                          11          14                          21                  26  27                                  --       2                   7                    

2023003  2023-01-07                   5   6                              14                          21  22                                                      --       2                           9            



[wit@fedora mysql]$ 
[wit@fedora mysql]$ 

 

 

 

 

三、参考文档

 

　　1、php_mysql:  PHP 格式化输出数据　　　　https://www.cnblogs.com/lnlidawei/p/17840034.html