XAMPP and PHP Databases

Alles, was PHP betrifft, kann hier besprochen werden.

XAMPP and PHP Databases

Postby hobbyist2 » 23. May 2018 19:49

Noob here with XAMPP. Someone stole my username so sorry about the lame username hobbyist2.

I have one simple question. It may not have a simple answer.

How do you create a PHP database and test it? I am going over tutorials but when I create a test database when the video is showing myadminphp the test database shows up in the video. However, when I log into XAMPP database control panel the database created using the tutorial does not show up in my list of databases. They request myphpadmin and it shows up. However, I do not see it in the XAMPP control panel using XAMPP as the local host.

So my question is. How do you connect a test database using PHP (Notepad++) to the XAMPP control panel?
hobbyist2
 
Posts: 8
Joined: 23. May 2018 19:40
XAMPP version: 3.2.2
Operating System: Windows 10

Re: XAMPP and PHP Databases

Postby Altrea » 24. May 2018 14:15

There are multiple ways to do so.
Explain to us what steps you did as detailed as possible so maybe we can get a clue what went wrong.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP and PHP Databases

Postby hobbyist2 » 24. May 2018 14:33

Thanks for the prompt reply.

I am doing 3 things at once right now. So if you can answer this question first. I do not have phpadmin installed. So if I create a database following instructions from tutorials that do not use XAMPP (and use phpadmin) without myself having phpadmin installed will it show up when running XAMPP?

So the steps would be to create a database on notepad(++) put it in htdocs then start myapache and mysql on XAMPP. Should I see it in the list of databases in XAMPP?
hobbyist2
 
Posts: 8
Joined: 23. May 2018 19:40
XAMPP version: 3.2.2
Operating System: Windows 10

Re: XAMPP and PHP Databases

Postby Altrea » 25. May 2018 07:03

No. You cannot create a MySQL database in Notepad++.
You need to use the MySQL CLI, an MySQL Client or third party script like phpmyadmin to connect to a running Database Managementsystem to perform statements that will create the database.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP and PHP Databases

Postby hobbyist2 » 25. May 2018 19:15

Ok so I need phpmyadmin. Phpmyadmin is needed to test my website with XAMPP too?
hobbyist2
 
Posts: 8
Joined: 23. May 2018 19:40
XAMPP version: 3.2.2
Operating System: Windows 10

Re: XAMPP and PHP Databases

Postby Altrea » 25. May 2018 20:35

phpmyadmin is a third party script too. You don't need it explicitly, but a graphical user interface like phpmyadmin can make your life easier if you don't want to write and execute SQL statements in the command line.
XAMPP already included phpmyadmin.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP and PHP Databases

Postby hobbyist2 » 29. May 2018 16:14

"XAMPP already included phpmyadmin"

So within XAMPP I can create a database to send test information (signup and login accounts) ? But without mysql or phpadmin I will be unable to create a test database to execute sql statements (signup and login accounts)?
hobbyist2
 
Posts: 8
Joined: 23. May 2018 19:40
XAMPP version: 3.2.2
Operating System: Windows 10

Re: XAMPP and PHP Databases

Postby TonyVier » 29. May 2018 16:32

Go to the youtubes, and search for "create a database in mysql" . Have fun.
TonyVier
 
Posts: 43
Joined: 24. May 2018 11:22
XAMPP version: 7.2.5-0
Operating System: Windows 10 pro


Return to PHP

Who is online

Users browsing this forum: No registered users and 11 guests