File: databasefiller_example.php

Recommend this page to a friend!
  Classes of Martin Latter  >  PHP Database Fill  >  databasefiller_example.php  >  Download  
File: databasefiller_example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Database Fill
Fill records of MySQL tables with test data
Author: By
Last change: update code to PHP 7.2
Date: 4 months ago
Size: 1,497 bytes


Class file image Download

    * Example to set-up and call databasefiller.class.php
    * Martin Latter, 14/12/2014


ini_set('memory_limit', '256M'); # for inserting a large number of rows ($aConfiguration['num_rows'])

header('Content-Type: text/html; charset=utf-8');

    * Configuration array settings to pass to databasefiller.class.php

$aConfiguration =
# output type toggle
'debug' => false, # set TRUE for verbose screen output and no database insertion, FALSE for database insertion

    # number of rows to insert
'num_rows' => 10,
// optimise mysqld variables in my.cnf/my.ini files when inserting a large number of rows (e.g. 50000)

    # database details
'host' => 'localhost',
'database' => 'dbfilltest',
'username' => 'USERNAME',
'password' => 'PASSWORD',

# schema file
'schema_file' => 'test.sql',

# database connection encoding
'encoding' => 'utf8', # latin1 / utf8 etc

    # random data toggle - set to false for a much faster fixed character fill - but ... no unique indexes permitted
'random_data' => true,

# random character range: ASCII integer values
'low_char' => 33,
'high_char' => 126,

# CLI usage: rows of SQL generated before displaying progress percentage
'row_counter_threshold' => 1000

$oDF = new DatabaseFiller($aConfiguration);


For more information send a message to info at phpclasses dot org.