I have a database wherein the files are named abcd100.00b, abcd101.00b,..... i need a code where wen the user enters abcd separate then 100 to 110 . all the files with the name abcd and in the range 100 to 110 should get displayed now the following code can display pnly the first four characters how do i implement this??????
<?php
//capture search term and remove spaces at its both ends if the is any
$searchTerm = trim($_GET['keyname']) ;
//check whether the name parsed is empty
if($searchTerm == "rinex_file")
{
echo "Enter name you are searching for.";
exit();
}
if($searchTerm == "rinex_file")
{
echo "Enter name you are searching for.";
exit();
}
//database connection info
$host = "localhost"; //server
$db = "rinex"; //database name
$user = "m"; //dabases user name
$pwd = "c"; //password
//connecting to server and creating link to database
$link = mysqli_connect($host, $user, $pwd, $db);
//MYSQL search statement
$query = "
SELECT * FROM rinexo WHERE rinex_file LIKE '%$searchTerm%'";
$results = mysqli_query($link, $query) ;
/* check whethere there were matching records in the table
by counting the number of results returned */
if(mysqli_num_rows($results) >= 1){
echo '<table border="1">
<tr>
<th>rinex version</th>
<th>program</th>
<th>date</th>
<th>maker name</th>
<th>maker number</th>
<th>observer</th>
<th>agency</th>
<th>position_X_Y_Z</th>
</tr>';
while($row = mysqli_fetch_array($results)){
echo '<tr>
<td>'.$row['rinex_version'].'</td>
<td>'.$row['pgm'].'</td>
<td>'.$row['date'].'</td>
<td>'.$row['marker_name'].'</td>
<td>'.$row['marker_no'].'</td>
<td>'.$row['observer'].'</td>
<td>'.$row['agency'].'</td>
<td>'.$row['position_X_Y_Z'].'</td>
</tr>';
}
echo '</table>';
}else{
echo "There was no matching record for the name " . $searchTerm;
}
