Connect To A Database Using MySQLi and OOP PHP | Object Oriented PHP Tutorial | PHP Tutorial

How do i output only one column? not in the function code but in HTML.
Fore example:
I want one html field to output name, second to output id.
i get all the rows in one field if i use the above method.

Would using fetch_assocAll() have worked in place of the loop getAllUsers()?

The first video that I've watched that actually helped me understand oop ;) thank you so much

thanks that's so helpful

In which folder is the database stored? Is it in the same folder where you store your php files, or do you create a subfolder like when you do to put CSS, JS or images for example, or is it somewhere else?

You don't close the connection? How it works if you want to manage transactions?

Please use naming conventions. don't use getAllUsers, use getUsers, that way you can add an optional "limit" parameter so you don't overwhelm your database retriving 9 million users at once, name your users variable "users" because it contains User instances (not really because you didn't use class mapping, but it should), that way you know what the variable contains. If you name it "datas", fuck knows what's in that variable, plus you could have another variable with the same generic ass name later in your code.

clear and concise!

I have to say, your videos helped me tremendously. Please do a video on how you can fetch stored data according to user ID using OOP. greatly appreciate it

I have to say, your videos helped me tremendously. Please do a video on how you can fetch stored data according to user ID using OOP. greatly appreciate it

hey does this vedio belong to any playlist or its just a random vedio?

so the "." keyword stands for "+" because I am confused I always use java.

Thanks for this info bro, now I can connect and fetch my data from my database using OOP, because all I know is procedural programming.

Sir I am creating a register and login system using php object oriented approach however I've already created it in procedural style. What I am confusing at is is it necessary to use $conn = new mysqli() inside a connect() function ? can't we use it write is outside that connect function by creating constants instead of variables and then extend the Dbh class and use the $conn directly with prepared statement ?

Thanks Dani, you helped me finally connect to my database via PHP and retreive some data. :) Here's a like. It's the least I can do.

Really useful now i find programming interesting thanks :)

Why don't you use a constructor within the dhb class?

Hi,
Your lessons are really helpful. Thank you for your work!
Maybe anybody can clarify a little thing to me. I have done everything the same as in video, but when I try to check result - each element from DB returns 2 times. Where can be a mistake?
Thank you in advance.

thanks

Can we display mysqli error in inherit class insert?
lf yes how

Could "viewUser" be a method within "User" class instead of object "viewUser" that extends "User" class?

What determines the choice of which type of connection to use between Mysqli and PDO ?

Hello, man. I'm from Brazil and I love your videos. You're so good. Congrats, teacher.

Please can you fix this error
Parse error: syntax error, unexpected '->' (T_OBJECT_OPERATOR), expecting ')'
which raises on
$conn = new mysqli($this->servername, this->username, $this->password, $this->dbname);

Can you check if the database did connected with this code ??
if ($this->conn->connect_error) {
die("Connection error" .$this->conn->connect_error);
}
echo "Connected Succesfully";

return $this->conn; ???

playlist link please...!!

Hey can you please help I am get an error call to a member function fetch() in the while loop

You are an amazing teacher... love the way you make it so simple to understand

dsfsd

The sound of your voice always makes me very happy. I love your videos!

Why so many classes?

I have problem that with the code in the video tutorial, my results do display but each line is displayed twice. So I have 4 results, while my database only has 2 in it.

Hello 👋 I'm used to using PDO on database handling, I just wanted to know what is better to use, mysqli or PDO? Thx.

Thank you very much. Your videos are very, very helpful. Along with your great tutorials, I'm trying to fulfill my dream of becoming a programmer.

could you add error message on your connection ?

what is "user" here → $sql = "SELECT * FROM user";

Hello, great tutorial!
I have a question: how can I access to single fields? something like this:

foreach($datas as $data) {
$username = $data["username "];
$password= $data["password"];
}

I'd like echo only Username o Password here: $leads->showAllLeads();

thanks!

very nice and clean, although lack the controller part but its much easier to understand simplified code like this. Thank you, keep up the good work!

How $data[ ] = $row works?

the server CPU and memory overhead of PDO is much more then MySQLi ... and if you are not worried about migrating to a different database server down the road... MySQLi is much better. This is not what most people say... but it is a fact.

hey mmtuts. I'm confused. Why did you create another class called ViewUser.inc.php if you can put the function that you've create to the class of user? is it because of MVC?

My code didn't work when I included all the files "dbh.inc.php" "user.inc.php" and "viewuser.inc.php" in the same order as shown in the tutorial in my "index" file. However when I included "view" file in my "index" file and "user" file in "viewuser" file and "dbh" file in "user" file my code worked accurately. I also tried different arrangement of files in my "index" file but none of them worked. Solution required "How to include all the files in the Index file so that I can get the desired result." thanks

Why these older lessons aren't in oop php playlist?

Amazing video 💯👍🙏

why database name and table name is static

thanks for ur knowledge

Hi, do you have a tutorial for PHP OOP CRUD? thank you. I liked your videos

Plz make a video login system in oops

Thank you sir.. this helps me a lot as a student.