CS479/579 - Web Programming II

Displaying ./code/SQL/rnd.php

#!/usr/bin/php

DROP TABLE IF EXISTS `tablename`;

create table `tablename` (
  `id`  INT,
  `A`   VARCHAR(32),
  `B`   INT,
  `C`   FLOAT
);

INSERT INTO tablename (`id`, `A`, `B`, `C`)
 VALUES
<?php
  srand();

  $alpha = "abcdefghijklmnopqrstuvwxyz";
  for($id = 0; $id < 30; $id++) {
    $A = "";
    for($i=0; $i < 3; $i++)
      $A .= $alpha[rand(0,25)];

    $B = rand(1, 100);
    $C = rand(1, 1000) / 10;

    echo "($id, '$A', $B, $C)";
    if ($id < 29) echo ",\n";
    else echo ";\n";
  }

?>