CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

30 August, 2018

Select Data table by select query CodeIgniter

 Programing Coderfunda     August 30, 2018     codeigniter     No comments   

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>

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

Select Data table by select query ...Codeiginter

 Programing Funda     August 30, 2018     codeigniter     No comments   

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>

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

29 August, 2018

Select data in table & Update data of table

 Programing Coderfunda     August 29, 2018     codeigniter     No comments   

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">

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

Select data in table & Update data of table

 Programing Funda     August 29, 2018     codeigniter     No comments   

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">

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

28 August, 2018

How to Insert Data In Data Base According by Codeigniter

 Programing Coderfunda     August 28, 2018     codeigniter     No comments   

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



Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

How to Insert Data In Data Base According by Codeigniter

 Programing Funda     August 28, 2018     codeigniter     No comments   

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



Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Newer Posts Home

Meta

Popular Posts

  • Vue.js Tutorial
      Vue.js Installation Compatibility Check Before going to install and use Vue.js in your project, you should check the compatibility issues....
  • JqueryUI Tutorial
    JqueryUI Tutorial    JqueryUI is the most popular front end frameworks currently. It is sleek, intuitive, and powerful mobile first fr...
  • Laravel - Application Structure
    The application structure in Laravel is basically the structure of folders, sub-folders and files included in a project. Once we create a ...
  • Python Tutorial
      Python   is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by Guido van...
  • CSS Online Training
    CSS Online Training CSS is used to control the style of a web document in a simple and easy way. CSS is the acronym for "Casca...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (69)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (4)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda