Ok, demain je vais vous attaché une démonstration vidéo de mon problème.
voici le code vehicule_add.php
<?php
include "config.php";
if (isset($_COOKIE["ValidUserAdmin"]))
{
?>
<HTML>
<HEAD>
<TITLE>Gestion d'Immatriculation</TITLE>
<LINK REL="STYLESHEET" HREF="style.css">
</HEAD>
<BODY> <?PHP include "header.php"; ?>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" WIDTH="95%">
<TR>
<TD VALIGN="TOP">
<?PHP include "leftmenu.php"; ?>
<IMG SRC="images/blank_.gif" WIDTH="180" HEIGHT="1" BORDER="0"></TD>
<TD WIDTH="100%" VALIGN="TOP" ALIGN="LEFT">
<font color="#FF802B">VEHICULE</font>
<head>
<?php
if (isset($_POST["op"]) && ($_POST["op"]=="AddProperty"))
{
if (!$userfile) {$userfile = "";}
else {
do_upload();
}
// Enter the details submitted into the Database.
mysql_connect($server, $DBusername, $DBpassword) or die ("$DatabaseError 12");
mysql_select_db($database);
mysql_query( "LOCK TABLES $vehicule_table WRITE" ); # Lock the tables for writing to
mysql_query("INSERT INTO $vehicule_table (
Numero_Serie,
Type,
Declaration_Douane,
Numero_BL,
Gamme,
Version
)
VALUES (
'".$_POST['Numero_Serie']."',
'".$_POST['Type']."',
'".$_POST['Declaration_Douane']."',
'".$_POST['Numero_BL']."',
'".$_POST['Gamme']."',
'".$_POST['Version']."'
)")or die ("$DatabaseError 48");
mysql_query( "UNLOCK TABLES" ); # Unlock the tables
print "<br><br><br>";
print "<br><br><br><p align=\"center\"><b>Le nouveau Véhicule <b>".$_POST['Numero_Serie']."</b>) est ajouté avec succès.</b></p>";
print "<p align=\"center\"><a href=\"vehicule_add.php\">Cliquer ici</a> pour ajouter un autre Véhicule</p>";
print "<br>";
}
else
{
?>
<form method="post" enctype="multipart/form-data">
<input name="op" type="hidden" value="AddProperty">
<input name="DateAdded" type="hidden" value="<?php print "$dateadded"; ?>">
<br>
<TABLE WIDTH="95%" border="0" ALIGN="CENTER" CELLPADDING="5" CELLSPACING="1" BGCOLOR="#000066">
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Type:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="Type" SIZE="20" MAXLENGTH="50" value="<? print $Type;?>"><a href="#" onClick="window.open('type_edit.php','Type', 'width=350,height=600,scrollbars=0').focus();"><img src="petitbouton.gif" border="0"/></a></P></TD></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Gamme:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="Gamme" SIZE="20" MAXLENGTH="50" value="<? print $Gamme;?>"></P></TD></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Version:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="Version" SIZE="20" MAXLENGTH="50" value="<? print $Version;?>"></P></TD></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Numéro de Série:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="Numero_Serie" SIZE="20" MAXLENGTH="50"></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Déclaration de douane:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<INPUT TYPE="TEXT" NAME="Declaration_Douane" SIZE="20" MAXLENGTH="50"value="<? print $Declaration_Douane;?>"><a href="#" onClick=" window.open('expedition.php','Declaration_Douane','width=350,height=600,scrollbars=0').focus();"><img src="petitbouton.gif" border="0"/></a></P></TD></P></TD>
</TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#FF802B">
<P><b>Numéro BL:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="Numero_BL" SIZE="20" MAXLENGTH="50"value="<? print $Numero_BL;?>">
</P></TD>
</TR>
</TABLE>
<br>
<p align="center"> <input value="Ajout d'un Véhicule" type="submit" class="textinput" ONCLICK="return confirm('Confirmez vous l'ajout de ce véhicule?');"></p>
</form>
<?php
}
?></TD>
</TR>
</TABLE><?PHP include "footer.php"; ?>
</BODY>
</HTML>
<?php
}
else
{
header("Location: login_error.php");
exit;
}
?>
et voici le code du popup type_edit.php
<?php
include "config.php";
if (isset($_COOKIE["ValidUserAdmin"]))
{
?>
<HTML>
<HEAD>
<TITLE>Gestion d'Immatriculation</TITLE><LINK
REL="STYLESHEET" HREF="style.css">
</HEAD>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" WIDTH="95%">
<TR>
<H4><font color="#003366">TYPE VEHICULE</font> <font color="#999999">></font> <font color="#FF802B">Editition/Modification Type</font></H4>
<p></p>
<br>
<br>
<?php
if (!$SortBy) {$SortBy = "Type"; }
{
// Connect to the database and get the hotels
mysql_connect($server, $DBusername, $DBpassword) or die("Cannot connect to the database.<br>" . mysql_error());
mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());
{
$sql = "SELECT * FROM $Type_table ORDER BY $SortBy ASC";
$query = mysql_query($sql);
$total_results = mysql_num_rows($query);
if (empty($total_results)) {print "<p align=\"center\">Pas de résultats trouvés<br><br>Vous n'avez aucun Type dans la base de données.</p>";}
else {
$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
{
$page = "1"; //default page if none is selected
}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
$result = mysql_query("SELECT * FROM $Type_table ORDER BY $SortBy ASC LIMIT $offset, $limit") or die ("$DatabaseError - 163");
# $query = "SELECT count(*) as count FROM $order_table";
$num = mysql_numrows($result);
if ($num == 0) :
// If no orders can be found let them know!
print "<br><br><p align=\"center\"><font size= \"-1\" color=\"red\">Désolé, Pas de Type trouvé dans la base de données.</font></p><br><br>";
// But .. If there are orders, we had better show them ..
elseif ($num > 0) :
##################################
// This is the Previous/Next Navigation
echo "<font face=Verdana size=1>";
echo "$total_results Résultat(s) trouvé(s): Page - "; // total pages
if ($page != 1)
{
echo "<a href=$PHP_SELF?page=1><< Début</a> "; // Début Page Link
$prevpage = $page - 1;
#echo " <a href=$PHP_SELF?page=$prevpage><<</a> "; // Previous Page Link
}
if ($page == $total_pages)
{
$to = $total_pages;
}
elseif ($page == $total_pages-1)
{
$to = $page+1;
}
elseif ($page == $total_pages-2)
{
$to = $page+2;
}
else
{
$to = $page+3;
}
if ($page == 1 || $page == 2 || $page == 3)
{
$from = 1;
}
else
{
$from = $page-3;
}
for ($i = $from; $i <= $to; $i++)
{
if ($i == $total_results) $to=$total_results;
if ($i != $page)
{
echo "<a href=$PHP_SELF?showold=yes&page=$i>$i</a>";
}
else
{
echo "<b><font face=Verdana color=darkblue>[$i]</font></b>";
}
if ($i != $total_pages)
echo " ";
}
if ($page != $total_pages)
{
$nextpage = $page + 1;
#echo " <a href=$PHP_SELF?page=$nextpage>>></a> "; // Next Page Link
echo " <a href=$PHP_SELF?page=$total_pages>Fin >></a>"; // Fin Page Link
}
print "<br><br>";
###################################
print "<p align=\"center\">Liste des Types <b>$limit</b> par page.</p>";
print "<TABLE WIDTH=\"100%\" \"0\" CELLPADDING=\"2\" CELLSPACING=\"1\" BGCOLOR=\"#CCCCCC\"><TR VALIGN=\"MIDDLE\">
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\" WIDTH=\"75\"><P><a href=\"?SortBy=Type\"><B>Type</B></a></P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P><a href=\"?SortBy=Gamme\"><B>Gamme</B></a></P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P><a href=\"?SortBy=Version\"><B>Version</B></a></P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P><B>Action</B></P></TD>
</TR>";
$i = 0;
while ($i < $num) :
$Type = mysql_result($result,$i,"Type");
$Genre = mysql_result($result,$i,"Genre");
$Gamme = mysql_result($result,$i,"Gamme");
print "<TR VALIGN=\"MIDDLE\">
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P>$Type</P></TD>
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P>$Gamme</P></TD>
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P>$Version</P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\" width=\"50\">";
print "<table><tr>";
print "<td><form method=\"post\" action=\"vehicule_add.php\" target=\"Gestion d'Immatriculation\" onsubmit=\"setTimeout('window.close()', 500); return(true);\"><input name=\"op\" type=\"hidden\" value=\"onsubmit\"><input name=\"Type\" type=\"hidden\" value=\"$Type\"><input name=\"op\" type=\"hidden\" value=\"onsubmit\"><input name=\"Gamme\" type=\"hidden\" value=\"$Gamme\"><input name=\"op\" type=\"hidden\" value=\"onsubmit\"><input name=\"Version\" type=\"hidden\" value=\"$Version\"><P><input value=\"Select\" type=\"submit\" class=\"textinput\"></P></form></td>";
print "</tr></table>";
print "</TD></TR>";
$i++;
endwhile;
endif;
if ($num == 0) { print "";} else {print "</table>";}
}
}
}
?></TD>
</TR>
</TABLE><?PHP include "footer.php"; ?>
</BODY>
</HTML>
<?php
}
else
{
header("Location: login_error.php");
exit;
}
?>
Et voici le code du 2eme popup
expedition.php
<?php
include "config.php";
if (isset($_COOKIE["ValidUserAdmin"]))
{
?>
<HTML>
<HEAD>
<TITLE>Gestion d'Immatriculation</TITLE><LINK
REL="STYLESHEET" HREF="style.css">
</HEAD>
<H4><font color="#003366">EPEDITION</font> <font color="#999999">></font> <font color="#FF802B">Editition/Modification Expedition</font></H4>
<p></p>
<br>
<br>
<?php
if (!$SortBy) {$SortBy = "Declaration_Douane"; }
{
// Connect to the database and get the hotels
mysql_connect($server, $DBusername, $DBpassword) or die("Cannot connect to the database.<br>" . mysql_error());
mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());
{
$sql = "SELECT * FROM $expedition_table ORDER BY $SortBy ASC";
$query = mysql_query($sql);
$total_results = mysql_num_rows($query);
if (empty($total_results)) {print "<p align=\"center\">Pas de résultats trouvés<br><br>Vous n'avez aucune Expedition dans la base de données.</p>";}
else {
$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
{
$page = "1"; //default page if none is selected
}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
$result = mysql_query("SELECT * FROM $expedition_table ORDER BY $SortBy ASC LIMIT $offset, $limit") or die ("$DatabaseError - 163");
# $query = "SELECT count(*) as count FROM $order_table";
$num = mysql_numrows($result);
if ($num == 0) :
// If no orders can be found let them know!
print "<br><br><p align=\"center\"><font size= \"-1\" color=\"red\">Désolé, Pas d'expedition trouvée dans la base de données.</font></p><br><br>";
// But .. If there are orders, we had better show them ..
elseif ($num > 0) :
##################################
// This is the Previous/Next Navigation
echo "<font face=Verdana size=1>";
echo "$total_results Résultat(s) trouvé(s): Page - "; // total pages
if ($page != 1)
{
echo "<a href=$PHP_SELF?page=1><< Début</a> "; // Début Page Link
$prevpage = $page - 1;
#echo " <a href=$PHP_SELF?page=$prevpage><<</a> "; // Previous Page Link
}
if ($page == $total_pages)
{
$to = $total_pages;
}
elseif ($page == $total_pages-1)
{
$to = $page+1;
}
elseif ($page == $total_pages-2)
{
$to = $page+2;
}
else
{
$to = $page+3;
}
if ($page == 1 || $page == 2 || $page == 3)
{
$from = 1;
}
else
{
$from = $page-3;
}
for ($i = $from; $i <= $to; $i++)
{
if ($i == $total_results) $to=$total_results;
if ($i != $page)
{
echo "<a href=$PHP_SELF?showold=yes&page=$i>$i</a>";
}
else
{
echo "<b><font face=Verdana color=darkblue>[$i]</font></b>";
}
if ($i != $total_pages)
echo " ";
}
if ($page != $total_pages)
{
$nextpage = $page + 1;
#echo " <a href=$PHP_SELF?page=$nextpage>>></a> "; // Next Page Link
echo " <a href=$PHP_SELF?page=$total_pages>Fin >></a>"; // Fin Page Link
}
print "<br><br>";
###################################
print "<p align=\"center\">Liste des Expeditions <b>$limit</b> par page.</p>";
print "<TABLE WIDTH=\"100%\" \"0\" CELLPADDING=\"2\" CELLSPACING=\"1\" BGCOLOR=\"#CCCCCC\"><TR VALIGN=\"MIDDLE\">
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\" WIDTH=\"75\"><P><a href=\"?SortBy=Declaration_Douane\"><B> N° déclaration douane</B></a></P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P><a href=\"?SortBy=Numero_BL\"><B>Numéro BL</B></a></P></TD>
<TD BGCOLOR=\"#F3F3F3\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P><B>Action</B></P></TD>
</TR>";
$i = 0;
while ($i < $num) :
$Declaration_Douane = mysql_result($result,$i,"Declaration_Douane");
$Numero_BL = mysql_result($result,$i,"Numero_BL");
print "<TR VALIGN=\"MIDDLE\">
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P>$Declaration_Douane</P></TD>
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\"><P>$Numero_BL</P></TD>
<TD BGCOLOR=\"#FFFFFF\" VALIGN=\"MIDDLE\" ALIGN=\"CENTER\">";
print "<table><tr>";
print "<td><form method=\"post\" action=\"vehicule_add.php\" target=\"Gestion d'Immatriculation\" onsubmit=\"setTimeout('window.close()', 500); return(true);\"><input name=\"op\" type=\"hidden\" value=\"onsubmit\"><input name=\"Declaration_Douane\" type=\"hidden\" value=\"$Declaration_Douane\"><input name=\"op\" type=\"hidden\" value=\"onsubmit\"><input name=\"Numero_BL\" type=\"hidden\" value=\"$Numero_BL\"><P><input value=\"Select\" type=\"submit\" class=\"textinput\"></P></form></td>";
print "</tr></table>";
print "</TD></TR>";
$i++;
endwhile;
endif;
if ($num == 0) { print "";} else {print "</table>";}
}
}
}
?></TD>
</TR>
</TABLE><?PHP include "footer.php"; ?>
</BODY>
</HTML>
<?php
}
else
{
header("Location: login_error.php");
exit;
}
?>
Je ne comprends pas vraiment ce que tu essayes de faire au juste ni comment. essaye d'être clair et de décomposer ton problème. T pars de quoi, tu veux obtenir quoi, quelle méthode utilises-tu pour y parvenir. Je suis certain que tu peux expliquer ça mieux que ça : n'oublies pas que je ne vois qu'une petite portion de code et absolument rien du résultat ou du déroulement des opérations.
