Friday, 16 May 2014

Data fetch from database in php

<?php
$query="select * from name of table";
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_object($result))
            {
            ?>
           <tr>
           <td align="center"><?php echo $row->ID; ?></td>
           <td align="center"><?php echo $row->Name; ?></td>
              <td align="center"><?php echo $row->Title; ?></td>
            <td align="center"><img src="<?php echo $row->Image; ?>" height="80" width="80>"></td>
            <td align="center"><?php echo $row->Descripation; ?></td>
            <td align="center"><a href="category_edit.php?id=<?php echo $row->ID; ?>">Edit</a><a href="category_del.php?id=<?php echo $row->ID; ?>">Delete</a></td>
         </tr>
            <?php
            }
            ?>

No comments :

Post a Comment