PHP danna un warella

G.D.1.nirmal · Aug 14, 2023

Menna html code eka!!

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>login/Signup Form</title>
<link rel="stylesheet" href="/src/main.css">
</head>
<body>
<header>
<div class="containerx">
<section class="logo">
<strong><a style="color:azure;text-decoration: none;" href="/Home.html">Mytestsite.lk</a></strong>
</a>
</section>
<nav>
<ul>
<li><a href="/Home.html">Home</a></li>
<li><a href="/Our Vision.html">Our Vision</a></li>
<li><a href="/Our Mission.html">Our Mission</a></li>

<li><a href="/src/signup.php">Sign up/Sign In</a></li>
<li class="menu-icon"><img src="images/menu_icon.png" alt="menu icon"></li>
</ul>
</nav>
</div>
</header>
<div class="container">
<form class="form" id="login">
<h1 class="form__title">login</h1>
<div class="form__message form__message--error"></div>
<div class="form__input-group">
<input type="text" class="form__input" autofocus placeholder="Username or email">
<div class="form__input-error-message"></div>
</div>
<div class="form__input-group">
<input type="text" class="form__input" autofocus placeholder="password">
<div class="form__input-error-message"></div>
</div>
<button class="form__button" type="submit">Continue</button>
<p class="form__text">
<a href="#" class="form__link">Forgot Your Password?</a>
</p>
<p class="form__text">
<a class="form__link" href=""./" id="linkCreateAccount" >Dont have an account? Create account</a>
</p>

</form>
<form class="form form--hidden" id="createAccount" action="insert.php" method="POST">
<h1 class="form__title">Create Account</h1>
<div class="form__message form__message--error"></div>
<div class="form__input-group">
<input type="text" id="signupUsername" class="form__input" autofocus placeholder="Username" name="Username" required>
<div class="form__input-error-message"></div>
</div>
<div class="form__input-group">
<input type="text" class="form__input" autofocus placeholder="Email Address" name="EmailAddress" required>
<div class="form__input-error-message"></div>
</div>
<div class="form__input-group">
<input type="password" class="form__input" autofocus placeholder="password" name="Password" required>
<div class="form__input-error-message"></div>
</div>
<div class="form__input-group">
<input type="password" class="form__input" autofocus placeholder="Confirm password" name="ConfirmPassword" required>
<div class="form__input-error-message"></div>
</div>
<button class="form__button" type="submit" name="submit">Continue</button>
<p class="form__text">
<a class="form__link" href="" id="linkLogin" >Already have an account? Sign in</a>
</p>

</form>
</div>

<script src="/src/main.js"></script>
</body>
</html>

Menna php eka

<?php
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];
$password = $_POST['password'];
$ConfirmPassword = $_POST['ConfirmPassword'];
if(!empty($username) || !empty($EmailAddress) || !empty($password ) || !empty($ConfirmPassword)) {
$host = "localhost";
$dbname = "sign_up";
$dbPass = "";
$dbuser = "root";
//create connection
$conn = mysqli_connect(hostname: $host,
username: $username,
password: $password,
database: $dbname);
if (mysqli_connect_error()) {
die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error())
}else{
$SELECT = "SELECT EmailAddress from signup where EmailAddress = ? Limit 1";
$INSERT = "INSERT Into signup (Username, EmailAddress, Password, ConfirmPassword) values(?,?,?,?)";
//Prepare Statement
$stmt = $conn->prepare($empty);
$stmt->bind_param("s", $EmailAddress);
$stmt->executive();
$stmt->bind_result($EmailAddress);
$stmt->store_result();
$rnum = $stmt->num_rows;
if($rnum==0) {
$stmt->close();
$stmt = $conn->prepare($INSERT);
$stmt->bind_param("ssss", $username, $EmailAddress, $password, $ConfirmPassword);
$stmt->execute;
echo "New record inserted sucessfully";
} else {
echo "Someone already used this email to register";
}
$stmt->close();
$conn->close();
}
}
else {
echo "All fields are required";
die();
}
?>
------ Post added on Aug 14, 2023 at 9:43 AM

හෙළයෙක් · Aug 14, 2023

<form class="form" id="login" method="post">

මොකද මෙතන තියෙන්නෙ පොස්ට් එක. ඔය ෆොම් එකත් ඒ මෙතඩ් එකෙන්ම එවන්න ඕනි
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];

https://www.w3schools.com/tags/att_form_method.asp

https://www.codiga.io/blog/code-sharing-tools/

code share karadi me wagen tool ekak balala gana. eka lesi. nathan apita ikmanata answers dena be
------ Post added on Aug 14, 2023 at 10:04 AM

G.D.1.nirmal · Aug 14, 2023

හෙළයෙක් said:
<form class="form" id="login" method="post">

මොකද මෙතන තියෙන්නෙ පොස්ට් එක. ඔය ෆොම් එකත් ඒ මෙතඩ් එකෙන්ම එවන්න ඕනි
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];

https://www.w3schools.com/tags/att_form_method.asp

https://www.codiga.io/blog/code-sharing-tools/

