Tecumseh | ok voilà le code...
Code :
- <?php require_once('Connections/maDeuxiemeConnexion.php'); ?>
- <?php
- if (!function_exists("GetSQLValueString" )) {
- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "" )
- {
- if (PHP_VERSION < 6) {
- $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
- }
- $theValue = function_exists("mysql_real_escape_string" ) ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
- switch ($theType) {
- case "text":
- $theValue = ($theValue != "" ) ? "'" . $theValue . "'" : "NULL";
- break;
- case "long":
- case "int":
- $theValue = ($theValue != "" ) ? intval($theValue) : "NULL";
- break;
- case "double":
- $theValue = ($theValue != "" ) ? doubleval($theValue) : "NULL";
- break;
- case "date":
- $theValue = ($theValue != "" ) ? "'" . $theValue . "'" : "NULL";
- break;
- case "defined":
- $theValue = ($theValue != "" ) ? $theDefinedValue : $theNotDefinedValue;
- break;
- }
- return $theValue;
- }
- }
- $editFormAction = $_SERVER['PHP_SELF'];
- if (isset($_SERVER['QUERY_STRING'])) {
- $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
- }
- if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1" )) {
- $insertSQL = sprintf("INSERT INTO inscriptions (id_abonne, mail, Prénom, nom, `code postal`, `date de naissance`, password) VALUES (%s, %s, %s, %s, %s, %s, %s)",
- GetSQLValueString($_POST['id_abonne'], "int" ),
- GetSQLValueString($_POST['mail'], "text" ),
- GetSQLValueString($_POST['Prénom'], "text" ),
- GetSQLValueString($_POST['nom'], "text" ),
- GetSQLValueString($_POST['code_postal'], "int" ),
- GetSQLValueString($_POST['date_de_naissance'], "date" ),
- GetSQLValueString($_POST['password'], "text" ));
- mysql_select_db($database_maDeuxiemeConnexion, $maDeuxiemeConnexion);
- $Result1 = mysql_query($insertSQL, $maDeuxiemeConnexion) or die(mysql_error());
- $theID = mysql_insert_id();
- $insertGoTo = "confirm_newsletter.php?id_abonne={theID}";
- if (isset($_SERVER['QUERY_STRING'])) {
- $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
- $insertGoTo .= $_SERVER['QUERY_STRING'];
- }
- header(sprintf("Location: %s", $insertGoTo));
- }
- function Genere_Password($size)
- {
- // Initialisation des caractères utilisables
- $characters = array(0 => array(0, 2, 3, 4, 5, 6, 7, 8, 9),
- 1 => array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z" ));
- $password_generated = array();
- for($i=0;$i<$size;$i++)
- {
- // On choisit au hasard entre quelle sorte de caractères choisir
- $p = rand(0, 1);
- switch($p)
- {
- case 0: $q = rand(0, 8);
- break;
- case 1: $q = rand(0, 24);
- break;
- }
- $password_generated[$i] = $characters[$p][$q];
- }
- return implode("", $password_generated);
- }
- // génération
- $mon_mot_de_passe = Genere_Password(6);
- mysql_select_db($database_maDeuxiemeConnexion, $maDeuxiemeConnexion);
- $query_Recordset1 = "SELECT * FROM inscriptions";
- $Recordset1 = mysql_query($query_Recordset1, $maDeuxiemeConnexion) or die(mysql_error());
- $row_Recordset1 = mysql_fetch_assoc($Recordset1);
- $totalRows_Recordset1 = mysql_num_rows($Recordset1);
- ?>
- <!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">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Paghyra | Inscription</title>
- <link href="styll.css" rel="stylesheet" type="text/css" />
- <script type="text/javascript">
- <!--
- function MM_validateForm() { //v4.0
- if (document.getElementById){
- var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
- for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
- if (val) { nm=val.name; if ((val=val.value)!="" ) {
- if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
- if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
- } else if (test!='R') { num = parseFloat(val);
- if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
- if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
- min=test.substring(8,p); max=test.substring(p+1);
- if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
- } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
- } if (errors) alert('The following error(s) occurred:\n'+errors);
- document.MM_returnValue = (errors == '');
- } }
- //-->
- </script>
- </head>
- <body onload="MM_validateForm('mail','','RisEmail');return document.MM_returnValue">
- <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
- <form action="<?php echo $editFormAction; ?>" method="post" name="form1" onsubmit="MM_validateForm('mail','','RisEmail');return document.MM_returnValue">
- <fieldset>
- <legend>Inscrivez-vous à notre newsletter</legend>
- <p>
- <label>Email :</label>
- <input name="mail" type="text" id="mail" value="" size="32">
- </p>
- <p>
- <label>Prénom :</label>
- <input type="text" name="Prénom" value="" size="32">
- <br /><br />
- <label>Nom :</label>
- <input type="text" name="nom" value="" size="32">
- <br /><br />
- <label>Code Postal :</label>
- <input type="text" name="code postal" value="" size="32">
- <br /><br />
- <label>Date de naissance:</label>
- <input type="text" name="date de naissance" value="" size="32">
- <br />
- <input type="hidden" name="password" value="<?php echo $mon_mot_de_passe; ?>">
- <br />
- </p>
- <div align="center">
- <input name="submit" type="submit" class="bouton" value="Envoyer" />
- <input type="hidden" name="MM_insert" value="form1">
- </div>
- </fieldset>
- </form>
- <input type="hidden" name="MM_insert" value="form1" />
- </form>
- <p> </p>
- </body>
- </html>
- <?php
- mysql_free_result($Recordset1);
- ?>
|
Code :
- <?php require_once('Connections/maDeuxiemeConnexion.php'); ?>
- <?php
- if (!function_exists("GetSQLValueString" )) {
- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "" )
- {
- if (PHP_VERSION < 6) {
- $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
- }
- $theValue = function_exists("mysql_real_escape_string" ) ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
- switch ($theType) {
- case "text":
- $theValue = ($theValue != "" ) ? "'" . $theValue . "'" : "NULL";
- break;
- case "long":
- case "int":
- $theValue = ($theValue != "" ) ? intval($theValue) : "NULL";
- break;
- case "double":
- $theValue = ($theValue != "" ) ? doubleval($theValue) : "NULL";
- break;
- case "date":
- $theValue = ($theValue != "" ) ? "'" . $theValue . "'" : "NULL";
- break;
- case "defined":
- $theValue = ($theValue != "" ) ? $theDefinedValue : $theNotDefinedValue;
- break;
- }
- return $theValue;
- }
- }
- mysql_select_db($database_maDeuxiemeConnexion, $maDeuxiemeConnexion);
- $query_Recordset1 = "SELECT * FROM inscriptions";
- $Recordset1 = mysql_query($query_Recordset1, $maDeuxiemeConnexion) or die(mysql_error());
- $row_Recordset1 = mysql_fetch_assoc($Recordset1);
- $totalRows_Recordset1 = mysql_num_rows($Recordset1);
- $email=$row_Recordset1['mail'];
- $sujet="Votre inscription à notre newsletter";
- $message="Bonjour,\n\n";
- $message.="Vous venez de vous inscrire à la newsletter de paghyra.fr.cr \n";
- $message.="Voici vos codes d'accès : \n";
- $message.="Login :".$row_Recordset1['mail']."\n";
- $message.="Mot de passe :".$row_Recordset1['password']."\n";
- $message.="Si vous souhaitez vous désabonner, cliquez ici : http://paghyra.fr.cr/desabonne_new [...] Recordset1['id_abonne']."\n";
- $headers="From: tecumseh@franceserv.com \n";
- $headers.="MIME-version: 1.0\n";
- $headers.="Content-type: text/html; charset= iso-8859-1\n";
- $headers.="Bcc: tecumseh@franceserv.com\n";
- mail($email,$sujet,$message,$headers);
- ?>
- <!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">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Paghyra | Inscription</title>
- </head>
- <body>
- Un e-mail vous a été adressé à l’adresse que vous nous avez communiquée, confirmant votre inscription.
- </body>
- </html>
- <?php
- mysql_free_result($Recordset1);
- ?>
|
Message édité par Tecumseh le 27-08-2011 à 20:08:37
|