The Entrepreneur Forum | Financial Freedom | Starting a Business | Motivation | Money | Success

Welcome to the only entrepreneur forum dedicated to building life-changing wealth.

Build a Fastlane business. Earn real financial freedom. Join free.

Join over 80,000 entrepreneurs who have rejected the paradigm of mediocrity and said "NO!" to underpaid jobs, ascetic frugality, and suffocating savings rituals— learn how to build a Fastlane business that pays both freedom and lifestyle affluence.

Free registration at the forum removes this block.

Databases Problems Are Painful...

David Borodin

Contributor
Read Fastlane!
User Power
Value/Post Ratio
75%
Oct 1, 2021
44
33
Bonjour,
So basically there is a problem that accrued recently... :xx:
I will try my best to explain it simply and save you time. :thumbsup:
If you have experience with it, and you have time to help me, I would absolutely appreciate it! :)
-------------------------------------------------------------------------------------------
I created a database in phpmyadmin,
I wrote PHP code in connect.php,
I wrote code in signin.html,
I connected them all together.
But still, this shows up:

Se kildebildet


------------------------------------------------------------------------------------------------
Here is my signin.html code:

<form method="post" action="connect.php">
<label>First Name...</label>
<input type="text" placeholder="" id="firstName" name="firstName">
<label>Last Name...</label>
<input type="text" placeholder="" id="lastName" name="lastName">
<label>Email</label>
<input type="email" placeholder="" id="email" name="email">
<label>Password...</label>
<input type="password" placeholder="" id="password" name="password">
<label>Comfirm Password...</label>
<input type="password" placeholder="">
<input type="submit" value="Submit" name="btn btn-primary">
</form>


----------------------------------------------------------------------------------------

Here is my connect.php code:

<?php
$firstName = filter_input(INPUT_POST, 'firstName');
$lastName = filter_input(INPUT_POST, 'lastName');
$email = filter_input(INPUT_POST, 'email');
$password = filter_input(INPUT_POST, 'password');
if (!empty($firstName)){
if (!empty($lastName)){
if (!empty($email)){
if (!empty($password)){
$host = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "accounts";
// Create connection
$conn = new mysqli ($host, $dbusername, $dbpassword, $dbname);
if (mysqli_connect_error()){
die('Connect Error ('. mysqli_connect_error() .') '
. mysqli_connect_error());
}
else{
$sql = "INSERT INTO registration (firstName, lastName, email, password)
values ('$firstName', '$lastName', '$email', '$password')";
if ($conn->query($sql))}
echo "New record is inserted sucessfully";
}
else{
echo "Error: ".$sql . "<br>". $conn->error;
}
$conn->close();
}
}
else{
echo "Password should not be empty";
die();
}
}
else{
echo "Username should not be empty"
die();
}
?>

-------------------------------------------------------------------------------------------------------

I have watched countless of videos of this problem,
but nothing seems to explain the problem.
I know really little about PHP and databases in general.


Thank you for reading through,
I hope you can help.
If you need more information, please contact me.
 
Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

schmidi

New Contributor
User Power
Value/Post Ratio
80%
Apr 6, 2021
5
4
Deutschland
Bonjour,
So basically there is a problem that accrued recently... :xx:
I will try my best to explain it simply and save you time. :thumbsup:
If you have experience with it, and you have time to help me, I would absolutely appreciate it! :)
-------------------------------------------------------------------------------------------
I created a database in phpmyadmin,
I wrote PHP code in connect.php,
I wrote code in signin.html,
I connected them all together.
But still, this shows up:

Se kildebildet


------------------------------------------------------------------------------------------------
Here is my signin.html code:

<form method="post" action="connect.php">
<label>First Name...</label>
<input type="text" placeholder="" id="firstName" name="firstName">
<label>Last Name...</label>
<input type="text" placeholder="" id="lastName" name="lastName">
<label>Email</label>
<input type="email" placeholder="" id="email" name="email">
<label>Password...</label>
<input type="password" placeholder="" id="password" name="password">
<label>Comfirm Password...</label>
<input type="password" placeholder="">
<input type="submit" value="Submit" name="btn btn-primary">
</form>


----------------------------------------------------------------------------------------

Here is my connect.php code:

<?php
$firstName = filter_input(INPUT_POST, 'firstName');
$lastName = filter_input(INPUT_POST, 'lastName');
$email = filter_input(INPUT_POST, 'email');
$password = filter_input(INPUT_POST, 'password');
if (!empty($firstName)){
if (!empty($lastName)){
if (!empty($email)){
if (!empty($password)){
$host = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "accounts";
// Create connection
$conn = new mysqli ($host, $dbusername, $dbpassword, $dbname);
if (mysqli_connect_error()){
die('Connect Error ('. mysqli_connect_error() .') '
. mysqli_connect_error());
}
else{
$sql = "INSERT INTO registration (firstName, lastName, email, password)
values ('$firstName', '$lastName', '$email', '$password')";
if ($conn->query($sql))}
echo "New record is inserted sucessfully";
}
else{
echo "Error: ".$sql . "<br>". $conn->error;
}
$conn->close();
}
}
else{
echo "Password should not be empty";
die();
}
}
else{
echo "Username should not be empty"
die();
}
?>

-------------------------------------------------------------------------------------------------------

I have watched countless of videos of this problem,
but nothing seems to explain the problem.
I know really little about PHP and databases in general.


Thank you for reading through,
I hope you can help.
If you need more information, please contact me.
Just two clues:
1. Stackoverflow is a really good resource for programming questions / problems / error messages.
2. A lot can go wrong by coding all yourself, SQL injections, missing indices, missing unique attributes .. I would go for some hosted solution instead of programming all myself. I am using firebase auth for my current project, they even have a ready ui: Easily add sign-in to your Web app with FirebaseUI
 

Mathuin

Provide Relative-Value or Die Trying
Read Rat-Race Escape!
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
360%
Dec 20, 2020
669
2,410
Belfast, Northern Ireland
As @schmidi mentioned above, this is a question for Stack Overflow/ Reddit.
 

Post New Topic

Please SEARCH before posting.
Please select the BEST category.

Post new topic

Guest post submissions offered HERE.

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Ideas needing execution, more!

Join Fastlane Insiders.

Top