Location: PHPKode > scripts > Datamodul > result.html
<p><u>DATAMODUL INFORMATION</u><p><table border="0" cellspacing="2" cellpadding="2"><tr bgcolor="#DDDDDD"><td width="200"><b>DATABASES:</b></td></tr><tr bgcolor="#DDDDDD"><td>information_schema</td></tr><tr bgcolor="#DDDDDD"><td>coffeebreak</td></tr><tr bgcolor="#DDDDDD"><td>db_diakmunka</td></tr><tr bgcolor="#DDDDDD"><td>db_eep</td></tr><tr bgcolor="#DDDDDD"><td>db_publikacio</td></tr><tr bgcolor="#DDDDDD"><td>db_tiliath</td></tr><tr bgcolor="#DDDDDD"><td>dd</td></tr><tr bgcolor="#DDDDDD"><td>mysql</td></tr><tr bgcolor="#DDDDDD"><td>test</td></tr><tr height="10"><td></td></tr><tr bgcolor="#DDDDDD"><td width="200"><b>CONNECTED SERVER:</b></td><td width="200">localhost</td></tr><tr bgcolor="#DDDDDD"><td><b>USER NAME:</b></td><td>root</td></tr><tr bgcolor="#DDDDDD"><td><b>SELECTED DATABASE:</b></td><td>coffeebreak</td></tr><tr height="10"><td></td></tr><tr bgcolor="#DDDDDD"><td><b>TABLES:</b></td><td><b>FIELDS:</b></td><td width="200"><b>TYPES:</b></td><td width="200"><b>NULLS:</b></td><td width="200"><b>KEYS:</b></td><td width="200"><b>DEFAULTS:</b></td><td width="200"><b>EXTRAS:</b></td></tr><tr><td bgcolor="#DDDDDD">coffees</td><td bgcolor="#DDDDDD">cof_name</td><td bgcolor="#DDDDDD">varchar(32)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD">PRI</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">sup_id</td><td bgcolor="#DDDDDD">int(11)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD">MUL</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">price</td><td bgcolor="#DDDDDD">float</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">sales</td><td bgcolor="#DDDDDD">int(11)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD">0</td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">total</td><td bgcolor="#DDDDDD">int(11)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD">0</td><td bgcolor="#DDDDDD"></td></tr><tr><td></td></tr><tr><td bgcolor="#DDDDDD">supplier</td><td bgcolor="#DDDDDD">sup_id</td><td bgcolor="#DDDDDD">int(11)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD">PRI</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">sup_name</td><td bgcolor="#DDDDDD">varchar(20)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">street</td><td bgcolor="#DDDDDD">varchar(20)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">city</td><td bgcolor="#DDDDDD">varchar(20)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">state</td><td bgcolor="#DDDDDD">varchar(2)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td><td bgcolor="#DDDDDD">zip</td><td bgcolor="#DDDDDD">varchar(5)</td><td bgcolor="#DDDDDD">NO</td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td><td bgcolor="#DDDDDD"></td></tr><tr><td></td></tr></table><p><u>DATAMODUL EXECUTED SELECT RESULT INFORMATION</u><p><table border="0" cellspacing="2" cellpadding="2"><tr bgcolor="#DDDDDD"><td width="200"><b>SELECT STRING:</b></td><td width="200">SELECT * FROM coffees</td></tr></table><table border="0" cellspacing="2" cellpadding="2"><tr height="10"><td></td></tr><tr bgcolor="#DDDDDD"><td></td><td><b>cof_name</b></td><td><b>sup_id</b></td><td><b>price</b></td><td><b>sales</b></td><td><b>total</b></td></tr><tr bgcolor="#DDDDDD"><td>1</td><td>Colombian</td><td>101</td><td>7.99</td><td>0</td><td>0</td></tr><tr bgcolor="#DDDDDD"><td>2</td><td>Colombian_Decaf</td><td>101</td><td>8.99</td><td>0</td><td>0</td></tr><tr bgcolor="#DDDDDD"><td>3</td><td>Espresso</td><td>150</td><td>9.99</td><td>0</td><td>0</td></tr><tr bgcolor="#DDDDDD"><td>4</td><td>French_Roast</td><td>49</td><td>8.99</td><td>0</td><td>0</td></tr><tr bgcolor="#DDDDDD"><td>5</td><td>French_Roast_Decaf</td><td>49</td><td>9.99</td><td>0</td><td>0</td></tr></table><p><u>DATAMODUL EXECUTED SELECT RESULT INFORMATION</u><p><table border="0" cellspacing="2" cellpadding="2"><tr bgcolor="#DDDDDD"><td width="200"><b>SELECT STRING:</b></td><td width="200">SELECT c.*, c.cof_name as cname, supplier.sup_name FROM coffees c, supplier WHERE c.sup_id=supplier.sup_id</td></tr></table><table border="0" cellspacing="2" cellpadding="2"><tr height="10"><td></td></tr><tr bgcolor="#DDDDDD"><td></td><td><b>cof_name</b></td><td><b>sup_id</b></td><td><b>price</b></td><td><b>sales</b></td><td><b>total</b></td><td><b>cname</b></td><td><b>sup_name</b></td></tr><tr bgcolor="#DDDDDD"><td>1</td><td>French_Roast</td><td>49</td><td>8.99</td><td>0</td><td>0</td><td>French_Roast</td><td>Superior Coffee</td></tr><tr bgcolor="#DDDDDD"><td>2</td><td>French_Roast_Decaf</td><td>49</td><td>9.99</td><td>0</td><td>0</td><td>French_Roast_Decaf</td><td>Superior Coffee</td></tr><tr bgcolor="#DDDDDD"><td>3</td><td>Colombian</td><td>101</td><td>7.99</td><td>0</td><td>0</td><td>Colombian</td><td>Acme, Inc.</td></tr><tr bgcolor="#DDDDDD"><td>4</td><td>Colombian_Decaf</td><td>101</td><td>8.99</td><td>0</td><td>0</td><td>Colombian_Decaf</td><td>Acme, Inc.</td></tr><tr bgcolor="#DDDDDD"><td>5</td><td>Espresso</td><td>150</td><td>9.99</td><td>0</td><td>0</td><td>Espresso</td><td>The High Ground</td></tr></table>
Return current item: Datamodul