1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| <?php
require '../libs/Smarty.class.php';
$smarty = new Smarty;
$smarty->compile_check = true;
$smarty->debugging = false;
include 'includes/connect_db.php';
/**************************************************************************
*On recupère la liste des clients
***************************************************************************/
$clients = $db->getAssoc("SELECT id_client, nom_client FROM client ORDER BY nom_client");
$smarty->assign('clients', $clients);
/**************************************************************************
*On récupère la liste de servers
***************************************************************************/
$servers = $db->getAssoc("SELECT id_server, nom_server FROM server ORDER BY nom_server");
$smarty->assign('servers', $servers);
/**************************************************************************
*Enregistrement dans la table client si l'utilisateur entre un client librement
***************************************************************************/
$id_filemaker = $_POST['id_filemaker'];
$nom_client_hors_liste = $_POST['client_hors_liste'];
$id_client = $_POST['id_client'] ;
$nom_site = $_POST['nom_site'];
$mail_resp = $_POST['mail_resp'];
if ($nom_client_hors_liste != ""){
mysql_query("INSERT INTO client (id_client, nom_client) VALUES ($id_filemaker, '$nom_client_hors_liste')");
$sql = mysql_query("SELECT id_client, nom_client FROM client WHERE nom_client = '$nom_client_hors_liste' ");
while ($l = mysql_fetch_array($sql)){
$id_client_hors_liste = $l['id_client'];
}
/**************************************************************************
*Enregistrement dans la table site de nom_site, mail_resp, id_client si client provient de l'input text
***************************************************************************/
mysql_query("INSERT INTO site (nom_site, mail_resp, id_client) VALUES ('$nom_site', '$mail_resp', $id_client_hors_liste)");
}
else{
/**************************************************************************
*Enregistrement dans la table site de nom_site, mail_resp, id_client si non client provient du select
***************************************************************************/
mysql_query ("INSERT INTO site (nom_site, mail_resp, id_client) VALUES ('$nom_site', '$mail_resp', $id_client)");
} |
Partager