x10webhosting Call to undefined method mysqli_stmt::get_result()
up vote
0
down vote
favorite
This is my php block that has the get_result()
public function storeUser($first_name,$middle_name,$last_name,$birthdate,$age,$monthly_salary,$tax,$email,$password) {
$uuid = uniqid('', true);
$hash = $this->hashSSHA($password);
$encrypted_password = $hash["encrypted"]; // encrypted password
$salt = $hash["salt"]; // salt
$stmt = $this->conn->prepare("INSERT INTO users(unique_id, first_name, middle_name, last_name, birthdate,age, monthly_salary,tax, email, encrypted_password, salt, created_at) VALUES(?, ?, ?, ?, ?,?,?,?,?,?,?,NOW())");
$stmt->bind_param("sssssssssss", $uuid, $first_name,$middle_name,$last_name,$birthdate,$age, $monthly_salary,$tax, $email, $encrypted_password, $salt);
$result = $stmt->execute();
$stmt->close();
// check for successful store
if ($result) {
$stmt = $this->conn->prepare("SELECT * FROM users WHERE email=?");
$stmt->bind_param("s", $email);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();
return $user;
} else {
return false;
}
}
I searched for answers and altered the get_result to native method but no luck I dont know what to do anymore and I am using webhost x10webhosting but when I try my PHP files on localhost it works just fine
php mysqli cpanel
add a comment |
up vote
0
down vote
favorite
This is my php block that has the get_result()
public function storeUser($first_name,$middle_name,$last_name,$birthdate,$age,$monthly_salary,$tax,$email,$password) {
$uuid = uniqid('', true);
$hash = $this->hashSSHA($password);
$encrypted_password = $hash["encrypted"]; // encrypted password
$salt = $hash["salt"]; // salt
$stmt = $this->conn->prepare("INSERT INTO users(unique_id, first_name, middle_name, last_name, birthdate,age, monthly_salary,tax, email, encrypted_password, salt, created_at) VALUES(?, ?, ?, ?, ?,?,?,?,?,?,?,NOW())");
$stmt->bind_param("sssssssssss", $uuid, $first_name,$middle_name,$last_name,$birthdate,$age, $monthly_salary,$tax, $email, $encrypted_password, $salt);
$result = $stmt->execute();
$stmt->close();
// check for successful store
if ($result) {
$stmt = $this->conn->prepare("SELECT * FROM users WHERE email=?");
$stmt->bind_param("s", $email);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();
return $user;
} else {
return false;
}
}
I searched for answers and altered the get_result to native method but no luck I dont know what to do anymore and I am using webhost x10webhosting but when I try my PHP files on localhost it works just fine
php mysqli cpanel
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This is my php block that has the get_result()
public function storeUser($first_name,$middle_name,$last_name,$birthdate,$age,$monthly_salary,$tax,$email,$password) {
$uuid = uniqid('', true);
$hash = $this->hashSSHA($password);
$encrypted_password = $hash["encrypted"]; // encrypted password
$salt = $hash["salt"]; // salt
$stmt = $this->conn->prepare("INSERT INTO users(unique_id, first_name, middle_name, last_name, birthdate,age, monthly_salary,tax, email, encrypted_password, salt, created_at) VALUES(?, ?, ?, ?, ?,?,?,?,?,?,?,NOW())");
$stmt->bind_param("sssssssssss", $uuid, $first_name,$middle_name,$last_name,$birthdate,$age, $monthly_salary,$tax, $email, $encrypted_password, $salt);
$result = $stmt->execute();
$stmt->close();
// check for successful store
if ($result) {
$stmt = $this->conn->prepare("SELECT * FROM users WHERE email=?");
$stmt->bind_param("s", $email);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();
return $user;
} else {
return false;
}
}
I searched for answers and altered the get_result to native method but no luck I dont know what to do anymore and I am using webhost x10webhosting but when I try my PHP files on localhost it works just fine
php mysqli cpanel
This is my php block that has the get_result()
public function storeUser($first_name,$middle_name,$last_name,$birthdate,$age,$monthly_salary,$tax,$email,$password) {
$uuid = uniqid('', true);
$hash = $this->hashSSHA($password);
$encrypted_password = $hash["encrypted"]; // encrypted password
$salt = $hash["salt"]; // salt
$stmt = $this->conn->prepare("INSERT INTO users(unique_id, first_name, middle_name, last_name, birthdate,age, monthly_salary,tax, email, encrypted_password, salt, created_at) VALUES(?, ?, ?, ?, ?,?,?,?,?,?,?,NOW())");
$stmt->bind_param("sssssssssss", $uuid, $first_name,$middle_name,$last_name,$birthdate,$age, $monthly_salary,$tax, $email, $encrypted_password, $salt);
$result = $stmt->execute();
$stmt->close();
// check for successful store
if ($result) {
$stmt = $this->conn->prepare("SELECT * FROM users WHERE email=?");
$stmt->bind_param("s", $email);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();
return $user;
} else {
return false;
}
}
I searched for answers and altered the get_result to native method but no luck I dont know what to do anymore and I am using webhost x10webhosting but when I try my PHP files on localhost it works just fine
php mysqli cpanel
php mysqli cpanel
edited Nov 19 at 7:55
asked Nov 19 at 6:39
Vennefor
76
76
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59
add a comment |
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53369503%2fx10webhosting-call-to-undefined-method-mysqli-stmtget-result%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I found this: stackoverflow.com/questions/8321096/…
– Justin Schwimmer
Nov 19 at 6:44
Possible duplicate of Call to undefined method mysqli_stmt::get_result
– paulsm4
Nov 19 at 6:47
“but when I try my PHP files on localhost it works just fine” - so what? Different systems can be configured differently, or have different supplemental software/libraries installed or enabled … “and altered the get_result to native method but no luck” - then show us what you tried, and with what result.
– misorude
Nov 19 at 8:59