使用codeigniter从数据库中检索视频和背景图像

Question

How do I obtain an image and use it as a background from my database and I obtain a video and display it on my site. I am using codeigntier.

Answer 1

You can store the image path in any db field.

• Store the image or video url in database table. Ex. tbl_settings
• Query the database and get the image or video URL.
• Use the image or video url in css background property.

Ex:

$this->db->select('settings_value')->from('tbl_settings');
$this->db->where(array('settings_key'=>'home_bg'));
$res=$this->db->get();
$home_bg='no-img.jpg';
if($res)
{
   $home_bg=$res->row();
}

Write the following CSS code in your view file.

<style>
#home_bg_style{
   background-image: url("<?php echo $home_bg;?>");
   height:100px;
}
</style>

In View file HTML

<div id="home_bg_style">

</div>

Similarly, you can implement for Video.