PHP echo同名的POST变量

Question

Ok i have two tables with a left join. Let call table one "people" and the second table "dog". I have left joined the tables by an id:

"SELECT * FROM people
      LEFT JOIN dog ON people.PK = dog.fk"; 

My problem is that both tables have a column title "name." When i echo back out the $_POST['name'] variable it give the same value for both fields I tried

echo $_POST['people.name']
echo $_POST['dog.name']

but this isn't returning any data so this must be incorrect. Can someone help me fix my problem without having to change my column names. Thanks you.

Answer 1

The $_POST superglobal contains data submitted from a form. It does not contain data from database queries. You probably do something like this (pseudocode):

$result = database_query (
    "SELECT * FROM people LEFT JOIN dog ON people.PK = dog.fk"
);

The data you want is now contained in the variable named $result. How you access it will depend on your database access method, but typically you would fetch a row from the result object, perhaps as an associative array.

$row = database_fetch_assoc($result);

Then the array $row would contain your data.

echo $row['name'];

You might need to alias the column names in the query in order to be able to access the values of both name columns.