doufan9290 2018-06-28 17:46
浏览 55
已采纳

PHP / HTML使用两个表并获取在html表中使用的名称

i have a little problem, right now i'm making a little ticket system.

I have a table where it displayes available tickets created related to that user.

Example: User Nick has 3 tickets and it gets displayed like that.

+-----------+------------+---------+
| Ticket ID | Created by | Comment |
+-----------+------------+---------+
|     2     |     4      |  Text   | <- Ticket 1
+-----------+------------+---------+
|     3     |     2      |  Text   | <- Ticket 2
+-----------+------------+---------+
|     5     |     3      |  Text   | <- Ticket 3
+-----------+------------+---------+

Right now, i have only the userid in the column 'created by' but i want the username to be displayed instead.

I have two database tables and all users are saved in table 1 and the tickets get saved in table 2, now I need a query to get the username of the userid 4,2,3 to display the username in the HTML table but i don't know how to do that.

My current query looks like this:

$pdo->query("BEGIN");
$t = ("SELECT * FROM ticket WHERE uid='$param'");
$pdo->query("COMMIT");

To explane the 'uid', with the uid i get the tickets related to that player.

//Edit

That is not exactly that what i'm searching for, maybe i explained it a little bit wrong.

This is my ticket table: Ticket Table

First row: Ticket ID Second row: The UID identifes the user the ticket got created for Third row: the ID of the user that created the ticket.

Now i have the user table: User Table

First row: Identifes the user Third row: Is the username of the user

Now i have a html table(That's just a small part of the table): HTML Table

First row: The userid of the user created that ticket Second row: The ticket ID

Right now it displays all the tickets created for UID 76561198073236987 and instead of displaying only the ID of the user created the ticket i want to display the username.

  • 写回答

2条回答 默认 最新

  • douque8861 2018-07-02 19:55
    关注

    I solved this on my own with following Query.

    SELECT ticket.*, users.benutzername FROM ticket INNER JOIN users ON ticket.created_by=users.id WHERE uid='$param'
    

    In this example i replaced all my results with a "*" to make this query shorter.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?