Recherche base de données SQL et l'affichage des résultats

 
<?php
 
 
 
 
 
$DBhost = "mysql";   // Database Server
 
   $DBuser = "*******";            // Database User
 
   $DBpass = "********";            // Database Pass
 
   $DBName = "warrents";            // Database Name
 
   $table = "peope";             // Database Table
 
 
 
 
 
$user= $name;
 
 
 
 
 
 
 
// Connect to mySQL Server
 
   $DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error in GuestBook Application: " . mysql_error());
 
   // Select mySQL Database
 
   mysql_select_db($DBName, $DBConn) or die("Error in GuestBook Application: " . mysql_error());
 
 
 
// The SQL query.
 
$query = "SELECT * FROM $table WHERE last ='$user'" ;
 
$result = mysql_query($query);
 
 
 
 
 
 
 
echo "<?xml version=\"1.0\"?>\n";
 
echo "<peope>\n";
 
 
 
while($line = mysql_fetch_assoc($result)) {
 
   echo "<item> ". $line["last"] . "  ". $line["first"] . "             ". $line["dob"] . "               ". $line["charge"] . "</item>\n";
 
   
 
   
 
     
 
}
 
 
 
echo "</peope>\n";
 
 
 
mysql_close($link);
 
 
 
?>
 
 

on (release) {
    
var my_vars = new LoadVars();
//Get the text from Input Text
my_vars.name=name.text;

//Send input (my_vars) to PHP and assign result back to my_vars
my_vars.sendAndLoad("search.php",my_vars,"POST");





var theXML:XML = new XML();
theXML.ignoreWhite = true;

theXML.onLoad = function() {
    var nodes = this.firstChild.childNodes;
        for(i=0;i<nodes.length;i++) {
        theList.addItem(nodes[i].firstChild.nodeValue,i);
    }
}

theXML.load("search.php");

}

    

<?php  
 
 
 
 
 
$user=$_POST['name'];
 
$XMLFILE =  $user ."." ." xml";
 
//create XML file on Server
 
touch($XMLFILE);
 
 
 
//$user = "ADAMEN";
 
 
 
$DBhost  =  "localhost";      //  Database  Server
 
      $DBuser  =  "root";                        //  Database  User
 
      $DBpass  =  "";                        //  Database  Pass
 
      $DBName  =  "warrents";                        //  Database  Name
 
      $table  =  "people";                          //  Database  Table
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
//  Connect  to  mySQL  Server
 
$DBConn  =  mysql_connect($DBhost,$DBuser,$DBpass)  or  die("Error  in  GuestBook  Application:  "  .  mysql_error());
 
      //  Select  mySQL  Database
 
 mysql_select_db($DBName,  $DBConn)  or  die("Error  in  GuestBook  Application:  "  .  mysql_error());
 
 
 
//  The  SQL  query.  
 
$query  =  "SELECT  *  FROM  $table  WHERE  last  ='$user'"  ;  
 
$result  =  mysql_query($query);  
 
 
 
 
 
if($result){
 
   
 
   
 
   
 
   //echo"<item>  moodz";
 
$Text2Write = "<?xml  version=\"1.0\"?>\n
 
<peope>\n";
 
   
 
 
 
   
 
 while($line  =  mysql_fetch_assoc($result))  {
 
    $Text2Write .=  "<item>  ".  $line["last"]  . " ".  $line["first"]  .  "</item>\n";
 
       
 
       
 
               
 
}
 
 
 
$Text2Write.="</peope>\n";
 
}else{
 
   echo " Whateva";
 
}
 
$fp = fopen($XMLFILE,"w");
 
fwrite($fp,"$Text2Write");
 
fclose($fp);
 
 
 
echo" toload=$XMLFILE";
 
 
 
//mysql_close($link);
 
 
 
?>

on(release){
    //loadVariablesNum (search, 0, "POST");
answer = "Please Wait....";
var my_vars = new LoadVars();
var my_rcv_vars = new LoadVars();

//Get the text from Input Text
my_vars.name=name.text;

//Send input (my_vars) to PHP and assign result back to my_rcv-vars

my_vars.sendAndLoad("http://localhost:8080/search/search.php",my_rcv_vars ,"POST");
trace(my_vars);


//When recieving the return from the PHP file load the XML    
my_rcv_vars.onLoad = function() {
    trace('loaded');
    //traces the XML file that should be loaded ...
    trace(my_rcv_vars.toload );
    var theXML:XML = new XML();
    theXML.ignoreWhite = true;
    //trace(theXML);

//trace(nodes);
    theXML.onLoad = function() {
        var nodes = this.firstChild.childNodes;
     for(i=0;i<nodes.length;i++) {
         theList.addItem(nodes[i].firstChild.nodeValue,i);
    
     }
    }

    
theXML.load("http://localhost:8080/search/" + my_rcv_vars.toload );
}
//onrelease Ending
}