PHP Mysql

来源：互联网发布：男士真皮手套品牌知乎编辑：程序博客网时间：2024/06/06 02:49

PHP Mysql

<?php require 'config.php';  //新增一条数据 /*$sql='insert into tbl_sysuser  (usercode,username,password,usertype,isActived)  values ("fc01","刘汪洋","w1251314","房产局管理员","YES");';  @mysql_query($sql) or die('SQL错误，新增用户错误：'.mysql_error()); */  //修改数据  /* $sql='update tbl_sysuser set username="蔡倩倩" where usercode="fc01"'; *  @mysql_query($sql) or die('SQL错误，修改用户错误：'.mysql_error()); *  */ //删除数据/*  $sql='delete from  tbl_sysuser where usercode="fc01"';  *  @mysql_query($sql) or die('SQL错误，删除用户错误：'.mysql_error()); * */$sql='select id,usercode,username,password,usertype,isActived from tbl_sysuser'; $result =@mysql_query($sql) or die('SQL错误，错误信息'.mysql_error());  while($row =mysql_fetch_array($result)) { echo 'username:'.$row['username'].'----password:'.$row['password'].'<br/>';  }  mysql_close();?>

config.php

<?phpheader('Content-Type:text/html;charset=utf-8');//常量参数define('DB_HOST','localhost');define('DB_USER','root');define('DB_PWD','root');define('DB_NAME','housing');//第一步，连接数据库$conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die('数据库连接失败，错误信息：'.mysql_error());//第二步，选择指定的数据库，设置字符集mysql_select_db(DB_NAME) or die('数据库错误，错误信息：'.mysql_error());mysql_query('set names UTF8') or die('字符集设置错误'.mysql_error());?>

0 0