public function insert_news(){
$this->load->model('news_model');
$data = array(
		//接收新闻的标题 用$this->input->post方法替换$_POST方法更好
		'title' => $this->input->get('title'),
		//接收新闻的内容
		'text' => $this->input->get('text'),
		//接收所选的频道
		'channel_id' => 6,
		//接收图片的地址
		//'image' => $this->input->post('image'),
		//根据所选的频道id查看频道的具体名字
		'channel_name' => "推荐",
	);
$this->news_model->add_data($data);
}

    public function add_data($data)
    {
    		$this->load->database();
        	$this->db->insert('news', $data);
    }

	public function show()
	{
		$this->load->helper('url');
		$this->load->model('news_model');
		$this->load->model('channel_model');
		//获取id和channel的对应关系表
		$data['channels'] = $this->channel_model->show_data();
		//从数据库新获取渲染到列表
		$data['news'] = $this->news_model->show_data();
		//将拿回来的图片字符串转化为数组的形式方便视图渲染
		$i = 0;
		foreach($data['news'] as $item){
			$data['news'][$i]['image'] = explode(",",$item['image']);
			$i++;
		}
		//显示退出登陆的页面
		//$this->load->view ('login/logout');
		$this->load->view('news/news_show', $data);
	}

    public function show_data()
    {
    		$this->load->database();
        $query = $this->db->get("news");
        return $query->result_array();
    }

<?php 
foreach ($news as $item): ?>
//..
<h4 class="weui-media-box__title"><?php echo $item['title'];?></h4>

//上传图片 使用uploadify插件
public function upload_picture()
{
	//记得更改目录位置，对应服务器的根目录，即htdocs为跟目录文件夹
	$targetFolder = '/CI/myCi//uploads'; // Relative to the root
	$verifyToken = md5('unique_salt' . $_POST['timestamp']);

	if (!empty($_FILES) && $_POST['token'] == $verifyToken) {
		$tempFile = $_FILES['Filedata']['tmp_name'];
		$targetPath = $_SERVER['DOCUMENT_ROOT'] . $targetFolder;
		$targetFile = rtrim($targetPath, '/') . '/' . $_FILES['Filedata']['name'];

		// Validate the file type
		$fileTypes = array('jpg', 'jpeg', 'gif', 'png'); // File extensions
		$fileParts = pathinfo($_FILES['Filedata']['name']);

		if (in_array($fileParts['extension'], $fileTypes)) {
			move_uploaded_file($tempFile, $targetFile);
			echo '1';
		} else {
			echo 'Invalid file type.';
		}
	}
}

<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Hello extends CI_Controller
{
    public function index()
    {
        $data['wsscat_list'] = array(
            'name' => 'Wsscat',
            'Autumns',
            array('first' => 'JS', 'second' => 'PHP'),
        );
        $this->load->view('hello', $data);
    }
}

//记得端口别写错
$con = mysql_connect("localhost:3306","wscats","123456789");
if (!$con) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("ws", $con);

//SQL语句对大小写不敏感，所以SELECT与select等效
$result = mysql_query("select * from news");

$data = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  //array_pop() 删除数组的最后一个元素（出栈）
  //array_push() 将一个或多个元素插入数组的末尾（入栈）
  array_push($data ,$row);
}

$apiData = array("news"=>$data);
//输出jsonp数据 {"news":[{"title":"qqqqaaa","text":"sssqweqweaaa","id":"29","source":"qqqqqwe"},{"title":"asdsasd","text":"asdasd","id":"31","source":"asdasd"},{"title":"123213qwewe","text":"123123qweqwe","id":"32","source":"12323qeqe"},{"title":"qweqwe","text":"qweqwe","id":"33","source":"qwqwe"}]}
echo json_encode($apiData);

//例如Array ( [title] => qqqqaaa [text] => sssqweqweaaa [id] => 29 [source] => qqqqqwe )
$result2 = mysql_query("select * from news where id = 29");
print_r(mysql_fetch_assoc($result2));

