I have been looking all over the place for how to dump all the column names in a SQL table into a PHP array. Unfortunately all the information I have dug up no longer works with PHP 5.5 ( depreciated ) .
Does any one have a WORKING code example that can grab all the column names and dump into an array in PHP ?
$sql = mysqli_connect("127.0.0.1","root","","players");
$table = "info";
Sorry, I don't have any PHP code to show, but you should try querying from the information_schema.columns table to get the column names. There is a query example at the bottom of the link.
After a couple hours of guessing, here is the solution I came up with for my problem:
<?php
$sql = mysqli_connect("127.0.0.1","root","","players");
$table = "info";
$get = mysqli_query($sql, "SHOW COLUMNS FROM " . $table);
while ($col = mysqli_fetch_row($get)) {
echo "Existing column: " .$col[0] . "<br>";
}
?>
