Page 1 of 1

view/edit/delete mysql database entries via php page(s)

Posted: Tue Dec 16, 2014 6:08 pm
by billythekid
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

Re: view/edit/delete mysql database entries via php page(s)

Posted: Tue Dec 16, 2014 7:08 pm
by Celauran
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
You just described phpMyAdmin.

Re: view/edit/delete mysql database entries via php page(s)

Posted: Wed Dec 17, 2014 2:07 am
by billythekid
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

Re: view/edit/delete mysql database entries via php page(s)

Posted: Wed Dec 17, 2014 1:03 pm
by Christopher
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
That sounds like an admin form.
billythekid wrote:i guess i sort of answered my own question though. just seemed a bit complicated for a new guy
The way you graduate from being the new guy is to build a few admin forms! :drunk: