assign sql results with same name to array

Question

I have a general question regarding the assigning of sql results to a arrays. What should I do when I want to assign some results to an array and when I am joining two or more tables and some columns got the same name:

Example:

$sqlExample = "select u.first_name, o.first_name from tbl_user u join tbl_owner o on u.user_id = o.user_id where u.user_id = $user_id;";
       ...
$userFirstName[$var] = $result['first_name'];
$ownerFirstName[$var] =

I know, that this is not a great example, but I hope that you are understanding my question.. I thought I could use something like the table prefix for the results, but it didn't worked.

-- Just an example not the code I am using/

Little Bobby says your script is at risk for SQL Injection Attacks.. Even escaping the string is not safe! — Jay Blanchard
– Jay Blanchard, Commented Jul 12, 2017 at 12:55
for example: select i.first_name uFirst_name, o.first_name oFirstname,... — Jeff
– Jeff, Commented Jul 12, 2017 at 12:55
Hi Jay, yes I know - just an example. In my project I am using something like: $stmt = $db->prepare('update first_name set name = ? where id = ?'); $stmt->bind_param('si',$name,$id); $stmt->execute(); — Jan
– Jan, Commented Jul 12, 2017 at 12:58

David · Accepted Answer · 2017-07-12 12:55:45Z

2

Alias your columns in the results:

select u.first_name as user_first_name, o.first_name as owner_first_name from ...

Then use those aliases in your code:

$userFirstName[$var] = $result['user_first_name'];
$ownerFirstName[$var] = $result['owner_first_name'];

answered Jul 12, 2017 at 12:55

David

221k42 gold badges247 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kevin P · Accepted Answer · 2017-07-12 12:57:40Z

0

$sqlExample = "SELECT
  u.first_name AS user_first_name,
  o.first_name AS owner_first_name
FROM tbl_user u
  JOIN tbl_owner o ON u.user_id = o.user_id
WHERE u.user_id = $user_id";

$result['user_first_name'];
$result['owner_first_name'];

answered Jul 12, 2017 at 12:57

Kevin P

6053 silver badges9 bronze badges

Collectives™ on Stack Overflow

assign sql results with same name to array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related