使用 CodeIgniter Active Records 插入数据

发布于 2024-11-19 13:45:36 字数 512 浏览 1 评论 0原文

我的问题是关于使用 CodeIgniter Active record 插入数据。指南上有一个使用数组插入数据的示例：

$data = array(
   'title' => 'My title' ,
   'name' => 'My Name' ,
   'date' => 'My date'
);

$this->db->insert('mytable', $data);

我想知道是否还有其他方法可以插入活动记录数据，例如以类似的语法：

    $this -> db -> select (*);
    $this -> db -> from ('users');
    $this -> db -> where('id', $id);
    $this -> db -> limit(1);

    $query = $this->db->get();

谢谢。

原文

My question is about inserting data with CodeIgniter Active record. There's an example on the guide to insert data with array:

$data = array(
   'title' => 'My title' ,
   'name' => 'My Name' ,
   'date' => 'My date'
);

$this->db->insert('mytable', $data);

I wonder if there is some other way to insert the active record data, For example in in similar syntax:

    $this -> db -> select (*);
    $this -> db -> from ('users');
    $this -> db -> where('id', $id);
    $this -> db -> limit(1);

    $query = $this->db->get();

Thanks.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

暮光沉寂 2024-11-26 13:45:36

您可以使用set()方法。

根据 CI 文档，您可以使用以下语法：

$this->db->set('name', $name);
$this->db->insert('mytable');

这将生成以下查询：

INSERT INTO mytable (name) VALUES ('{$name}')

希望这就是您正在寻找的内容。

You may use set() method.

According to CI documentation, you may use following syntax:

$this->db->set('name', $name);
$this->db->insert('mytable');

which will produce following query:

INSERT INTO mytable (name) VALUES ('{$name}')

Hopefully it's what you're looking for.

回复收藏 0 原文

贪了杯 2024-11-26 13:45:36

**its very simple just follow the following steps**<br>
**first prepare a dabase in mysql**<br>
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 02, 2013 at 03:48 AM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `persons`
--

-- --------------------------------------------------------

--
-- Table structure for table `person`
CREATE TABLE IF NOT EXISTS `person` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `person_name` varchar(50) NOT NULL,
  `person_address` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1728 ;

--
-- Dumping data for table `person`
--

INSERT INTO `person` (`id`, `person_name`, `person_address`) VALUES
(1726, 'soma', 'goma'),
(1727, 'roma', 'toma');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
<br>


**Open Codeigniter and make the follwoing changes in the following files**<br>

**make changes in autoload.php**<br>

**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>

  from 

**$autoload['libraries'] = array('');** to
**$autoload['libraries'] = array('database');**$config['base_url']<br>

make changes in config.php 


**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>


$config['base_url'] = ''; to

$config['base_url'] = 'http://localhost/';

make changes in database.php 


**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>


$db['default']['hostname'] = '';<br>
$db['default']['username'] = '';<br>
$db['default']['password'] = '';<br>
$db['default']['database'] = '';<br>
$db['default']['dbdriver'] = 'mysql';<br>

to<br>
$db['default']['hostname'] = 'localhost';<br>
$db['default']['username'] = 'root';<br>
$db['default']['password'] = '';<br>
$db['default']['database'] = 'persons';<br>
$db['default']['dbdriver'] = 'mysql';<br>


now open the views folder located at<br>

**C:\xampp\htdocs\CI_person\application**<br>
**Create a view persons.php in C:\xampp\htdocs\CI_person\application\views**


<html>
<head>
</head>
<body>
<script language="javascript">
function clicked()
{
alert("You clicked");
document.getElementById('check').value='I';

}
</script>

<form id="entry" name="entry"  method="post" >
<input type="hidden" name="check" id="check" value="">
Person Name 
  <input type="text" name="person_name" id="person_name" />
  <br />
  Person Address
  <input type="text" name="person_address" id="person_address" />
  <input type="submit" name="button" id="button" value="Submit" onClick="clicked()">
