Mostly using HeidiSQL on Windows 10 and phpMyAdmin where necessary.
Adminer is super useful if nothing else is available for whatever reason.
I was fairly interested in this until I went and looked at the installation instructions, at which point my interest immediately dropped to zero. In 2015, LAMP (especially with that M being MySQL) is a really significant hurdle to get someone to set something up, unless they're already running a LAMP stack.
My expectation here was something like an NPM package that I could install to start up. I mean, what's the practical difference between this tool and phpMyAdmin?
Sorry if I sound critical, but this is my reaction.
> get my database like up to a server
You'll need a server, some skills in ssh and ftp/sftp and your scripts.
> maybe connect it to a website
Are you looking at wordpress or hand-rolling your own? You'll need some skills in php probably for both. If you just want to connect to a remote database and run queries then for MySQL there is phpadmin
Edit: there are other languages out there
Edit2: Just noticed that you want to use SQL Server
You can always just upload the PHPMYADMIN folder to the website's directory. and hit it like this www.example.com/phpmyadmin. You only need the database login for that.
Download from here, and rename the folder to phpmyadmin, upload to root dir and bob's your uncle.
That's not surprising, but this isn't a phpmyadmin support forum. MySQL has lots of different applications that connect to it; we don't support them all, we support mysql itself. Maybe check out https://www.phpmyadmin.net/support/ ?
I use a program called Tables Plus to directly work with databases. It's a premium tool but if you need to directly interact with DBs it is well worth it.
You can always start a local hosting environment and use something like https://www.phpmyadmin.net/ which is free.
You should be able to extract information and add it to a new DB. But beware, DBs are a very deep puddle that have very specific ways of doing things.
Here is a free resource to learn about SQL https://selectstarsql.com/
Ah... I don't use Workbench either. Most of my clients are hosted on Plesk servers which provides phpMyAdmin by default. My usage of that is primarily a GUI around mysqldump/mysqlimport. Anything else I need I do from the CLI or my code.
If you did build a MySQL "IDE" I would certainly be interested, especially if it could be somewhat DB agnostic, like dbeaver but not written in #$%&&$#$€ Java.
So, you don't have a workspace on your local machine? You're gonna have a hard time finishing this^
If I were you, I'd quickly install XAMP. I do believe that it works pretty much out the box and then you will have a working developer environment on your local computer. This will not only save you the time of uploading to your sever every second (you should test as you work - Not write a whole bunch of code that is not tested, and then upload it), but it will also give you error reporting, making it much easier to evaluate where the mistakes might be.
XAMP also comes with a database you can play with (local). I do believe that you probably are gonna need to install something like phpMyAdmin to get a GUI over the database though.
What you do, is to place all the project files in XAMP www directory (I believe it's located C:/XAMP/htdoc
) and you visit localhost
through your browser.
This might seem a lot, but it's really not worth the trouble not to do it. The whole process is fairly simple and should not take much more than 5min of your time to get up and running.
> I need to change header and footer
If you just need to change the text content of the header/footer, you probably can start by searching for all the source files for some content in the header/footer. For example you should be able to find the string "CoinCompare is a PHP MVC web application" in some of the source files and change it.
If you don't find the text on any of the files, the content probably lies inside the database. There could be a place in your admin panel to change it, or you could use some database tool like phpMyAdmin to change it directly from the database.
> Is there any way to implement this app only in wordpress and play with plugins
I'd guess that there is not a Wordpress plugin that could replicate your site's functionality with Wordpress. If you would want to convert the site on top of Wordpress, you'd need to learn some PHP, JavaScript, CSS and HTML to do so. One possibility of course would be to hire a web developer to do this for you.
phpMyAdmin doesn't seem to be compatible with php8.
see also: https://www.phpmyadmin.net/downloads/
"phpMyAdmin 5.1.0 Released 2021-02-24, see release notes for details.
Current version compatible with PHP 7.1 and newer and MySQL/MariaDB 5.5 and newer."
Locally I use docker/ddev for my dev environments.
same type of issues......but I was only using it for running some ad-hoc reports from the Database
I didn't bother to look for a fix or anything, but maybe an updated version is needed. Sorry, that's all I got.
If your file starts with CREATE TABLE you could create a MySQL database, import the file and then do the SELECT query like davvblack suggested. There is a free phpMyAdmin demo here https://www.phpmyadmin.net/try/
By the way, I found something. phpMyAdmin has an Import XML File feature. I have a feeling that this only works for table data, not creating tables, but you can do some googling and see how it works. Might be what you're looking for.
>it's better to create tables directly via mysql and not from PHP
I agree with that, or rather, you should not create/change your schema via your application code (unless you really need to, eg, when building someting like phpMyAdmin).
Migrations can help with maintaining/documenting/sharing/applying schemas in production code. They are probably out of scope for a (simple) assignment though.
Not quite sure if this is what your after but you should check out phpmyadmin [ https://www.phpmyadmin.net/ ] Basic its a nice wrapper that handles all of that, you need to setup an account and add usernames and passwords.
You can get some of the really old releases here https://www.phpmyadmin.net/files/
I had a quick look into v1.1.0 from 1998, and it's not only not OOP, but even for PHP3 standards pretty terrible code. But given that OOP capabilities of PHP3 were quite limited, I'm not sure you'll find that many OOP examples from back then. OOP got more prevalent with PHP 4 and much more so 5.
Nevermind.
I fixed it. I installed PHP manually without PackageMangager. (https://www.phpmyadmin.net/downloads/ )
This is way easier to setup.
If somebody needs help you can contact me!
Would PHPMyAdmin work for you? https://commons.wikimedia.org/wiki/Category:PhpMyAdmin
Otherwise, creating a dashboard from scratch would require very little programming if using an ORM/framework
Check out phpMyAdmin -- https://www.phpmyadmin.net/
Of course the demo for MySQL seems to be broken at the moment. The GUI for MariaDB seems to be working. You can get an idea of the interface without going through the installation.
The PHPMyAdmin site agrees that the main version only supports up to PHP 7.2. It might still work on 7.3, you just won't be able to get support from PMA if you run into problems.
You could try the dev version (from https://www.phpmyadmin.net/downloads/, version "5.0+snapshot").
As an alternative, you could try Adminer instead. It's much lighter-weight than PMA (Adminer is a single ~400 KB PHP file), so it could have fewer potential compatibility issues.
I second this. There had been instances where the file failed to upload and you'll ended up with an empty CSS.
You can probably set up one locally with XAMPP and phpMyAdmin.
Here's a tutorial.
Also, https://www.phpmyadmin.net/ and https://www.microsoft.com/web/platform/database.aspx. It is amazing what you can do with free databases these days. If you want an easy way to play around with them, Amazon Web Services has a free tier for budding devs to tinker with.
I haven't used it in a few years but phpmyadmin is good enough for hacking around on the database and doing some queries and maintenance. You can even create a new user with read-only access for phpmyadmin and setup some reporting queries directly in it.
It still seems strange to me that your db is so large. Are you sure you're only loading the site's db and not something else? If that is the case, and you do want to try flushing the table in the db, here's what you can do.
Read up on PHPmyadmin: https://www.phpmyadmin.net/docs/ And MySql: https://dev.mysql.com/doc/
If you just want to try it, here's the steps to flushing a table: Remember to make a backup of your database before you flush any tables. Then go into PHPmyAdmin and navigate to the wp-posts table. Double check to make sure you backed up, or have a full backup somewhere to revert back to if you mess this part up. (I said that twice on purpose). Then you can flush the table, don't delete it. Do this by click on the Operations tab at the top of your PHPmyadmin window. Make sure you're in the wp-posts table, then you can Empty the table. Keep in mind This will delete all of the posts.