php question
- Started
- Last post
- 40 Responses
- mikotondria30
I'd be sure the last devs would have put together an update system, noone in their right mind is going to design a shop db whereby the only way to maintain it is through phpmyadmin...
- ephix0
hit browse, then you can hit the edit button
- Claymantis0
I see and I can just add items to this list as well?
- no, don't add tables until you've done some more homework.mikotondria3
- you can with "insert" but you're gonna need to know exactly what to fill in for some of them, and leave ID aloneephix
- catid is the important oneephix
- mikotondria30
Yeh, browse, then insert will give you a nice form to input new items, etc..
be sure to note what fields are filled with what on an existing item so interacting with the retrieval scripts is as you'd expect it.
Also check any of the other tables to see if products are referenced there also. It seems fairly simple set up though.
Phpmyadmin rocks, get to love it :)
- Claymantis0
Okay I see. I see that there is an ID number but the numbers are up and down? How do I know what ID to give it? and I dont see any place to update an image. Is that done in the HTML?
- Claymantis0
ahhhh ok. Basically I have to add a pizza section to this site. So it will have a whole new cat number.
- welded0
You can open up a second window and try to find a product in the same category you want to add to and use that records data as a general guide.
- Claymantis0
if I add a new category to his database with all the proper info... it should just update everything, without touching the html?
There is also a side scrolling menu on the left, will that be updated as well, or will I have to manually update that?
- ephix0
the other thing to consider is where the page is pulling the category and product picture from.
- welded0
In a perfect world, yes, if those elements are dynamically generated and not hard coded.
- how would I tell the difference?
I dont see anywhere in the phpmyadmin to update the side scrolling images...Claymantis
- how would I tell the difference?
- ********0
The MySQL database is only a small % of the whole picture... the PHP/etc script in the actual hosted filespace is what is doing all the work. You need to properly cross reference what's happening in PHP script before you start making changes/additions. Just adding something to the database technically wont do anything unless the php knows to either look for it or is told that it's there...
- ********0
That being said or not, the best place to start is not the DB but the actual script that the site is made up from. See what they're doing for the other categories that way... technically with the way you're presenting the URL it could very well be a wordpress site, in which case you don't have to fuck around in PHP MyAdmin at all...
- i know it's not wordpress, im just saying - you'll get a better idea by looking at the core files, not the DB..********
- i know it's not wordpress, im just saying - you'll get a better idea by looking at the core files, not the DB..
- ********0
Bam, my point exactly.. there's a CMS backend already built for you, you shouldnt be fucking around in PHPMyAdmin...
- Claymantis0
Ahhhhhhh.... thanks so much.
So I should be able to update everything with this CMS ?
- welded0
Good catch – don't touch a thing until you get that admin login. Why the client sent you to the control panel instead is beyond me...
- you know how clients are :PClaymantis
- Heh, yes, I do, but some poor developer build that CMS just so they would be able to update the site themselves...welded
- hiimerik0
Good god man, if you need help updating your site, hire someone to do it if you don't know how.
- ********0
'learning' like this is dangerous on a live site. haha I'm going to keep that site open & refresh just to see what happens. ;) let me know if you need a hand - im $75 an hour. ;)
- ETM0
I am predicting:
Insert Error: Column name or number of supplied values does not match table definition.
