Home > Developer > Go

"Go" The simplest example of a CI framework getting started--database fetching data

Source: Internet
Author: User
Tags vars codeigniter
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

1. Download the CI framework (find it yourself)

2. Configuration

database.php configuration:
To set the connection parameter for the database server:

SOURCE print?
    1. $db [ ' default '] [ ' hostname '] =  "Your-db-host";   
    2. $db [ ' default '][ ' username ']  =  "Your-username";   
    3. $db [ ' default '][ ' password '] =   "Your-password";   
    4. $db [ ' default '][ ' database '] =  "Your-db-name";   
    5. $db [ ' default '][ ' Dbdriver '] =   "MySQL";   

3. Build a table

SOURCE print?
  2. <strong>CREATE TABLE IF not EXISTS ' users ' (
  4. ' ID ' INT (8) not NULL auto_increment,
  6. 'name ' VARCHAR (CHARACTER) SET UTF8 DEFAULT NULL,
  8. ' Age ' VARCHAR (3) CHARACTER SET UTF8 DEFAULT NULL,
  10. ' Sex ' VARCHAR (2) CHARACTER SET UTF8 DEFAULT NULL,
  12. PRIMARY KEY (' id ')
  14. ) Engine=myisam DEFAULT Charset=utf8 collate=utf8_estonian_ci auto_increment=14;
  16. </strong>


Fill in a few data yourself

4. Implementing MVC

1) Implement m--data collection

Create a new file under CI models mtest.php

SOURCE print?
    1. <?php
    2. Class Mtest extends ci_model{
    3. function Mtest () {
    4. Parent::__construct ();
    5. }
    6. function get_last_ten_entries ()
    7. {
    8. $this->load->database ();
SOURCE print?
    1. mysql_query ("SET NAMES GBK"); //Prevent Chinese garbled characters
    2. $query = $this->db->get (' users ', 10);
    3. return $query->result ();
    4. }
    6. }
    7. ?>

Description

Parent::__construct (); no less
$this->load->database (); must not be less or will be an error

You can also implement the Auto Connect feature, which will automatically instantiate the database class each time a page is loaded. To enable automatic connection, you can add it in the library array in the following file database :

application/config/autoload.php

不然就要像这里一样写在每个页面上。

You can also use $query = $this->db->query (' SELECT * from users ');

Write your own SQL in this way

2) Implement c--decision to take those data

Create a new file under CI controllers test.php

SOURCE print?
  2. <?php
  4. Class Test extends Ci_controller {
  8. function Test () {
  10. Parent::__construct ();
  12. }
  16. function Index () {
  18. $this->load->helper (' form ');
  20. $data [' title '] = "Home";
  22. $data [' headline '] = "input user Information";
  24. //Multidimensional Arrays
  26. $data [' todo_list '] = Array (' Clean House ', ' call Mom ', ' Run errands ');
  30. //$this->load->vars ($data);
  32. $this->load->model (' mtest ');
  34. $data [' query1 '] = $this->mtest->get_last_ten_entries ();
  36. $this->load->view (' users ',$data);
  38. //$this->load->view (' NewFile ');
  40. //$this->load->view (' a/newfile ');
  44. }
  46. }
  48. ?>

Call model: $this->load->model (' mtest ');

Load the model into the array: $data [' query1 '] = $this->mtest->get_last_ten_entries ();

The array is reproduced on the page: $this->load->view (' users ', $data);



2) Implement v--page display

CI Views under Create a new file user.php

SOURCE print?
  6. <title><? echo $title;? ></title>
  10. <body>
  12. <ul>
  14. <?php foreach ($todo _list as $item):?>
  18. <li><?php echo $item;? ></li>
  22. <?php Endforeach;? >
  24. </ul>
  26. <ul>
  28. <?  Echo count ($query 1);
  30. foreach ($query 1 as $v 1) {
  32. foreach ($v 1 as $v 2) {
  34. echo "$v 2\n";
  36. }
  38. }
  42. For ($row =0; $row <count ($query 1); $row + +) {
  44. echo $query 1[$row]->name."  </br> ";
  46. }
  48. ?>
  54. <?php foreach ($query 1 as $v):?>
  58. <li><?php echo $v->name;? ></li>
  62. <?php Endforeach;? >
  64. </ul>
  66. echo $headline;?>
  70. </body>

Description: You can use for and foreach multiple methods to find the data you want!

Description: If the whole page is garbled , the page header is probably the case.

SOURCE print?
    1. <Meta http-equiv= "content-type" content= "text/html; Charset=utf-8 " />

If you are not using CI to connect to the database, add the following code to the database connection section.

mysql_query ("SET NAMES GBK"); Prevent Chinese garbled characters
mysql_query ("set names UTF8;");  //In mysql_select_db ("");

Prevent Chinese garbled to see your database character set

database.php file under CI Config

SOURCE print?
    1. $db [' Default '] [' char_set '] = ' UTF8 ';  //utf8. The database character set is also UTF8
    2. $db [' Default '] [' dbcollat '] = ' utf8_general_ci ';





More do not understand, please refer to:

Controller http://codeigniter.org.cn/user_guide/general/controllers.html

Model http://codeigniter.org.cn/user_guide/general/models.html

View http://codeigniter.org.cn/user_guide/general/views.html


Original link: http://blog.csdn.net/21aspnet/article/details/6599780

"Go" The simplest example of a CI framework getting started--database fetching data

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
getting started with zend framework zend framework 3 getting started getting started with spring framework go with microsoft office 2013 getting started entity framework data access layer example liferay getting started apache getting started
Related Article
Go combat--golang Get public IP, view intranet IP, detect IP ...
Golang client Sarama via SSL connection Kafka configuration
Golang private Key "encrypt" public key "decrypt"
Golang in net package usage (i)
Go Navicat Premium 12.1.8.0 Installation and activation
Go adobe Creative Cloud 2015 download adobe CC Download

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More