<table  cellpadding="2px" width="600px"  border="2">
        <?php
            foreach ($persons as $person){
                $id = $person['id'];
                $name = $person['person_name'];
                $address = $person['person_address'];

        ?>
        <tr>

            <td><?php echo $name; ?></td>
            <td><?php echo $address; ?><br /> </td>



        </tr>

        <?php } ?>
    </table>
</form>
</body>
    </html>

**create controller named persons.php in Controller folder**<br>



<?php if (!defined('BASEPATH')) exit('No direct script access allowed');


class Persons extends CI_Controller {

    public function __construct()
    {
        parent::__construct();
        $this->load->model('Person_model');
    }

    public function index()
    {       

         $person_name = $this->input->post('person_name');
         $person_address = $this->input->post('person_address');
         $check= $this->input->post('check');

    if  ($check=="") 
    {
        $this->data['persons'] = $this->Person_model->get_all();
        $this->load->view('persons', $this->data);
    }
    if  ($check=="I") 
    {

         /*$this->load->model('Person_model');
         $this->Person_model->insert_to_db($this->input->post('person_name'),$this->input->post('person_address'));
         */

         $this->Person_model->person_name = $person_name;
         $this->Person_model->person_address =$person_address;
         $this->Person_model->insert_into_db();
         $this->data['persons'] = $this->Person_model->get_all();
         $this->load->view('persons', $this->data);


    }


    }







}


**now create model as defined below in Models folder**<br>
<?php
class Person_model extends CI_Model
{
    public $person_name;
    public $person_address;
    public function __construct()
    {

    }

    public function get_all()
    {
    $this->db->select('id,person_name,person_address');
    $query= $this->db->get('person');
    return $query->result_array();  
    }

    function insert_into_db()
    {

      $f1 = $this->person_name;
      $f2 = $this->person_address;

     $this->db->query("INSERT INTO person(person_name,person_address) VALUES('$f1','$f2')"); 

    }




}




?>

**Save all and run**

**its very simple just follow the following steps**<br>
**first prepare a dabase in mysql**<br>
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 02, 2013 at 03:48 AM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `persons`
--

-- --------------------------------------------------------

--
-- Table structure for table `person`
CREATE TABLE IF NOT EXISTS `person` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `person_name` varchar(50) NOT NULL,
  `person_address` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1728 ;

--
-- Dumping data for table `person`
--

INSERT INTO `person` (`id`, `person_name`, `person_address`) VALUES
(1726, 'soma', 'goma'),
(1727, 'roma', 'toma');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
<br>


**Open Codeigniter and make the follwoing changes in the following files**<br>

**make changes in autoload.php**<br>

**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>

  from 

**$autoload['libraries'] = array('');** to
**$autoload['libraries'] = array('database');**$config['base_url']<br>

make changes in config.php 


**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>


$config['base_url'] = ''; to

$config['base_url'] = 'http://localhost/';

make changes in database.php 


**it is located  at**<br>

**C:\xampp\htdocs\CI_person\application\config**<br>


$db['default']['hostname'] = '';<br>
$db['default']['username'] = '';<br>
$db['default']['password'] = '';<br>
$db['default']['database'] = '';<br>
$db['default']['dbdriver'] = 'mysql';<br>

to<br>
$db['default']['hostname'] = 'localhost';<br>
$db['default']['username'] = 'root';<br>
$db['default']['password'] = '';<br>
$db['default']['database'] = 'persons';<br>
$db['default']['dbdriver'] = 'mysql';<br>


now open the views folder located at<br>

**C:\xampp\htdocs\CI_person\application**<br>
**Create a view persons.php in C:\xampp\htdocs\CI_person\application\views**


<html>
<head>
</head>
<body>
<script language="javascript">
function clicked()
{
alert("You clicked");
document.getElementById('check').value='I';

}
</script>