code share karadi me wagen tool ekak balala gana. eka lesi. nathan apita ikmanata answers dena be
------ Post added on Aug 14, 2023 at 10:04 AM

moakakda macho terune naa mama oy create form eke method eka POST widihatane daala tiyenne??

delmar · Aug 14, 2023

form method eka POST nemei neda

G.D.1.nirmal · Aug 14, 2023

delmar said:
form method eka POST nemei neda

POST tamai macho!!

හෙළයෙක් · Aug 14, 2023

G.D.1.nirmal said:
moakakda macho terune naa mama oy create form eke method eka POST widihatane daala tiyenne??

html eke method eka post karana

G.D.1.nirmal · Aug 14, 2023

හෙළයෙක් said:
html eke method eka post karana

hariyanne nane macho oka daana mokakhari widihak tiyenawada HTML eka athule??

-

This page isn’t working

If the problem continues, contact the site owner.

HTTP ERROR 405

හෙළයෙක් · Aug 14, 2023

G.D.1.nirmal said:
hariyanne nane macho oka daana mokakhari widihak tiyenawada HTML eka athule?? -

This page isn’t working
If the problem continues, contact the site owner.

HTTP ERROR 405

php karana kenekta kiyamu machan code eka debug karana kiyala ehemanan. mata oka run karala balana widiyak ne mage laga setup eka nathi nisa.

code eka balapuwama nan issue eka form eke method eka post nathi eka.

OnDaRock · Aug 14, 2023

isn't execute a function ?

/* Execute the statement */
$stmt->execute();

G.D.1.nirmal · Aug 14, 2023

Identity · Aug 14, 2023

Me code eka dapan

PHP:

<?php
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];
$password = $_POST['Password'];
$ConfirmPassword = $_POST['ConfirmPassword'];

if (!empty($username) && !empty($EmailAddress) && !empty($password) && !empty($ConfirmPassword)) {
    $host = "localhost";
    $dbname = "sign_up";
    $dbPass = "";
    $dbuser = "root";

    // Create connection
    $conn = mysqli_connect($host, $dbuser, $dbPass, $dbname);

    if (mysqli_connect_error()) {
        die('Connect Error('. mysqli_connect_errno() .')'. mysqli_connect_error());
    } else {
        $SELECT = "SELECT EmailAddress from signup WHERE EmailAddress = ? LIMIT 1";
        $INSERT = "INSERT Into signup (Username, EmailAddress, Password, ConfirmPassword) values(?,?,?,?)";

        // Prepare Statement
        $stmt = $conn->prepare($SELECT);
        $stmt->bind_param("s", $EmailAddress);
        $stmt->execute();
        $stmt->bind_result($EmailAddress);
        $stmt->store_result();
        $rnum = $stmt->num_rows;
        
        if ($rnum==0) {
            $stmt->close();
            $stmt = $conn->prepare($INSERT);
            $stmt->bind_param("ssss", $username, $EmailAddress, $password, $ConfirmPassword);
            $stmt->execute();
            echo "New record inserted successfully";
        } else {
            echo "Someone has already registered using this email";
        }

        $stmt->close();
        $conn->close();
    }
} else {
    echo "All fields are required";
}
?>

Amith0424 · Aug 14, 2023

Code:

<?php
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];
$password = $_POST['password'];
$ConfirmPassword = $_POST['ConfirmPassword'];
if(!empty($username) || !empty($EmailAddress) || !empty($password ) || !empty($ConfirmPassword)) {
$host = "localhost";
$dbname = "sign_up";
$dbPass = "";
$dbuser = "root";

//create connection
$conn = mysqli_connect($host,$username,$password,$dbname);

if (mysqli_connect_error()) {
    die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
} else  {
$SELECT = "SELECT EmailAddress from signup where EmailAddress = ? Limit 1";
$INSERT = "INSERT Into signup (Username, EmailAddress, Password, ConfirmPassword) values(?,?,?,?)";
//Prepare Statement
$stmt = $conn->prepare($empty);
$stmt->bind_param("s", $EmailAddress);
$stmt->executive();
$stmt->bind_result($EmailAddress);
$stmt->store_result();
$rnum = $stmt->num_rows;
if($rnum==0) {
$stmt->close();
$stmt = $conn->prepare($INSERT);
$stmt->bind_param("ssss", $username, $EmailAddress, $password, $ConfirmPassword);
$stmt->execute;
echo "New record inserted sucessfully";
} else {
echo "Someone already used this email to register";
}
$stmt->close();
$conn->close();
}
}
else {
echo "All fields are required";
die();
}
?>

දාල බලල කියන්න.

updates lines:
$conn = mysqli_connect(hostname: $host,
username: $username,
password: $password,
database: $dbname);
$conn = mysqli_connect($host,$username,$password,$dbname);

die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error())
die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());

G.D.1.nirmal · Aug 14, 2023

Amith0424 said:

Code:

