<a href='make_csv.php?id=<?php echo $results_id_str; ?> &type=items'><img src='img/spreadsheet.png' title='Export in spreadsheet file' alt='Export in spreadsheet file' /></a> </div> <?php if ($count == 1) { echo "<div id='search_count'>" . $count . " result</div>"; } else { echo "<div id='search_count'>" . $count . " results</div>"; } echo "<div class='search_results_div'>"; // Display results echo "<hr>"; foreach ($results_id as $id) { showDB($id, $_SESSION['prefs']['display']); } } else { // no results $message = "Sorry, I couldn't find anything :("; echo display_message('error', $message); } } } } ?> <script> $(document).ready(function(){ // DATEPICKER $( ".datepicker" ).datepicker({dateFormat: 'yy-mm-dd'});
$sql = "SELECT * FROM items ORDER BY id DESC LIMIT 10"; $req = $bdd->prepare($sql); $req->execute(); $count = $req->rowCount(); if ($count == 0) { $message = "<strong>Welcome to eLabFTW.</strong> \n Select an item in the «Create new» list to begin filling your database."; echo display_message('info', $message); } else { $results_arr = array(); while ($final_query = $req->fetch()) { $results_arr[] = $final_query['id']; } // loop the results array and display results echo "<p>Showing last 10 uploads :</p>"; foreach ($results_arr as $result_id) { showDB($result_id, $display); } } } ?> <script> function go_url(x) { if(x == '') { return; } location = x; } </script>
function deleteEverything() { $con = connect(); $sql = "DELETE FROM Hotel"; if (mysqli_query($con, $sql)) { echo " Deleted Everything in Hotel"; } else { echo " Failed to Delete Everything in Hotel"; } showDB($con); echo "All data deleted. Please insert some data"; }
} elseif (count($results_arr) === 0 && $search_type === 'none') { display_message('info', _('<strong>Welcome to eLabFTW.</strong> Select an item in the «Create new» list to begin filling your database.')); } else { ?> <div class='align_right'> <a name='anchor'></a> <p class='inline'><?php echo _('Export this result:'); ?> </p> <a href='make.php?what=zip&id=<?php echo Tools::buildStringFromArray($results_arr); ?> &type=items'> <img src='img/zip.png' title='make a zip archive' alt='zip' /> </a> <a href='make.php?what=csv&id=<?php echo Tools::buildStringFromArray($results_arr); ?> &type=items'> <img src='img/spreadsheet.png' title='Export in spreadsheet file' alt='Export CSV' /> </a> </div> <?php echo "<p class='smallgray'>" . count($results_arr) . " " . ngettext("result found", "results found", count($results_arr)) . " (" . $total_time['time'] . " " . $total_time['unit'] . ")</p>"; } // loop the results array and display results foreach ($results_arr as $result_id) { showDB($result_id, $_SESSION['prefs']['display']); }