SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: PHP and mysql

  1. #1
    I am the night... bman's Avatar
    Join Date
    Mar 2001
    Location
    In a van... down by the river.
    Posts
    366
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP and mysql

    i have been thinking about learning PHP and mysql... anyone know of any good books to help learn them??
    i read some articles on mysql.. and good grief, using command line to create a database? sounds brain intensive to me. but i think i can handle it. i am a pretty smart guy. (really i am, hey stop laughing, it wasnt a joke, i am smart, my mommy says so)..
    anyway.. if anyone can recomend any good resources, be my guest,

    Thanks, i love you all....
    Some say the world will end in fire, Some say in ice.
    From what I've tasted of desire
    I hold with those who favor fire.

  2. #2
    I am the night... bman's Avatar
    Join Date
    Mar 2001
    Location
    In a van... down by the river.
    Posts
    366
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok.. another part to this question. is there anyway to "import" data from an excel spread sheet into a mysql database.
    Some say the world will end in fire, Some say in ice.
    From what I've tasted of desire
    I hold with those who favor fire.

  3. #3
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check my signature for a link to helpful links

    Yes there is a good way to import data from your excel spreadsheet. First you will need to export the data as a CSV file (comma seperated values file). You can then use a LOAD DATA INFILE query to import the data into your MySQL table:
    http://www.mysql.com/doc/L/O/LOAD_DATA.html

  4. #4
    I am the night... bman's Avatar
    Join Date
    Mar 2001
    Location
    In a van... down by the river.
    Posts
    366
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks sid... i will have a look around and see what i can find..
    Some say the world will end in fire, Some say in ice.
    From what I've tasted of desire
    I hold with those who favor fire.


Bookmarks

Posting Permissions

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