//例如Array ( [0] => qqqqaaa [1] => sssqweqweaaa [2] => 29 [3] => qqqqqwe )
$result3 = mysql_query("select * from news where id = 29");
print_r(mysql_fetch_row($result3));

$result4 = mysql_query("select * from news");
while ($row = mysql_fetch_object($result4)) {
  echo $row->title."<br />";
}

mysql_close($con);

<?php
//记得端口别写错
$con = mysql_connect("localhost:3306","wscats","123456789");
if (!$con) {
  die('Could not connect: ' . mysql_error());
}
mysql_select_db("ws", $con);
$result = mysql_query("select * from news");

//1.mysql_fetch_array(data,array_type) 从结果集中取得一行作为关联数组，或数字数组，或二者兼有
//注意第二个参数是常量，不是字符串
/*MYSQL_ASSOC - 关联数组
MYSQL_NUM - 数字数组
MYSQL_BOTH - 默认。同时产生关联和数字数组*/
$data = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  //var_dump($row);
  //echo '<br />';
  //array_pop() 删除数组的最后一个元素（出栈）
  //array_push() 将一个或多个元素插入数组的末尾（入栈）
  array_push($data ,$row);
}

$apiData = array("news"=>$data);
//输出jsonp数据 {"news":[{"title":"qqqqaaa","text":"sssqweqweaaa","id":"29","source":"qqqqqwe"},{"title":"asdsasd","text":"asdasd","id":"31","source":"asdasd"},{"title":"123213qwewe","text":"123123qweqwe","id":"32","source":"12323qeqe"},{"title":"qweqwe","text":"qweqwe","id":"33","source":"qwqwe"}]}
echo json_encode($apiData);



//2.mysql_fetch_assoc 从结果集中取得一行作为关联数组
//例如Array ( [title] => qqqqaaa [text] => sssqweqweaaa [id] => 29 [source] => qqqqqwe )
$result2 = mysql_query("select * from news where id = 29");
print_r(mysql_fetch_assoc($result2));



//3.mysql_fetch_row() 函数从结果集中取得一行作为数字数组
//例如Array ( [0] => qqqqaaa [1] => sssqweqweaaa [2] => 29 [3] => qqqqqwe )
$result3 = mysql_query("select * from news where id = 29");
print_r(mysql_fetch_row($result3));



//4.mysql_fetch_object() 函数从结果集（记录集）中取得一行作为对象。
$result4 = mysql_query("select * from news");
while ($row = mysql_fetch_object($result4)) {
  echo $row->title."<br />";
}
mysql_close($con);
?>

<?php  
    define('DB_HOST', 'localhost:3306');  
    define('DB_USER', 'wscats');  
    define('DB_PWD', '123456789');  
    define('DB_CHARSET', 'UTF8');  
    define('DB_DBNAME', 'asm');  
?>  

<?php  
class mysql{  
    /** 
     * 连接MYSQL函数 
     * 连接MYSQL函数,通过常量的形式来连接数据库 
     * 自定义配置文件，配置文件中自定义常量，包含需要使用的信息 
     * @return resource 
     */  
    function connect2 (){   
        //连接mysql  
        $link=@mysql_connect(DB_HOST,DB_USER,DB_PWD) or die ('数据库连接失败<br/>ERROR '.mysql_errno().':'.mysql_error());  
        //设置字符集  
        mysql_set_charset(DB_CHARSET);  
        //打开指定的数据库  
        mysql_select_db(DB_DBNAME) or die('指定的数据库打开失败');  
        return $link;  
    }  
      
      
      
    /* array( 
    'username'=>'cy', 
    'password'=>'123456', 
    'email'=>'[email protected]' 
    ) */  
      
