Untitled

<?php
define('GLPI_ROOT','../..');
include (GLPI_ROOT . "/inc/includes.php");

Html::header($LANG['Menu'][0],$_SERVER['PHP_SELF'],"inventory"); //Affichage du menu de GLPI


    $host = 'localhost';
    $user = 'root';
    $mdp = '';
    $base = 'glpi';
    mysql_connect($host,$user,$mdp) or die("Impossible de se connecter");
    mysql_select_db($base) or die("Impossible de se connecter");

    $liste = mysql_query("SELECT id,name FROM glpi_users");
    $fab = mysql_query("SELECT id,name FROM glpi_manufacturers");
    $modele = mysql_query("SELECT id,name FROM glpi_computermodels");
    $os = mysql_query("SELECT id ,name FROM glpi_operatingsystems");

    if (!empty($_GET['client']))
    {
        $id = $_GET['client'];
        $listeordi = mysql_query("SELECT id,name FROM glpi_computers WHERE users_id = '$id'");
        $result = mysql_query("SELECT name, realname,firstname,phone,phone2 FROM glpi_users WHERE id = '$id'");
        $row = mysql_fetch_row($result);
        $login = $row[0];
        $name = $row[1];
        $prename = $row[2];
        $fixe = $row[3];
        $portable = $row[4];

        $result = mysql_query("SELECT address,postcode,town FROM glpi_entitydatas WHERE entities_id = (SELECT entities_id FROM glpi_users WHERE id ='$id')");
        $row = mysql_fetch_row($result);
        $adresse = $row[0];
        $cp = $row[1];
        $ville =$row[2];

        $result = mysql_query("SELECT email FROM glpi_useremails WHERE users_id = '$id'");
        $row = mysql_fetch_row($result);
        $mail = $row[0];

    }
    else
    {
            $login = "";
            $name = "";
            $prename = "";
            $fixe ="";
            $portable = "";
            $adresse = "";
            $cp = "";
            $ville = "";
            $mail = "";

            if (!empty($_GET['ordis']))
            {
                $id = $_GET['ordis'];
                $sql = mysql_query("SELECT glpi_computermodels.name , glpi_operatingsystems.name, glpi_manufacturers.name,glpi_computers.serial, glpi_computers.adminpw
                                 FROM glpi_computermodels, glpi_operatingsystems,glpi_manufacturers,glpi_computers
                                 WHERE glpi_computermodels.id = glpi_computers.computermodels_id
                                 AND glpi_operatingsystems.id = glpi_computers.operatingsystems_id
                                 AND glpi_manufacturers.id = glpi_computers.manufacturers_id
                                 AND glpi_computers.id = '$id'");
                $row = mysql_fetch_row($sql);
                $modelechoisi = $row[0];
                $oschoisi = $row[1];
                $fabchoisi = $row[2];
                $serial = $row[3];
                $adminpw = $row[4];

                $result = mysql_query("SELECT name, realname,firstname,phone,phone2 FROM glpi_users WHERE id = (SELECT users_id FROM glpi_computers WHERE id = '$id')");
                $row = mysql_fetch_row($result);
                $login = $row[0];
                $name = $row[1];
                $prename = $row[2];
                $fixe = $row[3];
                $portable = $row[4];

                $result = mysql_query("SELECT address,postcode,town FROM glpi_entitydatas WHERE entities_id = (SELECT entities_id FROM glpi_users WHERE id =(SELECT users_id FROM glpi_computers WHERE id = '$id'))");
                $row = mysql_fetch_row($result);
                $adresse = $row[0];
                $cp = $row[1];
                $ville =$row[2];

                $result = mysql_query("SELECT email FROM glpi_useremails WHERE users_id = (SELECT users_id FROM glpi_computers WHERE id = '$id')");
                $row = mysql_fetch_row($result);
                $mail = $row[0];
                echo "<script> document.getElementById('marque').selectedIndex = $fabchoisi;</script>";

            }
    }


?>
<html>
  <head>
    <title>Formulaire pour fiches techniques</title>
    <link rel="stylesheet" type="text/css" href="http://localhost/glpi/inc/style.css"/>
  </head>
<body>
<div id="principale">
<form name="formgeneral">
    <form method="get" name="select">
        <table class="tab_cadre_fixe">
            <tr>
                <th colspan="4" align="center" class="tab_cadre_report" >
                    CLIENT
                </th>
            </tr>
            <tr>
                <td colspan="1">Selectionnez le Client :
                <td colspan="1">
                    <select id="client" name="client">
                        <?php
                            echo "<option id='user' value='-1'>Nouvel utilisateur</option>";
                            while($ligne=mysql_fetch_row($liste))
                            {
                                echo "<option id='user' value=$ligne[0]>$ligne[1]</option>";
                            }
                        ?>
                    </select>
                </td>
                <td class="tab_bg2 center" id="bouton">
                        <input type="submit" value="OK" class="submit">
                </td>
            </tr>
        </table>
    </form>
    <form method="post" action="../front/index.form.php" name="infoos">
        <table class="tab_cadre_fixe">
            <tr>
                <th colspan="4" align="center" class="tab_cadre_report" >
                    INFORMATIONS CLIENT
                </th>
            </tr>
            <tr>
                    <div id="informations">
                         <tr>
                            <td> Identifiant : </td>
                            <td><input type="text" name="name" value="<?php echo $login ?>"></td>
                         </tr>
                        <tr>
                            <td>Nom : </td>
                            <td>
                                <input type="text" name="name" value="<?php echo $name ?>">
                            </td>
                            <td>Prenom : </td>
                            <td>
                                <input type="text" name="prename"value="<?php echo $prename ?>">
                            </td>
                        </tr>
                        <tr>
                            <td colspan="1">Adresse : </td>
                            <td colspan="1">
                                <input type="text" size="50" name="adresse" value="<?php echo $adresse ?>">
                            </td>
                        </tr>
                        <tr>
                            <td colspan="1">Code Postal :</td>
                            <td>
                                <input type="text" maxlength="5" name="cp" value="<?php echo $cp ?>">
                            </td>
                            <td colspan="1">Ville : </td>
                            <td>
                                <input type="text" maxlength="40" name="ville" value="<?php echo $ville ?>">
                            </td>
                        </tr>
                        <tr>
                            <td>T&eacute;l&eacute;phone fixe : </td>
                            <td>
                                <input type="text" maxlength="10" name="telf" value="<?php echo $fixe ?>">
                            </td>
                            <td>T&eacute;l&eacute;phone Portable: </td>
                            <td>
                                <input type="text" maxlength="10" name="telp" value="<?php echo $portable ?>">
                            </td>
                        </tr>
                        <tr>
                            <td>E-Mail : </td>
                            <td>
                                <input type="text" maxlength="40" name="mail" value="<?php echo $mail ?>" >
                            </td>
                        </tr>
                    </div>
        </table>
    </form>
    <form method="get" name="select" >
        <table class="tab_cadre_fixe" >
            <tr>
                <th colspan="4" align="center" class="tab_cadre_report" >
                    MATERIEL
                </th>
            </tr>
            <tr>
                <td colspan="1">Selectionnez l'ordinateur : </td>
                <td colspan="1">
                    <select id="ordis" name="ordis">
                        <?php
                            echo "<option id='user' value='-1'>Nouvel ordinateur</option>";
                            while($ligne=mysql_fetch_row($listeordi))
                            {
                                echo "<option value=$ligne[0]>$ligne[1]</option>";
                            }
                        ?>
                    </select>
                </td>
                <td class="tab_bg2 center" id="bouton">
                        <input type="submit" value="OK" class="submit">
                </td>
            </tr>
        </table>
    </form>
    <form name="materiel">
        <table class="tab_cadre_fixe">
            <tr>
                <th colspan="4" align="center" class="tab_cadre_report" >
                    INFORMATIONS MATERIEL
                </th>
            </tr>
            <tr>
                <td colspan="1">Marque/Fabricant :</td>
                <td>
                    <select name="marque" id="marque">
                        <?php
                            echo "<option id='marque' value='-1'>Nouveau fabricant</option>";
                            while($ligne=mysql_fetch_row($fab))
                        	    {
                        		echo "<option id='marque' value=$ligne[0]>$ligne[1]</option>";
                        	    }
                        ?>
                    </select>
                </td>