SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Feb 2006
    Posts
    299
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help Me On How To Send Many Records Or Tuples In A Table Using Php And Mysql

    How can I send values below is a table concurrently using php and mysql. The record number
    can change. For example the batch can have 4 or 7 records, but how do I send them in a database at
    once or currently??
    BUt how can I go about sending these batch numbers and records in small table.
    Example
    Batch number record ID
    2 1
    2 2
    2 3
    2 4
    2 5
    How do I send these values in table at concurrently in the table.

    Your help will be highly appreciated.

  2. #2
    SitePoint Wizard cranial-bore's Avatar
    Join Date
    Jan 2002
    Location
    Australia
    Posts
    2,634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry that didn't make any sense to me at all.
    What do you mean by "send" the values. What do you want to do with them?

  3. #3
    SitePoint Evangelist
    Join Date
    May 2004
    Location
    New Jersey, USA
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have a look at "prepared statements" in whatever you're using to access MySQL. Frequently you won't need to create a batch, since you use the same DB connection.

    Also, consider MySQL's ability to LOAD FILEs.

    Finally, if by "batch" you mean "all together or not at all," the term you're searching for is TRANSACTION. MySQL offers transaction support: check the documentation.

    =Austin
    Austin Hastings - Principal Consultant - Longacre, Inc.

    Anything you can do, you can do better.


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
  •