UPDATE 操作-PHP实现

sunlichao

下面的 PHP 代码显示了如何使用 UPDATE 语句来更新任何记录，然后从 COMPANY 表中获取并显示更新的记录：

1. <?php
   
2.    class MyDB extends SQLite3
   
3.    {
   
4.       function __construct()
   
5.       {
   
6.          $this->open('test.db');
   
7.       }
   
8.    }
   
9.    $db = new MyDB();
   
10.    if(!$db){
    
11.       echo $db->lastErrorMsg();
    
12.    } else {
    
13.       echo "Opened database successfully\n";
    
14.    }
    
15.    $sql =<<<EOF
    
16.       UPDATE COMPANY set SALARY = 25000.00 where ID=1;
    
17. EOF;
    
18.    $ret = $db->exec($sql);
    
19.    if(!$ret){
    
20.       echo $db->lastErrorMsg();
    
21.    } else {
    
22.       echo $db->changes(), " Record updated successfully\n";
    
23.    }
    
24. 
    
25.    $sql =<<<EOF
    
26.       SELECT * from COMPANY;
    
27. EOF;
    
28.    $ret = $db->query($sql);
    
29.    while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
    
30.       echo "ID = ". $row['ID'] . "\n";
    
31.       echo "NAME = ". $row['NAME'] ."\n";
    
32.       echo "ADDRESS = ". $row['ADDRESS'] ."\n";
    
33.       echo "SALARY =  ".$row['SALARY'] ."\n\n";
    
34.    }
    
35.    echo "Operation done successfully\n";
    
36.    $db->close();
    
37. ?>

复制代码

上述程序执行时，它会产生以下结果：

1. Opened database successfully
   
2. 1 Record updated successfully
   
3. ID = 1
   
4. NAME = Paul
   
5. ADDRESS = California
   
6. SALARY =  25000
   
7. 
   
8. ID = 2
   
9. NAME = Allen
   
10. ADDRESS = Texas
    
11. SALARY =  15000
    
12. 
    
13. ID = 3
    
14. NAME = Teddy
    
15. ADDRESS = Norway
    
16. SALARY =  20000
    
17. 
    
18. ID = 4
    
19. NAME = Mark
    
20. ADDRESS = Rich-Mond
    
21. SALARY =  65000
    
22. 
    
23. Operation done successfully

复制代码