PDOStatement::fetchColumn

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.9.0)

PDOStatement::fetchColumn 锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷蟹锟斤拷氐锟斤拷锟斤拷锟揭伙拷小锟�

说锟斤拷

PDOStatement::fetchColumn ([ int $column_number = 0 ] ) : string

锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷蟹锟斤拷氐锟斤拷锟斤拷锟揭伙拷校锟斤拷锟斤拷没锟斤拷锟剿o拷锟津返伙拷 FALSE 锟斤拷

锟斤拷锟斤拷

column_number

锟斤拷锟斤拷锟斤拷锟斤拷锟饺★拷氐锟斤拷械锟斤拷锟斤拷锟斤拷锟斤拷郑锟斤拷锟�0锟斤拷始锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷峁┲碉拷锟斤拷锟� PDOStatement::fetchColumn() 锟斤拷取锟斤拷一锟叫★拷

锟斤拷锟斤拷值

PDOStatement::fetchColumn() 锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷蟹锟斤拷氐锟斤拷锟斤拷锟揭伙拷小锟�

Warning

锟斤拷锟绞癸拷锟� PDOStatement::fetchColumn() 取锟斤拷锟斤拷锟捷o拷锟斤拷没锟叫办法锟斤拷锟斤拷同一锟叫碉拷锟斤拷锟斤拷一锟叫★拷

锟斤拷锟斤拷

Example #1 锟斤拷锟斤拷锟斤拷一锟叫的碉拷一锟斤拷

<?php
$sth 
$dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* 锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷谢锟饺★拷锟揭伙拷锟�  */
print("锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷谢锟饺★拷锟揭伙拷校锟絓n");
$result $sth->fetchColumn();
print(
"name = $result\n");

print(
"锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷谢锟饺★拷诙锟斤拷校锟絓n");
$result $sth->fetchColumn(1);
print(
"colour = $result\n");
?>

锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�

锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷谢锟饺★拷锟揭伙拷校锟�
name = lemon
锟接斤拷锟斤拷锟斤拷械锟斤拷锟揭伙拷谢锟饺★拷诙锟斤拷校锟�
colour = red

锟轿硷拷

  • PDO::query() - 执锟斤拷 SQL 锟斤拷洌拷锟� PDOStatement 锟斤拷锟斤拷锟斤拷式锟斤拷锟截斤拷锟斤拷锟�
  • PDOStatement::fetch() - 锟接斤拷锟斤拷锟斤拷谢锟饺★拷锟揭伙拷锟�
  • PDOStatement::fetchAll() - 锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷械锟斤拷锟斤拷锟�
  • PDO::prepare() - 准锟斤拷要执锟叫碉拷锟斤拷洌拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
  • PDOStatement::setFetchMode() - 为锟斤拷锟斤拷锟斤拷锟侥拷系幕锟饺∧J斤拷锟