上传代码是
//上传文件开始
$updir = "doc";//指定目录名称if(!is_dir($updir)){
mkdir($updir, 0777); //若不存在,则创建目录
}
if (!is_writeable($updir)){
echo "$updir目錄不可寫!"; exit;
}
/**
|+-----------------------------------------------
| 上传图片
|+-----------------------------------------------
**/
$up_pic = $_FILES['pic'];
$pic_name = $up_pic['name'];
if (!empty($pic_name)) {
if (!is_uploaded_file($up_pic['tmp_name'])){
echo "不能上傳 $pic_name";
exit();
}
$file_name=substr($pic_name, -3); //获取上存文件小点后的的文件名
$file_name_last=strtolower($file_name); //将文件名改成小写
if($file_name_last!="zip"&&$file_name_last!="rar"&&$file_name_last!="doc"){
echo "请输入zip,rar,doc三种格式的文件!";
exit();
}
$up_url=$updir."/".$pic_name;
if (!move_uploaded_file($up_pic['tmp_name'], $up_url)){ //上传样图
echo "上傳文件失敗";
}
}
//上传文件结束
?>文件名想存进person数据库,sc字段,怎么实现?
sc字段需要是什么数据类型?
//上传文件开始
$updir = "doc";//指定目录名称if(!is_dir($updir)){
mkdir($updir, 0777); //若不存在,则创建目录
}
if (!is_writeable($updir)){
echo "$updir目錄不可寫!"; exit;
}
/**
|+-----------------------------------------------
| 上传图片
|+-----------------------------------------------
**/
$up_pic = $_FILES['pic'];
$pic_name = $up_pic['name'];
if (!empty($pic_name)) {
if (!is_uploaded_file($up_pic['tmp_name'])){
echo "不能上傳 $pic_name";
exit();
}
$file_name=substr($pic_name, -3); //获取上存文件小点后的的文件名
$file_name_last=strtolower($file_name); //将文件名改成小写
if($file_name_last!="zip"&&$file_name_last!="rar"&&$file_name_last!="doc"){
echo "请输入zip,rar,doc三种格式的文件!";
exit();
}
$up_url=$updir."/".$pic_name;
if (!move_uploaded_file($up_pic['tmp_name'], $up_url)){ //上传样图
echo "上傳文件失敗";
}
}
//上传文件结束
?>文件名想存进person数据库,sc字段,怎么实现?
sc字段需要是什么数据类型?
<?php require_once('Connections/person.php'); ?>
<?php
//上传文件开始
$updir = "doc";//指定目录名称if(!is_dir($updir)){
mkdir($updir, 0777); //若不存在,则创建目录
}
if (!is_writeable($updir)){
echo "$updir目錄不可寫!"; exit;
}
/**
|+-----------------------------------------------
| 上传图片
|+-----------------------------------------------
**/
$up_pic = $_FILES['pic'];
$pic_name = $up_pic['name'];
if (!empty($pic_name)) {
if (!is_uploaded_file($up_pic['tmp_name'])){
echo "不能上傳 $pic_name";
exit();
}
$file_name=substr($pic_name, -3); //获取上存文件小点后的的文件名
$file_name_last=strtolower($file_name); //将文件名改成小写
if($file_name_last!="zip"&&$file_name_last!="rar"&&$file_name_last!="doc"){
echo "请输入zip,rar,doc三种格式的文件!";
exit();
}
$up_url=$updir."/".$pic_name;
if (!move_uploaded_file($up_pic['tmp_name'], $up_url)){ //上传样图
echo "上傳文件失敗";
}
}
//上传文件结束function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "file":
$theValue = ($theValue != "") ? "'" . $pic_name . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO person (xm, xb, xy, zy, nj, bbs, ss, dh, ff, xq, lb, jy, jh, sc) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['xm'], "text"),
GetSQLValueString($HTTP_POST_VARS['xb'], "text"),
GetSQLValueString($HTTP_POST_VARS['xy'], "text"),
GetSQLValueString($HTTP_POST_VARS['zy'], "text"),
GetSQLValueString($HTTP_POST_VARS['nj'], "text"),
GetSQLValueString($HTTP_POST_VARS['bbs'], "text"),
GetSQLValueString($HTTP_POST_VARS['ss'], "text"),
GetSQLValueString($HTTP_POST_VARS['dh'], "text"),
GetSQLValueString($HTTP_POST_VARS['ff'], "text"),
GetSQLValueString($HTTP_POST_VARS['xq'], "text"),
GetSQLValueString($HTTP_POST_VARS['lb'], "text"),
GetSQLValueString($HTTP_POST_VARS['jy'], "text"),
GetSQLValueString($HTTP_POST_VARS['jh'], "text"),
GetSQLValueString($HTTP_POST_VARS['sc'], "file")); mysql_select_db($database_person, $person);
$Result1 = mysql_query($insertSQL, $person) or die(mysql_error()); $insertGoTo = "index.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>