首页 > > 网络编程 > Php编程 >

PHP7.27: connect mysql 5.7 using new mysqli_c…

2018-07-18 01:25:33来源：博客园阅读 ()

<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">	
<meta charset="utf-8">
<title>my sql</title>
<meta name="keywords" content="geovindu">
<meta name="description" content="涂聚文"> 
</head>

<body>
<?php
// php 7.27 mysql 5.7 geovindu 涂聚文	
$mysql_conf = array(
    'host'    => '127.0.0.1:3306', 
    'db'      => 'sakila', 
    'db_user' => 'root', 
    'db_pwd'  => '888888', 
    );	
$link = mysqli_connect($mysql_conf['host'],$mysql_conf['db_user'], $mysql_conf['db_pwd'],$mysql_conf['db']);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "select * from city ORDER BY city_id LIMIT 5;";
// 获取表格字段属性
if ($result = mysqli_query($link, $query)) {

    /* Get field information for all fields */
    while ($finfo = mysqli_fetch_field($result)) {

        printf("Name:     %s\n", $finfo->name);
        printf("Table:    %s\n", $finfo->table);
        printf("max. Len: %d\n", $finfo->max_length);
        printf("Flags:    %d\n", $finfo->flags);
        printf("Type:     %d\n\n", $finfo->type);
		echo("<br/>");
    }
    mysqli_free_result($result);
}
// 	
echo("<table border='1' align='center'><tr align='center'>");
// 显示字段名
if ($result = mysqli_query($link, $query))
{	
	while($field=mysqli_fetch_field($result))
	{
		echo("<td>".$field->name."</td>");
	}
	 mysqli_free_result($result);
}
echo("</tr>");	
	
// 显示行数据	
if ($resultrow = mysqli_query($link, $query))
{		
	while($row=mysqli_fetch_row($resultrow))
	{
	
		echo("<tr>");
		for($i=0;$i<mysqli_field_count($link);$i++)
		{
			echo("<td>".$row[$i]."</td>");
		}
		echo("</tr>");
	}
	
}
echo("</table>");		
/* close connection */
mysqli_close($link);
?>
</body>
</html>

<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">	
<meta charset="utf-8">
<title>my sql</title>
<meta name="keywords" content="geovindu">
<meta name="description" content="涂聚文"> 	
</head>
<body>
<?php
// php 7.27  mysql 5.7
/*
character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8  -- 安装mysql时要设置的,所要考虑的
character_set_filesystem	binary
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
*/
session_start();	
$mysql_conf = array(
    'host'    => '127.0.0.1:3306', 
    'db'      => 'sakila', 
    'db_user' => 'root', 
    'db_pwd'  => '770214', 
    );
// 连接无效	
//http://php.net/manual/zh/function.mysql-connect.php  本扩展自 PHP 5.5.0 起已废弃，并在自 PHP 7.0.0 开始被移除
/*	
$mysqli = mysqli_connect($mysql_conf['host'],$mysql_conf['db_user'], $mysql_conf['db_pwd'],$mysql_conf['db']);
if(!$mysqli)
{
	echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;//诊断连接错误
}
	
$mysqli->set_charset('utf8');
mysqli_query($mysqli,'set names utf8');
*/	
//Verbindungen zu mySQL aufbauen
$mysqli = new mysqli($mysql_conf['host'],$mysql_conf['db_user'], $mysql_conf['db_pwd'],$mysql_conf['db']);
      //Verbindung überprüfen
if ($mysqli -> connect_errno)
{
	printf("无法建立连接数据库: %s\n", $mysqli->connect_error);
 	exit();
}

//1.
/*	
if (!$select_db) {
    die("could not connect to the db:\n" .  $mysqli->error);
}
*/
//$mysqli->set_charset('utf8');
//mysqli_query($mysqli,'set names utf8');	
$mysqli->query("set names 'utf8';");//编码转化	

	
$sql = "select * from city where city_id = 601;";
// $res = $mysqli->query($sql);
//mysqli_query($con,"SELECT * FROM Persons");
//$result = $mysqli -> prepare($sql);
//$result -> execute();
	
$fcoun=mysqli_field_count($mysqli);
	printf("geovindu");
echo("字段数：".$fcoun);	

	
// 显示字段名称  where city_id = 601
echo("<table border='1' align='center'><tr align='center'>");
$sql = "select * from city where city_id = 601;";	
//$res =  $mysqli->query($sql);	
/*	
if ($res=mysqli_query($mysqli,$sql))
{
    // 获取所有列的字段信息
    while ($fieldinfo = mysqli_fetch_field($res)) {

        printf("字段名:     %s\n", $fieldinfo->name);
        echo "<br>";
        printf("数据表:    %s\n", $fieldinfo->table);
        echo "<br>";
        printf("最大长度: %d\n", $fieldinfo->max_length);
        echo "<br>";
    }
    // 释放结果集
    mysqli_free_result($res);
}
*/	
/**/
if ($resultd = mysqli_query($mysqli, $sql)) 
{

    // Get field information for all fields 
    while ($finfo = mysqli_fetch_field($resultd)) 
	{
        
        printf("Name:     %s\n", $finfo->name);
        printf("Table:    %s\n", $finfo->table);
        printf("max. Len: %d\n", $finfo->max_length);
        printf("Flags:    %d\n", $finfo->flags);
        printf("Type:     %d\n\n", $finfo->type);
		echo("<br/>");
    }
    mysqli_free_result($resultd);
}	
// 显示字段名
if ($resfield = mysqli_query($mysqli, $sql)) 
{
	while($field=mysqli_fetch_field($resfield))	
	{
		echo("<td>".$field->name."</td>");
	}
	mysqli_free_result($resfield);
	echo("</tr>");
}
	
//显示某行  where city_id = 601;
$sql = "select * from city";	
$res =$mysqli->query($sql);// mysql_query($sql);	
while($rowd=$res->fetch_row())
{
	echo("<tr/>");
	for($i=0;$i<$res->field_count;$i++)
	{
		//echo("<td>".$res->fields['city']."</td>");
		 echo("<td>".$rowd[$i]."</td>");
	}
	echo("</tr>");
}	
echo("</table>");	
//echo("hi,geovindu");
	
//
$sql = "select * from city";	
$res = $mysqli->query($sql);//mysql_query($sql);	//
while ($rowfield = mysqli_fetch_array($res,MYSQLI_ASSOC)) //MYSQLI_BOTH  MYSQLI_NUM
{ 
  echo($rowfield['city'] . ' ' . $rowfield['country_id']."<br/>"); 
} 	

$res->free();
$mysqli->close();


mysqli_close($mysqli);	
?>
	
</body>
</html>

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有