print data by reusable code in PHP

---

database namd : student table name : stud table name : course Def: print data by reusable code and table name as per given can have any fields

---

<?php
$link=mysql_connect("localhost","root","");
mysql_select_db("student");
$res=mysql_query("select * from stud");
printdata($res);

echo "<hr>";
$res=mysql_query("select * from tblcourse");
printdata($res);

function printdata($datas)
{
echo "<table border=1>";
while($row=mysql_fetch_array($datas,MYSQL_NUM))
{
echo "<tr>";
foreach($row as $k=>$v)
{
echo "<td>",$v,"</td>";
}
echo "</tr>";
}
echo "</table>";

}
?>

mysql with php connection sample programme

---

database name :dbstud
table name : tblstud
fields
rno tinyint autoincrement and primary key
name varchar 20
gender enum "m","f"
city varchar 20

---

<?php
$link=mysql_connect("localhost","root","");

$db=mysql_select_db("dbstud");

$res=mysql_query("select *from tblstud");
echo $res,"<BR>";
echo "<table border=1>";
while($row=mysql_fetch_array($res,MYSQL_NUM))
{
echo "<TR bgcolor='yellow'>";
foreach($row as $k=>$v)
{

if($k == 2)
{
if($v=="f")
{
echo "<td bgcolor='pink'>Female</td>";
}
else
{
echo "<td bgcolor='cyan'>Male</td>";
}
}
else
{
echo "<td>",$v,"</td>";
}

}

echo "</TR>";
}
echo "<table>";
?>

ADVANCE SOFTWARE ENG. MSCIT - III

Advance software engineering MSc. IT & CA - III

SEM-3 Descriptive Question's Bank

1. UNIT-1
2. UNIT-2
3. UNIT-3
4. UNIT-4
5. UNIT-5
6. UNIT-6 & 7

---

• Session 1 presentation
• Session 2 Presentation
• Session 3 Presentation
• Session 4 Presentation
• Session 5 Presentation (UML)
• Session 6 Presentation 
• Session 7 Presentation
• Session 8 Presentation
• Session 9 Presentation
• Session 10 Presentation
• Session 12 Presentation
• Session 13 Presentation
• Session 14 Presentation
• Session 15 Presentation
• Session 16 Presentation
• Session 17 Presentation
• Session 18 Presentation
• Design patterns

---