Forum Moderators: open
i have a following problem, i have space on the server that i only have FTP access to. There is hosted simple web page with some html and php based photo album.
Now, i think that server also has mysql support, can i implement login system using mysql, using only FTP access?
Also if there is simple way to confirm if there really is mysql support?
I really only know how to code SQL and i have no clue about how it works in web based systems.
Thanks
If the page is a photo album there's a decent chance that it's using mySQL already to store info about the images etc.
You may be able to learn the mySQL connection string and database name just by examining the PHP pages that already exist and looking for things like $conn = mysql_connect($dbhost, $dbuser, $dbpass)
However, you probably won't be able to access the database on the server via FTP since most hosts keep the DBs on a separate server-- and if it was running on the same server as the webserver you'd probably want shell access, in which case you could just type "mysql" at a command prompt (or "mysql -v", "which mysql" etc.) to learn if mysql is installed.
Hope this helps.
The "blind" way -
If your client "knows" the mysql info, acquire the mysql host, login, pass, and mysql user info from them. Write up a small script to connect using those values and just do
show tables;
and output it. Seriously, I've been in these conditions and made them work.
The "right(-ish)" way: the domain will likely have an administrative control panel of some sort to set up and modify the databases, most likely using phpMyAdmin. Acquire the (trust and) access from the client, log in to the CP, and locate the above info.
