Return the name of each column in MySQL database

[malikah]

Hi, I'm trying to return the name of each column in a MySQL database using PREPARED statements only.

 

Cheers.

[taquitosensei]

you can query the information_schema for your table

SELECT * FROM information_schema.COLUMNS where table_name='yourtablename'

 

[cunoodle2]

Write the queries in standard mysql statements and I will help you convert to prepared statements.

[taquitosensei]

I'm retarded and didn't see the PREPARED in bold. Ignore my post.

[malikah]

Write the queries in standard mysql statements and I will help you convert to prepared statements.

 

This worked for me procedurally:

$query = "SELECT COLUMN_NAME FROM information_schema.COLUMNS where table_name='table'";
if(mysqli_real_query($dblink, $query))
{
$result = mysqli_store_result($dblink);
while($row = mysqli_fetch_assoc($result))
{
	foreach($row as $_colName => $_colValue)
	{
		echo "{$_colValue}<br />";
	}
}
}

 

Unfortunately, I can't figure out the object-oriented equivalent. Here's my attempt:

 

$query = "SELECT COLUMN_NAME FROM information_schema.COLUMNS where table_name='table'";
if($stmt = $this->conn->prepare($query))
{
$stmt->execute();
$stmt->store_result();

while($row = $stmt->fetch())
{
	foreach($row as $_colName => $_colValue)
	{
		echo "{$_colValue}<br />";
	}
}
}

[malikah]

bump...

[malikah]

bump...

[malikah]

bump...

[malikah]

sigh... bump...

[malikah]

bump... (25 hours and 10 minutes later...)

[malikah]

bump...

[trq]

What database access object are you using?

[malikah]

What database access object are you using?

 

You mean this?

 

$private $conn;

function __construct()
{
$this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME);
}

[malikah]

bump...

[trq]

Take a look at example #1 here.