SQLite Tutorial in PHP
	
    
    
	 
 SQLite Tutorial in PHP
 SQLite is an SQL database manager used locally or on a website, and compatible
    in particularly with PHP. 
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite table
.
    Creating a table. Deleting a table. Adding a record. Reading a record.
How to find and update a post
.
      Filling a database. Dump of the whole base. Finding a record by ID. Searching a post. Updating a post.
Download
The complete source code of the scripts
    in a ZIP archive. 
More
SQLite and multi-users. How to treat concurrency issue with SQLite
. 
    
     
	
	
    
    
	相关文档:
        
    
    php google baidu 分页
<?php
/**
作者:
潇湘博客 http://blog.csdn.net/fkedwgwy
时间:
2009-11-26
php技术群:
37304662
使用方法:
include_once'Pager.class.php';
$pager=new Pager();
if(isset($_GET['page']))
$pager->setCurrentPage($_GET['page']);
else
$pager->setCurrentPage(1);
 ......
	
    
        
    
        1、用PHP打印出前一天的时间格式是2006-5-10 22:21:21(2分)
  2、echo(),print(),print_r()的区别(3分)
  3、能够使HTML和PHP分离开使用的模板(1分)
  4、使用哪些工具进行版本控制?(1分)
  5、如何实现字符串翻转?(3分)
  --------------------------------------------------------------- ......
	
    
        
    
    <?php
// open database connection
@ $db = new mysqli($host, $user, $password, $database_name);
if (mysql_connect_error())
{
	echo '';
	exit;
}
// query 
$result = $db->query($sql);
$num_results = $db->num_rows;
// data
$row = $result->fetch_assoc(); // row is array, $row['id' ......
	
    
        
    
    cookie默认不能存数组,所以下面的写法是错误的。
 
<?php
$arr = array(1,2,3); 
setcookie('a',$arr); 
$arr = array(1,2,3);
setcookie('a',$arr);
?> 
报错如下:
Warning: setcookie() expects parameter 2 to be string, array given in
但是PHP可以把同名且后面以[]结尾的cookie解析为数组。在 ......