首页 > 代码库 > mysqli面向过程练手

mysqli面向过程练手

 1 代码: 2 //1.得到mysqli连接 3        header("Content-type: text/html;charset=utf-8"); 4        $mysqli=mysqli_connect("localhost","root","root","test"); 5        if(!$mysqli){ 6               die("连接失败".mysqli_connnect_error($mysqli)); 7        } 8        //2.向数据库发送sql语句(ddl,dml dql ...) 9        $sql="select * from user1";10        $res=mysqli_query($mysqli,$sql);11        //var_dump($res);12        //3.处理得到的结果13        //循环取出$res中的数据mysqli_fetch_row mysql_fetch_row14        while($row=mysqli_fetch_row($res)){15               16               foreach($row as $key=>$val){17                      echo "--$val";18               }19               echo "<br/>";20        }21        //4.关闭资源22        mysqli_free_result($res);23        mysqli_close($mysqli);

 

mysqli面向过程练手