<?php
$d = array(
array(
"id", "int(10) unsigned", "NO", "PRI", "auto_increment"
), array(
"title", "varchar(32)", "NO"
), array(
"author", "varchar(32)", "NO"
), array(
"category", "tinyint(3) unsigned", "NO"
), array(
"date", "datetime", "NO"
), array(
"post_ip", "int(10) unsigned", "NO"
), array(
"approved_by", "varchar(32)", "NO"
), array(
"text", "text", "NO"
)
);
$cols = array();
foreach ($d as $row) {
$id = 0;
foreach($row as $col) {
if (!isset($cols[$id])) $cols[$id] = 0;
if ($cols[$id] < strlen($col)) {
$cols[$id] = strlen($col);
}
$id++;
}
}
print_R($cols);
/*
id # int(10) unsigned # NO # PRI # auto_increment #
[19:44] <teehee> title # varchar(32) # NO #
[19:44] <teehee> author # varchar(32) # NO #
[19:44] <teehee> category # tinyint(3) unsigned # NO #
[19:44] <teehee> date # datetime # NO #
[19:44] <teehee> post_ip # int(10) unsigned # NO #
[19:44] <teehee> approved_by # varchar(32) # YES #
[19:44] <teehee> text # text # NO #
*/
- Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.24 - 5.5.35, 5.6.7 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.5 - 7.2.33, 7.3.12 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- Array
(
[0] => 11
[1] => 19
[2] => 2
[3] => 3
[4] => 14
)
preferences:
238.13 ms | 406 KiB | 315 Q