Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //variables inicials
- $db_host="localhost";
- $db_user="root";
- $db_password="root";
- $db_name="primera_bd";
- $db_table_name="registre";
- $mysqli=new mysqli($db_host,$db_user, $db_password,$db_name);
- /*$mysqli=mysqli_connect($db_host,$db_user, $db_password,$db_name);*/
- //consulta al servidor MySQL per establir el conjunt de caràcters
- mysqli_set_charset($mysqli,"utf8");
- /*recollim les dades de formulari.php que volem desar a la taula d'inscripcions*/
- $subs_name = @$_POST['nom'];
- $subs_last = @$_POST['cognoms'];
- $subs_email = @$_POST['email'];
- //comprovem les dades rebudes per seguretat
- $firstname = mysqli_real_escape_string($mysqli, $subs_name);
- $lastname = mysqli_real_escape_string($mysqli, $subs_last);
- $Email = mysqli_real_escape_string($mysqli, $subs_email);
- $db_table_name="registre";
- mysqli_query($link,$consulta_email)
- //no deixem registrar si un correu electrònic ja existeix
- $consulta_email="SELECT email * FROM registre WHERE email={$subs_email}";
- $res_email = mysqli_query($mysqli,$consulta_email);
- if($res_email->fetch_assoc()){
- header('Location: Fail.html');
- }
- //passem una sentència SQL amb variables a trevés de php
- $insert_value ="INSERT INTO `registre`(`nom`, `cognoms`, `email`) VALUES ('{$subs_name}','{$subs_last}','{$subs_email}')";
- $retry_value = mysqli_query($mysqli,$insert_value);
- /*echo "Benvingut/da".$_REQUEST['nom']."";$_REQUEST['cognoms'];
- $email=$_REQUEST['email'];*/
- if ($retry_value) {
- include("Success.php");
- } else {
- include("Fail.php");
- }
- $mysqli->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement