php PDO howto columns from table
$result = $db->query('select * from table limit 1');
$fields = array_keys($result->fetch(PDO::FETCH_ASSOC));
php PDO howto columns from table
$result = $db->query('select * from table limit 1');
$fields = array_keys($result->fetch(PDO::FETCH_ASSOC));
pdo get table column names
<?php
//Our MySQL connection details.
define('MYSQL_SERVER', 'localhost');
define('MYSQL_DATABASE_NAME', 'test');
define('MYSQL_USERNAME', 'root');
define('MYSQL_PASSWORD', '');
//Instantiate the PDO object and connect to MySQL.
$pdo = new PDO(
'mysql:host=' . MYSQL_SERVER . ';dbname=' . MYSQL_DATABASE_NAME,
MYSQL_USERNAME,
MYSQL_PASSWORD
);
//The name of the table that we want the structure of.
$tableToDescribe = 'users';
//Query MySQL with the PDO objecy.
//The SQL statement is: DESCRIBE [INSERT TABLE NAME]
$statement = $pdo->query('DESCRIBE ' . $tableToDescribe);
//Fetch our result.
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
//The result should be an array of arrays,
//with each array containing information about the columns
//that the table has.
var_dump($result);
//For the sake of this tutorial, I will loop through the result
//and print out the column names and their types.
foreach($result as $column){
echo $column['Field'] . ' - ' . $column['Type'], '<br>';
}
php PDO howto columns from table
$result = $db->query('select * from table limit 1');
$fields = array_keys($result->fetch(PDO::FETCH_ASSOC));
pdo get table column names
<?php
//Our MySQL connection details.
define('MYSQL_SERVER', 'localhost');
define('MYSQL_DATABASE_NAME', 'test');
define('MYSQL_USERNAME', 'root');
define('MYSQL_PASSWORD', '');
//Instantiate the PDO object and connect to MySQL.
$pdo = new PDO(
'mysql:host=' . MYSQL_SERVER . ';dbname=' . MYSQL_DATABASE_NAME,
MYSQL_USERNAME,
MYSQL_PASSWORD
);
//The name of the table that we want the structure of.
$tableToDescribe = 'users';
//Query MySQL with the PDO objecy.
//The SQL statement is: DESCRIBE [INSERT TABLE NAME]
$statement = $pdo->query('DESCRIBE ' . $tableToDescribe);
//Fetch our result.
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
//The result should be an array of arrays,
//with each array containing information about the columns
//that the table has.
var_dump($result);
//For the sake of this tutorial, I will loop through the result
//and print out the column names and their types.
foreach($result as $column){
echo $column['Field'] . ' - ' . $column['Type'], '<br>';
}
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us