view/edit/delete mysql database entries via php page(s)
Posted: Tue Dec 16, 2014 6:08 pm
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
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