Select Data table by select query CodeIgniter

Hi, Guys you can fetch data frome database "sql" very simple steps just follow you.

 'Controller' 

public function about_us(){
$data["result"]=$this->courses_model->fetch_data();
//print_r($data['result']->field); die();
//$this->load->model('Test');
$this->load->view('about-us',$data);
}

*

/////////////course_model

public function fetch_data()
{
return $this->db->select('field')->from('about')->get()->row();
//$query=$this->db->get("about")->row();
//$query=$this->db->query("SELECT * FROM about");
//$result = mysql_query("SELECT * FROM about ")or die(mysql_error());
//$query = mysql_fetch_array( $result );
//print_r($query); die();
return $query;
//WHERE last_name='Hart'

}


ablut-us (Html)

<section class="sec_1127024">
      <div class="container com-sp pad-bot-70">
        <div class="row">

        <div class="col-md-12">
            <div class="col-md-12">
              <h2 class="hd_112824">About Us</h2>


                <?php
                      echo $result->field;
               
                 ?>
           
              <a class="btn_112124" href="<?php echo base_url();?>Welcome/contact">Get in touch</a>
            </div>
          <!--   <div class="col-md-4 text-right">
              <img src="<?php echo base_url();?>assets/images/temp/kjhgfsdgudsgdhghd.png" class="max-width-sty">
            </div> -->
          </div>

       
        </div>
      </div>
    </section>

Select Data table by select query ...Codeiginter

Welcom....


* Welcom.... 'Controller'

public function about_us(){
$data["result"]=$this->courses_model->fetch_data();
//print_r($data['result']->field); die();
//$this->load->model('Test');
$this->load->view('about-us',$data);
}

*

/////////////course_model

public function fetch_data()
{
return $this->db->select('field')->from('about')->get()->row();
//$query=$this->db->get("about")->row();
//$query=$this->db->query("SELECT * FROM about");
//$result = mysql_query("SELECT * FROM about ")or die(mysql_error());
//$query = mysql_fetch_array( $result );
//print_r($query); die();
return $query;
//WHERE last_name='Hart'

}


ablut-us (Html)

<section class="sec_1127024">
      <div class="container com-sp pad-bot-70">
        <div class="row">

        <div class="col-md-12">
            <div class="col-md-12">
              <h2 class="hd_112824">About Us</h2>


                <?php
                      echo $result->field; Main
               
                 ?>
           
              <a class="btn_112124" href="<?php echo base_url();?>Welcome/contact">Get in touch</a>
            </div>
          <!--   <div class="col-md-4 text-right">
              <img src="<?php echo base_url();?>assets/images/temp/kjhgfsdgudsgdhghd.png" class="max-width-sty">
            </div> -->
          </div>


       
        </div>
      </div>
    </section>

Select data in table & Update data of table

HTML about.php

<form method="post" action="<?php echo base_url(); ?>admin/about"  enctype='multipart/form-data'>
                <div class="tab-inn">
                  <div class="row">
                   <div class="col-lg-12 nopadding col s12">
                      <label style="margin-top: 20px;">About Description</label>
                      <textarea class="ckeditor" cols="80" id="descen1" rows="10" name="about_description"><?php if($about->field!=''){ echo $about->field; } ?></textarea>
                      <span class="error_val"><?php echo $this->session->flashdata('about_description'); ?></span>
                      <input type="hidden" name="id" value="<?php if($about->id!=''){ echo $about->id; } ?>" id="t3">
                    </div>
                  <div class="input-field col s12">
                    <i class="waves-effect waves-light btn-large waves-input-wrapper" style="">
                      <input type="submit" class="waves-button-input" value="Add"></i>
                  </div>
                  </div>
                  <div class="clearfix"></div>
                  </div>
                  <input type="text" name="edit" value="">
</form>

>>>>>>>>>>>>>>>>>>>>admin.php

