<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ("ID: %s Name: %s", $row[0], $row[1]);
} mysql_free_result($result);
?> 去php手册去看一下吧
$mysql_host="localhost";
$mysql_user="root";
$mysql_pass="root";
$mysql_db="dc";
@$mysql_connect=mysql_connect($mysql_host,$mysql_user,$mysql_pass) or die ("无法连接MYSQL");
@$mysql_db=mysql_select_db($mysql_db) or die ("数据库错误");
$result=mysql_query("set names 'gb2312'");
?>
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='abc';
$mysql_database='ok';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
if(!$conn){die("error");}
@mysql_select_db($mysql_database, $conn);
$sqlString = "SELECT * FROM mytable";
?>
<?
$rs = mysql_query($sqlString, $conn);
while($row = @mysql_fetch_array($rs))
echo "$row[0] $row[1] <br />";
?>
<?
@mysql_close($conn);
?>
我这样写就是显示不出数据,只是空白网页,为什么呢?
<?php
$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='abc';
$mysql_database='ok';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
if(!$conn){die("error");}
@mysql_select_db($mysql_database, $conn);
$sqlString = "SELECT * FROM mytable";
$rs = mysql_query($sqlString, $conn);
while($row = @mysql_fetch_array($rs))
{
echo $row[0]."--".$row[1]."<br>"
}
@mysql_close($conn);
?>