PHP Help Needed.

Emmanuel A · Oct 13, 2020

Actually am not a pro in PHP and at times i run into a some crazy issue i do find hard to get a solution. here is my code

HTML:

$query = ("SELECT users.id, users.fname, users.lname, transfers.sender_id, transfers.beneficiary_id, transfers.amount, transfers.date_posted from transfers INNER JOIN users ON users.id=transfers.sender_id WHERE users.id='".$id."' ORDER BY transfers.date_posted DESC ");

Code:

<?php $i=1; while($row = $result->fetch_assoc()){ ?>
    <tr>
        <td><?= $i++ ?></td>
        <td><?= $row['fname'].' '.$row['lname'] ?></td>
        <td><?= $row['beneficiary_id'] ?></td>
        <td><?= $row['amount'] ?></td>
        <td><?= $row['date_posted'] ?></td>
    </tr>
<?php } ?>

"Beneficiary Name is in the Users Table."
"Beneficiary ID is from the transfer Table"
My problem is, i don't want to output beneficiary ID but instead output the Beneficiary name.

Thanks in advance....

Heiko · Oct 13, 2020

supereek · Oct 13, 2020

And where is that 'Beneficiary name' you are talking about in your query? I only see variable transfers.beneficiary_id being pulled...

Emmanuel A · Oct 13, 2020

supereek said:
And where is that 'Beneficiary name' you are talking about in your query? I only see variable transfers.beneficiary_id being pulled...

Beneficiary Name is in the Users Table.

Gogol · Oct 13, 2020

Your db can be hacked anytime. #JustSaying

ALWAYS, ALWAYS parameterize your SQL queries.

supereek · Oct 13, 2020

I think you need to update your query, you aren't asking this from the DB yet. Remember that you are using SELECT > specific values.. not SELECT ALL. So add that value to the selected query variables.

693840 · Oct 13, 2020

Emmanuel A said:
Beneficiary Name is in the Users Table.

It's a bit hard to give an answer here.
Could you show an ERD of your database tables?

Emmanuel A · Oct 13, 2020

Gogol said:
Your db can be hacked anytime. #JustSaying

ALWAYS, ALWAYS parameterize your SQL queries.

Okay thanks

Emmanuel A · Oct 13, 2020

Blackhat Lifter said:
It's a bit hard to give an answer here.
Could you show an ERD of your database tables?

What do you mean by ERD?

Gogol · Oct 13, 2020

Emmanuel A said:
Okay thanks

Try it yourself may be

In place of ID pass this:

1; DROP table transfers;#

Bamm..

Emmanuel A · Oct 13, 2020

Gogol said:
Try it yourself may be

In place of ID pass this:

1; DROP table transfers;

Bamm..

No way am gonna try that shit. Drop what!!!!!!

Gogol · Oct 13, 2020

Emmanuel A said:
No way am gonna try that shit. Drop what!!!!!!

Well, your user might. That's why..

On topic, you are probably looking for LEFT JOIN (or JOIN in general) ON the beneficiary table. For example:

SELECT t.a,t.b, b.name FROM transfer t LEFT JOIN beneficiary b ON b.id = t.something

b.name is the column you are looking for.

scrapingwebsite · Nov 4, 2020

$query = ("SELECT users.id, users.fname, users.lname, transfers.sender_id, transfers.beneficiary_id, transfers.beneficiary_name, transfers.amount, transfers.date_posted from transfers INNER JOIN users ON users.id=transfers.sender_id WHERE users.id='".$id."' ORDER BY transfers.date_posted DESC ");

<?php $i=1; while($row = $result->fetch_assoc()){ ?>
<tr>
<td><?= $i++ ?></td>
<td><?= $row['fname'].' '.$row['lname'] ?></td>
<td><?= $row['beneficiary_name'] ?></td>
<td><?= $row['amount'] ?></td>
<td><?= $row['date_posted'] ?></td>
</tr>
<?php } ?>

PS: replace "beneficiary_name" with the column name, I don;'t know if it's right

PHP Help Needed.

Emmanuel A

Junior Member

Heiko

Super Moderator

supereek

Power Member

Emmanuel A

Junior Member

Gogol

Administrator

supereek

Power Member

693840

Banned - Inappropriate behavior

Emmanuel A

Junior Member

Emmanuel A

Junior Member

Gogol

Administrator

Emmanuel A

Junior Member

Gogol

Administrator

scrapingwebsite

Newbie

Main Menu

Marketplace

Making Money

BlackHat World