OCsqlite

封裝FMDB的插入

- (BOOL)dataBaseInsertWith:(id)obj{
   
    NSString *className = NSStringFromClass([obj class]);
    
    NSString *SQLStr = [NSString stringWithFormat:@"INSERT INTO '%@' ",className];
    
    NSMutableArray *proArr = [NSMutableArray array];
    
    unsigned count = 0;
    objc_property_t *propertys = class_copyPropertyList([obj class], &count);
    
    NSMutableArray *paraArr = [NSMutableArray array];

    NSMutableDictionary *paraDict = [NSMutableDictionary dictionary];
    
    for (NSInteger i = 0; i<count; i++) {
        
        const char *cPro = property_getName(propertys[i]);
        NSString *proName = [NSString stringWithCString:cPro encoding:NSUTF8StringEncoding];
        
        [proArr addObject:proName];
        [paraArr addObject:[NSString stringWithFormat:@":%@",proName]];
        
        paraDict[proName] = [obj valueForKey:proName];
    }
    
    NSString *proArrStr = [proArr componentsJoinedByString:@","];
    NSString *paraStr = [paraArr componentsJoinedByString:@","];
 
    NSString *afterStr = [NSString stringWithFormat:@"(%@) values (%@)",proArrStr,paraStr];
   
    SQLStr = [SQLStr stringByAppendingString:afterStr];
    
    return [_dataBase executeUpdate:SQLStr withParameterDictionary:paraDict];
}

PHP 數(shù)據(jù)庫(kù)

數(shù)據(jù)庫(kù)相關(guān)操作 :

查看數(shù)據(jù)庫(kù)系統(tǒng)中數(shù)據(jù)庫(kù):
show databases;

選擇數(shù)據(jù)庫(kù):
use testDB;

創(chuàng)建數(shù)據(jù)庫(kù):
create database testDB;

刪除數(shù)據(jù)庫(kù):
drop database testDB;

建表:
create table myTable (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email varchar(50),
reg_data TIMESTAMP
)
`myTable` 表名
括號(hào)內(nèi):
表名 數(shù)據(jù)類型  屬性   

• NOT NULL - 必須含有值,不能為空,null值是不允許的
• DEFAULT value - 設(shè)置默認(rèn)值
• UNSIGNED - 使用無(wú)符號(hào)數(shù)值類型, 0 及 正數(shù)
• AUTO INCREMENT - 設(shè)置MySQL字段的值在新增記錄的時(shí)候,自動(dòng)增加1
• PRIMARY KEY - 設(shè)置數(shù)據(jù)表中每條記錄的唯一標(biāo)識(shí),通常設(shè)置為ID數(shù)值,和AUTO_INCREMENT一起使用

插入語(yǔ)句

INSERT INTO table_name (col1,col2,col3...)
VALUES (value1,value2,value3...)

mysqli_muti_query( )插入多條數(shù)據(jù)

查詢語(yǔ)句

name -> 列名
tables -> 表命
SELECT name FROM table

php文件中sql語(yǔ)句最好在phpmyadmin或者類似工具箱操作沒(méi)錯(cuò)了再寫(xiě)入