douchen2595 2015-08-24 16:45
浏览 25

当自动增量打开时,mysql插入2行一个调用

I post an INSERT sql statement from my App (Xcode - swift) to the database (MySql) on web server.

When I use it with table have auto increment feature it insert 2 rows with same data fields, but when i use it with another table (not have auto increment) it works fine!

also, i tried to post the connection string direct to the browser to see if there is any problem in my PHP file but t works fine!

The problem just happened when i use my PHP file via Xcode

any idea to fix this?

The code:

var urlString: NSString = "\(host)/(my PHP file name).php?stm=\(finalStatment)&user=\(user)&pass=\(password)&dbname=\(dbName)&mode=\(mode)"

var url = NSURL(string: urlString.stringByAddingPercentEscapesUsingEncoding(NSUTF8StringEncoding)!)

var urlRequest: NSMutableURLRequest = NSMutableURLRequest()
urlRequest.URL = NSURL(string: urlString.stringByAddingPercentEscapesUsingEncoding(NSUTF8StringEncoding)!)
urlRequest.HTTPMethod = "POST"

var con:NSURLConnection = NSURLConnection(request: urlRequest, delegate:self)!
var urlData = NSData(contentsOfURL: url!)
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 HLs设计手写数字识别程序编译通不过
    • ¥15 Stata外部命令安装问题求帮助!
    • ¥15 从键盘随机输入A-H中的一串字符串,用七段数码管方法进行绘制。提交代码及运行截图。
    • ¥15 TYPCE母转母,插入认方向
    • ¥15 如何用python向钉钉机器人发送可以放大的图片?
    • ¥15 matlab(相关搜索:紧聚焦)
    • ¥15 基于51单片机的厨房煤气泄露检测报警系统设计
    • ¥15 路易威登官网 里边的参数逆向
    • ¥15 Arduino无法同时连接多个hx711模块,如何解决?
    • ¥50 需求一个up主付费课程