<?php
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];
$password = $_POST['password'];
$ConfirmPassword = $_POST['ConfirmPassword'];
if(!empty($username) || !empty($EmailAddress) || !empty($password ) || !empty($ConfirmPassword)) {
$host = "localhost";
$dbname = "sign_up";
$dbPass = "";
$dbuser = "root";

//create connection
$conn = mysqli_connect($host,$username,$password,$dbname);

if (mysqli_connect_error()) {
    die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
} else  {
$SELECT = "SELECT EmailAddress from signup where EmailAddress = ? Limit 1";
$INSERT = "INSERT Into signup (Username, EmailAddress, Password, ConfirmPassword) values(?,?,?,?)";
//Prepare Statement
$stmt = $conn->prepare($empty);
$stmt->bind_param("s", $EmailAddress);
$stmt->executive();
$stmt->bind_result($EmailAddress);
$stmt->store_result();
$rnum = $stmt->num_rows;
if($rnum==0) {
$stmt->close();
$stmt = $conn->prepare($INSERT);
$stmt->bind_param("ssss", $username, $EmailAddress, $password, $ConfirmPassword);
$stmt->execute;
echo "New record inserted sucessfully";
} else {
echo "Someone already used this email to register";
}
$stmt->close();
$conn->close();
}
}
else {
echo "All fields are required";
die();
}
?>

දාල බලල කියන්න.

updates lines:
$conn = mysqli_connect(hostname: $host,
username: $username,
password: $password,
database: $dbname);
$conn = mysqli_connect($host,$username,$password,$dbname);

die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error())
die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());

Hariyanne naa macho

Mokakhari server connection issue ekak wenna athi tiyenne code eke nemei..........

Identity said:

Me code eka dapan

PHP:

<?php
$username = $_POST['Username'];
$EmailAddress = $_POST['EmailAddress'];
$password = $_POST['Password'];
$ConfirmPassword = $_POST['ConfirmPassword'];

if (!empty($username) && !empty($EmailAddress) && !empty($password) && !empty($ConfirmPassword)) {
    $host = "localhost";
    $dbname = "sign_up";
    $dbPass = "";
    $dbuser = "root";

    // Create connection
    $conn = mysqli_connect($host, $dbuser, $dbPass, $dbname);

    if (mysqli_connect_error()) {
        die('Connect Error('. mysqli_connect_errno() .')'. mysqli_connect_error());
    } else {
        $SELECT = "SELECT EmailAddress from signup WHERE EmailAddress = ? LIMIT 1";
        $INSERT = "INSERT Into signup (Username, EmailAddress, Password, ConfirmPassword) values(?,?,?,?)";

        // Prepare Statement
        $stmt = $conn->prepare($SELECT);
        $stmt->bind_param("s", $EmailAddress);
        $stmt->execute();
        $stmt->bind_result($EmailAddress);
        $stmt->store_result();
        $rnum = $stmt->num_rows;
       
        if ($rnum==0) {
            $stmt->close();
            $stmt = $conn->prepare($INSERT);
            $stmt->bind_param("ssss", $username, $EmailAddress, $password, $ConfirmPassword);
            $stmt->execute();
            echo "New record inserted successfully";
        } else {
            echo "Someone has already registered using this email";
        }

        $stmt->close();
        $conn->close();
    }
} else {
    echo "All fields are required";
}
?>

Hariyanne naa macho

Mokakhari server connection issue ekak wenna athi tiyenne code eke nemei..........
------ Post added on Aug 14, 2023 at 1:19 PM

Amith0424 · Aug 14, 2023

G.D.1.nirmal said:
Hariyanne naa macho
Mokakhari server connection issue ekak wenna athi tiyenne code eke nemei..........

Hariyanne naa macho
Mokakhari server connection issue ekak wenna athi tiyenne code eke nemei..........
------ Post added on Aug 14, 2023 at 1:19 PM

oka run karalamayine damme. connection db user pwd harida balanna.

windows_ubuntu · Aug 14, 2023

Uba db connection eke credentialui, user submit krana detailui patalawan inne.
Variable names hodata check krapan

G.D.1.nirmal · Aug 14, 2023

Amith0424 said:
oka run karalamayine damme. connection db user pwd harida balanna.

$dbPass = "";
$dbuser = "root";

me deka tamai tiyenne.

Amith0424 · Aug 14, 2023

windows_ubuntu said:
Uba db connection eke credentialui, user submit krana detailui patalawan inne.
Variable names hodata check krapan

maath dan dakke. wena error ekakne kiya kiya hitiye.

$conn = mysqli_connect($host,$dbuser,$dbPass,$dbname);

EKGuest · Aug 14, 2023

G.D.1.nirmal · Aug 14, 2023

Amith0424 said:
maath dan dakke. wena error ekakne kiya kiya hitiye.

$conn = mysqli_connect($host,$dbuser,$dbPass,$dbname);

dan mokakda mama karanna ona??

windows_ubuntu · Aug 14, 2023

G.D.1.nirmal said:
dan mokakda mama karanna ona??

Poddak hitpn. Free unama help ekak dennm.

iita klin kawru hri udaw krai

PHP danna un warella

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

This page isn’t working​

Well-known member

This page isn’t working​

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Similar threads

This page isn’t working

This page isn’t working