Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = 'x.x.mysql';
- $dbuser = 'xxxxx';
- $dbpass = 'xxxxx';
- $dbname = 'xxxxx';
- $connect = mysql_connect($server,$dbuser,$dbpass);
- mysql_select_db($dbname,$connect);
- $dirs = array_filter(glob('gbpics/*'), 'is_dir');
- foreach ($dirs as $dir) {
- $path = $dir . "/";
- $files = array_map('mysql_real_escape_string', array_filter(glob("{$path}*.*"), 'is_file'));
- if (empty($files)) {
- echo "The data was inserted successfully.";
- } else {
- $insertValues = array();
- foreach ($files as $file) {
- $data = getimagesize($file);
- $width = $data[0];
- $height = $data[1];
- $insertValues[] = "('Titel', '{$dir}', '{$file}', '$width', '$height')";
- }
- $query = "INSERT INTO `gbpics` (`gbpictitel`, `gbpiccat`, `gbpicurl`, `gbpicwidth`, `gbpicheight`) VALUES " . implode(', ', $insertValues);
- if (!mysql_query($query)) {
- echo "There was a problem inserting the data.";
- trigger_error("Query failed: $query<br />Error: " . mysql_error());
- } else {
- echo "The data was inserted successfully.";
- }
- }
- }
- ?>
Add Comment
Please, Sign In to add comment