Advertisement
Guest User

Create my table

a guest
Sep 12th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. <?php
  2.     $db_host = "127.0.0.1";
  3.     $db_username = "root";
  4.     $db_password = "xyz";
  5.     $db_name = "Test_Data";
  6.  
  7.     $connection = mysql_connect($db_host, $db_username, $db_password) or die(mysql_error());
  8.     $db = mysql_select_db($db_name, $connection);
  9.  
  10.     for ($i = 1; $i <= 250; $i++) {
  11.         $query = "INSERT INTO `Staff-Periods_Lookup` (`ID`, `Staff_ID`, `Period_ID`) VALUES ('$i', '1', '1')";
  12.         mysql_query($query) or die ("Error in query: $query. ".mysql_error());
  13.     }
  14. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement