Bonjour, je suis bloqué par une petite probleme depuis hier, j' arrive pas à savoir d' ou vient le probleme j' espere que j' aurai votre aide merci d' avance ! ça concerne une affichage les donné provien de trois different table mais qui ont des liens (entreprise, promoteur, projet) num_prom se trouve dans entreprise et projet ! voila le code quie me bloque ! j' ai deja une affichage du contenu du formulaire mais de cet etape affichage du promoteur et dans un autre afficage projet et entreprise mais on ne peut imprimer alor je voulais imprimer tout les donné en meme temps (promoteur projet et entreprise) j ai deja créer le champs de recuperation mais ca bloque ici <a href="edit.php?numpro=<? echo $result["num_projet"];?>&numprom=<? echo $num;?>&numentr=<? echo $moud["num_entre"];}}}?>">IMPRIMER SON DOSSIER</a></td> en clicant sur imprimer je devais avoir le renseignement souhaité pour imprimé mais imprimer dossier ne fonctionne et ily a ceci "> et je sais pas d' ou ils viennent ! l' essentiel ici c est que ce lien fonctionne !merci

{MySQL}

Réponse 1 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 08:47

Ben le "> c'est ce qui ferme ton href pour le ", et ta balise a pour le >

par contrece sont les 3 }}} que je ne sais pas ce qu'ils font là moi ...

Réponse 2 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 08:54

je m' excuse pour le retard mais je vais t envoyer le code complet tu vera plu claire

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" >
<head>
<title>formulaire de saisi de promoteur</title>

<?php
include("menu3.html");
include("connect_db.php");

$num=$_GET['num'];
$nom=$_GET['nom'];

$med = "SELECT * FROM entreprise WHERE num_prom='$num'";
$aden = mysql_query($med)or die("$med error");

$req="SELECT * FROM projet WHERE num_prom='$num'";

$req1 = mysql_query($req)or die('Erreur SQL !'.$req.' '.mysql_error());

?>
<SCRIPT language="JavaScript">
function verif_formulaire()
{
if(document.form1.nom_prom.value == "") {
alert("Veuillez entrer votre nom!");
document.form1.nom_prom.focus();
return false;
}
if(document.form1.genre.value == "") {
alert("Veuillez entrer votre nom!");
document.form1.genre.focus();
return false;
}
if(document.form1.date_nais.value == "") {
alert("Veuillez entrer votre date de naissance!");
document.form1.date_nais.focus();
return false;
}
if(document.form1.lieu_nais.value == "") {
alert("Veuillez entrer votre lieu de naissance!");
document.form1.lieu_nais.focus();
return false;
}
if(document.form1.nationalite.value == "") {
alert("Veuillez entrer lieu de votre naissance!");
document.form1.nationalite.focus();
return false;
}
if(document.form1.situation_matri.value == "") {
alert("Veuillez entrer votre situation matrimonial!");
document.form1.situation_matri.focus();
return false;
}
if(document.form1.nbre_pers.value == "") {
alert("Veuillez entrer le nombre de personne vivant sous votre charge!");
document.form1.nbre_pers.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.nbre_pers.value.length;++i)
if(document.form1.nbre_pers.value.charAt(i) < "0"
|| document.form1.nbre_pers.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.nbre_pers.focus();
return false;
}
if(document.form1.nom_source.value == "") {
alert("Veuillez entrer le nombre de personne vivant sous votre charge!");
document.form1.nom_source.focus();
return false;
}
if(document.form1.mont_glob_rev.value == "") {
alert("Veuillez entrer le montant global mensuel de votre revenu !");
document.form1.mont_glob_rev.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.mont_glob_rev.value.length;++i)
if(document.form1.mont_glob_rev.value.charAt(i) < "0"
|| document.form1.mont_glob_rev.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.mont_glob_rev.focus();
return false;
}
if(document.form1.act_prof.value == "") {
alert("Veuillez entrer votre activite professionnel !");
document.form1.act_prof.focus();
return false;
}
if(document.form1.tel_mob.value == "") {
alert("Veuillez entrer votre téléphone portable !");
document.form1.tel_mob.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.tel_mob.value.length;++i)
if(document.form1.tel_mob.value.charAt(i) < "0"
|| document.form1.tel_mob.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.tel_mob.focus();
return false;
}

if(document.form1.mail.value.indexOf('@') == -1) {
alert("Ce n'est pas une adresse électronique!");
document.form1.mail.focus();
return false;
}
if(document.form1.quartier.value == "") {
alert("Veuillez entrer votre quartier !");
document.form1.quartier.focus();
return false;
}
}

var datePickerDivID = "datepicker";
var iFrameDivID = "datepickeriframe";

var dayArrayShort = new Array('Di', 'Lu', 'Ma', 'Me', 'Je', 'Vr', 'Sa');
var dayArrayMed = new Array('Dim', 'Lun', 'Mar', 'Mer', 'Jeu', 'Ven', 'Sam');
var dayArrayLong = new Array('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi');
var monthArrayShort = new Array('Jan', 'Fév', 'Mar', 'Avr', 'Mai', 'Juin', 'Juil', 'Aoû', 'Sep', 'Oct', 'Nov', 'Dec');
var monthArrayMed = new Array('Jan', 'Fév', 'Mar', 'Avr', 'Mai', 'Juin', 'Juillet', 'Aoû', 'Sept', 'Oct', 'Nov', 'Dec');
var monthArrayLong = new Array('Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Decembre');

// these variables define the date formatting we're expecting and outputting.
// If you want to use a different format by default, change the defaultDateSeparator
// and defaultDateFormat variables either here or on your HTML page.
var defaultDateSeparator = "-"; // common values would be "/" or "."
var defaultDateFormat = "ymd" // valid values are "mdy", "dmy", and "ymd"
var dateSeparator = defaultDateSeparator;
var dateFormat = defaultDateFormat;

function displayDatePicker(dateFieldName, displayBelowThisObject, dtFormat, dtSep)
{
var targetDateField = document.getElementsByName (dateFieldName).item(0);

// if we weren't told what node to display the datepicker beneath, just display it
// beneath the date field we're updating
if (!displayBelowThisObject)
displayBelowThisObject = targetDateField;

// if a date separator character was given, update the dateSeparator variable
if (dtSep)
dateSeparator = dtSep;
else
dateSeparator = defaultDateSeparator;

// if a date format was given, update the dateFormat variable
if (dtFormat)
dateFormat = dtFormat;
else
dateFormat = defaultDateFormat;

var x = displayBelowThisObject.offsetLeft;
var y = displayBelowThisObject.offsetTop + displayBelowThisObject.offsetHeight ;

// deal with elements inside tables and such
var parent = displayBelowThisObject;
while (parent.offsetParent) {
parent = parent.offsetParent;
x += parent.offsetLeft;
y += parent.offsetTop ;
}

drawDatePicker(targetDateField, x, y);
}

/**
Draw the datepicker object (which is just a table with calendar elements) at the
specified x and y coordinates, using the targetDateField object as the input tag
that will ultimately be populated with a date.

This function will normally be called by the displayDatePicker function.
*/
function drawDatePicker(targetDateField, x, y)
{
var dt = getFieldDate(targetDateField.value );

// the datepicker table will be drawn inside of a <div> with an ID defined by the
// global datePickerDivID variable. If such a div doesn't yet exist on the HTML
// document we're working with, add one.
if (!document.getElementById(datePickerDivID)) {
// don't use innerHTML to update the body, because it can cause global variables
// that are currently pointing to objects on the page to have bad references
//document.body.innerHTML += "<div id='" + datePickerDivID + "' class='dpDiv'></div>";
var newNode = document.createElement("div");
newNode.setAttribute("id", datePickerDivID);
newNode.setAttribute("class", "dpDiv");
newNode.setAttribute("style", "visibility: hidden;");
document.body.appendChild(newNode);
}

// move the datepicker div to the proper x,y coordinate and toggle the visiblity
var pickerDiv = document.getElementById(datePickerDivID);
pickerDiv.style.position = "absolute";
pickerDiv.style.left = x + "px";
pickerDiv.style.top = y + "px";
pickerDiv.style.visibility = (pickerDiv.style.visibility == "visible" ? "hidden" : "visible");
pickerDiv.style.display = (pickerDiv.style.display == "block" ? "none" : "block");
pickerDiv.style.zIndex = 10000;

// draw the datepicker table
refreshDatePicker(targetDateField.name, dt.getFullYear(), dt.getMonth(), dt.getDate());
}

/**
This is the function that actually draws the datepicker calendar.
*/
function refreshDatePicker(dateFieldName, year, month, day)
{
// if no arguments are passed, use today's date; otherwise, month and year
// are required (if a day is passed, it will be highlighted later)
var thisDay = new Date();

if ((month >= 0) && (year > 0)) {
thisDay = new Date(year, month, 1);
} else {
day = thisDay.getDate();
thisDay.setDate(1);
}

// the calendar will be drawn as a table
// you can customize the table elements with a global CSS style sheet,
// or by hardcoding style and formatting elements below
var crlf = "\r\n";
var TABLE = "<table cols=7 class='dpTable'>" + crlf;
var xTABLE = "</table>" + crlf;
var TR = "<tr class='dpTR'>";
var TR_title = "<tr class='dpTitleTR'>";
var TR_days = "<tr class='dpDayTR'>";
var TR_todaybutton = "<tr class='dpTodayButtonTR'>";
var xTR = "</tr>" + crlf;
var TD = "<td class='dpTD' onMouseOut='this.className=\"dpTD\";' onMouseOver=' this.className=\"dpTDHover\";' "; // leave this tag open, because we'll be adding an onClick event
var TD_title = "<td colspan=5 class='dpTitleTD'>";
var TD_buttons = "<td class='dpButtonTD'>";
var TD_todaybutton = "<td colspan=7 class='dpTodayButtonTD'>";
var TD_days = "<td class='dpDayTD'>";
var TD_selected = "<td class='dpDayHighlightTD' onMouseOut='this.className=\"dpDayHighlightTD\";' onMouseOver='this.className=\"dpTDHover\";' "; // leave this tag open, because we'll be adding an onClick event
var xTD = "</td>" + crlf;
var DIV_title = "<div class='dpTitleText'>";
var DIV_selected = "<div class='dpDayHighlight'>";
var xDIV = "</div>";

// start generating the code for the calendar table
var html = TABLE;

// this is the title bar, which displays the month and the buttons to
// go back to a previous month or forward to the next month
html += TR_title;
html += TD_buttons + getButtonCode(dateFieldName, thisDay, -1, "<") + xTD;
html += TD_title + DIV_title + monthArrayLong[ thisDay.getMonth()] + " " + thisDay.getFullYear() + xDIV + xTD;
html += TD_buttons + getButtonCode(dateFieldName, thisDay, 1, ">") + xTD;
html += xTR;

// this is the row that indicates which day of the week we're on
html += TR_days;
for(i = 0; i < dayArrayShort.length; i++)
html += TD_days + dayArrayShort[i] + xTD;
html += xTR;

// now we'll start populating the table with days of the month
html += TR;

// first, the leading blanks
for (i = 0; i < thisDay.getDay(); i++)
html += TD + " " + xTD;

// now, the days of the month
do {
dayNum = thisDay.getDate();
TD_onclick = " onclick=\"updateDateField('" + dateFieldName + "', '" + getDateString(thisDay) + "');\">";

if (dayNum == day)
html += TD_selected + TD_onclick + DIV_selected + dayNum + xDIV + xTD;
else
html += TD + TD_onclick + dayNum + xTD;

// if this is a Saturday, start a new row
if (thisDay.getDay() == 6)
html += xTR + TR;

// increment the day
thisDay.setDate(thisDay.getDate() + 1);
} while (thisDay.getDate() > 1)

// fill in any trailing blanks
if (thisDay.getDay() > 0) {
for (i = 6; i > thisDay.getDay(); i--)
html += TD + " " + xTD;
}
html += xTR;

// add a button to allow the user to easily return to today, or close the calendar
var today = new Date();
var todayString = "Today is " + dayArrayMed[today.getDay()] + ", " + monthArrayMed[ today.getMonth()] + " " + today.getDate();
html += TR_todaybutton + TD_todaybutton;
html += "<button class='dpTodayButton' onClick='refreshDatePicker(\"" + dateFieldName + "\");'>Ce mois</button> ";
html += "<button class='dpTodayButton' onClick='updateDateField(\"" + dateFieldName + "\");'>Fermer</button>";
html += xTD + xTR;

// and finally, close the table
html += xTABLE;

document.getElementById(datePickerDivID).innerHTML = html;
// add an "iFrame shim" to allow the datepicker to display above selection lists
adjustiFrame();
}

/**
Convenience function for writing the code for the buttons that bring us back or forward
a month.
*/
function getButtonCode(dateFieldName, dateVal, adjust, label)
{
var newMonth = (dateVal.getMonth () + adjust) % 12;
var newYear = dateVal.getFullYear() + parseInt((dateVal.getMonth() + adjust) / 12);
if (newMonth < 0) {
newMonth += 12;
newYear += -1;
}

return "<button class='dpButton' onClick='refreshDatePicker(\"" + dateFieldName + "\", " + newYear + ", " + newMonth + ");'>" + label + "</button>";
}

/**
Convert a JavaScript Date object to a string, based on the dateFormat and dateSeparator
variables at the beginning of this script library.
*/
function getDateString(dateVal)
{
var dayString = "00" + dateVal.getDate();
var monthString = "00" + (dateVal.getMonth()+1);
dayString = dayString.substring(dayString.length - 2);
monthString = monthString.substring(monthString.length - 2);

switch (dateFormat) {
case "dmy" :
return dayString + dateSeparator + monthString + dateSeparator + dateVal.getFullYear();
case "ymd" :
return dateVal.getFullYear() + dateSeparator + monthString + dateSeparator + dayString;
case "mdy" :
default :
return monthString + dateSeparator + dayString + dateSeparator + dateVal.getFullYear();
}
}

/**
Convert a string to a JavaScript Date object.
*/
function getFieldDate(dateString)
{
var dateVal;
var dArray;
var d, m, y;

try {
dArray = splitDateString(dateString);
if (dArray) {
switch (dateFormat) {
case "dmy" :
d = parseInt(dArray[0], 10);
m = parseInt(dArray[1], 10) - 1;
y = parseInt(dArray[2], 10);
break;
case "ymd" :
d = parseInt(dArray[2], 10);
m = parseInt(dArray[1], 10) - 1;
y = parseInt(dArray[0], 10);
break;
case "mdy" :
default :
d = parseInt(dArray[1], 10);
m = parseInt(dArray[0], 10) - 1;
y = parseInt(dArray[2], 10);
break;
}
dateVal = new Date(y, m, d);
} else if (dateString) {
dateVal = new Date(dateString);
} else {
dateVal = new Date();
}
} catch(e) {
dateVal = new Date();
}

return dateVal;
}

