<!DOCTYPE html>
<html>
<head>SQL TEST</head>
<body>
<?php
/**
* Created by PhpStorm.
* User: Marlyon
* Date: 2017/06/30
* Time: 02:41
*/
/*----Database connection----*/
#mysqli_connect(server name,id,pwd)
$link= mysqli_connect("192.168.1.105","****","****");
#mysqli_select_db(conn,"DB name") or die("error");錯誤訊息
mysqli_select_db($link,"phptest") or die("error");
#偵錯
if(mysqli_connect_errno($link))
{echo "失敗".mysqli_connect_error();}
/*----Database connection----*/
#sql語法
$sql="select * from phpabc";
#sql語法執行 mysqli_query(conn,sql語法);
$result =mysqli_query($link,$sql);
#輸出mysqli_fetch_array(query,datatype);
$row =mysqli_fetch_array($result,MYSQLI_ASSOC);
echo $row["Name"]."|".$row["Address"]."<br>";
mysqli_close($link);
?>
</body>
</html>
留言列表