php_mysql: PHP 格式化输出数据

 1 [wit@fedora mysql]$ cat  php_mysql 
 2 #!/usr/bin/php
 3 
 4 
 5 <?php
 6 
 7 
 8 
 9 
10 // filename = php_mysql
11 
12 
13 
14 
15 function test()
16 {
17         echo "hello, php!\n";
18 }
19 
20 
21 function php_mysql()
22 {
23 
24         $server = "localhost";
25         $user = "admin";
26         $passwd = "211224ln";
27         $dbname = "tmp";
28 
29 
30         try
31         {
32                 $dbh = new PDO("mysql:host=$server;dbname=$dbname", $user, $passwd);
33                 $dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
34 
35                 $icount = 0;
36                 echo "\n\n";
37                 foreach ( $dbh->query('select * from dlt2023') as $row)
38                 {
39                         echo "\n\t----  [tmp:$icount]  ----\t\n";
40                         // print_r($row);
41 
42                         // feikong, bu jia yige kongge; kong, jia liangge kongge.  $row[i] = ($row[i] != NULL ? " $row" : "  " )
43                         for($i=0; $i<49; $i++)
44                         {
45                                 if ( ($row[$i] != 0) and ($row[$i] < 10) )
46                                 {
47                                         $row[$i] = " "  . $row[$i];
48                                 }
49                                 else if ( $row[$i] == NULL )
50                                 {
51                                         $row[$i] = "  ";
52                                 }
53                         }
54 
55                         echo "$row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8], $row[9]";
56                         echo ", $row[10], $row[11], $row[12], $row[13], $row[14], $row[15], $row[16], $row[17], $row[18], $row[19]";
57                         echo ", $row[20], $row[21], $row[22], $row[23], $row[24], $row[25], $row[26], $row[27], $row[28], $row[29]";
58                         echo ", $row[30], $row[31], $row[32], $row[33], $row[34], $row[35], $row[36], $row[37], $row[38], $row[39]";
59                         echo ", $row[40], $row[41], $row[42], $row[43], $row[44], $row[45], $row[46], $row[47], $row[48]";
60                         $icount = $icount + 1;
61                         echo "\n";
62                 }
63                 echo "\n\n";
64 
65                 $dbh = null;
66 
67         }
68         catch(PDOException $e)
69         {
70                 die( "Error!: " . $e->getMessage() . "<br/>");
71         }
72 
73 }
74 
75 
76 
77 
78 
79 
80 // test php_mysql
81 php_mysql();
82 
83 
84 ?>
85 [wit@fedora mysql]$ 
86 [wit@fedora mysql]$ 

 1 [wit@fedora mysql]$ ./php_mysql 
 2 
 3 
 4 
 5 
 6 
 7         ----  [tmp:0]  ----
 8 2023001, 2023-01-02,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   , 18, 19,   ,   ,   ,   , 24,   ,   , 27,   ,   ,   ,   ,   ,   , 34,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   , 11, 12
 9 
10         ----  [tmp:1]  ----
11 2023002, 2023-01-04,   ,   ,   ,   ,   ,   ,   ,   ,   ,   , 11,   ,   , 14,   ,   ,   ,   ,   ,   , 21,   ,   ,   ,   , 26, 27,   ,   ,   ,   ,   ,   ,   ,   ,   ,  2,   ,   ,   ,   ,  7,   ,   ,   ,   ,   
12 
13         ----  [tmp:2]  ----
14 2023003, 2023-01-07,   ,   ,   ,   ,  5,  6,   ,   ,   ,   ,   ,   ,   , 14,   ,   ,   ,   ,   ,   , 21, 22,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,   ,  2,   ,   ,   ,   ,   ,   ,  9,   ,   ,   
15 
16 
17 [wit@fedora mysql]$