PHP print multiple lines of code instead of execute query and put elements in Database (registration form)

Question

Hy, im new on php and im trying to make a registration and login form, but he show this code when i click the submit button to submit my user informations to database:

page sign-up.php:

<?php
require('functions/database.php');
session_start();
if(isset($_SESSION['user_id'])) {
 header("Location:dashboard.html");
}
session_destroy();
session_start();
ob_start();
?>

<html>
[...]
<head>
[...]
<body>
<form role="form text-left" action="sign_up.php" method="POST">
    <div class="mb-3">
        <input type="text" class="form-control" placeholder="First Name" name="userfirstname" id="userfirstname">
    </div>
    <div class="mb-3">
        <input type="text" class="form-control" placeholder="Last Name" name="userlastname" id="userlastname">
    </div>
    <div class="mb-3">
        <input type="text" class="form-control" placeholder="Nickname" name="usernickname" id="usernickname">

    </div>
    <div class="mb-3">
        <input type="password" class="form-control" placeholder="Password" name="userpass" id="userpass">
    </div>
    <div class="mb-3">
        <input type="password" class="form-control" placeholder="Confirm Password" name="userpassconfirm" id="userpassconfirm">
    </div>
    <div class="mb-3">
        <input type="email" class="form-control" placeholder="Email" name="useremail" id="useremail">

    </div>
    <div class="mb-3">
        <input type="text" class="form-control" placeholder="Hometown" name="userhometown" id="userhometown">
    </div>
    <div class="text-center">
        <input type="submit" class="btn bg-gradient-dark w-100 my-4 mb-2" name="register"></input>
    </div>
        <p class="text-sm mt-3 mb-0">Already have an account? <a href="javascript:;" class="text-dark font-weight-bolder">Sign in</a></p>
</form>
</body>
</head>
</html>

page sign_up.php:

<?
session_start();
require_once('functions/database.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

    if (isset($_POST['register'])) {
        // Retrieve Data
        $userfirstname = $_POST['userfirstname'];
        $userlastname = $_POST['userlastname'];
        $usernickname = $_POST['usernickname'];
        $userpassword = md5($_POST['userpass']);
        $useremail = $_POST['useremail'];
        $userhometown = $_POST['userhometown'];

        $query = "SELECT user_email, FROM users WHERE user_email=:email";
        $check = $pdo->prepare($query);
        $check->bindParam(':email', $useremail, PDO::PARAM_STR);
        $check->execute();

        $checkquery = $check->fetchAll(PDO::FETCH_ASSOC);

        if ($count($checkquery) > 0) {
            $msg = "User alredy registered";

        } else {
            // Insert Data
            $query = "INSERT INTO users(user_firstname, user_lastname, user_nickname, user_password, user_email,  user_hometown) VALUES (:firstname, :lastname, :nickname, :password, :email, :hometown)";
            $check = $pdo->prepare($query);
            $check->bindParam(':firstname', $userfirstname, PDO::PARAM_STR);
            $check->bindParam(':lastname', $userlastname, PDO::PARAM_STR);
            $check->bindParam(':nickname', $usernickname, PDO::PARAM_STR);
            $check->bindParam(':password', $userpassword, PDO::PARAM_STR);
            $check->bindParam(':email', $useremail, PDO::PARAM_STR);
            $check->bindParam(':hometown', $userhometown, PDO::PARAM_STR);
            $check->execute();

            if ($check->rowCount() > 0) {
                $msg = "success!";

            } else {
                $msg ="error, try again";
            }
        }
    }
}

echo $msg;
?>

error when submit registration form:

prepare($query); $check->bindParam(':email', $useremail, PDO::PARAM_STR); $check >execute(); $checkquery = $check->fetchAll(PDO::FETCH_ASSOC); if ($count($checkquery) > 0) { $msg = "Utente gia registrato"; } else { // Insert Data $query = "INSERT INTO users(user_firstname, user_lastname, user_nickname, user_password, user_email, user_hometown) VALUES (:firstname, :lastname, :nickname, :password, :email, :hometown)"; $check = $pdo->prepare($query); $check->bindParam(':firstname', $userfirstname, PDO::PARAM_STR); $check->bindParam(':lastname', $userlastname, PDO::PARAM_STR); $check->bindParam(':nickname', $usernickname, PDO::PARAM_STR); $check->bindParam(':password', $userpassword, PDO::PARAM_STR); $check->bindParam(':email', $useremail, PDO::PARAM_STR); $check->bindParam(':hometown', $userhometown, PDO::PARAM_STR); $check->execute(); if ($check->rowCount() > 0) { $msg = "utente registrato"; } else { $msg ="utente non registrato"; } } } } echo $msg; ?>

if you also have any suggestions for the syntax, comments, it is welcome

@Ahmed yes, same, i worked so long at this project, maybe i need a coffe ahaah — Petruz21, Jun 24 '22 at 02:20
Refer to this https://stackoverflow.com/questions/12142172/apache-shows-php-code-instead-of-executing-it — ahmed, Jun 24 '22 at 02:35

poppies · Answer 1 · 2022-06-24T02:25:02.317

0

Please remove "," after user_email in your code.

$query = "SELECT user_email FROM users WHERE user_email=:email";
$check = $pdo->prepare($query);
$check->execute(array('email' => $useremail));

edited Jun 24 '22 at 02:25

answered Jun 24 '22 at 02:20

poppies

142
6

I tryed, but nothing change :( – Petruz21 Jun 24 '22 at 02:21
https://www.php.net/manual/ja/pdo.prepare.php You can see it. – poppies Jun 24 '22 at 02:25

PHP print multiple lines of code instead of execute query and put elements in Database (registration form)

1 Answers1