php_mysql: PHP 格式化输出数据

php_mysql:  PHP 格式化输出数据

 

 

 

 

一、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]$

 

 

 

 

 二、输出结果

[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 PDO| 菜鸟教程    https://www.runoob.com/php/php-pdo.html