php - 在每个返回行的末尾添加一个 Edit.php 链接

Question

我正在尝试向 mysql 数据库返回的每个结果行的末尾添加一个链接，该链接会将我发送到另一个 php 页面，这将允许我编辑该行中的数据。问题是我找不到应该将链接代码添加到代码的哪一部分，这样无论返回多少结果，每行末尾都会出现一个编辑链接。

这是我目前用来检索结果的 php 代码。

<?php	
		
	echo "<table style='border: solid 1px black;'>";
	echo "<tr><th>Booking Ref</th><th>First Name</th><th>Last Name</th><th>Contact Number</th><th>Booked Date</th><th>Adults</th><th>Juniors</th><th>Paintballs</th><th>Edit</th></tr>";
	
	class TableRows extends RecursiveIteratorIterator { 
		function __construct($it) { 
			parent::__construct($it, self::LEAVES_ONLY); 
		}
	
		function current() {
			return "<td style='width:150px;border:1px solid black;'>" . parent::current(). "</td>";
		}
	
		function beginChildren() { 
			echo "<tr>"; 
		} 
	
		function endChildren() { 
			echo "</tr>" . "\n";
		} 
	} 
	
	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "login";
	
	$u_name = $_SESSION['user_name'];
	
	try {
		$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$stmt = $conn->prepare("SELECT booking_id, fname, lname, phone_number, date, adults, juniors, paintballs FROM bookings INNER JOIN users ON users.user_name = bookings.user_name WHERE users.user_name = '" . $u_name . "'"); 
		$stmt->execute();
	
		// set the resulting array to associative
		$result = $stmt->setFetchMode(PDO::FETCH_ASSOC); 
		foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) { 
			echo $v;			
		}
	}
	catch(PDOException $e) {
		echo "Error: " . $e->getMessage();
	}
	$conn = null;
	echo "</table>";
		
	?>

非常感谢任何帮助，提前致谢!

Answer 1

您可以将它放在 endChildren() 方法中。但我完全不确定您如何访问行数据(您显然需要行 ID 来编辑它)。