PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `ribhnumsoldeclien` ( `id` int(20) PRIMARY KEY NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL, `prix` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `ribhnumsoldeclien` (`id`, `email`, `prix`) VALUES (1, 'mehdi@gmail.com', '4.5'), (2, 'mehdi@gmail.com', '4.5'), (3, 'ayoub@gmail.com', '4.5'), (4, 'ayoub@gmail.com', '4.5');
Copy Clear
Copy Format Clear
<?php $query = mysqli_query($mysqli, "SELECT email , prix FROM ribhnumsoldeclien "); $array2=array(); while($row=mysqli_fetch_assoc($query)) { $email = explode("," ,$row['email']); $prix = explode("," ,$row['prix']); for($i = 0; $i<count($email); $i++) { array_push($array2, trim ($email[$i]) ); array_push($array2, trim ($prix[$i]) ); } } print_r( array_count_values($array2) ) ; print_r( array_keys(array_count_values($array2))[0] ); ?>
Show:  
Copy Clear