    /** 
     * 插入记录的操作 
     * @param array $array 
     * @param string $table 
     * @return boolean 
     */  
    function insert($array,$table){  
        $keys=join(',',array_keys($array));  
        $values="'".join("','", array_values($array))."'";  
        $sql="insert {$table}({$keys}) VALUES ({$values})";  
        $res=mysql_query($sql);  
        if($res){  
            return mysql_insert_id();  
        }else{  
            return false;  
        }  
    }  
      
      
    /** 
     * MYSQL更新操作 
     * @param array $array 
     * @param string $table 
     * @param string $where 
     * @return number|boolean 
     */  
    function update($array,$table,$where=null){  
        foreach ($array as $key=>$val){  
            $sets.=$key."='".$val."',";  
        }  
        $sets=rtrim($sets,','); //去掉SQL里的最后一个逗号  
        $where=$where==null?'':' WHERE '.$where;  
        $sql="UPDATE {$table} SET {$sets} {$where}";  
        $res=mysql_query($sql);  
        if ($res){  
            return mysql_affected_rows();  
        }else {  
            return false;  
        }  
    }  
      
      
    /** 
     * 删除记录的操作 
     * @param string $table 
     * @param string $where 
     * @return number|boolean 
     */  
    function delete($table,$where=null){  
        $where=$where==null?'':' WHERE '.$where;  
        $sql="DELETE FROM {$table}{$where}";  
        $res=mysql_query($sql);  
        if ($res){  
            return mysql_affected_rows();  
        }else {  
            return false;  
        }  
    }  
      
      
      
    /** 
     * 查询一条记录 
     * @param string $sql 
     * @param string $result_type 
     * @return boolean 
     */  
    function fetchOne($sql,$result_type=MYSQL_ASSOC){  
        $result=mysql_query($sql);  
        if ($result && mysql_num_rows($result)>0){  
            return mysql_fetch_array($result,$result_type);  
        }else {  
            return false;  
        }  
    }  
      
      
      
      
      
    /** 
     * 得到表中的所有记录 
     * @param string $sql 
     * @param string $result_type 
     * @return boolean 
     */  
    function fetchAll($sql,$result_type=MYSQL_ASSOC){  
        $result=mysql_query($sql);  
        if ($result && mysql_num_rows($result)>0){  
            while ($row=mysql_fetch_array($result,$result_type)){  
                $rows[]=$row;  
            }  
            return $rows;  
        }else {  
            return false;  
        }  
    }  
      
      
    /**取得结果集中的记录的条数 
     * @param string $sql 
     * @return number|boolean 
     */  
    function getTotalRows($sql){  
        $result=mysql_query($sql);  
        if($result){  
            return mysql_num_rows($result);  
        }else {  
            return false;  
        }  
          
    }  
      
    /**释放结果集 
     * @param resource $result 
     * @return boolean 
     */  
    function  freeResult($result){  
        return  mysql_free_result($result);  
    }  
      
      
      
    /**断开MYSQL 
     * @param resource $link 
     * @return boolean 
     */  
    function close($link=null){  
        return mysql_close($link);  
    }  
      
      
    /**得到客户端的信息 
     * @return string 
     */  
    function getClintInfo(){  
        return mysql_get_client_info();  
    }  
      
      
    /**得到MYSQL服务器端的信息 
     * @return string 
     */  
    function getServerInfo($link=null){  
        return mysql_get_server_info($link);  
    }  
      
      
      
    /**得到主机的信息 
     * @return string 
     */  
    function getHostInfo($link=null){  
        return mysql_get_host_info($link);  
    }  
      
    /**得到协议信息 
     * @return string 
    */  
    function getProtoInfo($link=null){  
        return mysql_get_proto_info($link);  
    }  
}  
?>  

<?php  
    require_once 'function.php';
    require_once 'config.php';
    $db = new mysql();  
    $link = $db->connect2();  
    //var_dump($link);
    $sql='SELECT * FROM news';  
    $rows = $db->fetchAll($sql);  
    //var_dump($rows); 
    echo json_encode($rows);
?>