PHP7.27: connect mysql 5.7 using new mysqli_connect

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
<!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>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
<!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>

　　

 

posted @   ®Geovin Du Dream Park™  阅读(418)  评论(0)  编辑  收藏  举报
编辑推荐：
· AI与.NET技术实操系列：基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语，封装的思维：从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热？
阅读排行：
· 25岁的心里话
· 闲置电脑爆改个人服务器（超详细） #公网映射 #Vmware虚拟网络编辑器
· 基于 Docker 搭建 FRP 内网穿透开源项目（很简单哒）
· 零经验选手，Compose 一天开发一款小游戏！
· 一起来玩mcp_server_sqlite，让AI帮你做增删改查！！
历史上的今天：
2014-07-17 sql:日期操作注意的,如果以字符串转日期时的函数,因为数据量大,会出问题
2013-07-17 Csharp: Detect Mobile Browsers
< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
点击右上角即可分享
微信分享提示