CODEWITHSUNDEEP
mysqlcodeigniter-3
user7306068
user7306068

Reputation:

codeigniter 3 $query = $this->db->query($queri_str); return 0 result

Good morning, I have a problem with mysql and coeigniter 3. if I request data with 

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

it does not give me results. if I enter the query on phpmyadmin it shows me two results.

$ queri_str = 'SELECT * FROM `my_table` WHERE` id_mytable2` = "'. $ id_name. '"';

The database tables were created with mysql workbench and automatically the reference to the main table with a 1: n ratio was added

Upvotes: 0

Views: 504

Answers (3)

user7306068
user7306068

Reputation:

the problem is back. I'll explain. 

function myfunction($id_myname) {
    $this->db->select('*');
    $this->db->where('id_myname', $id_myname);
    //$query = $this->db->get('my_table');
    $query = $this->db->get('my_table');
    //print_r($query);
    //var_dump($query);
    if ( !$query ){
        $error = $this->db->error(); // Has keys 'code' and 'message'
    }
    return $query->result();
}

when I call this function an empty value comes back to me. While if I enter the value of the query in phpmyadmin I find two values

Upvotes: 0

lutakyn
lutakyn

Reputation: 474

Try this solution, you want to do a normal select,I don't know the query your wrote but 

public fucntion get_data($id){

     $this->db->select('*');
    $this->db->from('your_table');
    $this->db->where('id','=' ,'$id');
    $query = $this->db->get();
     $data = $query->result_array(); 
     return $data;
   }

Upvotes: 1

Devsi Odedra
Devsi Odedra

Reputation: 5322

Try this query

$this->db->select('*');
    $this->db->where('id', '58e5j0m5bqrs7hk8suokko28hj7ni0v6');
    $result = $this->db->get('ci_sessions')->result_array();
    print_r($result);

Upvotes: 1

Related Questions