什么是编写php mysql函数的最佳方法？

Question

i want to retrieve information from my database quite a lot throughout my app, i was thinking it would be easier to write function, so i can access it anytime, what is the best way to write one! thanks :))

Answer 1

hope this helps, you have to pass variables to a function, then use that variable to retrieve something from your database! i.e.

function getUserInfo($username) {

                $query = "SELECT * FROM user WHERE username = '$username'";
                $result = mysql_query($query);
                if (!mysql_num_rows($result)) return false;
                $row = mysql_fetch_array($result);
                return $row;

            }