/**
Try to split a date string into an array of elements, using common date separators.
If the date is split, an array is returned; otherwise, we just return false.
*/
function splitDateString(dateString)
{
var dArray;
if (dateString.indexOf("/") >= 0)
dArray = dateString.split("/");
else if (dateString.indexOf(".") >= 0)
dArray = dateString.split(".");
else if (dateString.indexOf("-") >= 0)
dArray = dateString.split("-");
else if (dateString.indexOf("\\") >= 0)
dArray = dateString.split("\\");
else
dArray = false;

return dArray;
}

function updateDateField(dateFieldName, dateString)
{
var targetDateField = document.getElementsByName (dateFieldName).item(0);
if (dateString)
targetDateField.value = dateString;

var pickerDiv = document.getElementById(datePickerDivID);
pickerDiv.style.visibility = "hidden";
pickerDiv.style.display = "none";

adjustiFrame();
targetDateField.focus();

// after the datepicker has closed, optionally run a user-defined function called
// datePickerClosed, passing the field that was just updated as a parameter
// (note that this will only run if the user actually selected a date from the datepicker)
if ((dateString) && (typeof(datePickerClosed) == "function"))
datePickerClosed(targetDateField);
}

/**
Use an "iFrame shim" to deal with problems where the datepicker shows up behind
selection list elements, if they're below the datepicker. The problem and solution are
described at:

https://www.drdobbs.com/windows/
https://www.drdobbs.com/windows/
*/
function adjustiFrame(pickerDiv, iFrameDiv)
{
// we know that Opera doesn't like something about this, so if we
// think we're using Opera, don't even try
var is_opera = (navigator.userAgent.toLowerCase().indexOf("opera") != -1);
if (is_opera)
return;

// put a try/catch block around the whole thing, just in case
try {
if (!document.getElementById(iFrameDivID)) {
// don't use innerHTML to update the body, because it can cause global variables
// that are currently pointing to objects on the page to have bad references
//document.body.innerHTML += "<iframe id='" + iFrameDivID + "' src='javascript:false;' scrolling='no' frameborder='0'>";
var newNode = document.createElement("iFrame");
newNode.setAttribute("id", iFrameDivID);
newNode.setAttribute("src", "javascript:false;");
newNode.setAttribute("scrolling", "no");
newNode.setAttribute ("frameborder", "0");
document.body.appendChild(newNode);
}

if (!pickerDiv)
pickerDiv = document.getElementById(datePickerDivID);
if (!iFrameDiv)
iFrameDiv = document.getElementById(iFrameDivID);

try {
iFrameDiv.style.position = "absolute";
iFrameDiv.style.width = pickerDiv.offsetWidth;
iFrameDiv.style.height = pickerDiv.offsetHeight ;
iFrameDiv.style.top = pickerDiv.style.top;
iFrameDiv.style.left = pickerDiv.style.left;
iFrameDiv.style.zIndex = pickerDiv.style.zIndex - 1;
iFrameDiv.style.visibility = pickerDiv.style.visibility ;
iFrameDiv.style.display = pickerDiv.style.display;
} catch(e) {
}

} catch (ee) {
}

}

</script>

<style>

/* the div that holds the date picker calendar */
.dpDiv {
}

/* the table (within the div) that holds the date picker calendar */
.dpTable {
font-family: Tahoma, Arial, Helvetica, sans-serif;
font-size: 12px;
text-align: center;
color:#000000;
background-color:#999999;
border: 1px solid #AAAAAA;
}

/* a table row that holds date numbers (either blank or 1-31) */
.dpTR {
}

/* the top table row that holds the month, year, and forward/backward buttons */
.dpTitleTR {
}

/* the second table row, that holds the names of days of the week (Mo, Tu, We, etc.) */
.dpDayTR {
}

/* the bottom table row, that has the "This Month" and "Close" buttons */
.dpTodayButtonTR {
}

/* a table cell that holds a date number (either blank or 1-31) */
.dpTD {
border: 1px solid #ece9d8;
}

/* a table cell that holds a highlighted day (usually either today's date or the current date field value) */
.dpDayHighlightTD {
background-color: #CCCCCC;
border: 1px solid #AAAAAA;
}

/* the date number table cell that the mouse pointer is currently over (you can use contrasting colors to make it apparent which cell is being hovered over) */
.dpTDHover {
background-color: #aca998;
border: 1px solid #888888;
cursor: pointer;
color:#0033CC;
}

/* the table cell that holds the name of the month and the year */
.dpTitleTD {
}

/* a table cell that holds one of the forward/backward buttons */
.dpButtonTD {
}

/* the table cell that holds the "This Month" or "Close" button at the bottom */
.dpTodayButtonTD {
}

/* a table cell that holds the names of days of the week (Mo, Tu, We, etc.) */
.dpDayTD {
background-color:#00CC99;
border: 1px solid #AAAAAA;
color: white;
}

/* additional style information for the text that indicates the month and year */
.dpTitleText {
font-size: 12px;
color:#000000;
font-weight: bold;
}

/* additional style information for the cell that holds a highlighted day (usually either today's date or the current date field value) */
.dpDayHighlight {
color:#0066CC;
font-weight: bold;
}

/* the forward/backward buttons at the top */
.dpButton {
font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
font-size: 10px;
color: gray;
background: #d8e8ff;
font-weight: bold;
padding: 0px;
}

/* the "This Month" and "Close" buttons at the bottom */
.dpTodayButton {
font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
font-size: 10px;
color: gray;
background: #d8e8ff;
font-weight: bold;
}

.Style1 {font-size: 12px}
-->
</style>

</head>

<div id="corps">
<h5 align="left" class="Style1"> <img src="../images/puce_pointillet.gif" alt="fleche" width="9" height="21" />
<a href="../index.html">Accueil </a>>Procedure de prêt >Consultation de projet 

