php + sqlite 的内存数据表操作问题

这是网上的一段代码,运行正常,也得到了结果,但运行后这个内存数据表就自动释放了,在别的网页再连接这个表就提示出错,而我想让这个表继续存在,在其它网页中可以再查询这个表,另外内存数据表是否可以定义名字,因为我想建几个内存数据表进行操作。求解!!!
PHP code
<?php 
    //open the database, note that ':memory:' is used as filename
    $db = sqlite_open(":memory:");

    //create a table and insert some data
    sqlite_exec($db, 
        "BEGIN; 
        CREATE TABLE plays (id, author, title); 
        INSERT INTO plays (id, author, title) VALUES (1, 'Goethe', 'Faust'); 
        INSERT INTO plays (id, author, title) VALUES (2, 'Shakespeare', 'Hamlet'); 
        INSERT INTO plays (id, author, title) VALUES (3, 'Sophocles', 'Oedipus Rex'); 
        COMMIT;"
        );
    //select all records from our table
    $result = sqlite_query($db, "SELECT * FROM plays");
    //fetch them into an array of arrays
    $data = sqlite_fetch_all($result);
    //display the data
    echo "<ul>";
    foreach($data as $key => $row){ 
        echo "<li>".$row['title']." (by ".$row['author'].")</li>"; 
    }
    echo "</ul>";
?>

作者: qaz1znz   发布时间: 2011-06-02

不可以
内存表只生存与当前程序中

作者: xuzuning   发布时间: 2011-06-02