sqlite_field_name

SQLiteResult::fieldName

SQLiteUnbuffered::fieldName

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)

sqlite_field_name -- SQLiteResult::fieldName -- SQLiteUnbuffered::fieldName — Returns the name of a particular field

说明

sqlite_field_name ( resource $result , int $field_index ) : string

面向对象风格 (method):

SQLiteResult::fieldName ( int $field_index ) : string

SQLiteUnbuffered::fieldName ( int $field_index ) : string

Given the ordinal column number, field_index, sqlite_field_name() returns the name of that field in the result set result.

参数

result: The SQLite result resource. This parameter is not required when using the object-oriented method.
field_index: The ordinal column number in the result set.

返回值

Returns the name of a field in an SQLite result set, given the ordinal column number; FALSE on error.

由 SQLITE_ASSOC 与 SQLITE_BOTH 返回的列名会依照 sqlite.assoc_case 配置选项的值决定大小写。

add a note

User Contributed Notes 3 notes

down

admin at psychonautical dot org ¶

8 years ago


It's not the most elegant way, but it works:

<?php
function sqlite_field_names($db, $tablename){
    $sq5=sqlite_single_query($db, "SELECT sql FROM sqlite_master WHERE tbl_name='".$tablename."'", SQLITE_NUM);
    $kommando=$sq5[0];
    $cut=strtok($kommando,"(");
    while($fieldnames[]=strtok(",")) {};
    array_pop($fieldnames);
    foreach($fieldnames as $no => $field)
        if (strpos($field, "PRIMARY KEY")){
            strtok($field,"(");
            $primary=strtok(")");
            unset($fieldnames[$no]);
        } else
            $fieldnames[$no]=strtok($field, " ");
    return $fieldnames;
}
?>

down

-1

rrf5000 at psu dot edu ¶

11 years ago


While working with SQLite using its object-oriented mode, I found need to display a column/field name without knowing what it was in advance.  I couldn't find any examples on the Internet, just this document.  So, for anyone who happens to need to do this, here's an example.

<?php

$db = "db/database.sqlite";

// create new database (OO interface)
$dbo = new SQLiteDatabase("$db");

// create table foo and insert sample data
$dbo->query("
 CREATE TABLE foo(id INTEGER PRIMARY KEY, name CHAR(255));
 INSERT INTO foo (name) VALUES('Ilia1');
 INSERT INTO foo (name) VALUES('Ilia2');
 INSERT INTO foo (name) VALUES('Ilia3');
");

$query = "SELECT * FROM foo;";

$result = $dbo->query($query) or die("Error in query");

echo "
<table border='1' cellpadding='10'>
 <tr>
  <td>".$result->fieldName(0)."</td>
  <td>".$result->fieldName(1)."</td>
 </tr>";

// iterate through the retrieved rows
while ($result->valid()) {
  // fetch current row
  $row = $result->current();
  echo "
 <tr>
  <td>".$row[0]."</td>
  <td>".$row[1]."</td>
 </tr>";
  // proceed to next row
  $result->next();
}

echo "</table>";

?>

down

-2

Jan Holeek ¶

8 years ago


This code works with SQlite version 3 databases. 
<?php
function sqlite_field_names($dbfile, $tablename){
    try
      {
    $db = new PDO("sqlite:".$dbfile);
    $sql=$db->query("SELECT sql FROM sqlite_master WHERE tbl_name='".$tablename."'");
    foreach($sql as $row)
        {
        $fields = $row["sql"];
        }
    $db = NULL;
   }
   catch(PDOException $e)
   {
    print "Exception : ".$e->getMessage();
   }
    $cut=strtok($fields,"(");
    while($fieldnames[]=strtok(",")) {};
    array_pop($fieldnames);
    foreach($fieldnames as $no => $field)
        if (strpos($field, "PRIMARY KEY")){
            strtok($field,"(");
            $primary=strtok(")");
            unset($fieldnames[$no]);
        } else
            $fieldnames[$no]=strtok($field, " ");
    return $fieldnames;
}

print_r(array_values(sqlite_field_names($dbfile, $tablename)));
?>

add a note

官方地址：https://www.php.net/manual/en/function.sqlite-field-name.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHP获取指定函数定义在哪个文件中及行号 PHP mkdir()写出来的权限与mode值不符合 adodb连接mysql多个数据库的问题 PHP-FPM进程数的设定利用PHP SOAP实现WEB SERVICE

略微加速

PHP官方手册 - 互联网笔记

sqlite_field_name

SQLiteResult::fieldName

SQLiteUnbuffered::fieldName

说明

参数

返回值

User Contributed Notes 3 notes