Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Web Database

  • 28-08-2008 1:20pm
    #1
    Truck
    Registered Users, Registered Users 2 Posts: 211 ✭✭


    Hi All,

    Im just about to start a web design project, the main part of it will be the Database. The database will mainly store videos and presentations. Im nearly certain I will use MySQL for the database design. Im relatively new to MySQL, i know how to create tables and fields, using 'PhpMyAdmin'. How do I import/store the videos in the MySQL Database ?

    Any help/ideas would be great..

    Thanks..


Comments

  • #2
    Adam
    Closed Accounts Posts: 8,866 ✭✭✭Adam


    Truck wrote: »
    Hi All,

    Im just about to start a web design project, the main part of it will be the Database. The database will mainly store videos and presentations. Im nearly certain I will use MySQL for the database design. Im relatively new to MySQL, i know how to create tables and fields, using 'PhpMyAdmin'. How do I import/store the videos in the MySQL Database ?

    Any help/ideas would be great..

    Thanks..
    well assuming the videos and presentations (what does this mean?) will be user submitted, phpmyadmin won't help you there.

    I would suggest you start here for a web based intro


  • #3
    Goodshape
    Registered Users, Registered Users 2 Posts: 8,488 ✭✭✭Goodshape


    Truck wrote: »
    How do I import/store the videos in the MySQL Database ?
    You wouldn't -- you'd 'store' a link to the video which resides on your server, or maybe even some other website. You don't physically store the video data inside the database.

    You'd probably want to use a scripting language like PHP to upload the video, insert the database link and information, and retrieve that information later on for output to the website.

    Just having a database is such a small part of the operation, really.


  • #4
    Truck
    Registered Users, Registered Users 2 Posts: 211 ✭✭Truck


    Ok great, That makes sense.

    How do I go about displaying the database? I assume i can use PHP and call certain parts of the database to display.

    Thanks,


  • #5
    Adam
    Closed Accounts Posts: 8,866 ✭✭✭Adam


    Truck wrote: »
    Ok great, That makes sense.

    How do I go about displaying the database? I assume i can use PHP and call certain parts of the database to display.

    Thanks,
    that's precisely what you do. in fact, that's precisely what phpmyadmin does, it's all mysql queries being called through php and then displayed.

    I recommend you look up some basic php + mysql forms examples, best to start learning how to put data into a database, things will then become a lot clearer.


  • #6
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    Truck wrote: »
    Ok great, That makes sense.

    How do I go about displaying the database? I assume i can use PHP and call certain parts of the database to display.

    Thanks,
    Read up on some basic SQL first and then start doing it with PHP. You can do it via phpMyAdmin to give you a taste of whats going on.


  • Advertisement
Advertisement