php连接数据库

iam_Cheng

于 2019-04-26 10:50:57 发布

阅读量214

点赞数

CC 4.0 BY-SA版权

分类专栏： PHP

本文链接：https://blog.youkuaiyun.com/unclebober/article/details/89533812

PHP 专栏收录该内容

2 篇文章

订阅专栏

<?php

// 创建连接
$conn = mysqli_connect($host = 'localhost', $user = '', $password = 
'',$database = 'test', $port = '3308', $socket = '');

// 检测连接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

//sql语句
$sql = "INSERT INTO people(Name,Sex,Age) VALUES('网三','男',36)";

//判断语句是否执行成功
if (mysqli_query($conn, $sql)) { 
    echo "New record created successfully"; 
} else { 
    echo "Error: " . $sql . "<br>" . mysqli_error($conn); 
}

$result = $conn->query($sql);//执行结果赋给$result变量

//输出执行结果
if ($result->num_rows > 0) {
    // 输出每行数据
    while ($row=mysqli_fetch_array($result)){
    	echo $row['Name']." ". $row['Sex']. " ". $row['Age'];
    	echo "<br />";
	}
} else {
    echo "0 results";
}

//关闭连接
mysqli_close($conn);