mardi 3 mars 2015

codeigniter random databse row to android string

I have a website built with codeigniter that picks a random row from my "facts" table. I want to build a android app that simply displays this random fact, with a button to refresh/get a new fact. I am new to android/API builing so i don't know anything about it. Can anyone help me?


ffotd_model.php:



function getrandom_facts()
{
$this->db->order_by('id', 'RANDOM');
$this->db->limit(1);
$query = $this->db->get('facts');
return $result = $query->result();
}


Controller ffotd.php:



public function index()
{
$data = array();
$this->load->helper('url');
$this->load->view('header');
$data['result'] = $this->ffotd_model->getrandom_facts();
$this->load->view('ffotd.php', $data);
$this->load->view('footer');
}




Aucun commentaire:

Enregistrer un commentaire