PHP链接MYSQL

来源：互联网发布：管理日程的软件编辑：程序博客网时间：2024/06/06 13:19

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?php

 $user = "root";
 $passwd = "root";


 $connect = mysql_connect('localhost', $user, $passwd)
 or die('数据库连接失败: ' . mysql_error());
 echo ' 第一步:成功建立连接! ';

 $db = 'test';
 mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
 echo '第二步: 成功连接到 ('.$db.')! ';


 mysql_close($connect);
 echo "冒称";

获取数据库里面的信息

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?php

 $user = "root";
 $passwd = "root";


 $connect = mysql_connect('localhost', 'root', 'root')
 or die('Could not connect: ' . mysql_error());
 mysql_query("SET NAMES 'GB2312'",$connect);
 echo '第一步:成功建立连接! ';

 $db = 'test';
 mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
 echo '第二步: 成功连接到 ('.$db.') ! ';


 $query = 'SELECT * FROM user';
 $result = mysql_query($query) or die('Query failed: ' . mysql_error());



 echo " 获取数据... ";
 echo "<table border='1' width='3000'>\n";

 $count = 0;
 while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
 echo "\t<tr>\n";
 foreach ($line as $col_value) {
 echo "\t\t<td>$col_value</td>\n";
 }
 $count++;
 echo "\t</tr>\n";
 }

 echo "</table>\n";

 if ($count < 1) {
 echo " 表格中未发现记录. ";
 } else {
 echo " 表格中有".$count."行记录. ";
 }


 mysql_free_result($result);


 mysql_close($connect);
?>

0 0