会员
周边
捐助
新闻
博问
闪存
赞助商
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
alex hu
你若盛开,清风自来!
博客园
首页
新随笔
联系
订阅
管理
PHP5+SQLITE3+PDO实例
连接
Code
$dsn
=
'
sqlite:tools.db
'
;
try
{
$dbh
=
new
PDO(
$dsn
);
}
catch
(PDOException
$e
)
{
echo
'
Connection failed:
'
.
$e
->
getMessage();
$dbh
=
null
;
}
不带参数查询(1)
Code
1
$sql
=
"
SELECT visitor FROM guestbook ORDER BY id DESC
"
;
2
foreach
(
$dbh
->
query(
$sql
)
as
$rs
) {
3
echo
(
$rs
[
0
]
.
"
<br>\n
"
);
#
或者 echo($rs["visitor"]);
4
}
不带参数查询(2)
Code
1
$sth
=
$dbh
->
prepare(
"
SELECT visitor FROM guestbook
"
);
2
$sth
->
execute();
3
$result
=
$sth
->
fetch(PDO
::
FETCH_ASSOC);
4
print_r
(
$result
[
"
visitor
"
]);
5
print
(
"
\n
"
);
带参数查询
Code
1
$sql
=
'
SELECT visitor, email
2
FROM guestbook
3
WHERE visitor = :visitor
'
;
4
$sth
=
$dbh
->
prepare(
$sql
,
array
(PDO
::
ATTR_CURSOR
=>
PDO
::
CURSOR_FWDONLY));
5
$sth
->
execute(
array
(
'
:visitor
'
=>
'
alex
'
));
6
$result
=
$sth
->
fetchAll();
7
print_r
(
$result
) ;
Code
1
$sql
=
'
SELECT visitor, email
2
FROM guestbook
3
WHERE visitor = ?
'
;
4
$sth
=
$dbh
->
prepare(
$sql
,
array
(PDO
::
ATTR_CURSOR
=>
PDO
::
CURSOR_FWDONLY));
5
$sth
->
execute(
array
(
'
alex
'
));
6
$result
=
$sth
->
fetchAll();
7
print_r
(
$result
) ;
Code
1
$visitor
=
'
alex
'
;
2
$sth
=
$dbh
->
prepare(
'
SELECT visitor, email
3
FROM guestbook
4
WHERE visitor = :visitor
'
);
5
$sth
->
bindParam(
'
:visitor
'
,
$visitor
,
PDO
::
PARAM_STR);
6
$sth
->
execute();
7
8
foreach
(
$sth
->
fetchAll()
as
$row
)
9
{
10
echo
(
$row
[
0
]
.
"
<br>\n
"
);
11
}
posted @
2008-12-06 14:55
alex hu
阅读(
477
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
公告