<form id="entry" name="entry"  method="post" >
<input type="hidden" name="check" id="check" value="">
Person Name 
  <input type="text" name="person_name" id="person_name" />
  <br />
  Person Address
  <input type="text" name="person_address" id="person_address" />
  <input type="submit" name="button" id="button" value="Submit" onClick="clicked()">
<table  cellpadding="2px" width="600px"  border="2">
        <?php
            foreach ($persons as $person){
                $id = $person['id'];
                $name = $person['person_name'];
                $address = $person['person_address'];

        ?>
        <tr>

            <td><?php echo $name; ?></td>
            <td><?php echo $address; ?><br /> </td>



        </tr>

        <?php } ?>
    </table>
</form>
</body>
    </html>

**create controller named persons.php in Controller folder**<br>



<?php if (!defined('BASEPATH')) exit('No direct script access allowed');


class Persons extends CI_Controller {

    public function __construct()
    {
        parent::__construct();
        $this->load->model('Person_model');
    }

    public function index()
    {       

         $person_name = $this->input->post('person_name');
         $person_address = $this->input->post('person_address');
         $check= $this->input->post('check');

    if  ($check=="") 
    {
        $this->data['persons'] = $this->Person_model->get_all();
        $this->load->view('persons', $this->data);
    }
    if  ($check=="I") 
    {

         /*$this->load->model('Person_model');
         $this->Person_model->insert_to_db($this->input->post('person_name'),$this->input->post('person_address'));
         */

         $this->Person_model->person_name = $person_name;
         $this->Person_model->person_address =$person_address;
         $this->Person_model->insert_into_db();
         $this->data['persons'] = $this->Person_model->get_all();
         $this->load->view('persons', $this->data);


    }


    }







}


**now create model as defined below in Models folder**<br>
<?php
class Person_model extends CI_Model
{
    public $person_name;
    public $person_address;
    public function __construct()
    {

    }

    public function get_all()
    {
    $this->db->select('id,person_name,person_address');
    $query= $this->db->get('person');
    return $query->result_array();  
    }

    function insert_into_db()
    {

      $f1 = $this->person_name;
      $f2 = $this->person_address;

     $this->db->query("INSERT INTO person(person_name,person_address) VALUES('$f1','$f2')"); 

    }




}




?>

**Save all and run**

回复收藏 0 原文

一抹苦笑 2024-11-26 13:45:36

在 Codeigniter 中插入数据的其他方式

    $query = $this->db->query('YOUR SQL QUERY');

或

   $this->db->set('name', $name);
   $this->db->insert('mytable');  // Produces: INSERT INTO mytable (`name`) VALUES ('{$name}')

希望它可以帮助您。

Other way of inserting data in Codeigniter

    $query = $this->db->query('YOUR SQL QUERY');

   $this->db->set('name', $name);
   $this->db->insert('mytable');  // Produces: INSERT INTO mytable (`name`) VALUES ('{$name}')

Hopefully it can help you.

回复收藏 0 原文

~没有更多了~

关于作者

箜明

暂无简介

0 文章

0 评论

23 人气

关注发私信

情绪操控生活

文章 0 评论 0

关注

github_voSE7JHikn

文章 0 评论 0

关注

Auto-Service

文章 0 评论 0

关注

め可乐爱微笑

文章 0 评论 0

关注

离不开的别离

文章 0 评论 0

关注

柳家齐

文章 0 评论 0

友情链接

文江博客

使用 CodeIgniter Active Records 插入数据

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

评论（3）

关于作者

相关话题

热门标签

推荐作者

情绪操控生活

github_voSE7JHikn

Auto-Service

め可乐爱微笑

离不开的别离

柳家齐

友情链接

使用 CodeIgniter Active Records 插入数据

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

评论（3）

关于作者

相关话题

热门标签

推荐作者

情绪操控生活

github_voSE7JHikn

Auto-Service

め可乐爱微笑

离不开的别离

柳家齐

友情链接

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。