Bayron wrote:http://www.databrowser.org/databrowser/
id name type price
123451 Park's Great Hits Music 19.99
123452 Silly Puddy Toy 3.99
123453 Playstation Toy 89.95
123454 Men's T-Shirt Clothing 32.50
123455 Blouse Clothing 34.97
123456 Electronica 2002 Music 3.99
123457 Country Tunes Music 21.55
123458 Watermelon Food 8.73
<?php
// Make a MySQL Connection
$query = "SELECT type, COUNT(name) FROM products GROUP BY type";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(name)'] ." ". $row['type'] ." items.";
echo "<br />";
}
?>
There are 2 Clothing items.
There are 1 Food items.
There are 3 Music items.
There are 2 Toy items.
Enrico Maria Giordano wrote:The "problem" with web scripting languages is that the final result has to be HTML.
EMG
<?php
$KoolControlsFolder = "";
require $KoolControlsFolder."koolControls/KoolTreeView/kooltreeview.php";
$treeview = new KoolTreeView("treeview");
$treeview->scriptFolder = $KoolControlsFolder."koolControls/KoolTreeView";
$treeview->imageFolder=$KoolControlsFolder."koolControls/KoolTreeView/icons";
$root = $treeview->getRootNode();
$root->text = "My Properties";
$root->expand=true;
$root->image="woman2S.gif";
$treeview->Add("root","hardware","Hardware",false,"xpNetwork.gif","");
$treeview->Add("hardware","laptop","HP dv2500 Laptop",false,"square_blueS.gif","");
$treeview->Add("hardware","desktop","Lenovo desktop",false,"square_greenS.gif","");
$treeview->Add("hardware","lcd","Asus 19\" LCD",false,"square_redS.gif","");
$treeview->Add("root","software","Software",true,"ie.gif","");
$treeview->Add("software","os","Operating System",true,"bfly.gif","");
$treeview->Add("os","linux","Ubuntu 8.10",false,"ball_redS.gif","");
$treeview->Add("os","windows","Vista Home Edition",false,"ball_blueS.gif","");
$treeview->Add("software","office","Office",false,"doc.gif","");
$treeview->Add("office","msoffice","Microsoft Office 2007",false,"square_redS.gif","");
$treeview->Add("office","ooffice","Open Office 2.4",false,"square_greenS.gif","");
$treeview->Add("software","burning","Burn CD/DVD",false,"xpShared.gif","");
$treeview->Add("burning","nero","Nero 8",false,"triangle_yellowS.gif","");
$treeview->Add("burning","k3b","K3B <i>(on Ubuntu)</i>",false,"triangle_blueS.gif","");
$treeview->Add("software","imageeditor","Image editors",false,"goblet_bronzeS.gif","");
$treeview->Add("imageeditor","photoshop","Photoshop 10",false,"ball_glass_blueS.gif","");
$treeview->Add("imageeditor","gimp","GIMP 2.3.4",false,"ball_glass_greenS.gif","");
$treeview->Add("root","book","Books",true,"book.gif","");
$treeview->Add("book","ajax","Ajax For Dummies",false,"BookY.gif","");
$treeview->Add("book","csharp","Mastering C#",false,"BookY.gif","");
$treeview->Add("book","flash","Flash 8 Bible",false,"BookY.gif","");
$treeview->showLines = true;
$style_select = "default";
if(isset($_POST["style_select"]))
{
$style_select = $_POST["style_select"];
}
$treeview->styleFolder=$style_select;
?>
<form id="form1" method="post">
Select style:
<select id="style_select" name="style_select" onchange="submit();">
<option value="default" <?php if ($style_select=="default") echo "selected" ?> >Default</option>
<option value="vista" <?php if ($style_select=="vista") echo "selected" ?> >Vista</option>
<option value="hay" <?php if ($style_select=="hay") echo "selected" ?> >Hay</option>
<option value="inox" <?php if ($style_select=="inox") echo "selected" ?> >Inox</option>
<option value="office2007" <?php if ($style_select=="office2007") echo "selected" ?> >Office2007</option>
<option value="outlook" <?php if ($style_select=="outlook") echo "selected" ?> >Outlook</option>
<option value="silver" <?php if ($style_select=="silver") echo "selected" ?> >Silver</option>
<option value="gray" <?php if ($style_select=="gray") echo "selected" ?> >Gray</option>
<option value="graygreen" <?php if ($style_select=="graygreen") echo "selected" ?> >Graygreen</option>
<option value="pink" <?php if ($style_select=="pink") echo "selected" ?> >Pink</option>
<option value="green" <?php if ($style_select=="green") echo "selected" ?> >Green</option>
<option value="darkgray" <?php if ($style_select=="darkgray") echo "selected" ?> >Darkgray</option>
</select>
<div style="padding:10px;">
<?php echo $treeview->Render();?>
</div>
</form>
Antonio Linares wrote:March 2010
==========
* We keep quite busy working on the new FiveTech Web & Facebook development API that we expect to publish next month
Return to Off Topic / Otros temas
Users browsing this forum: No registered users and 54 guests