PHPRecipeBook 2.36 review

PHPRecipeBook's purpose is to provide a convenient way to construct a weekly shopping list from a known list of recipes

License: GPL (GNU General Public License) File size: 0K Developer: Todd Rogers

0

PHPRecipeBook's purpose is to provide a convenient way to construct a weekly shopping list from a known list of recipes. The user can view, add, search and modify recipes like any decent web based cookbook.

This cookbook provides the extra functionality to add recipes to a shopping list. The shopping list then can be saved or printed out. The printed out version of the shopping list will attempt to merge similar items on the list. For example if two recipes call for 1 onion each, then the list will show a listing for 2 onions and not two separate onion listings.

The ability to sort the shopping list will also be a feature of the project. The user will be able to set in preferences if they want vegetables to appear at the top, or meats, or whatever items the first find when walking into their local supermarket.

The lists that are saved to the database can be later loaded and viewed. An option to delete saved lists will also be available. The names of the lists can be changed, and a new list can be saved to an existing list name (save to??¦ option).

Requirements:
Apache 2.0/1.3
PHP 4.2.2:
- with PostgreSQL or MySQL Support compiled in or installed as a package
- XML support
Database: PostgreSQL 7.2.3 or MySQL 3.23.52-3

Installation

Make sure the version of PHP and PostgreSQL/MySQL match or exceed those given above. PHP especially, I know they changed some of the method names, so an older version will not function correctly.

Install and setup Apache, PHP, PostgreSQL/MySQL on your system. Then proceed with these instructions to setup PHPRecipeBook.

Database:
Table Names:
If you have to share a database with other applications first edit the database schema to make sure it does not conflict. Then update the settings in custom_inc.php (get values from includes/config_inc.php) to match your new table names.

PostgreSQL:
1. Create the database. As the postgres user:
createdb recipedb

Note: The argument "recipedb" can be anything you want, just make sure you edit the PHP settings later to reflect this.

2. Import the Schema:
cd sql
psql recipedb
> i recipedb.pgsql
> i recipedb_data_(lang).sql
> i recipedb_ingredients_en.sql (optional step)

3. Grant permissions to a user of your choosing to access the database. These values are changed in hba.conf of PostgreSQL's config (found in /var/lib/pgsql/data on Redhat and some other systems).

Remember the user and password you select for later use in config.

MySQL:
1. Create the database.
mysqladmin -u user -p mypass create recipedb

2. Import the Schema:
mysql -u user -p mypass recipedb < recipedb.mysql
mysql -u user -p mypass recipedb < recipedb_data_en.sql
mysql -u user -p mypass recipedb < recipedb_ingredients_en.sql (optional step)

Customize The Data:
You can customize the dropdown selectings such as the ethnicity, courses, bases, etc... in the PHPRecipeBook by logging in as a admin user and selecting the Settings->Administration->Customize menu.

What's New in This Release:
MySQL 5.0 fix made, curdate() removed.
Some UTF-8 fixes made
Shopping list lost ingredients now get removed when checked.