Viewing file: displayData.php (722 B) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<form method="get"> <?php //connects to database $con = mysql_connect("localhost","rb!bsa838mau","baserain_db838"); if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("baserain_dba838", $con);
//retrieve data from database $result = mysql_query("SELECT * FROM addmember");
Print "<table border cellpadding=3>"; while($row = mysql_fetch_array($result)) { Print "<tr>"; Print "<td>" . $row['rank'] . "</td>"; Print "<td>" . $row['name'] . "</td>"; Print "<td>" . $row['occupation'] . "</td>"; Print "<td>" . $row['pan'] . "</td>"; Print "<td>" . "<a href='editData.php?action=edit&id=" . $row['name'] . "'>Edit</a>" . "</td>";
Print "</tr>"; } echo "</table>";
?> </form>
|