<?php
$url = "http://localhost/index.php/%E9%94%A1"; //测试一个网页
$contents = file_get_contents($url);
preg_match_all('/(<h1.*<\/table>)/iUs', $contents, $match);
$contents = $match[1][0];
echo $contents;$DBserver = "localhost";
$DBname = "lookdb";
$DBuser = "root";
$DBpassword = "68568";mysql_connect("localhost","root","68568");
mysql_select_db("lookdb");
mysql_query("set names 'gbk'");
$sql="";
mysql_query($sql);$SQL="INSERT INTO page (pagetext) VALUES('{$contents}')";
mysql_query($SQL);?>
把这段代码改写成,存入到sqlite中,应该怎么写啊?
$contents = file_get_contents($url);
preg_match_all('/(<h1.*<\/table>)/iUs', $contents, $match);
$contents = $match[1][0];
$contents = sqlite_escape_string($contents);if ($db = sqlite_open('lookdb', 0666, $sqliteerror)) {
sqlite_query($db, 'CREATE TABLE page (pagetext text)');
sqlite_query($db, "INSERT INTO page (pagetext) VALUES('$contents')");
} else {
die($sqliteerror);
}
;extension=php_sqlite.dll
去掉分号。重启apache.
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll\PHPnow\php-5.2.14-Win32\ext目录下,也有:
php_sqlite.dll
php_pdo_sqlite.dll
php_pdo.dll可是还是报这个错误:
Fatal error: Call to undefined function sqlite_open() in:
echo sqlite_libversion();
echo "<br>";
echo phpversion();
?>Fatal error: Call to undefined function sqlite_libversion() in
<?php
//echo sqlite_libversion();
echo "<br>";
echo phpversion();
?>
5.2.14
<?php
if (extension_loaded('sqlite')) {
echo '支持';
}else{
echo '不支持';
}
?>
不支持我这里是用php.ini-recommended,改了也重启了,用上面的代码,是不支持。项目是PHPNOW环境的,现在是想这里做服务器,把页面存到sqlite中给客户端。