10 {{ upvoteCount | shortNum }}
10 {{ upvoteCount | shortNum }}

Applying a SQL file to my website help!?

by nikeman070
8 replies
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?
#applying #file #sql #website
  • Profile picture of the author aaron_nimocks
    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
    Signature

    My free PSD logs can be downloaded at PSD Bum. Enjoy!

    {{ DiscussionBoard.errors[3554833].message }}
  • Profile picture of the author voitenkos
    You have to connect to your database from within a web scripting language like PHP and perform sql queries to get results
    {{ DiscussionBoard.errors[3556141].message }}
  • Profile picture of the author phpdev
    If you can convert your quotes files to CSV, then you can import that from phpMyAdmin
    Signature
    Ali Usman
    PHP, MySql, WordPress, API Programming, E-Commerce Site, Payment Integration, Twilio, SMS Marketing, Custom Development, Wordpress, Joomla, Interspire, BigCommerce, Volusion, 3dCart and many more...
    sales@bluecomp.net
    {{ DiscussionBoard.errors[3567981].message }}
  • Profile picture of the author forum386
    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
    {{ DiscussionBoard.errors[3576947].message }}
  • Profile picture of the author rockerzz
    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
    {{ DiscussionBoard.errors[5182713].message }}
  • Profile picture of the author tampaprogrammer
    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
    {{ DiscussionBoard.errors[5183765].message }}
    • Profile picture of the author robfrancis
      Originally Posted by tampaprogrammer View Post

      To be honest, you need to learn a whole lot to achieve what you want.
      Just "connecting" won't do it.
      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
      {{ DiscussionBoard.errors[5196367].message }}
  • Profile picture of the author casius
    Another things is to use phpMyAdmin which has the major control of MySQL.
    Signature
    Cloud VPS || Shared Hosting
    Web Hosting Solutions for Geeks!
    HOST1PLUS
    {{ DiscussionBoard.errors[5203899].message }}

Trending Topics