Results 1 to 12 of 12

Thread: mysql & database help

  1. #1
    Homestarr Mod
    Join Date
    Jul 2003
    Posts
    3,863
    Thanks
    17
    Thanked
    31 times in 28 posts

    mysql & database help

    anyone know of a program that is user friendly GUI to easily write a simple mysql database with a cgi or php online search function?

    or indeed anyhelp in setting up a simple online searchable database (doesent have to be mysql) if it can be done just as easy in another language

    thanks

  2. #2
    Ah, Mrs. Peel! mike_w's Avatar
    Join Date
    Oct 2003
    Location
    Hertfordshire, England
    Posts
    3,326
    Thanks
    3
    Thanked
    9 times in 7 posts
    phpMyAdmin?

    http://www.phpmyadmin.net/

    Is this just for editing the database yourself, or for lots of people (e.g. a wiki)? What operating system?

    Mike.
    "Well, there was your Uncle Tiberius who died wrapped in cabbage leaves but we assumed that was a freak accident."

  3. #3
    Homestarr Mod
    Join Date
    Jul 2003
    Posts
    3,863
    Thanks
    17
    Thanked
    31 times in 28 posts
    basically we have a list of therapists and want a searchable database online so people can find the therapist they need via location or treatment

    supported FrontPage 98/2000/2002 Extensions
    PHP4 & PHP5 w/Zend Optimizer, Perl5, Sendmail
    CGI-BIN, SSI, .htaccess, Cronjobs
    Flash, Shockwave, Midi, Multimedia Support


    MySQL Database 5
    phpMyAdmin
    Daily Database Backups

  4. #4
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    you may find the mysqladmin or the old mysqlcc tools on the mysql website
    It is Inevitable.....


  5. #5
    Vive le pants! directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • MSI X99A Gaming 7
      • CPU:
      • Intel Core i7 5280k
      • Memory:
      • 32GiB ADATA DDR4
      • Storage:
      • Corsair Neutron XT 960GB
      • Graphics card(s):
      • MSI GTX 980 Gaming 4G Twin Frozr 5
      • PSU:
      • Corsair AX860i
      • Case:
      • NZXT H440
      • Operating System:
      • Ubuntu 17.10, Windows 10
      • Monitor(s):
      • Dell U2713HM
      • Internet:
      • FIOS
    can OOo2 Base connect to a MySQL DB?

  6. #6
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    I can't see a direct connection option in oo1.4 or oo2,
    however 2 does support the odbc unix drivers which would allow mysql connection
    It is Inevitable.....


  7. #7
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,048
    Thanks
    1,016
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable
    The MySQL Tools Website has a few things you might have use for.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  8. #8
    Homestarr Mod
    Join Date
    Jul 2003
    Posts
    3,863
    Thanks
    17
    Thanked
    31 times in 28 posts
    did i mention i am a mysql virgin

  9. #9
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,664
    Thanks
    53
    Thanked
    385 times in 314 posts
    Quote Originally Posted by 5cupa
    did i mention i am a virgin
    no , but thats hardly relevent

    I don't think there is nessesarily a wizard driven , or point and click way of doing this

    I assume it would be public facing and on the internet ?

    designing the database is possibly the easy bit , but you'll porbably need someon who is reaosably good to write the front end so that not only does it look good / be easy to use , but is secure as well.
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  10. #10
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts
    Indeed all the tools mentioned aren't really suitable for a public facing database.

    If the data isn't updated regularally, its possible that a CSV (comma seperated value) list could be used, there might be a simple alternative..... but you loose the benefits of a database.

    How many accesses do you reacon your going to have from clients just searching the database?

    How many times a day do you want to update the database?

    You might find its easyest just to hire some kid do whip something up, or outsorce the website. Or better yet, learn say PHP yourself (thou i wouldn't recomend it enless your stuck with it, the language has come under a lot of flack lately for been insecure by design and the 'new' version hasn't done many of the things people had hoped it would)!
    throw new ArgumentException (String, String, Exception)

  11. #11
    Gaarrrrr! Dav0s's Avatar
    Join Date
    Aug 2005
    Location
    Bristol
    Posts
    1,442
    Thanks
    1
    Thanked
    3 times in 3 posts
    hmmm...tbh i woyld write a PHP GUI to edit the database..but im sure that somebody ahs done the same thing but generic.

  12. #12
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    there is a VERY good tool called "Case Studio" - be warning its not free or cheap for a home user £100+ I think.

    I've used it before. Its very good. It allows database design with "gui tools" and linking to tables, triggers, stored procedures etc etc. It will also generate scripts that create the database you've just designed for your required platform. Mysql/MSQL/Informix/Oracle etc etc. Its not really an enterprise class tool, but SME its perfect.

    It also has the function to display your database design in a graphical display, with lines showing triggers and joins etc etc.

    It is really good and worth the money if your using it more than once.

    http://www.casestudio.com/enu/default.aspx


    http://www.casestudio.com/enu/prices.aspx
    Last edited by ikonia; 20-12-2005 at 11:15 AM.
    It is Inevitable.....


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using a switch statement and MySQL database
    By Kezzer in forum Software
    Replies: 2
    Last Post: 15-10-2004, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •