promash/setup.php

21 lines
507 B
PHP
Raw Permalink Normal View History

2014-03-07 18:45:30 +00:00
<?php
die("!!!");
include("connect.php");
$sql = "DROP TABLE pros";
$result = mysql_query($sql);
echo mysql_error();
$sql = "CREATE TABLE pros ( id INT AUTO_INCREMENT, image TEXT, value INT, PRIMARY KEY ( id ))";
$result = mysql_query($sql);
echo mysql_error();
$array = scandir("images");
foreach ($array as $i) {
if ($i == ".")
continue;
if ($i == "..")
continue;
echo $i . "<br />";
$sql = "INSERT INTO pros (image, value) VALUES ('" . $i . "', 1024)";
mysql_query($sql);
}
?>