public function about($input)
{
$input=$this->input->post();

$data['about']=$this->course_model->get_about();  (select data frome table)

if(!empty($input))
{
$result=$this->course_model->about($input);
    if($result==1)
      {
$this->session->set_flashdata('success','Data Submit.');
redirect('admin/about');
      }
      else
{
$this->session->set_flashdata('success','Fill the Data Not Changes.');
redirect('admin/about');

}

}
/*if condition is true then it work ((data submit & resubmit call submit))*/

$this->load->view('admin/about',$data);  (page loader)

}
................................................

admin.course.model.php
........................................................Model.................

public function get_about()
{
return $this->db->get('about')->row(); (Select from table only 1 row)
}

public function about($input)
{
$data=array('field'=>$input['about_description']);
if($input['id']=='')
{
$query=$this->db->insert('about',$data);
}
else
{
$query=$this->db->where('id',$input['id'])->update('about',$data);
}

if($query)
{
return true;
}
else
{
return false;
}


}


Table Name : About

ID: 1;
Field :  'hello fr. data inserted in row';

route

$route['admin/about'] = 'admin/admin/about';

$route i use for shortcut....


Note ::  <?php if($about->field!=''){ echo $about->field; } ?> in text area .html field.

$about is database name

(Field) is a table row name

Rule : if

<input type="hidden" name="id" value="<?php if($about->id!=''){ echo $about->id; } ?>" id="t3">

Select data in table & Update data of table

HTML about.php

<form method="post" action="<?php echo base_url(); ?>admin/about"  enctype='multipart/form-data'>
                <div class="tab-inn">
                  <div class="row">
                   <div class="col-lg-12 nopadding col s12">
                      <label style="margin-top: 20px;">About Description</label>
                      <textarea class="ckeditor" cols="80" id="descen1" rows="10" name="about_description"><?php if($about->field!=''){ echo $about->field; } ?></textarea>
                      <span class="error_val"><?php echo $this->session->flashdata('about_description'); ?></span>
                      <input type="hidden" name="id" value="<?php if($about->id!=''){ echo $about->id; } ?>" id="t3">
                    </div>
                  <div class="input-field col s12">
                    <i class="waves-effect waves-light btn-large waves-input-wrapper" style="">
                      <input type="submit" class="waves-button-input" value="Add"></i>
                  </div>
                  </div>
                  <div class="clearfix"></div>
                  </div>
                  <input type="text" name="edit" value="">
</form>

>>>>>>>>>>>>>>>>>>>>admin.php

public function about($input)
{
$input=$this->input->post();

$data['about']=$this->course_model->get_about();  (select data frome table)

if(!empty($input))
{
$result=$this->course_model->about($input);
    if($result==1)
      {
$this->session->set_flashdata('success','Data Submit.');
redirect('admin/about');
      }
      else
{
$this->session->set_flashdata('success','Fill the Data Not Changes.');
redirect('admin/about');

}

}
/*if condition is true then it work ((data submit & resubmit call submit))*/

$this->load->view('admin/about',$data);  (page loader)

}
................................................

admin.course.model.php
........................................................Model.................

public function get_about()
{
return $this->db->get('about')->row(); (Select from table only 1 row)
}

public function about($input)
{
$data=array('field'=>$input['about_description']);
if($input['id']=='')
{
$query=$this->db->insert('about',$data);
}
else
{
$query=$this->db->where('id',$input['id'])->update('about',$data);
}

if($query)
{
return true;
}
else
{
return false;
}


}


Table Name : About

ID: 1;
Field :  'hello fr. data inserted in row';

route

$route['admin/about'] = 'admin/admin/about';

$route i use for shortcut....


Note ::  <?php if($about->field!=''){ echo $about->field; } ?> in text area .html field.

$about is database name

(Field) is a table row name

Rule : if

<input type="hidden" name="id" value="<?php if($about->id!=''){ echo $about->id; } ?>" id="t3">

How to Insert Data In Data Base According by Codeigniter

Hi Guys you can use very simple

1. if you instal (IC)
.
Then you 1st Create A tabel in data base

