Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- 說明:
- 1.php變數可以隨取隨用,不用宣告(基本上很多型態我也不知道怎麼宣告才好)\
- 2.echo等同於printf,字串請用 " " 把它包起來,連結字串用 . 這個符號
- 3.與mysql的連線從$conn = mysql_connect ... (恕刪)這裡開始
- 4.取得mysql資料的方法,我是都用mysql_fetch_array(),可以問問t4有無更好的東西
- 5.在輸出一筆資料各個欄位時使用 $row['欄位名稱'] (要先用$row去接mysql_fetch_array()的東西)
- */
- echo "Hello Word!! <br>";
- //mysql 位址
- $dbhost = "127.0.0.1";
- //mysql 帳號
- $dbuser = "admin";
- //mysql 密碼
- $dbpass = "1234";
- //mysql 資料庫名稱
- $dbname = "demo";
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error with MySQL connection');
- mysql_query("SET NAMES 'utf8'") or die('mysql SET NAMES error!');
- mysql_select_db($dbname) or die('mysql select db error!');
- $sql = "SELECT * FROM `demotable`";
- $result = mysql_query($sql) or die('mysql query error!');
- while($row = mysql_fetch_array($result)){
- echo $row['id'].":".$row['name']."<br>";
- }
- ?>
Add Comment
Please, Sign In to add comment