php向Mysql数据库保存数据代码示例

<?php
mysql_connect("localhost","root","");//连接MySQL
mysql_select_db("mythroad");//选择数据库
?>

<?php
require_once("conn.php");//引用数据库链接文件
$uname = $_GET['n'];//GET方法为URL参数传递
$pwd = $_GET['p'];
$pwd =md5($pwd );//直接使用MD5加密
$sql = "insert into mythroad(username,password) values ('$uname','$pwd')";
mysql_query($sql);//借SQL语句插入数据
mysql_close();//关闭MySQL连接
echo "成功录入数据";
?>

<?php
$conn = @mysql_connect("localhost","root","root123");
if (!$conn){
    die("连接数据库失败：" . mysql_error());
}

mysql_select_db("test", $conn);
mysql_query("set names 'gbk'");

$sql = "UPDATE user SET email = 'xiaoming@163.com' WHERE username = '小明'";
if(mysql_query($sql,$conn)){
    echo "更新数据成功！";
} else {
    echo "更新数据失败：".mysql_error();
}
?>

1 $mysql_mylink = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
2 mysql_query("SET NAMES 'GBK'");

header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=".$title .".xls ");
header("Content-Transfer-Encoding: binary ");

<?php   
$DB_Server = "localhost";     
$DB_Username = "root";     
$DB_Password = www.111cn.net;     
$DB_DBName = "ishop";     
$DB_TBLName = "oi_mall_payment";     
    
$savename = date("YmjHis");  
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect.");     
mysql_query("Set Names 'gbk'"); 
$file_type = "vnd.ms-excel";     
$file_ending = "xls"; 
header("Content-Type: application/$file_type;charset=big5");  
header("Content-Disposition: attachment; filename=".$savename.".$file_ending");     
//header("Pragma: no-cache");        
    
$now_date = date("Y-m-j H:i:s");      
$title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";      
    
$sql = "Select * from $DB_TBLName";      
$ALT_Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database");     
$result = @mysql_query($sql,$Connect) or die(mysql_error());   
    
echo("$titlen");      
$sep = "t";      
for ($i = 0; $i < mysql_num_fields($result); $i++) { 
    echo mysql_field_name($result,$i) . "t";      
}      
print("n");      
$i = 0;      
while($row = mysql_fetch_row($result)) {      
    $schema_insert = ""; 
    for($j=0; $j<mysql_num_fields($result);$j++) {      
        if(!isset($row[$j]))      
            $schema_insert .= "NULL".$sep;      
        elseif ($row[$j] != "")      
            $schema_insert .= "$row[$j]".$sep; 
        else      
            $schema_insert .= "".$sep;      
    }      
    $schema_insert = str_replace($sep."$", "", $schema_insert);      
    $schema_insert .= "t";      
    print(trim($schema_insert));      
    print "n";      
    $i++;      
}      
return (true);   
?>

<?php

 header("Content-type:text/html;charset=utf-8");

 //配置信息

 $cfg_dbhost = 'localhost';

 $cfg_dbname = 'ftdm';

 $cfg_dbuser = 'root';

 $cfg_dbpwd = 'root';

 $cfg_db_language = 'utf8';

 $to_file_name = "ftdm.sql";

 // END 配置

 //链接数据库

 $link = mysql_connect($cfg_dbhost,$cfg_dbuser,$cfg_dbpwd);

 mysql_select_db($cfg_dbname);

 //选择编码

 mysql_query("set names ".$cfg_db_language);

 //数据库中有哪些表

 $tables = mysql_list_tables($cfg_dbname);

 //将这些表记录到一个数组

 $tabList = array();

 while($row = mysql_fetch_row($tables)){

  $tabList[] = $row[0];

 }

 echo "运行中，请耐心等待...<br/>";

 $info = "-- ----------------------------rn";

 $info .= "-- 日期：".date("Y-m-d H:i:s",time())."rn";

 $info .= "-- Power by 代潇瑞博客(http://www.daixiaorui.com/read/34.html)rn";

 $info .= "-- 仅用于测试和学习,本程序不适合处理超大量数据rn";

 $info .= "-- ----------------------------rnrn";

 file_put_contents($to_file_name,$info,FILE_APPEND);

 //将每个表的表结构导出到文件

 foreach($tabList as $val){

  $sql = "show create table ".$val;

  $res = mysql_query($sql,$link);

  $row = mysql_fetch_array($res);

  $info = "-- ----------------------------rn";

  $info .= "-- Table structure for `".$val."`rn";

  $info .= "-- ----------------------------rn";

  $info .= "DROP TABLE IF EXISTS `".$val."`;rn";

  $sqlStr = $info.$row[1].";rnrn";

  //追加到文件

  file_put_contents($to_file_name,$sqlStr,FILE_APPEND);

  //释放资源

  mysql_free_result($res);

 }

 //将每个表的数据导出到文件

 foreach($tabList as $val){

  $sql = "select * from ".$val;

  $res = mysql_query($sql,$link);

  //如果表中没有数据，则继续下一张表

  if(mysql_num_rows($res)<1) continue;

  //

  $info = "-- ----------------------------rn";

  $info .= "-- Records for `".$val."`rn";

  $info .= "-- ----------------------------rn";

  file_put_contents($to_file_name,$info,FILE_APPEND);

  //读取数据

  while($row = mysql_fetch_row($res)){

   $sqlStr = "INSERT INTO `".$val."` VALUES (";

   foreach($row as $zd){

    $sqlStr .= "'".$zd."', ";

   }

   //去掉最后一个逗号和空格

   $sqlStr = substr($sqlStr,0,strlen($sqlStr)-2);

   $sqlStr .= ");rn";

   file_put_contents($to_file_name,$sqlStr,FILE_APPEND);

  }

  //释放资源

  mysql_free_result($res);

  file_put_contents($to_file_name,"rn",FILE_APPEND);

 }

 echo "OK!";

?>

update user set password=password(’123456′) where User=’root’

D:/Program Files/APMServ5.2.6>cd MySQL5.1/bin

D:/Program Files/APMServ5.2.6/MySQL5.1/bin>mysqladmin -u root -p password 123456