Magento 1.9 – How to Display Whole Data from Database

magento-1.9

I want to display the whole data present in database in front end. I could not get how to display it in front end. However I can display a single row with the help of id. The given below is what I did

<?php
    $test_id = 3;
    $model = Mage::getModel('test/test')->load($test_id);
    echo '<tr>';
    echo '<td>'.$model->gettest_id().'</td>';
    echo '<td>'.$model->gettitle().'</td>';
    echo '<td>'.$model->getfilename().'</td>';
    echo '<td>'.$model->getcontent().'</td>';
    echo '<td>'.$model->getstatus().'</td>';
    echo '<td>'.$model->getcreated_time().'</td>';
    echo '<td>'.$model->getupdate_time().'</td>';
    echo '</tr>';
 ?>

Can anyone suggest me how to display the whole data from database.
Thanx..

Best Answer

Use below code:

<?php
    $collection= Mage::getModel('test/test')->getCollection();
    foreach($collection as $model){
      echo '<tr>';
      echo '<td>'.$model->gettest_id().'</td>';
      echo '<td>'.$model->gettitle().'</td>';
      echo '<td>'.$model->getfilename().'</td>';
      echo '<td>'.$model->getcontent().'</td>';
      echo '<td>'.$model->getstatus().'</td>';
      echo '<td>'.$model->getcreated_time().'</td>';
      echo '<td>'.$model->getupdate_time().'</td>';
      echo '</tr>';
   }
 ?>

Related Solutions

Magento – Products exist in the database but are not showing in backend or frontend

I managed to reproduce the effect. If the status doesn't have the value "1" (enabled) or "2" (disabled), the product doesn't display at all.

You can fix this as follows. Create a PHP file in the base directory named "update_status.php". Paste the following contents:

<?php
require_once 'app/Mage.php';
Mage::app()->setCurrentStore(0);

$collection = Mage::getResourceModel('catalog/product_collection');
$collection->addAttributeToFilter('status', array(
    array('nin' => array(1,2)),
    array('null' => true)
), 'left');
foreach ($collection as $product) {
    $product->addAttributeUpdate('status', 1, 0);
}

This will set the status "1" to all products which don't have a correct status. Don't forget to delete the file afterwards.

Magento 1.9 – Admin Login Error: Access Denied

In the admin_rule table there should be an entry with record

INSERT INTO `admin_rule` (`rule_id`, `role_id`, `resource_id`, `privileges`, `assert_id`, `role_type`, `permission`) VALUES
(1, 1, 'all', NULL, 0, 'G', 'allow');

For admin_role table

INSERT INTO `admin_role` (`role_id`, `parent_id`, `tree_level`, `sort_order`, `role_type`, `user_id`, `role_name`, `gws_is_all`, `gws_websites`, `gws_store_groups`) VALUES
(1, 0, 1, 1, 'G', 0, 'Administrators', 1, NULL, NULL);

And create one admin user from root file using below script and try to login with that detail and see if that work.

<?php

# Create New admin User programmatically.
require_once('./app/Mage.php');
umask(0);
Mage::app();

try {
    $user = Mage::getModel('admin/user')
            ->setData(array(
                'username' => 'admin1',
                'firstname' => 'Admin',
                'lastname' => 'Admin',
                'email' => 'admin@test.com',
                'password' => 'admin123',
                'is_active' => 1
            ))->save();
}
catch (Exception $e) {
    echo $e->getMessage();
    exit;
}

//Assign Role Id
try {
    $user->setRoleIds(array(1))  //Administrator role id is 1 ,Here you can assign other roles ids
            ->setRoleUserId($user->getUserId())
            ->saveRelations();
}
catch (Exception $e) {
    echo $e->getMessage();
    exit;
}

echo "User created successfully";
?>

Best Answer

Related Solutions

Magento – Products exist in the database but are not showing in backend or frontend

Magento 1.9 – Admin Login Error: Access Denied

Related Topic