Buona sera, come da titolo il problema riguarda un minimotore di ricerca interno: vorrei selezionare gli utenti presenti nel database. Ecco il codice:

Codice PHP:
<?php
                        if (isset($src) && trim($src)!="")
                        {
                            $arr_txt = explode(" ", $src);
                            $sql = "SELECT * FROM user_info WHERE ";
                            for ($i = 1; $i <= count($arr_txt); $i++)
                            {
                                if ($i > 1)
                                    $sql .= " AND ";
                                
                                $sql .= "(first_name LIKE '%" .$arr_txt[$i]. "%' OR last_name LIKE '%" .$arr_txt[$i]. "%')";
                            }
                            $sql .= " AND active='1'";
                            
                            $query = $data -> query($sql);
                            
                            $obj_num = mysql_num_rows($query);
                            if ($obj_num == 0)
                                echo "Nessun risultato";
                            else
                            {
                                $num = 1;
                                
                                while ($obj = $data -> estract($query))
                                {
                                    $name        = $obj -> first_name;
                                    $surname    = $obj -> last_name;
                                    
                                    echo ($name." ".$surname);
                                    
                                    if ($num == $obj_num)
                                        break;
                                    
                                    $num++;
                                }
                            }
                        }
                    ?>
In questo modo mi stampa tutti i risultati nel database qualunque sia la chiave di ricerca