Forum d'entraide PHPFrance

Venez poser vos questions PHP, MySQL, HTML5, CSS, Javascript, Gestion de serveurs à la communauté PHPfrance
https://forum.phpfrance.com/

probleme de script

https://forum.phpfrance.com/viewtopic.php?f=23&t=257828

Page 1 sur 1

probleme de script

Posté : 17 mars 2011, 12:08
par godza
je suis en train de créer uun site et je n'arrive pas a enregistrer les donnés dans ma base de données.
veuillé m'aider s'il vous plait.
<?php
session_start();
if (isset($_POST['loginONG']) && isset($_POST['password']))
{
$db=mysql_connect("localhost","root","");

mysql_select_db("gesttub",$db);

$chainesql="select * from utilisateur where login='$_POST[loginONG]' and password='$_POST[password]'";

$result=mysql_query($chainesql); //,$db);

if ($row=mysql_fetch_assoc($result))
{
session_register('validutil');
$_SESSION['validutil']=$_POST['loginONG'];
}
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>Ajouter un patient</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>

<div id="header">

<div id="header_inner" class="fixed">

<div id="logo">
<h1><span>ONG SAKPAA </span></h1>
<h2>By Ngatta hugues</h2>
</div>

<div id="menu">
<ul>
<li><a href="index_2column.html" >Accueil</a></li>
<li><a href="action.html" class="active">Actions</a></li>
<li><a href="photo.html">Photos</a></li>
<li><a href="Organisation.html">Organisations</a></li>
<li><a href="contact.html">Contacts </a></li>
</ul>
</div>

</div>
</div>

<div id="main">

<div id="main_inner" class="fixed">

<div id="primaryContent_2columns">

<div id="columnA_2columns">

<h3>Une organisation au service de la population la main sur le coeur<br>
<center>ADMINISTRATION</center></h3>
<?php
if (session_is_registered('validutil'))
{
echo "Bienvenue : ".$_SESSION['validutil'];
echo " - <a href='deconexion.php'> se déconnecter</a>";
echo " - <a href='suivimaladesuraction.php'>Administration</a>&nbsp;";
}
?>

<table border="0" cellspacing="0" cellpadding="0" width="566">
<tr>
<td valign='top'>&nbsp;

</td>
</tr>

<tr>
<td>


<?
//************************************************************************** begin
?>




<?php
if (isset($_SESSION['validutil']))
{
?>

<form method="POST" action="patient.php" name="ajoutpatient">
<center><table align='center'>


<tr>
<td align='left'>Nom du patient:</td>
<td align='left'><input type="text" name="txtNomPat" size="20"></TD>
</tr>
<tr>
<td align='left'>Prénom du patient:</td>
<td align='left'><input type="text" name="txtPrenPat" size="40"></TD>
</tr>
<tr>
<td width="30%" height="10%" align='left'>Sexe</td>
<td width="70%" height="10%" align='left'>
<input type="radio" size="30" name="optsexe" value="F">F
<input type="radio" size="30" name="optsexe" value="M">M
</td>
</tr>
<tr>
<td align='left'>Date de naissance:</td>
<td align='left'>
<select name="cmbjour">
<option value="" size="" name="" selected>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select size="" name="cmbmois">
<option value=""></option>
<option value="01">janvier</option>
<option value="02">fevrier</option>
<option value="03"> mars </option>
<option value="04">avril</option>
<option value="05">mai</option>
<option value="06"> juin</option>
<option value="07">juillet</option>
<option value="08">aout</option>
<option value="09"> septembre</option>
<option value="10">octobre</option>
<option value="11">novembre</option>
<option value="12"> decenbre</option>
</select>
<select size="" name="cmbannee">
<option></option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
</select>
</td>
</tr>
<tr>
<td align='left'>Centre de suivie du malade:</td>
<td align='left'><input type="text" name="txtCat" size="50"></TD>
</tr>
<tr>
<td align='left'>Tél patient:</td>
<td align='left'><input type="text" name="txttelPat" size="20"></TD>
</tr>
<tr>
<td align='left'>Ville du patient:</td>
<td align='left'><input type="text" name="txtVilPat" size="30"></TD>
</tr>
<tr>
<td align='left'>Domicile:</td>
<td align='left'><input type="text" name="txtKtierPat" size="30"></TD>
</tr>
<tr>
<td align='left'>Statut vih:</td>
<td align='left'>
<select size="" name="cmbstat">
<option></option>
<option value="SN">sero-negatif</option>
<option value="Vih1">vih 1</option>
<option value="Vih2">vih2</option>
</select>
</td>
</tr>
<tr>
<td align='left'>Type de patient:</td>
<td align='left'>
<select size="" name="cmbsTypPat">
<option value= >choisir</option>
<option value="Nouveau">Nouveau</option>
<option value="Rechute">Rechute</option>
<option value="Rep apre aband">Reprise apres abandon</option>
<option value="Echec">Echec</option>
<option value="Autre">Autre</option>
</select>
</td>
</tr>

<tr>
<td width="30%" height="10%" align='left'>Forme de la maladie</td>
<td width="70%" height="10%" align='left'>
<input type="radio" size="30" name="optForMal" value="F">TPM+
<input type="radio" size="30" name="optFormMal" value="M">TPM-
<input type="radio" size="30" name="optFormMal" value="F">TEP

</td>
</tr>

<tr>
<td align='left'>Debut du traitement:</td>
<td align='left'>
<select name="cmbjour">
<option value="" size="" name="" selected>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select size="" name="cmbmois">
<option value=""></option>
<option value="01">janvier</option>
<option value="02">fevrier</option>
<option value="03"> mars </option>
<option value="04">avril</option>
<option value="05">mai</option>
<option value="06"> juin</option>
<option value="07">juillet</option>
<option value="08">aout</option>
<option value="09"> septembre</option>
<option value="10">octobre</option>
<option value="11">novembre</option>
<option value="12"> decenbre</option>
</select>
<select size="" name="cmbannee">
<option></option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
</select>
</td>
</tr>
<tr>
<td align='left'>fin du traitement:</td>
<td align='left'>
<select name="cmbjour">
<option value="" size="" name="" selected>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select size="" name="cmbmois">
<option value=""></option>
<option value="01">janvier</option>
<option value="02">fevrier</option>
<option value="03"> mars </option>
<option value="04">avril</option>
<option value="05">mai</option>
<option value="06"> juin</option>
<option value="07">juillet</option>
<option value="08">aout</option>
<option value="09"> septembre</option>
<option value="10">octobre</option>
<option value="11">novembre</option>
<option value="12"> decenbre</option>
</select>
<select size="" name="cmbannee">
<option></option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
</select>
</td>
</tr>
<tr>
<td align='left'>Nom superviseur:</td>
<td align='left'><input type="text" name="txtNomSup" size="20"></TD>
</tr>
<tr>
<td align='left'>Prenom superviseur:</td>
<td align='left'><input type="text" name="txtPrenSup" size="40"></TD>
</tr>
<tr>
<td align='left'>Tél superviseur:</td>
<td align='left'><input type="text" name="txttelSup" size="8"></TD>
</tr>
</tr>

<tr>
<td align="center" colspan='2'><br>

<center>
<input type="reset" value="Annuler" >
<input type="submit" value="Enregistrer">
</center>

</td>
</tr>
</table></center>
</form>
<center>
<?
}
else
{
echo "<p>Vous n'avez pas le droit de consulter cette page</p>";
echo "<p><a href='suivimaladesuraction.php'>Connectez</a> vous d'abord.</p>";
}
?>
<br><br><center><a href='javascript:history.back()'>Page précédante</a><center><br />
<?
//************************************************************************** end
?>

<br>&nbsp;</td>
</tr>
</table>

<br class="clear" />

<div class="post">


</div>

</div>

</div>
<div id="secondaryContent_2columns">

<div id="columnC_2columns">

<h4><span>Partenaires</span> </h4>
<ul class="links">
<li class="first"><a href="#">Centre AntiTubeculeux</a></li>

<li><a href="#">District de yamoussoukro</a></li>

<li><a href="#">Mairie Danané</a></li>

<li><a href="#">CHR yamousoukro</a></li>

<li><a href="#">Abidjan</a></li>

</ul>

<h4><span>Divers</span></h4>
<ul class="links">
<li class="first"><a href="#">Remerciemment</a></li>

<li><a href="#">Evenement</a></li>

<li><a href="#">Caledrier des actions</a></li>

<li><a href="#">Benevoles</a></li>

<li><a href="#">action</a></li>

</ul>
</div>
</div>
<br class="clear" />
</div>

</div>

<div id="footer" class="fixed">
Copyright &copy; 2011 N'gatta Hugues. All rights reserved. Design by <a href="http://www.nodethirtythree.com/">N'gatta Hugues</a>.
</div>

</body>
</html>



la page de réception des variables qui est la page patient.



<?php
session_start();
if (isset($_POST['loginONG']) && isset($_POST['password']))
{
$db=mysql_connect("localhost","root","");

mysql_select_db("gesttub",$db);

$chainesql="select * from utilisateur where login='$_POST[loginONG]' and password='$_POST[password]'";

$result=mysql_query($chainesql); //,$db);

if ($row=mysql_fetch_assoc($result))
{
session_register('validutil');
$_SESSION['validutil']=$_POST['loginONG'];
}
}
?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>enregistrement patient</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>

<div id="header">

<div id="header_inner" class="fixed">

<div id="logo">
<h1><span>ONG SAKPAA </span></h1>
<h2>By Ngatta hugues</h2>
</div>

<div id="menu">
<ul>
<li><a href="index_2column.html" >Accueil</a></li>
<li><a href="action.html"class="active">Actions</a></li>
<li><a href="photo.html">Photos</a></li>
<li><a href="Organisation.html">Organisations</a></li>
<li><a href="contact.html">Contacts </a></li>
</ul>
</div>

</div>
</div>

<div id="main">

<div id="main_inner" class="fixed">

<div id="primaryContent_2columns">

<div id="columnA_2columns">

<h3>Une organisation au service de la population la main sur le coeur</h3>

<?php


if (session_is_registered('validutil'))
{
echo "Bienvenue : ".$_SESSION['validutil'];
echo " - <a href='deconexion.php'> se déconnecter</a>";
echo " - <a href='index.php'>Administration</a>&nbsp;";
}
?>


<?
//************************************************************************** begin
?>

<?php

$nompat=addslashes($_POST['txtNomPat']);
$prenpat=addslashes($_POST['txtPrenPat']);
$sexe=addslashes($_POST['optsexe']);
$datjour=addslashes($_POST['cmbjour']);
$datmois=addslashes($_POST['cmbmois']);
$datannee=addslashes($_POST['cmbannee']);
$Cat=addslashes($_POST['txtCat']);
$telpat=addslashes($_POST['txttelPat']);
$vilpat=addslashes($_POST['txtVilPat']);
$Ktierpat=addslashes($_POST['txtKtierPat']);
$statu=addslashes($_POST['cmbstat']);
$Typpat=addslashes($_POST['cmbsTypPat']);
$ForMal=addslashes($_POST['optForMal']);
$debtraitjour=addslashes($_POST['cmbjour']);
$debtraitmois=addslashes($_POST['cmbmois']);
$debtraitannee=addslashes($_POST['cmbannee']);
$fintraitjour=addslashes($_POST['cmbjour']);
$fintraitmois=addslashes($_POST['cmbmois']);
$fintraitannee=addslashes($_POST['cmbannee']);
$nomsup=addslashes($_POST['txtNomSup']);
$prensup=addslashes($_POST['txtPrenSup']);
$telsup=addslashes($_POST['txttelSup']);
$datnaiss=$datjour+"-"+$datmois+"-"+$datannee;
$debu=$debtraitjour+"-"+$debtraitmois+"-"+$debtraitannee;
$fin=$fintraitjour+"-"+$fintraitmois+"-"+$fintraitannee;
// connexion au seveur de donnees
$dp=mysql_connect("localhost","root","");
// selectionner la base de donnees
mysql_select_db("gesttub",$dp);
// ecriture de la requete sql a excuter
$chainesql="insert into patient
(NomPat,PrenPat,SexPat,DatNaissPat,CentrSuiviPat,
TelPat,VilPat,KtierPat,StatVihPat,TypPat,
FormMalPat,Debtrait,FinTrait,NomSupPat,PrenSupPat,
TelSupPat)
values ('','$nompat','$prenpat','$sexe','$datnaiss','$Cat',
'$telpat''$vilpat','$Ktierpat','$statu','$Typpat',
'$ForMal','$debu','$fin','$nomsup','$prensup','$telsup' )";
// execution de la requete
//$result=mysql_query($chainesql);


if($result=mysql_query($chainesql))
{
echo "<center>L'enregistrement est fait avec succes</center>";
}
else
{
echo "<center>Echec de l'opération</center>";
}
?>

<?
//************************************************************************** end
?>

<br />
</td>
</tr>
<tr>
<td class="bodyText Style23"></td>
</tr>
</table>
<br><br><center><a href='javascript:history.back()'>Page précédante</a><center><br />


<br class="clear" />

<div class="post">


</div>

</div>

</div>

<div id="secondaryContent_2columns">

<div id="columnC_2columns">

<h4><span>Partenaires</span> </h4>
<ul class="links">
<li class="first"><a href="#">Centre AntiTubeculeux</a></li>

<li><a href="#">District de yamoussoukro</a></li>

<li><a href="#">Mairie Danané</a></li>

<li><a href="#">CHR yamousoukro</a></li>

<li><a href="#">Abidjan</a></li>

</ul>

<h4><span>Divers</span></h4>
<ul class="links">
<li class="first"><a href="#">Remerciemment</a></li>

<li><a href="#">Evenement</a></li>

<li><a href="#">Caledrier des actions</a></li>

<li><a href="#">Benevoles</a></li>

<li><a href="#">action</a></li>

</ul>



</div>

</div>

<br class="clear" />

</div>

</div>

<div id="footer" class="fixed">
Copyright &copy; 2011 N'gatta Hugues. All rights reserved. Design by <a href="http://www.nodethirtythree.com/">N'gatta Hugues</a>.
</div>

</body>
</html>

Re: probleme de script

Posté : 17 mars 2011, 12:09
par stealth35
hello, met bien ton code dans balise PHP du forum.
Heures au format UTC+02:00
Page 1 sur 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/