Bulk Editor for mySQL Database Rows ... Host on Site ??

Discussion in 'MySQL' started by SellLinks, Apr 27, 2007.

  1. #1
    Hi Everyone!!

    I have a mySQL database on my shared hosting server with DreamHost.

    I am looking for a script of some kind that will allow me to easily edit multiple rows at once.

    I see two ways for this to happen, and would like a solution that is already coded if you can recommend one that is good, otherwise I will just have to do it myself ( I am using PHP for my site)

    1. Ajax editing tool that basically displays all rows as a table (with the columns that I am interested in making available for edit) and allows me to just edit the columns I want by selecting an "edit" link that turns the row into editable text fields and then I just click a "save" link at the right of that row.

    2. Boring form version that just shows all rows with textfields for each column that I want to edit, and then I click a "Save" button at the end that runs through a script to update each row at a time.


    In reality, I am looking for a package that is like the standard "mysql query browser" but one that I can access from home, as Dreamhost doesnt allow me to create a connection with the database remotely (must be done from the hosted server)


    Thanks for any advice you can give.
     
    SellLinks, Apr 27, 2007 IP
  2. abdussamad

    abdussamad Active Member

    Messages:
    543
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Dh has phpmyadmin. So why not use that? You can access it at mysql.yourdomain.tld
     
    abdussamad, Apr 29, 2007 IP