ci框架连接mysql 简单查询demo

[php]代码库

		//先在application/config/database.php文件中配置好数据库用户名密码等
		$this->load->database();

		$query = $this->db->query('SELECT * FROM test');

		//对象形式返回结果
		foreach ($query->result() as $row)
		{
			echo $row->id . ' ';
			echo $row->content . '<br><br>';
		}

		echo '查询结果数: ' . $query->num_rows();



		$query = $this->db->query('SELECT * FROM test');

		//数组形式返回结果
		foreach ($query->result_array() as $row)
		{
			echo $row['id'] . ' ';
			echo $row['content'] . '<br><br>';
		}


		echo '查询结果数: ' . $query->num_rows();