Hi Everyone,
I would like to know how to change this script to read from a Mysql database instead of a flat text file, without making to many changes to the script.
Flat database file reg.txt
aaaaaaa|bbbbbbbbbbb|ccccccccc|ddddddd|eeeeeeee
<?PHP
if(isset($_POST['search'])){
$fp = file("reg.txt");
$search = "/".$_POST['search']."/i";
$y = 0;
$results[0]=Array();
$results[1]=Array();
$results[2]=Array();
$results[3]=Array();
$results[4]=Array();
for($x=0; $x<count($fp); $x++){
$search_text = "";
if(@$_POST['radiobutton']==5){
$search_text = split("\|",$fp[$x]);
$search_text = $search_text[4];
}else if(@$_POST['radiobutton']==4){
$search_text = split("\|",$fp[$x]);
$search_text = $search_text[3];
}else if(@$_POST['radiobutton']==3){
$search_text = split("\|",$fp[$x]);
$search_text = $search_text[2];
}else if(@$_POST['radiobutton']==2){
$search_text = split("\|",$fp[$x]);
$search_text = $search_text[1];
}else{
$search_text = split("\|",$fp[$x]);
$search_text = $search_text[0];
}
if(preg_match($search,$search_text)){
list($results[0][$y],$results[1][$y],$results[2][$y],$results[3][$y],$results[4][$y])=split("\|",$fp[$x]);
$y++;
}
}
if(@$_POST['radiobutton']==5){
array_multisort($results[4],$results[0],$results[1],$results[2],$results[3]);
}else if(@$_POST['radiobutton']==4){
array_multisort($results[3],$results[0],$results[1],$results[2],$results[4]);
}else if(@$_POST['radiobutton']==3){
array_multisort($results[2],$results[0],$results[1],$results[3],$results[4]);
}else if(@$_POST['radiobutton']==2){
array_multisort($results[1],$results[0],$results[2],$results[3],$results[4]);
}else{
array_multisort($results[0],$results[1],$results[2],$results[3],$results[4]);
}
