46 users online (0 members and 46 guests)  


  Results 1 to 7 of 7

Related

  1. How to Decode the data from Database using database handler?    Forum: Search Engine Optimization - SEO - Forum
    Replies: 1
  2. Replies: 0
  3. Scripts for editing by non-webmasters    Forum: Website Scripts Forum
    Replies: 1
  4. Editing window sizes    Forum: Website Scripts Forum
    Replies: 0
  5. editing videos    Forum: General Discussion
    Replies: 2
  1. #1
    PHPworker's Avatar
    New User

    Status
    Offline
    Join Date
    Mar 2007
    Posts
    3

    Question PHP editing database

    I have a new database driven site, I can add rows to my database from a PHP page I've created. It would be awesome to make a page allowing me to edit the rows, one at a time. Do you have or know of any PHP scripts that can edit databases

  2. #2
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: PHP editing database

    If you're using mySQL (the recommended database for PHP) then your starting point for DB funtions is here
    If not, use the link anyway and use the search box to find commands relevant to your database engine.
    Last edited by HTML; 03-09-2012 at 09:43 PM.

  3. #3
    PHPworker's Avatar
    New User

    Status
    Offline
    Join Date
    Mar 2007
    Posts
    3

    Arrow Re: PHP editing database

    I am using mySQL with PHP. I have looked / searched for weeks for an update function, or template script...I was wondering if anyone (maybe you) knows of one I can have?

    Thanks for the site, another one to search through, but I don't mind getting a direct link to an "update" script

  4. #4
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: PHP editing database

    I may have misread your intentions.
    UPDATE is a mySQL command to add a row to the database table, which in PHP you do with mysql_query().
    If you want to manage your database with a php front-end, try phpMyAdmin which does exactly that.
    Last edited by HTML; 03-09-2012 at 09:43 PM.

  5. #5
    PHPworker's Avatar
    New User

    Status
    Offline
    Join Date
    Mar 2007
    Posts
    3

    Lightbulb Re: PHP editing database

    Yes, PHPmyAdmin is good for that, but I would like to form my own PHP script for updating a database. I have a script that adds more rows, but I'd like to make a script that allows me to see the database, choose a row, edit it, then have the Database updated with the corrected row. Thanks for your time

  6. #6
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: PHP editing database

    You'd just read the data, populate textboxes in a form with it and display that, then update the db with data from any textbox that has changed when the form is submitted.

    Which is what phpMyAdmin does - well, a small part of what it does.

  7. #7
    vinyl-junkie's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    721

    Re: PHP editing database

    From what you say, I'm assuming you want this to be part of a web page and not something you do with phpMyAdmin, right? If so, would this work for you?
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more



Tags for this Thread