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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
billythekid
Forum Newbie
Posts: 8
Joined: Tue Dec 09, 2014 11:12 pm

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

Post 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
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

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

Post 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.
billythekid
Forum Newbie
Posts: 8
Joined: Tue Dec 09, 2014 11:12 pm

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

Post 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
User avatar
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)

Post 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:
(#10850)
Post Reply