Skip to content

Instantly share code, notes, and snippets.

@Moketronics

Moketronics/generator.php

Created February 25, 2012 23:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Moketronics/1911526 to your computer and use it in GitHub Desktop.
Save Moketronics/1911526 to your computer and use it in GitHub Desktop.
Download ZIP
Basically complete tile product entry generator
Raw
generator.php
<?php
$sPage_title = 'Random Tile Generator';
include ('./includes/header.html');
require_once('../../../mysql_connect.php');
if (isset($_POST['submitted'])) {
if (is_numeric($_POST['quantity'])) {
$aTile_colours = array('Bianco', 'Gris', 'Beige', 'Nero', 'Oro', 'Negro', 'Noce', 'Sequoia', 'Ivory', 'Sage', 'Azure', 'Argento', 'Chiaro', 'Rojo', 'Rosa', 'Accaico', 'Cream', 'Verde', 'Cielo', 'Mediterannio');
$aTile_descriptors = array('Polished', 'Honed', 'Tumbled', 'Brillo', 'Matte', 'Travertino', 'Frosted', 'Clear', 'Crackle', 'Beveled', 'Rectified', 'Classic');
$aTile_names = array('Lappanto', 'Tivolino', 'Darby', 'Fabulisimo', 'Barocious', 'Pietra', 'Select', 'Bokononist', 'Crema', 'Taborone', 'Copperworks', 'Landscape', 'Chromatic', 'Sun', 'Echo', 'Happle', 'Bagatelle', 'Torchlight', 'Rainforest', 'Diabolo');
$aManufacturers = array();
$result = mysql_query('SELECT manufacturer_id FROM manufacturer');
while ($row = mysql_fetch_array($result)) {
array_push($aManufacturers, $row['manufacturer_id']);
}
$aColours = array();
$result = mysql_query('SELECT colour_id FROM colour');
while ($row = mysql_fetch_array($result)) {
array_push($aColours, $row['colour_id']);
}
$aCountries = array();
$result = mysql_query('SELECT country_id FROM country');
while ($row = mysql_fetch_array($result)) {
array_push($aCountries, $row['country_id']);
}
$aMaterials = array();
$result = mysql_query('SELECT material_id FROM material');
while ($row = mysql_fetch_array($result)) {
array_push($aMaterials, $row['material_id']);
}
$aSealants = array();
$result = mysql_query('SELECT sealant_id FROM sealant');
while ($row = mysql_fetch_array($result)) {
array_push($aSealants, $row['sealant_id']);
}
for ($i = 1; $i <= $_POST['quantity']; $i++) {
switch (rand(1, 6)) {
case 1:
$sTile_name = $aTile_colours[array_rand($aTile_colours)] . ' ' . $aTile_descriptors[array_rand($aTile_descriptors)] . ' ' . $aTile_names[array_rand($aTile_names)];
break;
case 2:
$sTile_name = $aTile_colours[array_rand($aTile_colours)] . ' ' . $aTile_names[array_rand($aTile_names)] . ' ' . $aTile_descriptors[array_rand($aTile_descriptors)];
break;
case 3:
$sTile_name = $aTile_descriptors[array_rand($aTile_descriptors)] . ' ' . $aTile_colours[array_rand($aTile_colours)] . ' ' . $aTile_names[array_rand($aTile_names)];
break;
case 4:
$sTile_name = $aTile_descriptors[array_rand($aTile_descriptors)] . ' ' . $aTile_names[array_rand($aTile_names)] . ' ' . $aTile_colours[array_rand($aTile_colours)];
break;
case 5:
$sTile_name = $aTile_names[array_rand($aTile_names)] . ' ' . $aTile_descriptors[array_rand($aTile_descriptors)] . ' ' . $aTile_colours[array_rand($aTile_colours)];
break;
default:
$sTile_name = $aTile_names[array_rand($aTile_names)] . ' ' . $aTile_colours[array_rand($aTile_colours)] . ' ' . $aTile_descriptors[array_rand($aTile_descriptors)];
}
$query = "SELECT tile_name FROM tiles WHERE tile_name = '$sTile_name'";
if (!$result = mysql_fetch_array(@mysql_query($query))) {
$iTile_price = rand(175, 9500);
$iQuantity = rand(15, 10000);
$iOld_lot_qty = ($iQuantity - rand(0, (round($iQuantity / 2))));
$iNom_height = (rand(1, 48) + (rand(1, 32) / 32));
$iNom_width = (rand(1, 48) + (rand(1, 32) / 32));
$iExact_height = round($iNom_height * 25.4);
$iExact_width = round($iNom_width * 25.4);
$iNom_thick = (rand(8, 20) / 32);
$iBox_tile_count = (rand(0, 50) * 5);
if (rand(0, 4) == 0) {
$iBox_tile_count = NULL; // Can be null, so this way ~20% of the time it will be sometimes
}
$iLocal_supply = rand(0, 3);
$iRating = rand(0,9);
if (rand(0,2) > 1) {
$sTile_notes = 'Some of the tiles will have notes like this. They can be pretty long! Here is a random number unlikely to be over 9000: ' . rand(0,9001);
}
$iPrimary_colour = $aColours[array_rand($aColours)];
switch (rand(1,4)) {
case 1:
$aSecondary_colours = array(); // No secondary colour, but I'm making the array just in case.
break;
case 2:
$aSecondary_colours = array($aColours[array_rand($aColours)]);
$b = 0;
while ($iPrimary_colour == $aSecondary_colours[0]) {
$aSecondary_colours[0] = $aColours[array_rand($aColours)];
$b++;
if ($b >= 5) { // limits tries at getting a non-duplicate value, doubling to suppress the number tiles with extra colours.
unset($aSecondary_colours[0]);
break;
}
}
break;
case 3:
$aSecondary_colours = array($aColours[array_rand($aColours)],
$aColours[array_rand($aColours)]);
$b = 0;
while ($iPrimary_colour == $aSecondary_colours[0]) {
$aSecondary_colours[0] = $aColours[array_rand($aColours)];
$b++;
if ($b >= 5) {
unset($aSecondary_colours[0]);
break;
}
}
$b = 0;
while (($iPrimary_colour == $aSecondary_colours[1]) || ($aSecondary_colours[0] == $aSecondary_colours[1])) {
$aSecondary_colours[1] = $aColours[array_rand($aColours)];
$b++;
if ($b >= 5) {
unset($aSecondary_colours[1]);
break;
}
}
break;
case 4:
$aSecondary_colours = array($aColours[array_rand($aColours)],
$aColours[array_rand($aColours)],
$aColours[array_rand($aColours)]);
$b = 0;
while ($iPrimary_colour == $aSecondary_colours[0]) {
$aSecondary_colours[1] = $aColours[array_rand($aColours)];
$b++;
if ($b >= 5) {
unset($aSecondary_colours[0]);
break;
}
}
$b = 0;
while (($iPrimary_colour == $aSecondary_colours[1]) || ($iPrimary_colour == $aSecondary_colours[2]) || ($aSecondary_colours[0] == $aSecondary_colours[1]) || ($aSecondary_colours[0] == $aSecondary_colours[2]) || ($aSecondary_colours[1] == $aSecondary_colours[2])) {
$aSecondary_colours[1] = $aColours[array_rand($aColours)];
$aSecondary_colours[2] = $aColours[array_rand($aColours)];
$b++;
if ($b >= 10) {
unset($aSecondary_colours[1]);
unset($aSecondary_colours[2]);
break;
}
}
}
$iManufacturers = $aManufacturers[array_rand($aManufacturers)];
$iCountry = $aCountries[array_rand($aCountries)];
$iMaterials = $aMaterials[array_rand($aMaterials)];
if (rand(0,1) == 0) {
$iSealants = $aSealants[array_rand($aSealants)];
} else {
$iSealants = NULL;
}
$query = "SELECT series_id FROM series WHERE manufacturer_id='$iMaterials'";
$result = mysql_query($query);
$iSeries = NULL;
if ($result) {
$aSeries = array();
while ($row = mysql_fetch_array($result)) {
array_push($aSeries, $row['series_id']);
}
//Suppresses adding a series at a rate inversely prelated to the number of series associated with the tile.
if (rand(0, count($aSeries)) != 0) {
$iSeries = $aSeries[array_rand($aSeries)];
}
}
$query = "INSERT INTO tiles (tile_name, tile_price, quantity, old_lot_qty, nom_height, nom_width, nom_thick, exact_height, exact_width, box_tile_count, local_supply, rating, tile_notes) VALUES (
'$sTile_name',
'$iTile_price',
'$iQuantity',
'$iOld_lot_qty',
'$iNom_height',
'$iNom_width',
'$iNom_thick',
'$iExact_height',
'$iExact_width',
'$iBox_tile_count',
'$iLocal_supply',
'$iRating',
'$sTile_notes'
);";
$result_tiles = @mysql_query($query);
if ($result_tiles) {
$query = "SELECT tile_id FROM tiles WHERE tile_name = '$sTile_name'";
$iTile_id = mysql_fetch_array(mysql_query($query));
$iTile_id = $iTile_id['tile_id'];
$query = "INSERT INTO material_associations (tile_id, material_id) VALUES ('$iTile_id', '$iMaterials');";
$result_material = mysql_query($query);
$query = "INSERT INTO country_associations (tile_id, country_id) VALUES ('$iTile_id', '$iCountry');";
$result_country = mysql_query($query);
$query = "INSERT INTO manufacturer_associations (tile_id, manufacturer_id) VALUES ('$iTile_id', '$iManufacturers');";
$result_manufacturer = mysql_query($query);
if ($iSealants != NULL) {
$query = "INSERT INTO sealant_associations (tile_id, sealant_id) VALUES ('$iTile_id', '$iSealants');";
$result_manufacturer = mysql_query($query);
}
$query = "INSERT INTO colour_associations (tile_id, colour_id, b_primary_colour) VALUES ('$iTile_id', '$iPrimary_colour', 1);";
$result_primary_colour = mysql_query($query);
// insert series associations here.
if ($iSeries != NULL) {
$query = "INSERT INTO seies_associations (tile_id, series_id) VALUES ('$iTile_id', '$iSeries')";
}
if (isset($aSecondary_colours[0])) {
for ($k = 0; $k < count($aSecondary_colours); $k++) {
$iScolour = current($aSecondary_colours);
$query = "INSERT INTO colour_associations (tile_id, colour_id, b_primary_colour) VALUES ('$iTile_id', '$iScolour', 0);";
$result_country = mysql_query($query);
next($aSecondary_colours);
}
}
} else {
// delete the entry, print an error message and quit. But I don't think I really have to do this for the generator.
}
}
}
} else {
echo '<p class="error">Please input a valid tile quantity less than 1000</p>';
}
}
if (isset($_POST['clear_it'])) {
mysql_query("TRUNCATE TABLE tiles;");
mysql_query("TRUNCATE TABLE colour_associations;");
mysql_query("TRUNCATE TABLE country_associations;");
mysql_query("TRUNCATE TABLE manufacturer_associations;");
mysql_query("TRUNCATE TABLE material_associations;");
mysql_query("TRUNCATE TABLE sealant_associations;");
mysql_query("TRUNCATE TABLE series_associations;");
}
$count_query = "SELECT tile_id FROM tiles";
$count_result = mysql_num_rows(mysql_query($count_query));
mysql_close(); // Done everything!
?>
<p>Current total tile records in database: <?php echo $count_result; ?></p>
<p>This fills up the tile database with a bunch of randomly generated tiles.</p>
<form action="generator.php" method="POST">
<p>Number of Tiles: <input type="text" name="quantity" size="3" maxlength="3" /></p>
<p><input type="submit" name="submitted" value="Generate!" /></p>
</form>
<form action="generator.php" method="POST">
<p><input type="submit" name="clear_it" value="*WARNING* Clear the database! *NO CONFIRMATION*" /></p>
</form>
<?php
include ('./includes/footer.html');
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment