Installation of ApPHP DataGrid

• 1. Installation of ApPHP DataGrid
  • 1.1 Step 1. Uncompressing downloaded file.
  • 1.2 Step 2. Uploading files.
  • 1.3 Step 3. Creating database.
  • 1.4 Step 4. Editing some important values.
  • 1.5 Step 5. Renaming code_template.php file.
  • 1.6 Step 6. Configure settings (optional).
  • 1.6 Step 6. Configure settings (optional).
  2. How to nstall and run script examples

Installation of ApPHP DataGrid

A new installation of ApPHP DataGrid is a very straight forward process

Step 1. Uncompressing downloaded file.

---

Uncompress the ApPHP DataGrid script archive. The archive will create a directory called "PHPDG_XYZ", where XYZ - is a number of current version.

Step 2. Uploading files.

---

Upload content of sub-directory datagrid/ (all files and sub-directories it includes) to your document root (public_html, www, httpdocs etc.) using FTP.

Pay attention: DON'T use the capital letters in the name of the folder (for Linux users).

For example:

public_html/your_site/datagrid/

Step 3. Creating database.

---

Using your hosting Control Panel, phpMyAdmin or another tool, create your database and user, and assign that user to the database. Provide the user you created with required permissons to allow the user to read, edit, execute and perform all tasks across all the databases and tables (SELECT, UPDATE, DELETE etc.). Write down the name of the database, username, and password for the site installation procedure.

Create all needed database tables.

Step 4. Editing some important values.

---

Create a new PHP file, using as example datagrid/code_template.php, uncomment following lines of code and change values of variables on yours (saved on step 3).

$DB_USER='db_user';       /* usually like this: prefix_name          */
$DB_PASS='db_password';   /* must be strong-generated (recommended)  */
$DB_HOST='localhost';     /* usually localhost                       */
$DB_NAME='db_name';       /* usually like this: prefix_dbName        */

Define a relative path to datagrid.class.php file (relatively to the code_template.php file).

NEW SYNTAX (v7.0.0 or higher):

/* Ex.: 'datagrid/' or '../datagrid/' */
define ('DATAGRID_DIR', '');                             
require_once(DATAGRID_DIR.'datagrid.class.php');        

OLD SYNTAX:

/* Ex.: 'datagrid/' or '../datagrid/' */
/* Ex.: 'datagrid/pear/' or '../datagrid/pear/' */
define ('DATAGRID_DIR', '');    
define ('PEAR_DIR', 'pear/');           

require_once(DATAGRID_DIR.'datagrid.class.php');
require_once(PEAR_DIR.'PEAR.php');
require_once(PEAR_DIR.'DB.php');

Step 5. Renaming code_template.php file.

---

Rename code_template.php file according to your needs, such as first_example.php or any other and then type in your browser:

http://your_site/datagrid/first_example.php

Step 6. Additional settings (optional).

---

Set allow_call_time_pass_reference to true in your INI file.

Congratulations, you now have ApPHP DataGrid installed!