删除查询 [英] delete query
问题描述
大家好，
我创建一个表格，将图像上传到一个文件夹，并将他们的姓名和其他详细信息写入数据库。
我能上传但我的删除功能不起作用，请
任何人都可以告诉我错误n帮我？
image_uploader.php
< ;?
if（isset（$ _ REQUEST [''sub'']））
{
/ / print"< pre>";
// print_r（$ _FILES）;
$ dir_path = $ _ SERVER [''DOCUMENT_ROOT'']。" / uploadproject / images /"。
$ _FILES [''img1''] [''name''];
// print $ dir_path;
if（move_uploaded_file（$ _ FILES [''img1''] [''tmp_name'']，$ dir_path））
{
// print sucessfull;
}
else
{
// print" error";
}
mysql_connect（" localhost"，" root"，""）;
mysql_select_db（" mac&quo t;）;
$ date1 = date（" Ymd H：i：s"）;
$ sql ="插入图片（imagename，image_type，created_date ）
values（''"。$ _ FILES [''img1''] [''name'']。"''，''"。$ _ FILES [''img1' ''[''type'']。"''，''"。
$ date1。"''）" ;;
mysql_query（$ sql）;
print"< font color =''blue''size =''3''>图片已成功添加...< /
font>" ;;
}
？>
< form name =" frm"行动= QUOT;"方法= QUOT;交" enctype =" multipart / form-
data">
< table border =" 1" align =" center">
< tr>< td colspan =" 2" align =" center">图片上传< / td>< / tr>
< tr>< td>选择图片< / td>< td><输入类型= QUOT;文件"名称= QUOT; IMG1" /< /
td>
< / tr>< tr>< td>< / td>< td>< input type =" ;提交"名称= QUOT;子" value =" Add
Image" />& nbsp;& nbsp;< a href =" show_images.php" target =" _blank">显示
images< / a>
& nbsp;& nbsp;< a href =" delete_images.php" target =" _blank">删除图片< /
a>< / td>
< / table>
< / form>
show_images.php
< ;?
mysql_connect（" localhost"，" root"，""）;
mysql_select_db（" mac"）;
$ rs = mysql_query（" select * from images"）;
$ count = mysql_num_rows（$ rs）;
$ i = 1;
while（$ row = mysql_fetch_array（$ rs））
{
if（$ i == 1 || $ i == 4）
{
if（$ i == 4）
{
$ i = 1;
}
？>
< / tr>< tr>
< ;?
}
else < br $>
{
//打印$ i;
}
$ i = $ i + 1;
？>
< td>< img width =" 100"高度= QUOT; 100" src =" images /<？=
$ row [''imagename'']？>" />< / td>
< ;?
}
？>
< / tr>
< tr< td< a href =" img_uploader.php"返回< / a< / td< / tr>
< ; / table>
--------------------------
delete_images.php
---这个页面的一些问题
<？php
mysql_connect（" localhost"，" root" ，"）;
mysql_select_db（" mac"）;
@ $ id = $ _POST [" id"];
// @ $ delete = $ _POST [" delete"];
if（$ id）{
mysql_connect（" localhost"， " root"，""）;
mysql_select_db（" mac"）;
$ sql =" DELETE FROM images WHERE id = ''$ id''" ;;
mysql_query（$ sql）;
print" Deleted"。 $ img1。来自数据库" ;;
}
mysql_connect（" localhost"，" root"，""）;
mysql_select_db（" ; mac"）;
$ sql =" SELECT imagename FROM images" ;;
$ result = mysql_query（$ sql）;
？ >
< form method =" post" action =" show_images.php">
图片：< select name =" imagename">
<？php
while（$ row = mysql_fetch_array（（$ result），MYSQL_ASSOC））
print"< option>" 。 $ row [" imagename"];
？>
< / select>
< input type =" submit"命名= QUOT;删除" value =" delete">
< / form>
--------------------- --------
hi all,
im creating a form wich wil upload images to a folder and
their names and other details to a database.
im able to do uploading but my delete function is not working, please
can anybody tell me mistake n help me??
image_uploader.php
<?
if(isset($_REQUEST[''sub'']))
{
//print "<pre>";
//print_r ($_FILES);
$dir_path=$_SERVER[''DOCUMENT_ROOT'']."/uploadproject/images/".
$_FILES[''img1''][''name''];
//print $dir_path;
if(move_uploaded_file($_FILES[''img1''][''tmp_name''],$dir_path))
{
//print "sucessfull";
}
else
{
//print "error";
}
mysql_connect("localhost","root","");
mysql_select_db("mac");
$date1=date("Y-m-d H:i:s");
$sql="insert into images(imagename,image_type,created_date)
values(''".$_FILES[''img1''][''name'']."'',''".$_FILES[''img1''][''type'']."'',''".
$date1."'')";
mysql_query($sql);
print "<font color=''blue'' size=''3''>Image Added sucessfully...</
font>";
}
?>
<form name="frm" action="" method="post" enctype="multipart/form-
data">
<table border="1" align="center">
<tr><td colspan="2" align="center">Image upload</td></tr>
<tr><td>Choose An Image</td><td><input type="file" name="img1" /</
td>
</tr><tr><td></td><td><input type="submit" name="sub" value="Add
Image" /> <a href="show_images.php" target="_blank">Show
images</a>
<a href="delete_images.php" target="_blank">Delete images</
a></td>
</table>
</form>
show_images.php
<?
mysql_connect("localhost","root","");
mysql_select_db("mac");
$rs=mysql_query("select * from images");
$count=mysql_num_rows($rs);
$i=1;
while($row=mysql_fetch_array($rs))
{
if($i==1 || $i==4)
{
if($i==4)
{
$i=1;
}
?>
</tr><tr>
<?
}
else
{
//print $i;
}
$i=$i+1;
?>
<td><img width="100" height="100" src="images/<?=
$row[''imagename'']?>" /></td>
<?
}
?>
</tr>
<tr<td<a href="img_uploader.php"Back </a</td</tr>
</table>
--------------------------
delete_images.php
---some problem with this page
<?php
mysql_connect("localhost","root","");
mysql_select_db("mac");
@$id = $_POST["id"];
//@$delete = $_POST["delete"];
if ($id) {
mysql_connect("localhost","root","");
mysql_select_db("mac");
$sql = "DELETE FROM images WHERE id=''$id''";
mysql_query($sql);
print "Deleted ". $img1 ." from database";
}
mysql_connect("localhost","root","");
mysql_select_db("mac");
$sql = "SELECT imagename FROM images";
$result = mysql_query($sql);
?>
<form method="post" action="show_images.php">
Picture: <select name="imagename">
<?php
while ($row = mysql_fetch_array(($result), MYSQL_ASSOC))
print "<option>" . $row["imagename"];
?>
</select>
<input type="submit" name="delete" value="delete">
</form>
-----------------------------
推荐答案
_REQUEST [''sub'']） ）
{
//打印"< pre>" ;;
// print_r（
_REQUEST[''sub'']))
{
//print "<pre>";
//print_r (
_FILES）;
_FILES);
dir_path =
dir_path=
这篇关于删除查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
