php 显示一张数据表,php-以表格形式显示插入数据库的数据

我创建了此表,该表的一部分从用户那里获取输入并将其保存在数据库中.

我试图使用户放置在标签中的数据保持显示状态.基本上,输入形式将同时成为输入/输出源.有什么帮助吗？

switch ($selected){

case 'University':

$stmt = $conn->prepare("SELECT employees.afnumber,employees.name,employees.actualpost,university.brevet FROM employees,university WHERE employees.status='Employed' AND employees.afnumber=university.afnumber ORDER BY employees.afnumber DESC LIMIT :start,:end");

$stmt->bindParam(':start', $pages->limit_start, PDO::PARAM_INT);

$stmt->bindParam(':end', $pages->limit_end, PDO::PARAM_INT);

$stmt->execute();

$result = $stmt->fetchAll();

$selectedtable = "

\n";

$selectedtable .= "

Description	A	B	C	D

foreach($result as $row) {

$selectedtable .= "

Brevet".$row[0]."".$row[2]."".$row[3]."Baccalaureat/BT".$row[1]."$row[2]$row[3]License/TS".$row[1]."".$row[2]."$row[3]M1".$row[1]."".$row[2]."".$row[3]."Master's Degree".$row[1]."".$row[2]."".$row[3]."PHD".$row[1]."".$row[2]."".$row[3]."";

}

$selectedtable .= "

\n";

$selectedtable .= "\n";

$selectedtable .= "

\n";

if(isset($_POST['submit']))

{ $brevet1 = $_POST['Brevet1'];

$baccalaureatbt = $_POST['Baccalaureatbt'];

$licensets = $_POST['Licensets'];

$m1 = $_POST['M1'];

$mastersdegree = $_POST['Mastersdegree'];

$phd = $_POST['Phd'];

$sql1="SELECT Brevet1,Baccalaureatbt,Licensets,M1,Mastersdegree,Phd FROM university";

if ($result=mysqli_query($con,$sql1))

{

$rowcount=mysqli_num_rows($result);

}

if($rowcount==0)

{

$sql="INSERT INTO university(Brevet1,Baccalaureatbt,Licensets,M1,Mastersdegree,Phd) VALUES('$brevet1','$baccalaureatbt','$licensets','$m1','$mastersdegree','$phd')";

$result = mysql_query($sql);

}

else

{

$sql2 = "UPDATE university SET Brevet1 = '$brevet1' , Baccalaureatbt = '$baccalaureatbt', Licensets = '$licensets', M1 = '$m1', Mastersdegree = '$mastersdegree', Phd = '$phd'";

$result2 = mysql_query($sql2);

}

}

break;