<?php
include_once('connect.php');
$filenames = new Connection(); //Instantiate a new connection.
//Filename cleanup: Rename files and remove spaces, commas, equal signs, semi-colons, apostrophes, etc.:
//foreach(glob("{*.amr,*.AMR,*.mp3,*.MP3}",GLOB_BRACE ) as $file) {
foreach(glob("{*.mp3}",GLOB_BRACE ) as $file) {
if (strpos($file, " ") > 0) { //If there are more than 0 spaces in the name.
/*
$x = "mv \"" . $file . "\" ";
$y = str_replace(" ", "_", $file); //Remove spaces.
$y = str_replace(",", "", $y); //Remove commas.
$y = str_replace("=", "", $y); //Remove equals.
$y = str_replace(";", "", $y); //Remove semi-colons.
$y = str_replace("'", "", $y); //Remove apostrophes.
$y = str_replace("(", "", $y); //Remove left parenthesis.
$y = str_replace(")", "", $y); //Remove right prenthesis.
$y = str_replace("$", "", $y); //Remove dollar signs.
$y = str_replace("[", "", $y); //Remove left brackets.
$y = str_replace("]", "", $y); //Remove right brackets.
$y = str_replace("&", "", $y); //Remove ampersands.
$y = str_replace("`", "", $y); //Remove accent aigou.
$y = str_replace("._", "_", $y); //Remove period underscore.
*/
//echo "mv " . $x . " " . $y . "<br />";
//echo $x . " " . $y . "<br />";
// WHEN REDIRECTING TO A FILE, DO NOT USE "\r\n" BECAUSE IT WILL PUT A CARRIAGE RETURN IN THE FILENAME!
}
$a = str_replace("CALLU_","",$file);
$a = str_replace("_Private.mp3","",$a);
$a = str_replace("_"," ",$a);
$b = explode(' ',$a);
$c = date_create($b[0] . " " . str_replace("-",":",$b[1]));
$d = date_format($c, "Y-m-d H:i:s");
$e = date_format($c, "YmdHis"); //Military time.
/*
//Echo query to see what it looks like.
echo "insert into call_u (orig_filename, call_dt_tm, new_filename) values ('" .
$file . "','" .
$d . "','" .
$e . "_CALLU_Private.mp3'," .
"'mv " . $file . " " . $e . "_CALLU_Private.mp3');
";
*/
//Add named parameters to query begin:
$FileQ = "insert into call_u (orig_filename, call_dt_tm, new_filename) values (" .
":orig_filename," .
":call_dt_tm," .
":new_filename);";
//Add named parameters to query end:
//Testing begin.
//echo $FileQ . "
";
//echo $file . " " . $d . " " . $e . "_CALLU_Private.mp3";
//Testing end.
////Insert user data.
$filenames->myQuery($FileQ);
$filenames->bind(':orig_filename', $file); //bind each value
$filenames->bind(':call_dt_tm', $d); // bind
$filenames->bind(':new_filename', $e . '_CALLU_Private.mp3');
//Execute the query.
if($filenames->run()){
//$lastid = $filenames->lastInsertId(); //Get the last inserted ID
//echo "ID of record inserted: " . $lastid . ".
";
}
}
?>