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 数据库

数据库相关操作 :

查看数据库系统中数据库:
show databases;

选择数据库:
use testDB;

创建数据库:
create database testDB;

删除数据库:
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` 表名
括号内:
表名 数据类型  属性   

• NOT NULL - 必须含有值,不能为空,null值是不允许的
• DEFAULT value - 设置默认值
• UNSIGNED - 使用无符号数值类型, 0 及 正数
• AUTO INCREMENT - 设置MySQL字段的值在新增记录的时候,自动增加1
• PRIMARY KEY - 设置数据表中每条记录的唯一标识,通常设置为ID数值,和AUTO_INCREMENT一起使用

插入语句

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

mysqli_muti_query( )插入多条数据

查询语句

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

php文件中sql语句最好在phpmyadmin或者类似工具箱操作没错了再写入