mysqli类的简单归纳总结

$link = mysqli_connect($host,$name,$password,$dBase); //连接数据库,返回连接对象

                           mysqli_connect_error();//上述函数进行之后,如果成功,不返回,如果失败,返回错误信息

                           mysqli_connect_errno();//上述函数进行之后,如果成功,返回0,如果失败,返回错误号

                                                常用判断连接的正误(检查连接)：if(mysqli_connect_errno()){
                                                                                               printf("Connect failed: %s\n",  mysqli_connect_error()  );
                                                                                               exit();
                                                                                         }

mysqli_set_charset($link,'utf8')//连接之后设置字符集,$link, utf8/gbk……

mysqli_query($link,$sql)//发送执行sql语句,需要$link,$sql;

mysqli_free_result($result)//释放结果集

mysqli_close($link)//关闭上述数据库的连接

mysqli_select_db($link,$dbname)//选择mysql中的库

1，如果sql语句是DML语句,mysqli_query($link,$sql)返回布尔值，成功为真，失败为假---------可以利用mysqli_affected_rows($resoult)返回受影响行数。

2，如果sql语句是DQL语句,mysqli_query($link,$sql)返回结果集资源类型,------------mysqli_num_rows($result）获取结果集的记录条数(行的数目)

                                                                              ------------解析结果集资源类型-------------mysqli_fetch_array()返回索引和关联混合的数组

                                                                                                                                                   mysqli_fetch_assoc()返回关联数组

                                                                                                                                                   mysqli_fetch_row()返回索引数组

                                                                                                                                                   mysqli_fetch_object()返回一个对象-----------四个函数执行一次,指针后移一位-----------

                                                                                                                                                                                                                  ---------------------常用循环的方式取出-----------------

mysqli_insert_id($link)//插入的主键

mysqli_num_fileds($link)//结果集中字段的个数

mysql_fetch_fields($link)//取得具体字段的信息         mysql_fetch_field($link)//取得列的信息,作为字段返回

mysql_result($link)取得记录第n条信息