if ($hidemarks != 1) { echo "<p><a href=\"db_filedetails.php?SoundID={$SoundID}&hidemarks=1&d={$d}&hidekml={$hidekml}\">Hide marks on spectrogram</a><br>"; } else { echo "<p><a href=\"db_filedetails.php?SoundID={$SoundID}&d={$d}&hidekml={$hidekml}\">Show marks on spectrogram</a><br>"; } echo "<a href=\"#\" onclick=\"window.open('db_filemarks.php?SoundID={$SoundID}', 'marks', 'width=600,height=550,status=yes,resizable=yes,scrollbars=auto')\">Show list of marks</a><br>"; } } echo "\n\t\t\t\t\t<dl class=\"dl-horizontal\">\n\t\t\t\t\t\t<dt>Original filename</dt>\n\t\t\t\t\t\t<dd>{$OriginalFilename}</dd>"; #Check if the file size is in the database if ($FileSize == NULL || $FileSize == 0) { $file_filesize = filesize("sounds/sounds/{$ColID}/{$DirID}/{$OriginalFilename}"); #$result_size = mysqli_query($connection, "UPDATE Sounds SET FileSize='$file_filesize' WHERE SoundID='$SoundID' LIMIT 1") # or die (mysqli_error($connection)); $this_array = array('FileSize' => $file_filesize); DB::update('Sounds', $this_array, $SoundID, 'SoundID'); $FileSize = formatSize($file_filesize); } else { $FileSize = formatSize($FileSize); } echo "<dt>File Format</dt><dd>{$SoundFormat}</dd>\n\t\t\t\t\t\t<dt>Sampling rate</dt><dd>{$SamplingRate} Hz</dd>\n\t\t\t\t\t\t<dt>Number of channels</dt><dd>{$Channels}</dd>"; echo "\n\t\t\t\t\t\t<dt>File size</dt>\n\t\t\t\t\t\t<dd>{$FileSize}</dd>"; if ($Duration > 60) { $formated_Duration = formatTime(round($Duration)); echo "<dt>Duration</dt><dd>{$formated_Duration} (hh:mm:ss)</dd>"; } else { echo "<dt>Duration</dt><dd>{$Duration} seconds</dd>"; } #Check if from a sample set if ($pumilio_loggedin) { $sample_check = mysqli_query($connection, "SELECT Samples.SampleName,Samples.SampleID FROM\n\t\t\t\t\t\t\tSamples,SampleMembers WHERE Samples.SampleID=SampleMembers.SampleID \n\t\t\t\t\t\t\tAND SampleMembers.SoundID='{$SoundID}'") or die(mysqli_error($connection));
// Insert some users $user = array('username' => 'Mary', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); $user = array('username' => 'John', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); $user = array('username' => 'Bobb', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); $user = array('username' => 'Troll', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); // Oops! We got Bob's info wrong! Lets fix it! $user = array('username' => 'Bob', 'email' => '*****@*****.**'); $result = DB::update('users', $user, 3); var_dump($result); // Our moderators say that the "Troll" user needs to be deleted! $result = DB::query('DELETE FROM users WHERE username = ?', array('Troll')); var_dump($result); /* * Select Queries */ // Count all the users $result = DB::column('SELECT COUNT(*) FROM `users`'); var_dump('Total users: ' . $result); br(); // Get user number 2 (John) $result = DB::row('SELECT * FROM `users` WHERE id = ?', array(3)); var_dump($result); br();