php question
- Started
- Last post
- 40 Responses
- Claymantis
http://www.odoughs.com/products.…
Does "?catid=1" mean that it is calling out that information from a database?
thanks
- Claymantis0
and if I wanted to add a new product, it would have to be added to the database? correct?
- ephix0
yes
- welded0
'?catid=1' is what's call the query string and yes, it's passing data to the server and in this case I assume you're correct in that it correlates to a category and again my assumption is that you're correct and that any products and categories will be coming from a database somewhere.
- Claymantis0
thanks
- Claymantis0
you would access the database using a phpadmin right?
- Claymantis0
I have to update this site and I have never updated a database! I might be over my head!
- welded0
That's one way, yes.
- Claymantis0
I just started at this job and I don't even know where I would find access to the myphpadmin!
- ephix0
maybe you should have said "no"
- welded0
Is there no content management system – no admin area you log into to update the site? Normally you don't need to resort to manually editing database records but it'll depend on how the site was built. :/
- There might be a CMS. I'm waiting for a responds from the client.Claymantis
- Claymantis0
well if I can't do this, its not the end of the world... But I was hoping to learn...
- ephix0
after considering what welded said, contact the webhost if you don't have access to the control panel.
- okay thanksClaymantis
- they might be able to let you know where phpmyadmin, or myphpadmin is locatedephix
- welded0
Well if you have FTP access and don't see PHPmyAdmin anywhere then you can take a crack at installing it yourself. You'll need to know some info such as the main mySQL root user and password.
- Claymantis0
I see.. well I'm going to check out some old emails see if I can find anything that will help..
but thanks alot for the help..
- welded0
Good luck. Don't break anything. :p
- Claymantis0
I have found access to the control panel.. can i update the site from here?
- depends on the webhost, but they should have a link to manage the sql with phpmyadmin or somethingephix
- welded0
If you are meaning the web host's control panel, then probably not. You might find access to PHPmyAdmin somewhere in there though. It might behoove you to first find a way to backup the database – just in case...
- fugged0
If you can get SSH/telnet access and know the MySQL password, you can update the database. But, I'm guessing that's going to be more difficult than desired.
You could write a PHP script to update the database. But, you'd need to know the structure of the tables and their relationships. You could have PHP dump this info out, but again - probably more than you want to deal with.
I think without phpMyAdmin, you're gonna have a hard time doing it.
- Claymantis0
I have loged into the phpmyadmin.. but I'm not understanding how to update the database
- welded0
You may be a bit over your head, unfortunately. It'll be tough to talk you through it and futzing around with a clients' live site isn't really the best way to figure it out yourself. :/