<!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>

arrow
arrow
    文章標籤
    PHP Mysql
    全站熱搜

    周道格 發表在 痞客邦 留言(0) 人氣()