你看看这个$url = trim($_GET['url']);$db = sqlite_open("db.sqlite"); @sqlite_query($db, 'create table url (id,url,primary key (id))');if($url){ $sqla = "select url from url where url='".$url."' order by id asc"; $resa=sqlite_query($db,$sqla); $row=sqlite_fetch_array($resa); if ($row['url']==$url) {}else{ $sql = "insert into url (url) values ('$url')"; $result = sqlite_query($db, $sql); } } $sqlb = "select url from url order by id desc limit 10"; $query = sqlite_query($db, $sqlb); while ($res = sqlite_fetch_array($query)){ echo "<a href=?url=" . ($res['url']+1) . ">" . ($res['url']) . "</a>"; } sqlite_close($db);
Warning: sqlite_query() [function.sqlite-query]: database schema has changed in E:\1.php on line 18Warning: sqlite_fetch_array() expects parameter 1 to be resource, boolean given in E:\1.php on line 19 在本机测试可用。远程电脑上就出现 上面那种 情况。。原始的代码在本机也可以用,远程就不可以用了。而且用到sqlite_open和sqlite_query 很占cpu,不知是哪里设置问题还是
尝试 $db = sqlite_open("db.sqlite", 0666);
<?php $dbhandle = new SQLiteDatabase('sqlitedb');$query = $dbhandle->query('SELECT name, email FROM users LIMIT 25'); // buffered result set $query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25'); // unbuffered result set$result = $query->fetchAll(SQLITE_ASSOC); foreach ($result as $entry) { echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email']; } ?>
@sqlite_query($db, 'create table url (id,url,primary key (id))');if($url){
$sqla = "select url from url where url='".$url."' order by id asc";
$resa=sqlite_query($db,$sqla); $row=sqlite_fetch_array($resa);
if ($row['url']==$url) {}else{
$sql = "insert into url (url) values ('$url')";
$result = sqlite_query($db, $sql);
}
}
$sqlb = "select url from url order by id desc limit 10";
$query = sqlite_query($db, $sqlb);
while ($res = sqlite_fetch_array($query)){
echo "<a href=?url=" . ($res['url']+1) . ">" . ($res['url']) . "</a>";
}
sqlite_close($db);
在本机测试可用。远程电脑上就出现 上面那种 情况。。原始的代码在本机也可以用,远程就不可以用了。而且用到sqlite_open和sqlite_query 很占cpu,不知是哪里设置问题还是
$db = sqlite_open("db.sqlite", 0666);
$dbhandle = new SQLiteDatabase('sqlitedb');$query = $dbhandle->query('SELECT name, email FROM users LIMIT 25'); // buffered result set
$query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25'); // unbuffered result set$result = $query->fetchAll(SQLITE_ASSOC);
foreach ($result as $entry) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>