' . mysql_field_name ( $result, $i ); echo " |
'; echo $row [$i]; echo ' |
<?php $mysql_server_name = "127.0.0.1"; // 数据库服务器名称 $mysql_username = "root"; // 连接数据库用户名 $mysql_password = "123456"; // 连接数据库密码 $mysql_database = "demo"; // 数据库的名字 // /连接到数据库 $conn = mysql_connect ( $mysql_server_name, $mysql_username, $mysql_password ); // 从表中提取信息的sql语句 // $strsql = "SELECT sname as 姓名,spassword as 密码 FROM tb_sql"; $strsql = "SELECT * FROM tb_sql"; mysql_query ( "set names 'gbk'" ); $result = mysql_db_query ( $mysql_database, $strsql, $conn ); $row = mysql_fetch_row ( $result ); echo '
'; echo '
"; echo ""; /* * $sql = "insert into tb_sql(sname, spassword, bumen) values('zhangsan', '123456', '外联部')"; mysql_query($sql); //执行插入语句 echo "插入成功!" ; */ // 释放资源 mysql_free_result ( $result ); // 关闭连接 mysql_close ( $conn ); ?>
转载于:https://www.cnblogs.com/wwxblog/p/4277564.html