this is example

prepare("SELECT * FROM tbl_settings WHERE id=1"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { $cta_title = $row['cta_title']; $cta_content = $row['cta_content']; $cta_read_more_text = $row['cta_read_more_text']; $cta_read_more_url = $row['cta_read_more_url']; $cta_photo = $row['cta_photo']; $featured_product_title = $row['featured_product_title']; $featured_product_subtitle = $row['featured_product_subtitle']; $latest_product_title = $row['latest_product_title']; $latest_product_subtitle = $row['latest_product_subtitle']; $popular_product_title = $row['popular_product_title']; $popular_product_subtitle = $row['popular_product_subtitle']; $total_featured_product_home = $row['total_featured_product_home']; $total_latest_product_home = $row['total_latest_product_home']; $total_popular_product_home = $row['total_popular_product_home']; $home_service_on_off = $row['home_service_on_off']; $home_welcome_on_off = $row['home_welcome_on_off']; $home_featured_product_on_off = $row['home_featured_product_on_off']; $home_latest_product_on_off = $row['home_latest_product_on_off']; $home_popular_product_on_off = $row['home_popular_product_on_off']; } ?>
prepare("SELECT * FROM tbl_service"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?>
<?php echo $row['title']; ?>

prepare("SELECT * FROM tbl_product WHERE p_is_featured=? AND p_is_active=? LIMIT ".$total_featured_product_home); $statement->execute(array(1,1)); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?>

Rs Rs

prepare("SELECT * FROM tbl_rating WHERE p_id=?"); $statement1->execute(array($row['p_id'])); $tot_rating = $statement1->rowCount(); if($tot_rating == 0) { $avg_rating = 0; } else { $result1 = $statement1->fetchAll(PDO::FETCH_ASSOC); foreach ($result1 as $row1) { $t_rating = $t_rating + $row1['rating']; } $avg_rating = $t_rating / $tot_rating; } ?> '; } elseif($avg_rating == 2.5) { echo ' '; } elseif($avg_rating == 3.5) { echo ' '; } elseif($avg_rating == 4.5) { echo ' '; } else { for($i=1;$i<=5;$i++) { ?> $avg_rating): ?>
Out Of Stock

Add to Cart

prepare("SELECT * FROM tbl_product WHERE p_is_active=? ORDER BY p_id DESC LIMIT ".$total_latest_product_home); $statement->execute(array(1)); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?>

Rs Rs

prepare("SELECT * FROM tbl_rating WHERE p_id=?"); $statement1->execute(array($row['p_id'])); $tot_rating = $statement1->rowCount(); if($tot_rating == 0) { $avg_rating = 0; } else { $result1 = $statement1->fetchAll(PDO::FETCH_ASSOC); foreach ($result1 as $row1) { $t_rating = $t_rating + $row1['rating']; } $avg_rating = $t_rating / $tot_rating; } ?> '; } elseif($avg_rating == 2.5) { echo ' '; } elseif($avg_rating == 3.5) { echo ' '; } elseif($avg_rating == 4.5) { echo ' '; } else { for($i=1;$i<=5;$i++) { ?> $avg_rating): ?>
Out Of Stock

Add to Cart

prepare("SELECT * FROM tbl_product WHERE p_is_active=? ORDER BY p_total_view DESC LIMIT ".$total_popular_product_home); $statement->execute(array(1)); $result = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { ?>

Rs Rs

prepare("SELECT * FROM tbl_rating WHERE p_id=?"); $statement1->execute(array($row['p_id'])); $tot_rating = $statement1->rowCount(); if($tot_rating == 0) { $avg_rating = 0; } else { $result1 = $statement1->fetchAll(PDO::FETCH_ASSOC); foreach ($result1 as $row1) { $t_rating = $t_rating + $row1['rating']; } $avg_rating = $t_rating / $tot_rating; } ?> '; } elseif($avg_rating == 2.5) { echo ' '; } elseif($avg_rating == 3.5) { echo ' '; } elseif($avg_rating == 4.5) { echo ' '; } else { for($i=1;$i<=5;$i++) { ?> $avg_rating): ?>
Out Of Stock

Add to Cart