Can I enter data into the MySQL database using the Swift 2

Question

I have 3 textfield in my application which are the following:

e-mail
username
password

I want to enter this data into the MySQL database using Xcode swift

no i want to insert textfield data into mysql localhost server — teko
– teko, Commented May 4, 2016 at 11:25
@teko i have answered if you find it useful don't forget to upvote and acccept — O-mkar
– O-mkar, Commented May 4, 2016 at 12:18

O-mkar · Accepted Answer · 2016-05-04 11:08:37Z

2

Do you want to connect MySql Server externally or your local my SQL database

Here is the way using this library https://github.com/novi/mysql-swift

How to make connection

 let options = Options(host: "db.example.tokyo"...)
    let pool = ConnectionPool(options: options)

    let conn = try pool.getConnection() 
    conn.query("SELECT 1 + 2;")
    conn.release()

How to get data from database

 let rows: [User] = try pool.execute { conn in
        // The connection is held in this block
        try conn.query("SELECT * FROM users;") // And also it returns result to outside execute block
    }

For more refer the library documentation here

Documentation

answered May 4, 2016 at 11:08

O-mkar

5,6768 gold badges42 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I enter data into the MySQL database using the Swift 2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related