If you are a hard coder, you might write hundreds of lines of php code to fetch the data from database, to show it in the form. But it may eat up lots of time and also costs the energy of your fingers.
Why not we use the php functions to fetch the data and avoid rewriting of the code?
Suppose we want to display the information of a product based on the category it belongs to. For this, we write a query like: select * from products where category_id=1 and product_id=2.
This will fetch the details about a product with id=2(say, Reynolds) and category with id=1(say, Pens). Then we can fetch the Reynolds product data and display it as needed.
But suppose you need to fetch the details of the Reynolds product often and display it. Its not easy for a common developer to write queries now and then to fetch 1 or 2 columns of data (say, we just need the price and color).
Then we can use custom php functions to get the work done. For ex, i frequently need to fetch the price of a product, and display it beside a product name, that is chosen random, or based on a condition such as the latest product. Then i write a php function like: getPrice(id), and include it in the file includes/functions.php.
This function will take the id of the product and queries the database to fetch the price of it and returns it. Thus our effort to write the query, fetch the result set and the required column (price) is now reduced to just calling the getPrice(id) function.
Similarly, we can write many functions to fetch the desired data and use it as often, without manually writing the queries everytime.
Why not we use the php functions to fetch the data and avoid rewriting of the code?
Suppose we want to display the information of a product based on the category it belongs to. For this, we write a query like: select * from products where category_id=1 and product_id=2.
This will fetch the details about a product with id=2(say, Reynolds) and category with id=1(say, Pens). Then we can fetch the Reynolds product data and display it as needed.
But suppose you need to fetch the details of the Reynolds product often and display it. Its not easy for a common developer to write queries now and then to fetch 1 or 2 columns of data (say, we just need the price and color).
Then we can use custom php functions to get the work done. For ex, i frequently need to fetch the price of a product, and display it beside a product name, that is chosen random, or based on a condition such as the latest product. Then i write a php function like: getPrice(id), and include it in the file includes/functions.php.
This function will take the id of the product and queries the database to fetch the price of it and returns it. Thus our effort to write the query, fetch the result set and the required column (price) is now reduced to just calling the getPrice(id) function.
Similarly, we can write many functions to fetch the desired data and use it as often, without manually writing the queries everytime.
Comments
Post a Comment