Laravel获取数据表字段注释的两种方法 [复制链接]

通过doctrine/dbal包来实现，首先通过composer安装doctrine/dbal包：

composer require doctrine/dbal
1
接下来就简单多了，直接执行如下代码即可获得表字段注释：

// 获取整张表的详细信息
$columns = \DB::getDoctrineSchemaManager()->listTableDetails('table-name');
// 获取年龄字段的注释
$ageColumnComment = $columns->getColumn('age')->getComment();
// 获取性别字段的注释
$sexColumnComment = $columns->getColumn('sex')->getComment();
---------------------
作者：Abbotton
来源：CSDN
原文：https://blog.csdn.net/abbotton/article/details/80860353
版权声明：本文为博主原创文章，转载请附上博文链接！

use Illuminate\Support\Facades\Schema;
use DB;

public function getDatabaseColumns() {
    $tables = DB::select('show tables');
    $tables = array_column($tables, 'Tables_in_new_bcc_web');
    $columns = ['email', 'user_name', 'nick_name', 'first_name', 'last_name'];
    // dd(Schema::getConnection());
    foreach ($tables as $key => $value) {
        foreach ($columns as $k => $v) {
            if (Schema::hasColumn($value, $v)) {
                $table[] = $value;
            };
        }
        // $columns[] = Schema::getColumnListing('users');
    }
    $table = array_unique($table);
    dd($table);
}
---------------------
作者：SHUIPING_YANG
来源：CSDN
原文：https://blog.csdn.net/zhezhebie/article/details/78589812
版权声明：本文为博主原创文章，转载请附上博文链接！

Schema::getColumnListing('user');
Schema::hasColumn($table, $column_name)

public function getDatabaseColumns() {
    $tables = array_map('reset', \DB::select('SHOW TABLES'));
    $columns = ['email', 'user_name', 'nick_name', 'first_name', 'last_name'];
    foreach ($tables as $key => $value) {
        foreach ($columns as $k => $v) {
            if (Schema::hasColumn($value, $v)) {
                $table[] = $value;
            };
        }
    }
    $table = array_unique($table);
    dd($table);
}

$schema = \DB::getDoctrineSchemaManager();
$columns = $schema->listTableColumns('table_name'); //get table columns
foreach ($table->getColumns() as $column) { //run loop
   $column->getName(). - .$column->getType()->getName(); //here you can define your inputes
}

$model = new ExampleModel();
$model->getConnection()->getSchemaBuilder()->getColumnListing($model->getTable());

public function getColumnsNames() {
    return (array) $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());
}

$user = new User();

// 调用方法
$user->getTableColumns();


/**
  * 获取表结构
  * @return array
  */
public function getTableColumns()
{
     return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());
}

laravel 获取所有表名


$tables = DB::connection()->getDoctrineSchemaManager()->listTableNames();

use Illuminate\Support\Facades\Schema;
2、

$columns = Schema::getColumnListing('admins');

1、引用  use Illuminate\Support\Facades\Schema;2、$tables = Schema::getConnection()->getDoctrineSchemaManager()->listTableNames();3、$columns = Schema::getConnection()->getDoctrineSchemaManager()->listTableColumns('表名‘)；4、获取表的注释：    foreach ($columns as $column) {            $comment = $column->getComment();    }

作者：程序小白菜
链接：https://www.jianshu.com/p/6119cf5e18be
来源：简书
简书著作权归作者所有，任何形式的转载都请联系作者获得授权并注明出处。