</h5>
<form method="post" action="edit.php">
<table width="934" height="380" border="0" bgcolor="" >
<?
while( $result = mysql_fetch_array( $req1 ) )
{

?>
<tr><td height="39">Numero du Projet :</td>
<td><? echo $result["num_projet"];?></td></tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Projet :</td>
<td width="107" bgcolor="#999999"><? echo $result["nom_projet"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Promoteur :</td>
<td width="107" bgcolor="#999999"><? echo $nom;?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Dépossé le :</td>
<td width="102" bgcolor="#999999"><? echo $result["Date_depot"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Forme Juridique :</td>
<td width="86" bgcolor="#999999"><? echo $result["forme_juridique"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Nombre des employés :</td>
<td width="81" bgcolor="#999999"><? echo $result["nbre_employe"];?></td>
</tr>

<tr>
<td width="129" height="40" bgcolor="#FF9933">Secteur :</td>
<td width="107" bgcolor="#999999"><? echo $result["secteur"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Activité :</td>
<td width="102" bgcolor="#999999"><? echo $result["activite"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Salaire Mensuel :</td>
<td width="86" bgcolor="#999999"><? echo $result["sal_men"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Estimation du client :</td>
<td width="81" bgcolor="#999999"><? echo $result["est_clt"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Frais d'installation :</td>
<td width="107" bgcolor="#999999"><? echo $result["frai_inst"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Frais d'amenagement :</td>
<td width="102" bgcolor="#999999"><? echo $result["frai_amen"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Immobilisation Incorporelle :</td>
<td width="86" bgcolor="#999999"><? echo $result["imob_incorp"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Besoin fond deroulement :</td>
<td width="81" bgcolor="#999999"><? echo $result["bes_fond_der"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Totaux Emplois :</td>
<td width="107" bgcolor="#999999"><? echo $result["tot_emplois"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Fond Propre :</td>
<td width="102" bgcolor="#999999"><? echo $result["fond_propre"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Apport Associé :</td>
<td width="86" bgcolor="#999999"><? echo $result["app_aso"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Emprunt FDED :</td>
<td width="81" bgcolor="#999999"><? echo $result["emprunt_fded"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Prêt Bancaire :</td>
<td width="107" bgcolor="#999999"><? echo $result["pret_banque"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Total Ressource :</td>
<td width="102" bgcolor="#999999"><? echo $result["tot_ressource"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Garantie :</td>
<td width="86" bgcolor="#999999"><? echo $result["garantie"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Autres Emplois :</td>
<td width="81" bgcolor="#999999"><? echo $result["autre_empl"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Autres Ressources :</td>
<td width="107" bgcolor="#999999"><? echo $result["autre_ressource"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Le rôle du Promoteur :</td>
<td width="102" bgcolor="#999999"><? echo $result["mon_role"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Quantité :</td>
<td width="86" bgcolor="#999999"><? echo $result["qte_produite"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Immobilisation Corporelle :</td>
<td width="81" bgcolor="#999999"><? echo $result["imob_corp"];?></td>
</tr>
<tr>
<td width="129" bgcolor="#FF9933">Equipements :</td>
<td width="107" bgcolor="#999999"><? echo $result["equipement"];?></td>

</tr>
</table>

<table width="934" height="167" border="0" bgcolor="" >
<?
while( $moud = mysql_fetch_array( $aden ) )
{
if($moud["nom_entre"]==''){
$message='Ce promoteur ne possede pas une Entreprise';
}else {
?>
<tr>
<td height="51">Nom de son Entreprise :</td>
<td><? echo $moud["nom_entre"];?></td>
</tr>

<tr>
<td width="129" height="54" bgcolor="#FF9933">Forme Juridique :</td>
<td width="107" bgcolor="#999999"><? echo $moud["forme_jurid"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Employés :</td>
<td width="102" bgcolor="#999999"><? echo $moud["nbre_empl"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Chiffre d'Affaire :</td>
<td width="86" bgcolor="#999999"><? echo $moud["chifre_affair"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Quantité produit :</td>
<td width="81" bgcolor="#999999"><? echo $moud["qte_produit"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Salaire Moyenne Global :</td>
<td width="107" bgcolor="#999999"><? echo $moud["sal_moy_glob"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Clients:</td>
<td width="102" bgcolor="#999999"><? echo $moud["est_clt"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Rôle du Promoteur :</td>
<td width="86" bgcolor="#999999"><? echo $moud["role"];?></td>
<td width="10"></td>
<td width="10">
<a href="edit.php?numpro=<? echo $result["num_projet"];?>&numprom=<? echo $num;?>&numentr=<? echo $moud["num_entre"];?>">IMPRIMER SON DOSSIER</a></td>

</tr>

</table>
</form>

</div>


<div id="pied_de_page">

<marquee> Siège social : Angle de l' av. George Clémenceau et de la rue Pierre Curie -Tèl:(253)35 50 22 - Bp.520 Djibouti - Email:fded@intnet.dj </marquee>
</div>

</body>
</html>

voila le code

Réponse 3 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 08:54

je m' excuse pour le retard mais je vais t envoyer le code complet tu vera plu claire

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" >
<head>
<title>formulaire de saisi de promoteur</title>

<?php
include("menu3.html");
include("connect_db.php");

$num=$_GET['num'];
$nom=$_GET['nom'];

$med = "SELECT * FROM entreprise WHERE num_prom='$num'";
$aden = mysql_query($med)or die("$med error");

$req="SELECT * FROM projet WHERE num_prom='$num'";

$req1 = mysql_query($req)or die('Erreur SQL !'.$req.' '.mysql_error());

?>
<SCRIPT language="JavaScript">
function verif_formulaire()
{
if(document.form1.nom_prom.value == "") {
alert("Veuillez entrer votre nom!");
document.form1.nom_prom.focus();
return false;
}
if(document.form1.genre.value == "") {
alert("Veuillez entrer votre nom!");
document.form1.genre.focus();
return false;
}
if(document.form1.date_nais.value == "") {
alert("Veuillez entrer votre date de naissance!");
document.form1.date_nais.focus();
return false;
}
if(document.form1.lieu_nais.value == "") {
alert("Veuillez entrer votre lieu de naissance!");
document.form1.lieu_nais.focus();
return false;
}
if(document.form1.nationalite.value == "") {
alert("Veuillez entrer lieu de votre naissance!");
document.form1.nationalite.focus();
return false;
}
if(document.form1.situation_matri.value == "") {
alert("Veuillez entrer votre situation matrimonial!");
document.form1.situation_matri.focus();
return false;
}
if(document.form1.nbre_pers.value == "") {
alert("Veuillez entrer le nombre de personne vivant sous votre charge!");
document.form1.nbre_pers.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.nbre_pers.value.length;++i)
if(document.form1.nbre_pers.value.charAt(i) < "0"
|| document.form1.nbre_pers.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.nbre_pers.focus();
return false;
}
if(document.form1.nom_source.value == "") {
alert("Veuillez entrer le nombre de personne vivant sous votre charge!");
document.form1.nom_source.focus();
return false;
}
if(document.form1.mont_glob_rev.value == "") {
alert("Veuillez entrer le montant global mensuel de votre revenu !");
document.form1.mont_glob_rev.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.mont_glob_rev.value.length;++i)
if(document.form1.mont_glob_rev.value.charAt(i) < "0"
|| document.form1.mont_glob_rev.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.mont_glob_rev.focus();
return false;
}
if(document.form1.act_prof.value == "") {
alert("Veuillez entrer votre activite professionnel !");
document.form1.act_prof.focus();
return false;
}
if(document.form1.tel_mob.value == "") {
alert("Veuillez entrer votre téléphone portable !");
document.form1.tel_mob.focus();
return false;
}
var chkZ = 1;
for(i=0;i<document.form1.tel_mob.value.length;++i)
if(document.form1.tel_mob.value.charAt(i) < "0"
|| document.form1.tel_mob.value.charAt(i) > "9")
chkZ = -1;
if(chkZ == -1) {
alert("Cette mention n'est pas un nombre!");
document.form1.tel_mob.focus();
return false;
}

if(document.form1.mail.value.indexOf('@') == -1) {
alert("Ce n'est pas une adresse électronique!");
document.form1.mail.focus();
return false;
}
if(document.form1.quartier.value == "") {
alert("Veuillez entrer votre quartier !");
document.form1.quartier.focus();
return false;
}
}

var datePickerDivID = "datepicker";
var iFrameDivID = "datepickeriframe";

var dayArrayShort = new Array('Di', 'Lu', 'Ma', 'Me', 'Je', 'Vr', 'Sa');
var dayArrayMed = new Array('Dim', 'Lun', 'Mar', 'Mer', 'Jeu', 'Ven', 'Sam');
var dayArrayLong = new Array('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi');
var monthArrayShort = new Array('Jan', 'Fév', 'Mar', 'Avr', 'Mai', 'Juin', 'Juil', 'Aoû', 'Sep', 'Oct', 'Nov', 'Dec');
var monthArrayMed = new Array('Jan', 'Fév', 'Mar', 'Avr', 'Mai', 'Juin', 'Juillet', 'Aoû', 'Sept', 'Oct', 'Nov', 'Dec');
var monthArrayLong = new Array('Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Decembre');

// these variables define the date formatting we're expecting and outputting.
// If you want to use a different format by default, change the defaultDateSeparator
// and defaultDateFormat variables either here or on your HTML page.
var defaultDateSeparator = "-"; // common values would be "/" or "."
var defaultDateFormat = "ymd" // valid values are "mdy", "dmy", and "ymd"
var dateSeparator = defaultDateSeparator;
var dateFormat = defaultDateFormat;

function displayDatePicker(dateFieldName, displayBelowThisObject, dtFormat, dtSep)
{
var targetDateField = document.getElementsByName (dateFieldName).item(0);

// if we weren't told what node to display the datepicker beneath, just display it
// beneath the date field we're updating
if (!displayBelowThisObject)
displayBelowThisObject = targetDateField;

// if a date separator character was given, update the dateSeparator variable
if (dtSep)
dateSeparator = dtSep;
else
dateSeparator = defaultDateSeparator;

// if a date format was given, update the dateFormat variable
if (dtFormat)
dateFormat = dtFormat;
else
dateFormat = defaultDateFormat;

var x = displayBelowThisObject.offsetLeft;
var y = displayBelowThisObject.offsetTop + displayBelowThisObject.offsetHeight ;

// deal with elements inside tables and such
var parent = displayBelowThisObject;
while (parent.offsetParent) {
parent = parent.offsetParent;
x += parent.offsetLeft;
y += parent.offsetTop ;
}

drawDatePicker(targetDateField, x, y);
}

/**
Draw the datepicker object (which is just a table with calendar elements) at the
specified x and y coordinates, using the targetDateField object as the input tag
that will ultimately be populated with a date.

This function will normally be called by the displayDatePicker function.
*/
function drawDatePicker(targetDateField, x, y)
{
var dt = getFieldDate(targetDateField.value );

// the datepicker table will be drawn inside of a <div> with an ID defined by the
// global datePickerDivID variable. If such a div doesn't yet exist on the HTML
// document we're working with, add one.
if (!document.getElementById(datePickerDivID)) {
// don't use innerHTML to update the body, because it can cause global variables
// that are currently pointing to objects on the page to have bad references
//document.body.innerHTML += "<div id='" + datePickerDivID + "' class='dpDiv'></div>";
var newNode = document.createElement("div");
newNode.setAttribute("id", datePickerDivID);
newNode.setAttribute("class", "dpDiv");
newNode.setAttribute("style", "visibility: hidden;");
document.body.appendChild(newNode);
}

// move the datepicker div to the proper x,y coordinate and toggle the visiblity
var pickerDiv = document.getElementById(datePickerDivID);
pickerDiv.style.position = "absolute";
pickerDiv.style.left = x + "px";
pickerDiv.style.top = y + "px";
pickerDiv.style.visibility = (pickerDiv.style.visibility == "visible" ? "hidden" : "visible");
pickerDiv.style.display = (pickerDiv.style.display == "block" ? "none" : "block");
pickerDiv.style.zIndex = 10000;

// draw the datepicker table
refreshDatePicker(targetDateField.name, dt.getFullYear(), dt.getMonth(), dt.getDate());
}

/**
This is the function that actually draws the datepicker calendar.
*/
function refreshDatePicker(dateFieldName, year, month, day)
{
// if no arguments are passed, use today's date; otherwise, month and year
// are required (if a day is passed, it will be highlighted later)
var thisDay = new Date();

if ((month >= 0) && (year > 0)) {
thisDay = new Date(year, month, 1);
} else {
day = thisDay.getDate();
thisDay.setDate(1);
}

// the calendar will be drawn as a table
// you can customize the table elements with a global CSS style sheet,
// or by hardcoding style and formatting elements below
var crlf = "\r\n";
var TABLE = "<table cols=7 class='dpTable'>" + crlf;
var xTABLE = "</table>" + crlf;
var TR = "<tr class='dpTR'>";
var TR_title = "<tr class='dpTitleTR'>";
var TR_days = "<tr class='dpDayTR'>";
var TR_todaybutton = "<tr class='dpTodayButtonTR'>";
var xTR = "</tr>" + crlf;
var TD = "<td class='dpTD' onMouseOut='this.className=\"dpTD\";' onMouseOver=' this.className=\"dpTDHover\";' "; // leave this tag open, because we'll be adding an onClick event
var TD_title = "<td colspan=5 class='dpTitleTD'>";
var TD_buttons = "<td class='dpButtonTD'>";
var TD_todaybutton = "<td colspan=7 class='dpTodayButtonTD'>";
var TD_days = "<td class='dpDayTD'>";
var TD_selected = "<td class='dpDayHighlightTD' onMouseOut='this.className=\"dpDayHighlightTD\";' onMouseOver='this.className=\"dpTDHover\";' "; // leave this tag open, because we'll be adding an onClick event
var xTD = "</td>" + crlf;
var DIV_title = "<div class='dpTitleText'>";
var DIV_selected = "<div class='dpDayHighlight'>";
var xDIV = "</div>";

// start generating the code for the calendar table
var html = TABLE;

// this is the title bar, which displays the month and the buttons to
// go back to a previous month or forward to the next month
html += TR_title;
html += TD_buttons + getButtonCode(dateFieldName, thisDay, -1, "<") + xTD;
html += TD_title + DIV_title + monthArrayLong[ thisDay.getMonth()] + " " + thisDay.getFullYear() + xDIV + xTD;
html += TD_buttons + getButtonCode(dateFieldName, thisDay, 1, ">") + xTD;
html += xTR;

// this is the row that indicates which day of the week we're on
html += TR_days;
for(i = 0; i < dayArrayShort.length; i++)
html += TD_days + dayArrayShort[i] + xTD;
html += xTR;

// now we'll start populating the table with days of the month
html += TR;

// first, the leading blanks
for (i = 0; i < thisDay.getDay(); i++)
html += TD + " " + xTD;

// now, the days of the month
do {
dayNum = thisDay.getDate();
TD_onclick = " onclick=\"updateDateField('" + dateFieldName + "', '" + getDateString(thisDay) + "');\">";

if (dayNum == day)
html += TD_selected + TD_onclick + DIV_selected + dayNum + xDIV + xTD;
else
html += TD + TD_onclick + dayNum + xTD;

// if this is a Saturday, start a new row
if (thisDay.getDay() == 6)
html += xTR + TR;

// increment the day
thisDay.setDate(thisDay.getDate() + 1);
} while (thisDay.getDate() > 1)

// fill in any trailing blanks
if (thisDay.getDay() > 0) {
for (i = 6; i > thisDay.getDay(); i--)
html += TD + " " + xTD;
}
html += xTR;

// add a button to allow the user to easily return to today, or close the calendar
var today = new Date();
var todayString = "Today is " + dayArrayMed[today.getDay()] + ", " + monthArrayMed[ today.getMonth()] + " " + today.getDate();
html += TR_todaybutton + TD_todaybutton;
html += "<button class='dpTodayButton' onClick='refreshDatePicker(\"" + dateFieldName + "\");'>Ce mois</button> ";
html += "<button class='dpTodayButton' onClick='updateDateField(\"" + dateFieldName + "\");'>Fermer</button>";
html += xTD + xTR;

// and finally, close the table
html += xTABLE;

document.getElementById(datePickerDivID).innerHTML = html;
// add an "iFrame shim" to allow the datepicker to display above selection lists
adjustiFrame();
}

/**
Convenience function for writing the code for the buttons that bring us back or forward
a month.
*/
function getButtonCode(dateFieldName, dateVal, adjust, label)
{
var newMonth = (dateVal.getMonth () + adjust) % 12;
var newYear = dateVal.getFullYear() + parseInt((dateVal.getMonth() + adjust) / 12);
if (newMonth < 0) {
newMonth += 12;
newYear += -1;
}

return "<button class='dpButton' onClick='refreshDatePicker(\"" + dateFieldName + "\", " + newYear + ", " + newMonth + ");'>" + label + "</button>";
}

/**
Convert a JavaScript Date object to a string, based on the dateFormat and dateSeparator
variables at the beginning of this script library.
*/
function getDateString(dateVal)
{
var dayString = "00" + dateVal.getDate();
var monthString = "00" + (dateVal.getMonth()+1);
dayString = dayString.substring(dayString.length - 2);
monthString = monthString.substring(monthString.length - 2);

switch (dateFormat) {
case "dmy" :
return dayString + dateSeparator + monthString + dateSeparator + dateVal.getFullYear();
case "ymd" :
return dateVal.getFullYear() + dateSeparator + monthString + dateSeparator + dayString;
case "mdy" :
default :
return monthString + dateSeparator + dayString + dateSeparator + dateVal.getFullYear();
}
}

/**
Convert a string to a JavaScript Date object.
*/
function getFieldDate(dateString)
{
var dateVal;
var dArray;
var d, m, y;

try {
dArray = splitDateString(dateString);
if (dArray) {
switch (dateFormat) {
case "dmy" :
d = parseInt(dArray[0], 10);
m = parseInt(dArray[1], 10) - 1;
y = parseInt(dArray[2], 10);
break;
case "ymd" :
d = parseInt(dArray[2], 10);
m = parseInt(dArray[1], 10) - 1;
y = parseInt(dArray[0], 10);
break;
case "mdy" :
default :
d = parseInt(dArray[1], 10);
m = parseInt(dArray[0], 10) - 1;
y = parseInt(dArray[2], 10);
break;
}
dateVal = new Date(y, m, d);
} else if (dateString) {
dateVal = new Date(dateString);
} else {
dateVal = new Date();
}
} catch(e) {
dateVal = new Date();
}

return dateVal;
}

/**
Try to split a date string into an array of elements, using common date separators.
If the date is split, an array is returned; otherwise, we just return false.
*/
function splitDateString(dateString)
{
var dArray;
if (dateString.indexOf("/") >= 0)
dArray = dateString.split("/");
else if (dateString.indexOf(".") >= 0)
dArray = dateString.split(".");
else if (dateString.indexOf("-") >= 0)
dArray = dateString.split("-");
else if (dateString.indexOf("\\") >= 0)
dArray = dateString.split("\\");
else
dArray = false;

return dArray;
}

function updateDateField(dateFieldName, dateString)
{
var targetDateField = document.getElementsByName (dateFieldName).item(0);
if (dateString)
targetDateField.value = dateString;

var pickerDiv = document.getElementById(datePickerDivID);
pickerDiv.style.visibility = "hidden";
pickerDiv.style.display = "none";

adjustiFrame();
targetDateField.focus();

// after the datepicker has closed, optionally run a user-defined function called
// datePickerClosed, passing the field that was just updated as a parameter
// (note that this will only run if the user actually selected a date from the datepicker)
if ((dateString) && (typeof(datePickerClosed) == "function"))
datePickerClosed(targetDateField);
}

/**
Use an "iFrame shim" to deal with problems where the datepicker shows up behind
selection list elements, if they're below the datepicker. The problem and solution are
described at:

https://www.drdobbs.com/windows/
https://www.drdobbs.com/windows/
*/
function adjustiFrame(pickerDiv, iFrameDiv)
{
// we know that Opera doesn't like something about this, so if we
// think we're using Opera, don't even try
var is_opera = (navigator.userAgent.toLowerCase().indexOf("opera") != -1);
if (is_opera)
return;

// put a try/catch block around the whole thing, just in case
try {
if (!document.getElementById(iFrameDivID)) {
// don't use innerHTML to update the body, because it can cause global variables
// that are currently pointing to objects on the page to have bad references
//document.body.innerHTML += "<iframe id='" + iFrameDivID + "' src='javascript:false;' scrolling='no' frameborder='0'>";
var newNode = document.createElement("iFrame");
newNode.setAttribute("id", iFrameDivID);
newNode.setAttribute("src", "javascript:false;");
newNode.setAttribute("scrolling", "no");
newNode.setAttribute ("frameborder", "0");
document.body.appendChild(newNode);
}

if (!pickerDiv)
pickerDiv = document.getElementById(datePickerDivID);
if (!iFrameDiv)
iFrameDiv = document.getElementById(iFrameDivID);

try {
iFrameDiv.style.position = "absolute";
iFrameDiv.style.width = pickerDiv.offsetWidth;
iFrameDiv.style.height = pickerDiv.offsetHeight ;
iFrameDiv.style.top = pickerDiv.style.top;
iFrameDiv.style.left = pickerDiv.style.left;
iFrameDiv.style.zIndex = pickerDiv.style.zIndex - 1;
iFrameDiv.style.visibility = pickerDiv.style.visibility ;
iFrameDiv.style.display = pickerDiv.style.display;
} catch(e) {
}

} catch (ee) {
}

}

</script>

<style>

/* the div that holds the date picker calendar */
.dpDiv {
}

/* the table (within the div) that holds the date picker calendar */
.dpTable {
font-family: Tahoma, Arial, Helvetica, sans-serif;
font-size: 12px;
text-align: center;
color:#000000;
background-color:#999999;
border: 1px solid #AAAAAA;
}

/* a table row that holds date numbers (either blank or 1-31) */
.dpTR {
}

/* the top table row that holds the month, year, and forward/backward buttons */
.dpTitleTR {
}

/* the second table row, that holds the names of days of the week (Mo, Tu, We, etc.) */
.dpDayTR {
}

/* the bottom table row, that has the "This Month" and "Close" buttons */
.dpTodayButtonTR {
}

/* a table cell that holds a date number (either blank or 1-31) */
.dpTD {
border: 1px solid #ece9d8;
}

/* a table cell that holds a highlighted day (usually either today's date or the current date field value) */
.dpDayHighlightTD {
background-color: #CCCCCC;
border: 1px solid #AAAAAA;
}

/* the date number table cell that the mouse pointer is currently over (you can use contrasting colors to make it apparent which cell is being hovered over) */
.dpTDHover {
background-color: #aca998;
border: 1px solid #888888;
cursor: pointer;
color:#0033CC;
}

/* the table cell that holds the name of the month and the year */
.dpTitleTD {
}

/* a table cell that holds one of the forward/backward buttons */
.dpButtonTD {
}

/* the table cell that holds the "This Month" or "Close" button at the bottom */
.dpTodayButtonTD {
}

/* a table cell that holds the names of days of the week (Mo, Tu, We, etc.) */
.dpDayTD {
background-color:#00CC99;
border: 1px solid #AAAAAA;
color: white;
}

/* additional style information for the text that indicates the month and year */
.dpTitleText {
font-size: 12px;
color:#000000;
font-weight: bold;
}

/* additional style information for the cell that holds a highlighted day (usually either today's date or the current date field value) */
.dpDayHighlight {
color:#0066CC;
font-weight: bold;
}

/* the forward/backward buttons at the top */
.dpButton {
font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
font-size: 10px;
color: gray;
background: #d8e8ff;
font-weight: bold;
padding: 0px;
}

/* the "This Month" and "Close" buttons at the bottom */
.dpTodayButton {
font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
font-size: 10px;
color: gray;
background: #d8e8ff;
font-weight: bold;
}

.Style1 {font-size: 12px}
-->
</style>

</head>

<div id="corps">
<h5 align="left" class="Style1"> <img src="../images/puce_pointillet.gif" alt="fleche" width="9" height="21" />
<a href="../index.html">Accueil </a>>Procedure de prêt >Consultation de projet 

</h5>
<form method="post" action="edit.php">
<table width="934" height="380" border="0" bgcolor="" >
<?
while( $result = mysql_fetch_array( $req1 ) )
{

?>
<tr><td height="39">Numero du Projet :</td>
<td><? echo $result["num_projet"];?></td></tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Projet :</td>
<td width="107" bgcolor="#999999"><? echo $result["nom_projet"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Promoteur :</td>
<td width="107" bgcolor="#999999"><? echo $nom;?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Dépossé le :</td>
<td width="102" bgcolor="#999999"><? echo $result["Date_depot"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Forme Juridique :</td>
<td width="86" bgcolor="#999999"><? echo $result["forme_juridique"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Nombre des employés :</td>
<td width="81" bgcolor="#999999"><? echo $result["nbre_employe"];?></td>
</tr>

<tr>
<td width="129" height="40" bgcolor="#FF9933">Secteur :</td>
<td width="107" bgcolor="#999999"><? echo $result["secteur"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Activité :</td>
<td width="102" bgcolor="#999999"><? echo $result["activite"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Salaire Mensuel :</td>
<td width="86" bgcolor="#999999"><? echo $result["sal_men"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Estimation du client :</td>
<td width="81" bgcolor="#999999"><? echo $result["est_clt"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Frais d'installation :</td>
<td width="107" bgcolor="#999999"><? echo $result["frai_inst"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Frais d'amenagement :</td>
<td width="102" bgcolor="#999999"><? echo $result["frai_amen"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Immobilisation Incorporelle :</td>
<td width="86" bgcolor="#999999"><? echo $result["imob_incorp"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Besoin fond deroulement :</td>
<td width="81" bgcolor="#999999"><? echo $result["bes_fond_der"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Totaux Emplois :</td>
<td width="107" bgcolor="#999999"><? echo $result["tot_emplois"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Fond Propre :</td>
<td width="102" bgcolor="#999999"><? echo $result["fond_propre"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Apport Associé :</td>
<td width="86" bgcolor="#999999"><? echo $result["app_aso"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Emprunt FDED :</td>
<td width="81" bgcolor="#999999"><? echo $result["emprunt_fded"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Prêt Bancaire :</td>
<td width="107" bgcolor="#999999"><? echo $result["pret_banque"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Total Ressource :</td>
<td width="102" bgcolor="#999999"><? echo $result["tot_ressource"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Garantie :</td>
<td width="86" bgcolor="#999999"><? echo $result["garantie"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Autres Emplois :</td>
<td width="81" bgcolor="#999999"><? echo $result["autre_empl"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Autres Ressources :</td>
<td width="107" bgcolor="#999999"><? echo $result["autre_ressource"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Le rôle du Promoteur :</td>
<td width="102" bgcolor="#999999"><? echo $result["mon_role"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Quantité :</td>
<td width="86" bgcolor="#999999"><? echo $result["qte_produite"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Immobilisation Corporelle :</td>
<td width="81" bgcolor="#999999"><? echo $result["imob_corp"];?></td>
</tr>
<tr>
<td width="129" bgcolor="#FF9933">Equipements :</td>
<td width="107" bgcolor="#999999"><? echo $result["equipement"];?></td>

</tr>
</table>

<table width="934" height="167" border="0" bgcolor="" >
<?
while( $moud = mysql_fetch_array( $aden ) )
{
if($moud["nom_entre"]==''){
$message='Ce promoteur ne possede pas une Entreprise';
}else {
?>
<tr>
<td height="51">Nom de son Entreprise :</td>
<td><? echo $moud["nom_entre"];?></td>
</tr>

<tr>
<td width="129" height="54" bgcolor="#FF9933">Forme Juridique :</td>
<td width="107" bgcolor="#999999"><? echo $moud["forme_jurid"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Employés :</td>
<td width="102" bgcolor="#999999"><? echo $moud["nbre_empl"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Chiffre d'Affaire :</td>
<td width="86" bgcolor="#999999"><? echo $moud["chifre_affair"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Quantité produit :</td>
<td width="81" bgcolor="#999999"><? echo $moud["qte_produit"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Salaire Moyenne Global :</td>
<td width="107" bgcolor="#999999"><? echo $moud["sal_moy_glob"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Clients:</td>
<td width="102" bgcolor="#999999"><? echo $moud["est_clt"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Rôle du Promoteur :</td>
<td width="86" bgcolor="#999999"><? echo $moud["role"];?></td>
<td width="10"></td>
<td width="10">
<a href="edit.php?numpro=<? echo $result["num_projet"];?>&numprom=<? echo $num;?>&numentr=<? echo $moud["num_entre"];?>">IMPRIMER SON DOSSIER</a></td>

</tr>

</table>
</form>

</div>


</body>
</html>

voila le code

Réponse 4 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 09:01

Non dsl mais je lis pas les pavés comme ca ...
si au moins c'était correctement indenté je dis pas, mais là ...

Réponse 5 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 09:03

excuse c est tro vague je vai juste t envoyer l esentiel

<form method="post" action="edit.php">
<table width="934" height="380" border="0" bgcolor="" >
<?
while( $result = mysql_fetch_array( $req1 ) )
{

?>
<tr><td height="39">Numero du Projet :</td>
<td><? echo $result["num_projet"];?></td></tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Projet :</td>
<td width="107" bgcolor="#999999"><? echo $result["nom_projet"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Nom du Promoteur :</td>
<td width="107" bgcolor="#999999"><? echo $nom;?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Dépossé le :</td>
<td width="102" bgcolor="#999999"><? echo $result["Date_depot"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Forme Juridique :</td>
<td width="86" bgcolor="#999999"><? echo $result["forme_juridique"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Nombre des employés :</td>
<td width="81" bgcolor="#999999"><? echo $result["nbre_employe"];?></td>
</tr>

<tr>
<td width="129" height="40" bgcolor="#FF9933">Secteur :</td>
<td width="107" bgcolor="#999999"><? echo $result["secteur"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Activité :</td>
<td width="102" bgcolor="#999999"><? echo $result["activite"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Salaire Mensuel :</td>
<td width="86" bgcolor="#999999"><? echo $result["sal_men"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Estimation du client :</td>
<td width="81" bgcolor="#999999"><? echo $result["est_clt"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Frais d'installation :</td>
<td width="107" bgcolor="#999999"><? echo $result["frai_inst"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Frais d'amenagement :</td>
<td width="102" bgcolor="#999999"><? echo $result["frai_amen"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Immobilisation Incorporelle :</td>
<td width="86" bgcolor="#999999"><? echo $result["imob_incorp"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Besoin fond deroulement :</td>
<td width="81" bgcolor="#999999"><? echo $result["bes_fond_der"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Totaux Emplois :</td>
<td width="107" bgcolor="#999999"><? echo $result["tot_emplois"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Fond Propre :</td>
<td width="102" bgcolor="#999999"><? echo $result["fond_propre"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Apport Associé :</td>
<td width="86" bgcolor="#999999"><? echo $result["app_aso"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Emprunt FDED :</td>
<td width="81" bgcolor="#999999"><? echo $result["emprunt_fded"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Prêt Bancaire :</td>
<td width="107" bgcolor="#999999"><? echo $result["pret_banque"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Total Ressource :</td>
<td width="102" bgcolor="#999999"><? echo $result["tot_ressource"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Garantie :</td>
<td width="86" bgcolor="#999999"><? echo $result["garantie"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Autres Emplois :</td>
<td width="81" bgcolor="#999999"><? echo $result["autre_empl"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Autres Ressources :</td>
<td width="107" bgcolor="#999999"><? echo $result["autre_ressource"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Le rôle du Promoteur :</td>
<td width="102" bgcolor="#999999"><? echo $result["mon_role"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Quantité :</td>
<td width="86" bgcolor="#999999"><? echo $result["qte_produite"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Immobilisation Corporelle :</td>
<td width="81" bgcolor="#999999"><? echo $result["imob_corp"];?></td>
</tr>
<tr>
<td width="129" bgcolor="#FF9933">Equipements :</td>
<td width="107" bgcolor="#999999"><? echo $result["equipement"];?></td>

</tr>
</table>

<table width="934" height="167" border="0" bgcolor="" >
<?
while( $moud = mysql_fetch_array( $aden ) )
{
if($moud["nom_entre"]==''){
$message='Ce promoteur ne possede pas une Entreprise';
}else {
?>
<tr>
<td height="51">Nom de son Entreprise :</td>
<td><? echo $moud["nom_entre"];?></td>
</tr>

<tr>
<td width="129" height="54" bgcolor="#FF9933">Forme Juridique :</td>
<td width="107" bgcolor="#999999"><? echo $moud["forme_jurid"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Employés :</td>
<td width="102" bgcolor="#999999"><? echo $moud["nbre_empl"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Chiffre d'Affaire :</td>
<td width="86" bgcolor="#999999"><? echo $moud["chifre_affair"];?></td>
<td width="10"></td>
<td width="128" bgcolor="#FF9933">Quantité produit :</td>
<td width="81" bgcolor="#999999"><? echo $moud["qte_produit"];?></td>
</tr>
<tr>
<td width="129" height="40" bgcolor="#FF9933">Salaire Moyenne Global :</td>
<td width="107" bgcolor="#999999"><? echo $moud["sal_moy_glob"];?></td>
<td width="5"></td>
<td width="122" bordercolor="#000000" bgcolor="#FF9933">Nombres des Clients:</td>
<td width="102" bgcolor="#999999"><? echo $moud["est_clt"];?></td>
<td width="10"></td>
<td width="108" bgcolor="#FF9933">Rôle du Promoteur :</td>
<td width="86" bgcolor="#999999"><? echo $moud["role"];?></td>
<td width="10"></td>
<td width="10">
<a href="edit.php?numpro=<? echo $result["num_projet"];?>&numprom=<? echo $num;?>&numentr=<? echo $moud["num_entre"];}}}?>">IMPRIMER SON DOSSIER</a></td>

</tr>

</table>

Réponse 6 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 09:26

jeangilles voila les origines des acolades je m excuse pour les pavé il me reste 20 jour pour le finaliser et passer sur mon exam de licence j ai un peu la tete confus bon pour les accolades voila ! j ai affichage promoteur et j ai un affichage de projet et entreprise ensemble donc les acolades je les ai ouvert ici !
<?
while( $result = mysql_fetch_array( $req1 ) )
{
?>

ici

<?
while( $moud = mysql_fetch_array( $aden ) )
{
if($moud["nom_entre"]==''){
$message='Ce promoteur ne possede pas une Entreprise';
}else {
?>

et ici

<?
while( $result = mysql_fetch_array( $req1 ) )
{
?> je te rappele que ce dans 2 different pages d' affichage !! merci

Réponse 7 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 09:28

Oui j'avais trouvé ca
mais pourquoi tu les ferme dans la balise a ?
ca veut rien dire !
il faut soit les fermer avant, soit après, mais pas au milieu :S

Réponse 8 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 09:34

tu me donnes une solution <a href="edit.php?numpro=<? echo $result["num_projet"];?>&numprom=<? echo $num;?>&numentr=<? echo $moud["num_entre"];">IMPRIMER SON DOSSIER</a></td>
je met car il y a en meme temps l envois pour trouver le promoteur rechercher !!

Réponse 9 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 09:36

Et puis autre question :
pourquoi tu as un form alors que tu as juste un lien ?
soit c'est un formulaire avec un bouton d'envoi, soit un lien, mais un form vide ca ne sert à rien

Réponse 10 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 09:40

aahh oui mais je vais l enlever merci ! mais vous avez trouvez ou pourai je metre les accolades si je change avant les condition ne seron pas verifier et apre ca marche pas

Réponse 11 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 09:42

Ben ca dépend ce que tu veux faire ...
mais je suppose que c'est après le </a>, sans vraiment chercher à comprendre ^^

Réponse 12 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 09:53

c est que je veu c 'est quand je clic sur sur dossier imprimer il me donne le promoteur et son nouveau projet son entreprise et que j' imprime !!

Réponse 13 / 15

jeangilles Messages postés 816 Date d'inscription samedi 21 juin 2008 Statut Membre Dernière intervention 17 juillet 2012 185
4 août 2009 à 09:55

Ben oui mais tu les as déjà normalement
dans ta page edit.php, tu les récupereras en faisant un $_GET['numpro'], $_GET['numprom'] et $_GET['numentr']

Réponse 14 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 10:11

oui j en ai mais ce recuperation ce font apre l envoi de cete pages
$a=$_GET["numpro"];
$b=$_GET["numprom"];
$c=$_GET["numentr"];
ou bien je peu faire autrement

Réponse 15 / 15

medaden Messages postés 52 Date d'inscription lundi 27 avril 2009 Statut Membre Dernière intervention 27 janvier 2010 1
4 août 2009 à 10:42

merci jeangilles
je vous remerci de m avoir voulu aider j etai un peu vague mai grace aux accolades que vous avez pointé le doigt c est ok !!!!

{MySQL}

15 réponses

Discussions similaires

Newsletters