转载自CSDN.net的论坛 _Shakespeare(网络骑士) / 撰文
发布文章、或者新闻、或者产品说明,这一类的图片、文字均有的资料,要求的是,根据文章的需要随时插入图片、并且由其自己指定对齐方式。文字进库,图片上传?
adddata.php文件的代码:
1<html>
2<head>
3<title>增加数据</title>
4<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
5</head>
6
7<body bgcolor="#FFFFFF">
8
9
10<?
11@$link=mysql_pconnect("localhost","root","rpass007") or
12die ("登陆服务器失败,请稍候再试");
13mysql_select_db($db);
14$date=date('Y-m-d H:i:s');
15if((($db=="foltyx"&&$tb=="wlg_master")||($db=="foljrbd"&&$tb=="tpxw"))||($db=="foljrxt"&&($tb=="shpx"||$tb=="tswl")))//for tyx jrbd jrxt
16{
17 if(chop($imagein)!="none")
18 {
19 $picuppath="/home/fol/php/admin/"; //define up pic path
20 $dirname="picup";
21 if(!(chdir($picuppath)))
22 {
23 die("can not change path!");
24 }
25 if(!(file_exists("$dirname")))
26 {
27 if(!(mkdir($dirname,0777))) die("can not make dir!");
28 if(!(chmod($dirname,0777))) die("can not change dir mode!");
29 }
30 if(!(chdir($dirname))) die("can not change dir!");
31 $dirpath=$dirname."/";
32 $imagepath=$picuppath.$dirpath; //path end
33
34 $image="";
35 $imagename="";
36 $imagetype="";
37 $nowtime=time();
38
39 $imagename=$imagein_name ; //old pic name for db
40 $imagetail=strrchr($imagename,"."); //get pic name type name
41 $imagename=$nowtime.$imagetail;
42 if(!copy($imagein,$imagepath.$imagename)) die("up pic false"); //up pic end
43 $size=getimagesize($imagename); //get size array,for now in uppic,so just imagename else dirpaht
44 $imgwidth=$size[0];
45 $imgheight=$size[1];
46 $imgsize=$size[3];
47 unlink($imagename); //delete pic in remote
48
49 $image=base64_encode(fread(fopen($imagein,"r"),10000000)); //inset db begin
50 $imagetype=$imagein_type ;
51 $imgtype=$imagetype;
52 unlink($imagein);
53
54 $imgoldname=$imagename;
55 $imgname=$imagename;
56 $imgbody=$image;
57if($db=="foljrbd"&&tb=="tpxw"){//there is no summary in tpxw of foljrbd,so
58$result =mysql_query("insert into $tb (title,content,date,author,origin,imgoldname,imgtype,imgname,imgwidth,imgheight,imgsize,imgbody) values('$title','$content','$date','$author','$origin','$imgoldname','$imgtype','$imgname','$imgwidth','$imgheight','$imgsize','$imgbody')",$link);
59}
60else{//tpxw of foljrbd
61$result =mysql_query("insert into $tb (title,summary,content,date,author,origin,imgoldname,imgtype,imgname,imgwidth,imgheight,imgsize,imgbody) values('$title','$summary','$content','$date','$author','$origin','$imgoldname','$imgtype','$imgname','$imgwidth','$imgheight','$imgsize','$imgbody')",$link);
62}
63 }
64 else die("请上传图片");
65}//end of pic or pic with no summary
66elseif($db=="foljrbd"&&$tb=="cjzt"){//beggin of cjzt of fol jrbd
67$result =mysql_query("insert into $tb (title,content,date,author,origin,topic) values('$title','$content','$date','$author','$origin','$topic')",$link);
68}//end of cjzt of fol jrbd
69elseif($db=="foljrsx"&&$tb=="pshzl")//for jrsx
70{
71 if(chop($imagein)!="none")
72 {
73 $picuppath="/home/fol/php/jrsx/"; //define up pic path
74 $dirname="article";
75 if(!(chdir($picuppath)))
76 {
77 die("can not change path!");
78 }
79 if(!(file_exists("$dirname")))
80 {
81 if(!(mkdir($dirname,0777))) die("can not make dir!");
82 if(!(chmod($dirname,0777))) die("can not change dir mode!");
83 }
84 if(!(chdir($dirname))) die("can not change dir!");
85 $dirpath=$dirname."/";
86 $imagepath=$picuppath.$dirpath; //path end
87
88 $image="";
89 $imagename="";
90 $imagetype="";
91 $nowtime=time();
92
93 $imagename=$imagein_name ; //old pic name for db
94 $imagetail=strrchr($imagename,"."); //get pic name type name
95 $imagename=$nowtime.$imagetail;
96 if(!copy($imagein,$imagepath.$imagename)) die("up pic false"); //up pic end
97 //unlink($imagename); //delete pic in remote
98
99 //$image=base64_encode(fread(fopen($imagein,"r"),10000000)); //inset db begin
100 $imagetype=$imagein_type ;
101 $imgtype=$imagetype;
102 unlink($imagein);
103
104 $imgoldname=$imagename;
105 $imgname=$imagename;
106 $imgbody=$image;
107$result =mysql_query("insert into $tb (title,content,date,author,origin,artcloldname,artcltype,artclname) values('$title','$content','$date','$author','$origin','$imgoldname','$imgtype','$imgname')",$link);
108 }
109 else die("请上传论文");
110}//end of art
111elseif($db=="foljrxt"&&($tb=="ztjz"||$tb=="alfx")){
112$result =mysql_query("insert into $tb (title,summary,content,date,author,origin) values('$title','$summary','$content','$date','$author','$origin')",$link);
113}
114else{
115$result =mysql_query("insert into $tb (title,content,date,author,origin) values('$title','$content','$date','$author','$origin')",$link);
116}
117if (mysql_affected_rows()==1)
118{
119 ?>
120 添加成功,请返回!
121 <p><a href="add.php?db=<? echo $db ?>&tb=<? echo $tb ?>">返回</a> </p>
122 <?
123}
124else
125{
126 ?>
127 添加不成功,请稍候再试!
128 <p><a href="add.php?db=<? echo $db ?>&tb=<? echo $tb ?>">返回</a> </p>
129 <?
130}
131?>
132
133</body>
134</html>
135
136 add.php文件的内容:
1<html>
2<head>
3<title>增加数据</title>
4<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
5</head>
6
7<body bgcolor="#FFFFFF">
8<?
9if($db=="foljrbd"&&$tb=="cjzt"){
10?>
11<form name="form1" method="post" action="addcjzt.php" enctype="multipart/form-data">
12 <table width="50%" border="0" align="center">
13 <tr>
14 <td align="center">
15 <p>请选择需要增加内容的专题:</p>
16 <p> </p>
17 </td>
18 </tr>
19 <tr>
20 <td align="center">金融报道>>财经专题>>
21 <select name="topic">
22<? @$link=mysql_pconnect("localhost","root","rpass007")
23 or die("登陆失败,稍后重试");
24 mysql_select_db("fol") or die("unable to select database");
25 $query="select topic,tpcname from foljrbd_cjzt order by id desc";
26 $result=mysql_query($query,$link);
27 while (list($topic,$tpcname)=mysql_fetch_row($result))
28 {
29 ?>
30 <option value="<? echo $topic ?>">
31 <? echo $tpcname ?>
32 </option>
33<?
34}
35?>
36 </select>
37 </td>
38 </tr>
39 <tr>
40 <td align="right">
41 <input type="hidden" name="db" value="<? echo $db ?>">
42 <input type="hidden" name="tb" value="<? echo $tb ?>">
43 <input type="submit" name="Submit" value="填加">
44 </td>
45 </tr>
46 <tr>
47 <td>
48 <p> </p>
49 <p><a href="mkspecial.php?db=<? echo $db ?>&tb=<? echo $tb ?>">建立新的专题</a></p>
50 </td>
51 </tr>
52 <tr>
53 <td> </td>
54 </tr>
55 </table>
56</form>
57<?
58}
59
60elseif($db=="foljrsx"&&$tb=="pshzl")//beggin of pshzl of foljrsx
61{
62?>
63<p align="center"><font size="4">论文上传</font> </p>
64<form name="form1" ENCTYPE="multipart/form-data" method="post" action="adddata.php?db=<? echo $db ?>&tb=<? echo $tb ?>">
65 <div align="center">
66 <table width="75%" border="0">
67 <tr>
68 <td>论文标题:
69 <input type="text" name="title" size="40">
70 作者:
71 <input type="text" name="author">
72 </td>
73 </tr>
74 <tr>
75 <td>
76 <p align="left">论文简介:
77 <textarea name="content" cols="90" rows="10"></textarea>
78 </p>
79 </td>
80 </tr>
81 <tr>
82 <td>
83 <div align="left">论文:
84 <input type="file" name="imagein">
85 </div>
86 </td>
87 </tr>
88
89 <tr>
90 <td>
91 <div align="center"> </div>
92 </td>
93 </tr>
94 <tr>
95 <td>
96 <div align="center"><font size="4">
97 <input type="submit" name="submit" value="提交">
98
99 <input type="reset" value="清空" name="reset">
100 </font></div>
101 </td>
102 </tr>
103 </table>
104 </div>
105</form>
106<?
107}//end of pshzl of foljrsx
108
109else
110{
111?>
112<p align="center"><font size="4">录入数据</font> </p>
113<form name="form1" ENCTYPE="multipart/form-data" method="post" action="adddata.php?db=<? echo $db ?>&tb=<? echo $tb ?>">
114 <div align="center">
115 <table width="75%" border="0">
116 <tr>
117 <td>文章标题:
118 <input type="text" name="title" size="40">
119 作者:
120 <input type="text" name="author">
121 </td>
122 </tr>
123 <? if((($db=="foltyx"&&$tb=="wlg_master")||($db=="foljrsx"&&$tb=="pshzl"))||($db=="foljrxt"&&($tb!="hbyh"&&$tb!="tzlc")))
124{
125?>
126 <tr>
127 <td>
128 <p align="left">简短介绍:
129 <textarea name="summary" cols="80" rows="3"></textarea>
130 </p>
131 </td>
132 </tr>
133 <?
134 }
135?>
136 <tr>
137 <td>
138 <p align="left">文章内容:
139 <textarea name="content" cols="90" rows="10"></textarea>
140 </p>
141 </td>
142 </tr>
143 <tr>
144 <td>
145 <div align="left">出处:
146 <input type="text" name="origin" size="80">
147 </div>
148 </td>
149 </tr>
150 <? if((($db=="foltyx"&&$tb=="wlg_master")||($db=="foljrbd"&&$tb=="tpxw"))||($db=="foljrxt"&&($tb=="shpx"||$tb=="tswl")))
151{
152?>
153 <tr>
154 <td>
155 <div align="left">图片:
156 <input type="file" name="imagein">
157 </div>
158 </td>
159 </tr>
160 <?
161 }
162?>
163 <tr>
164 <td>
165 <div align="center"> </div>
166 </td>
167 </tr>
168 <tr>
169 <td>
170 <div align="center"><font size="4">
171 <input type="submit" name="submit" value="提交">
172
173 <input type="reset" value="清空" name="reset">
174 </font></div>
175 </td>
176 </tr>
177 </table>
178 </div>
179</form>
180<?
181}
182?>
183</body>
184</html>
185 具体的数据表的建立方式可以从执行语句中看到
附:这是我和一个研究生为学校的一个网站写的后台管理程序的处理后台管理上传的东西,不当之处还请指出来
posted on 2005-05-13 15:20
楚客 阅读(417)
评论(0) 编辑 收藏 所属分类:
转载