Sorry, your browser does not support JavaScript!

Have an account?

Don't have account,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

1+5 = ? ( 6 )

Have an account?

You must login to ask question.

Need An Account,

You must login to add post.

Need An Account,
Search
Ask A Question

LEARN, SHARE KNOWLEDGE & WORK TOGETHER

Aviance School is one of the largest web solutions platform in India for developers to learn and share​ ​their programming ​knowledge and build their careers.

Ask A Question
Home / Questions / Q 5790
In Process
  • 0
Pundit
Asked:

How can you connect models to a database manually?

  • 0

How can you connect models to a database manually?

Share

    0 Answers

    1. Learner

      Using Functional php to connect to a mysql db. It comes form the php manual. Put this in your model. Call it by calling a model function the normal CI way. It will return the result array, so assign the model call to a variable in your controller.

      <?php
function my_model_query(){
    //replace the function arguments with your information
    $link = mysql_connect('host_name', 'mysql_user', 'mysql_password');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    //your code here
    $query = "SELECT * FROM mytable";
    $result = mysql_query($query);
    while($row = mysql_fetch_assoc($result)){

        $result_array[]['your_field_1'] = $row['your_field_1'];
        $result_array[]['your_field_2'] = $row['your_field_2']; 
        //and so on

       }

  
    //send results back to controller
    return $result_array;


}//endfunction
?>
      • 0

    Leave an answer