- sujoy98
- Posts : 19
Join date : 2020-07-25
Age : 25
Database error.
Tue Jul 28, 2020 9:49 pm
mysqli_num_rows() expects parameter 1 in line 11
dbh.inc.php
Database
- Code:
<?php include_once 'include/dbh.inc.php'?>
<!DOCTYPE html>
<html>
<head>
<title>php-Database-connection</title>
</head>
<body>
<?php
$sql="SELECT * FORM users;";
$results=mysqli_query($conn,$sql);
$resultscheck=mysqli_num_rows($results);
if($resultscheck > 0){
while ($row=mysqli_fetch_assoc($results)) {
echo $row['user_uid'];
}
}
?>
</body>
</html>
dbh.inc.php
- Code:
<?php
$dbServername="localhost";
$dbUsername="root";
$dbPassword="";
$dbName="loginsystem";
$conn=mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
?>
- Code:
$results=mysqli_query($conn,$sql);
Database
- Code:
CREATE TABLE users(
user_id int(11) AUTO_INCREMENT PRIMARY KEY not null,
user_first varchar(256) not null,
user_last varchar(256) not null,
user_email varchar(256) not null,
user_uid varchar(256) not null,
user_pwd varchar(256) not null
);
INSERT INTO users (user_first, user_last, user_email, user_uid, user_pwd)
VALUES('abc','def','user@gmail.com','Admin','test123');
INSERT INTO users (user_first, user_last, user_email, user_uid, user_pwd)
VALUES('ghi','jkl','user2@gmail.com','ghi123','test1234');
- sujoy98
- Posts : 19
Join date : 2020-07-25
Age : 25
Error fixed!
Tue Jul 28, 2020 10:19 pm
Spellng mistake
- ritendubhattacharyya
- Posts : 13
Join date : 2020-07-25
Re: Database error.
Tue Jul 28, 2020 10:21 pm
yup that should be FROM
- sujoy98
- Posts : 19
Join date : 2020-07-25
Age : 25
Re: Database error.
Tue Jul 28, 2020 10:26 pm
yup so foolish of me
ritendubhattacharyya likes this post
Permissions in this forum:
You cannot reply to topics in this forum