I'm trying to display unique value in for loop per below. The data is retrieved from mysql. Currently, it's displaying all the values in this column (Book Name) but just want to show just unique value and remove any duplicated values from displaying.
<?php
$i=0;
while($rows=mysql_fetch_array($result))
{
$roll1[$i]=$rows['bkname'];
$i++;
}
$total_elmt=count($roll1);
?>
<form method="POST" action=" ">
<select name="sel1" id="sel1">
<option value="Select Book Name">Book Name</option>
<?php
for($j=0;$j<$total_elmt;$j++)
{
?><option><?php
echo $roll1[$j];
?></option><?php
}
?>
</select>
</form>
Instead of removing duplicates in the PHP, you could just use a DISTINCT clause in your query:
<?php
$db = new mysqli('localhost', 'username', 'password', 'database_name');
// $sql = 'SELECT DISTINCT(bkname) FROM your_table_name';
$sql = 'SELECT * FROM your_table_name GROUP BY bkname';
$query = mysqli_query($db, $sql);
?>
<form method="POST" action="">
<select name="sel1" id="sel1">
<option disabled selected>Book Name</option>
<?php while($row = mysqli_fetch_assoc($query)): ?>
<option value="<?php echo $row['bkname']; ?>"><?php echo $row['bkname']; ?></option>
<?php endwhile; ?>
</select>
</form>
Obligatory Note:
Please, don't use
mysql_*functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.
How about PHPs array_unique function?
<?php
$input = array("Tale of two cities", "Tale of two cities", "A brief history of time", "Hop on Pop");
$noduplicates = array_unique($input);
var_dump($noduplicates);
?>
This can be handled in your query easiest most likely by using the DISTINCT keyword. If your query is something like
SELECT bkname FROM Books;
Instead you would do
SELECT DISTINCT bkname FROM Books;
If you don't want to modify your dataset though, and want an array of unique values from just a column in the dataset you can insert those values into an array utilizing it as a hashmap. The key will ensure uniqueness and eliminate duplicates.
while($rows=mysql_fetch_array($result)){
$roll1[$rows['bkname']] = $rows['bkname'];
}