Re: Is there an editor that allows changes to data in MySQL?
Posted: 08. June 2014 01:33
Nobbie wrote:OrcaSoul wrote:The ideal form would allow me to enter the product name, and it would use that to pull just the record for that product, and allow me to enter text in any field, then save it into the database, replacing the existing record.
I still dont understand, what you are messing aroung - of course phpmyadmin provides this functionality as well. Instead of browsing thru all your records, click the "Search" button in the top menu, you will receive a form, which shows ALL fields of your choosen table, you may specify any values, any special functionts, whatever you want for each field and finally hit "Submit" and phpmyadmin will show you all records, which matches your criterias. YOu may then even use grid edit / inline edit or hit "edit" to enter data in an appropriate form.
You dont have to write your own code, phpmyadmin is a very sophisticated tool and you really can do everything with this tool, what you are looking for. It is the "swiss army knife" of MySQL.
Nobbie wrote:OrcaSoul wrote:The result is, searching for the name isn't the fastest way to go - and yes, I can sort the list, but it's still a nuisance when dealing with many bowls.
Because you are searching "manually" (this is indeed a bad idea). Why dont you simply search with MySQL (Select.... Where bowlname = "...." or similar)? MySQL provides not only Metacharacters for Search, it also supports regular expressions.
You may also define an index for the column which holds the names, which makes the search very fast. For columns of type TEXT you may also define a "FULLTEXT" Index, which is a special MySQL Feature.
OK, let me put it this way - at my age, 71, and with my eyesight not the best due to being very nearsighted - I find a cluttered screen like phpMyAdmin hard to read, mostly because of the small font and the confusion of so many things to look at - which can be distracting.
But it is mostly just a matter of my choice. Since I am the only one who will use this, that is my prerogative. You can disagree with how I do this, but don't argue that I am doing it wrong...
Thing is, I prefer a single subject form to do this kind of work - I always have.
I start the script, and enter the name of the bowl:
- Edit a bowl record
Enter Name of bowl to edit
BubingaCopper06-001
Submit
This takes me to the form:
- Edit bowl in database
Bowl Code:BubingaCopper06-001
Species Seq:Bubinga06-001
Source Wood:Bubinga05:031
Notes:Bubinga05:031
Product ID Code:Really nice bowl!
Heading:9-1/2” Bubinga BowlEdged with Copper Patina accent
Details:Bubinga is a richly dark hardwood of high figure that comes from Africa. Favored for valued furniture - the wood adds a touch of elegance to table tops - bookcases – and turned objects. The patina effect on copper leaf is a technique learned from David Marks - a Master of the craft.
Image File:BowlPhotos/Thumbs/BubingaCopper06-001tmb.jpg
Bowl Status:In stock
VenderID:1
Price Asked:$125
Sold for:$
Proceeds:$
Current Venue:A/NT Gallery
Submit
Say I sold the bowl, I want to add the sales price $125 and how much I made $82.66, and remove A/NT Gallery as the Current Venue, plus change the Bowl Status field to Sold!.
Then I hit Submit and the update is entered.
For my way of working, this is the best methodology...for anyone else, they can decide themselves.