Looking for some help on this topic, or maybe someone to write the code for me and i can pay with bitcoin if anyone is interested.
I have about 5-6 databases, each one has 6-8 tables in it and each table has anywhere from 3-35 columns in it.
I would like to have a page where I can log in as an admin, and have a form where I can just easily select which database(s)
and which table(s) I want to view/edit/delete from, and I also want to be able to search the database(s) for rows pertaining to
certain criteria.
I.E.
customer submits 2 orders with order number 2578. spells john smith wrong on the first one.
I want to log in to a form where I can say...
"Show me all rows for order number 2578";
"Where order number= 2578 and name= john simth, DELETE"
Obviously thats not the correct query but you know what I generally mean, and I don't want to have to actually type out any queries, in the above example I feel that the only thing I should have to type out is his order number. The rest should be all done by clicking radio buttons or drop down menus
view/edit/delete mysql database entries via php page(s)
Moderator: General Moderators
-
billythekid
- Forum Newbie
- Posts: 8
- Joined: Tue Dec 09, 2014 11:12 pm
Re: view/edit/delete mysql database entries via php page(s)
You just described phpMyAdmin.billythekid wrote:I would like to have a page where I can log in as an admin, and have a form where I can just easily select which database(s)
and which table(s) I want to view/edit/delete from, and I also want to be able to search the database(s) for rows pertaining to
certain criteria.
I.E.
customer submits 2 orders with order number 2578. spells john smith wrong on the first one.
I want to log in to a form where I can say...
"Show me all rows for order number 2578";
"Where order number= 2578 and name= john simth, DELETE"
Obviously thats not the correct query but you know what I generally mean, and I don't want to have to actually type out any queries, in the above example I feel that the only thing I should have to type out is his order number. The rest should be all done by clicking radio buttons or drop down menus
-
billythekid
- Forum Newbie
- Posts: 8
- Joined: Tue Dec 09, 2014 11:12 pm
Re: view/edit/delete mysql database entries via php page(s)
yes i was just looking to set up something easier that even a monkey could understand, phpmyadmin just seems a little more complicated than just filling out a form
basically, the php page that processes the form could have every single query written out before hand, and a bunch of IF statements so that IF you select 7 different databases/tables from the radio options and want to edit them all at the same time, you dont need to type out 7 queries each time you want to run them
i guess i sort of answered my own question though. just seemed a bit complicated for a new guy
basically, the php page that processes the form could have every single query written out before hand, and a bunch of IF statements so that IF you select 7 different databases/tables from the radio options and want to edit them all at the same time, you dont need to type out 7 queries each time you want to run them
i guess i sort of answered my own question though. just seemed a bit complicated for a new guy
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: view/edit/delete mysql database entries via php page(s)
That sounds like an admin form.billythekid wrote:basically, the php page that processes the form could have every single query written out before hand, and a bunch of IF statements so that IF you select 7 different databases/tables from the radio options and want to edit them all at the same time, you dont need to type out 7 queries each time you want to run them
The way you graduate from being the new guy is to build a few admin forms!billythekid wrote:i guess i sort of answered my own question though. just seemed a bit complicated for a new guy
(#10850)