refactoring sql in php

Question

What is a good place to put sql commands so they do not appear in the main code, how can this be done? How can sql commands such as the following be refactorised:

function select_Query($sql, $link)
{
    $query = mysqli_query($link, $sql);

    if (!$query)
    {
        echo "Failure"; #   TODO: LOG THIS
    }

    $data = array();
    while ($row = mysqli_fetch_array($query) )
    {
        $data[] = $row;
    }    

    return $data;
}


$query = select_Query("SELECT thread.title, thread.id as t_id,
                         thread.content
                         FROM thread
                         LIMIT $start, 30", $link);

How would you factorise the $query var part to generalise it for other sql statements - as that is fairly simple sql, however when several joins are used sql commands take up several lines in my code, I don't want to mix them with my php code.

Dan Grossman · Accepted Answer · 2011-02-05 19:33:08Z

1

Read about ORM and MVC. You factor it out by building a layered application, and encapsulating your data models in classes.

answered Feb 5, 2011 at 19:33

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.P. · Accepted Answer · 2011-02-05 21:51:15Z

0

Check out Zend Framework I have became to worship it.

answered Feb 5, 2011 at 21:51

A.P.

3053 silver badges5 bronze badges

Collectives™ on Stack Overflow

refactoring sql in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related