Comments by MekaC - CodeProject

MekaC 4-Apr-23 8:51am View

I looked up tutorials. Alot were in regards to using sites such as PHPBB, Vanilla, or code that was outdated. Will check out the link you sent me.

In my last post I corrected myself and stated where I had issues but as I thought no one can help me and that's fine.

MekaC 1-Apr-23 22:01pm View

First off did I state in any of my post that I wanted to have you or anybody else do the work for me? I posted here because I assumed this was a forum that I can get help in. I searched to find clarification on what my issue is and no help whatsoever.

Also if I have a problem with a specific script wouldn't it be smart to ask the creator of the script for help since they are the ones who created it?

If you couldn't help me with my issue then it would've been best to either say you couldn't or just kept silent. The so called "do it for me because I can't be bothered" attitude towards this you assume I have is a lie. The site I'm working on I'm doing it myself. I'm still working on my developer skills but have improved in lots of ways.

Once again just admit you cant come up with a solution or just keep quiet...that would be greatly appreciated. Have a Blessed Day

MekaC 1-Mar-23 9:07am View

Thank ya so very much Sir this is exactly what I was looking for :)

MekaC 23-Jan-23 21:19pm View

Thank ya :)

MekaC 22-Jan-23 20:20pm View

Sorry for late repsonse...the Datasource is the DB connection. That part is fine!

MekaC 21-Jan-23 22:41pm View

This is the backend code for the main login/register:

ds = new DataSource();
}

/**
* to check if the username already exists
*
* @param string $username
* @return boolean
*/
public function isUsernameExists($username)
{
$query = 'SELECT * FROM tbl_member where username = ?';
$paramType = 's';
$paramValue = array(
$username
);
$resultArray = $this->ds->select($query, $paramType, $paramValue);
$count = 0;
if (is_array($resultArray)) {
$count = count($resultArray);
}
if ($count > 0) {
$result = true;
} else {
$result = false;
}
return $result;
}

/**
* to check if the email already exists
*
* @param string $email
* @return boolean
*/
public function isEmailExists($email)
{
$query = 'SELECT * FROM tbl_member where email = ?';
$paramType = 's';
$paramValue = array(
$email
);
$resultArray = $this->ds->select($query, $paramType, $paramValue);
$count = 0;
if (is_array($resultArray)) {
$count = count($resultArray);
}
if ($count > 0) {
$result = true;
} else {
$result = false;
}
return $result;
}

/**
* to signup / register a user
*
* @return string[] registration status message
*/
public function registerMember()
{
$isUsernameExists = $this->isUsernameExists($_POST["username"]);
$isEmailExists = $this->isEmailExists($_POST["email"]);
if ($isUsernameExists) {
$response = array(
"status" => "error",
"message" => "Username already exists."
);
} else if ($isEmailExists) {
$response = array(
"status" => "error",
"message" => "Email already exists."
);
} else {
if (! empty($_POST["signup-password"])) {

// PHP's password_hash is the best choice to use to store passwords
// do not attempt to do your own encryption, it is not safe
$hashedPassword = password_hash($_POST["signup-password"], PASSWORD_DEFAULT);
}
$query = 'INSERT INTO tbl_member (username, password, email) VALUES (?, ?, ?)';
$paramType = 'sss';
$paramValue = array(
$_POST["username"],
$hashedPassword,
$_POST["email"]
);
$memberId = $this->ds->insert($query, $paramType, $paramValue);
if (! empty($memberId)) {
$response = array(
"status" => "success",
"message" => "You have registered successfully."
);
}
}
return $response;
}

public function getMember($username)
{
$query = 'SELECT * FROM tbl_member where username = ?';
$paramType = 's';
$paramValue = array(
$username
);
$memberRecord = $this->ds->select($query, $paramType, $paramValue);
return $memberRecord;
}

/**
* to login a user
*
* @return string
*/
public function loginMember()
{
$memberRecord = $this->getMember($_POST["username"]);
$loginPassword = 0;
if (! empty($memberRecord)) {
if (! empty($_POST["login-password"])) {
$password = $_POST["login-password"];
}
$hashedPassword = $memberRecord[0]["password"];
$loginPassword = 0;
if (password_verify($password, $hashedPassword)) {
$loginPass

MekaC 21-Jan-23 13:07pm View

Sir you didn't answer my question. I have that in place I just want to connect the tables from both scripts within the code so they work together.

MekaC 17-Jan-23 16:49pm View

Thank ya so very much Sir...that did the trick :)

Comments by MekaC (Top 8 by date)