Staff engaged for Lakshmi tender
- need to list new staff IFU HR System
<php> set the necessary connection variables include (“/var/www/html/IFU/sqlconnect.php”); 20 connect to MySQL server and select the IFU database include (“/var/www/html/IFU/sqlconnect2.php”);
$db = mysql_select_db('full-moon_info_-_IFU',$connection);
$query = 'SELECT * FROM Employees where active=“YES” ORDER by EmplID'; $result = mysql_query($query);
36 the first bit of the table that we want to do once echo “<table width=90% cellpadding=1>”; echo “<tr>\n <td><b>EmplID\n <td><b>Name\n <td><b>Skill\n <td><b>Type\n <td><b>Status\n </tr>\n”; 46 a while loop to put all the data in a row at a time (pg 184)
while ($employees=mysql_fetch_array($result,MYSQL_ASSOC)) { extract($employees); echo "<tr> \n <td>$EmplID</td> \n <td>$FirstName $Surname</td> \n <td>$MainSkill</td> \n <td>$EmplType</td> \n <td>$Status</td> \n </tr> \n"; }
58 finally close off the html table echo “</table>\n”; </php> back