PHP Classes

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 of databasefiller_example.php
Date: 2 months ago
Size: 1,587 bytes
 

Contents

Class file image Download
<?php

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

declare(strict_types=1);

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

require('classes/databasefiller.class.php');
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,

   
// 'incremental_ints' => true,
    // 'populate_primary_key' => true, # experimental

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


$oDF = new DatabaseFiller($aConfiguration);

echo
$oDF->displayMessages();