CREATE DATABASE oktech_courses;CREATE TABLE contact(id int(10) NOT NULL AUTO_INCREMENT,Name varchar(255) NOT NULL,
Phone int(15) NOT NULL,
City varchar(255) NOT NULL, Email varchar(255) NOT NULL,
Message text(255) NOT NULL,Date timestamp(255) NOT NULL,PRIMARY KEY (Student_id))


connect database to you file then

Then you go the controller and open file welcome.php

$this->load->helper(array('form','url','validate_helper','image_helper')); $this->load->library(array('email','session','form_validation'));

Insert the text:

>> public function filename contect()
{
$this->load->view('Contect');
}
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
public function contact(){ $this->load->view('contact'); }
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
public function contact_form(){ $input=$this->input->post();Validation Satart if(!empty($input)) { require_validations(['name','phone','city','email','message'],'','CI','Welcome/contact'); $result=$this->courses_model->contact_form($input); if($result==true) { $to='vinaykumar.vismaad@gmail.com'; $subject='Contact-US Enquiry'; $message='Email : '.$input['email'].'<br> '.'Name :'.$input['name'].'<br>'.'phone :'.$input['phone'].'<br>'.'city :'.$input['city'].'<br>'.'message :'.$input['message']; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= 'From: oketch-courses<info@oketch-courses.com>' . "\r\n" . 'Reply-To: no-reply@oketch-courses.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); $sta_email=mail($to,$subject,$message,$headers); $this->session->set_flashdata('success','Contact form Successfully submit.'); } else { $this->session->set_flashdata('error','Unable to Submit Contact form.'); } redirect('Welcome/contact'); } else { redirect('Welcome/contact'); } }




Validation End
you can change the contact name acording your file.

$input >> Store the all value in variable


><>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Contact.php

<div class="container"> <div class="overlay-contact footer-part footer-part-form"> <div class="map-head"> <p>Send Us Now</p> <h2>GetIn Touch</h2> <span class="footer-ser-re">Service Request Form</span> </div> <!-- ENQUIRY FORM -->
Validation
<?php if(!empty($this->session->flashdata('error'))){ ?> <div class="alert alert-danger alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button> <i class="fa fa-times-circle"></i> <?php echo $this->session->flashdata('error'); ?> </div> <?php } ?> <?php if(!empty($this->session->flashdata('success'))){ ?> <div class="alert alert-success alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button> <i class="fa fa-times-circle"></i> <?php echo $this->session->flashdata('success'); ?> </div> <?php } ?>

Validation

form

*Note : Welcome/contact_form You can change name which you create file name in welcome page

* Contact_forme Taken By welcome to function you can check the welcome.php page.

<form method="post" action="<?php echo base_url(); ?>/Welcome/contact_form"> <ul> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f1" value="" name="name" placeholder="Name" > <span class="error_val"><?php echo $this->session->flashdata('name'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f2" value="" name="phone" placeholder="Phone" > <span class="error_val"><?php echo $this->session->flashdata('phone'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f3" value="" name="city" placeholder="City"> <span class="error_val"><?php echo $this->session->flashdata('city'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="email" id="f4" value="" name="email" placeholder="Email"> <span class="error_val"><?php echo $this->session->flashdata('email'); ?></span> </li> <li class="col-md-12 col-sm-12 col-xs-12 contact-input-spac"> <textarea id="f5" name="message" ></textarea> <span class="error_val"><?php echo $this->session->flashdata('message'); ?></span> </li> <li class="col-md-6"> <input type="submit" value="SUBMIT"> </li> </ul> </form> </div> </div>

*Note :

This scentex use when you give a temprory data story

and you get better result

...When you create a forme the clic submit button

then show the data "submit" if error the page redirect

same page or 1 time use if you reload page then it

erase the success data note.

<input type="email" id="f4" value="" name="email" placeholder="Email">

<span class="error_val"><?php echo $this->session->flashdata('Email'); ?></span>

form

How to Insert Data In Data Base According by Codeigniter

Hi Guys you can use very simple

1. if you instal (IC)
.
Then you 1st Create A tabel in data base

CREATE DATABASE oktech_courses; CREATE TABLE contact( id int(10) NOT NULL AUTO_INCREMENT, Name varchar(255) NOT NULL,
Phone int(15) NOT NULL,
City varchar(255) NOT NULL, Email varchar(255) NOT NULL,
Message text(255) NOT NULL, Date timestamp(255) NOT NULL, PRIMARY KEY (Student_id) )


connect database to you file then

Then you go the controller and open file welcome.php

$this->load->helper(array('form','url','validate_helper','image_helper')); $this->load->library(array('email','session','form_validation'));

Insert the text:

>> public function filename contect()
{
$this->load->view('Contect');
}
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
public function contact(){ $this->load->view('contact'); }
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
public function contact_form(){ $input=$this->input->post(); Validation Satart if(!empty($input)) { require_validations(['name','phone','city','email','message'],'','CI','Welcome/contact'); $result=$this->courses_model->contact_form($input); if($result==true) { $to='vinaykumar.vismaad@gmail.com'; $subject='Contact-US Enquiry'; $message='Email : '.$input['email'].'<br> '.'Name :'.$input['name'].'<br>'.'phone :'.$input['phone'].'<br>'.'city :'.$input['city'].'<br>'.'message :'.$input['message']; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= 'From: oketch-courses<info@oketch-courses.com>' . "\r\n" . 'Reply-To: no-reply@oketch-courses.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); $sta_email=mail($to,$subject,$message,$headers); $this->session->set_flashdata('success','Contact form Successfully submit.'); } else { $this->session->set_flashdata('error','Unable to Submit Contact form.'); } redirect('Welcome/contact'); } else { redirect('Welcome/contact'); } }




Validation End
you can change the contact name acording your file.

$input >> Store the all value in variable


><>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Contact.php

<div class="container"> <div class="overlay-contact footer-part footer-part-form"> <div class="map-head"> <p>Send Us Now</p> <h2>GetIn Touch</h2> <span class="footer-ser-re">Service Request Form</span> </div> <!-- ENQUIRY FORM -->
Validation
<?php if(!empty($this->session->flashdata('error'))){ ?> <div class="alert alert-danger alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button> <i class="fa fa-times-circle"></i> <?php echo $this->session->flashdata('error'); ?> </div> <?php } ?> <?php if(!empty($this->session->flashdata('success'))){ ?> <div class="alert alert-success alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button> <i class="fa fa-times-circle"></i> <?php echo $this->session->flashdata('success'); ?> </div> <?php } ?>

Validation

form

*Note : Welcome/contact_form You can change name which you create file name in welcome page

* Contact_forme Taken By welcome to function you can check the welcome.php page.

<form method="post" action="<?php echo base_url(); ?>/Welcome/contact_form"> <ul> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f1" value="" name="name" placeholder="Name" > <span class="error_val"><?php echo $this->session->flashdata('name'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f2" value="" name="phone" placeholder="Phone" > <span class="error_val"><?php echo $this->session->flashdata('phone'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="text" id="f3" value="" name="city" placeholder="City"> <span class="error_val"><?php echo $this->session->flashdata('city'); ?></span> </li> <li class="col-md-6 col-sm-6 col-xs-12 contact-input-spac"> <input type="email" id="f4" value="" name="email" placeholder="Email"> <span class="error_val"><?php echo $this->session->flashdata('email'); ?></span> </li> <li class="col-md-12 col-sm-12 col-xs-12 contact-input-spac"> <textarea id="f5" name="message" ></textarea> <span class="error_val"><?php echo $this->session->flashdata('message'); ?></span> </li> <li class="col-md-6"> <input type="submit" value="SUBMIT"> </li> </ul> </form> </div> </div>

*Note :

This scentex use when you give a temprory data story

and you get better result

...When you create a forme the clic submit button

then show the data "submit" if error the page redirect

same page or 1 time use if you reload page then it

erase the success data note.

<input type="email" id="f4" value="" name="email" placeholder="Email">

<span class="error_val"><?php echo $this->session->flashdata('Email'); ?></span>

form