Applying a SQL file to my website help!?

by 8 replies
10
I can create the database I just learned pretty simple..

Import the sql using php my admin

Buuut I cant put it together in my mind how to apply the script to my site..

Now this is a script I belive that has 1k quotes on it..

Any ideas??

note.. this is for a site that is new and has no files do I need to create an index file and apply it with a path or something or what?
#programming #applying #file #sql #website
  • Well you need to learn PHP or something and make queries to the DB to pull the data out and display it.

    Id start reading

    PHP Tutorial
    and then go through
    PHP MySQL Introduction
  • You have to connect to your database from within a web scripting language like PHP and perform sql queries to get results
  • If you can convert your quotes files to CSV, then you can import that from phpMyAdmin
  • Importing the data
    After logging in, navigate to the phpMyAdmin import screen by doing this:

    Look in the left-hand column and click on the name of the table into which you want to import the data.
    Click the Import tab that appears at the top of the page.
    Change the "Format of imported file" to CSV. (Do not choose "CSV using LOAD DATA"; it will not work.)
    You'll then see a screen that allows you to choose the import options:

    Next to "Location of the text file", choose the file from your hard disk that you want to import.
    Change the Fields terminated by option to be a comma instead of the default semicolon.
    Leave the other options unchanged unless you know what you're doing.
    Press Go.


    From support.tigertech.net
  • [DELETED]
  • Banned
    [DELETED]
  • Banned
    [DELETED]
  • Banned
    [DELETED]
  • use a server-side language like PHP to connect to the Mysql DB

    then you can manipulate the data any way you want and also list them on your website
  • To be honest, you need to learn a whole lot to achieve what you want.
    Just "connecting" won't do it.
    Depending on what and how you want to display your data, you need to learn query call statements, php (or some other server side script) to retrieve and then display the code.

    Do you know html? That is the first basic step to displaying ANY page on the internet.
    You say there are no files...everything above is built from files (one or many).

    Good luck
    • [1] reply
    • I agree with tampaprogrammer. Searching google for "php mysql tutorial" will bring up plenty of results to guide you step by step along the path.

      Best of luck to you,
      Rob Francis
  • Another things is to use phpMyAdmin which has the major control of MySQL.

Next Topics on Trending Feed