update dynamically added files or image script....

zenag · March 25, 2008

::)

page1.php

<?

$con=mysql_connect("localhost","root","");

mysql_select_db("databasename",$con);

$id=$_GET["var"];

echo $id;

?>

<head>

<title>Untitled Document</title><link href="css/admin_style.css" rel="stylesheet" type="text/css" />

</head>

<body>

<tr> <?php if($_GET["var"]) {

$qryAnnouncement=mysql_query("select * from post_add_picture where add_id ='$_GET[var]'");

while($row=mysql_fetch_array($qryAnnouncement)){

?>

<td > File Upload<span style="color:red"> *</span><br />

</tr><tr><td><? echo $row["ad_picture"]; ?></td></tr>

</td> <?

}

?><?

$tsv = array();

$html = array();

$sql = mysql_query("select * from post_add_picture where add_id ='$_GET[var]'");

while ($rowqw = mysql_fetch_array($sql))

{

$value[] = $rowqw["ad_picture"];

//echo $value;

$tsv = implode(",", $value);

}

?><?php echo $tsv;?> <input type="hidden" name="new[]" value="<?php echo $tsv;?>" />

</tr><? }?>

</table>

<!--

<tr>

<td > File Upload<span style="color:red"> *</span><br />

<tr>-->

<label>

</label> </td>

</table>

<tr>

<td > File Upload<span style="color:red"> *</span><br />

</tr>

<tr>

</tr>

<tr>

</table>

<?

if(!$_GET["var"])

{?>

<label>

</div> </label> </td> <?

}?></td></tr>

</div></form>

</body>

</html>

-----------------

page2.php

<?

$con=mysql_connect("localhost","root","");

mysql_select_db("databasename",$con);

$addid=$_POST["add_id"];

$fileName=$_FILES['file']['name'];

while(list($key,$value) = each($_FILES['file']['name']))

{

$folder="/uploads/";

$fil = $value;

$add = $folder.$fil;

copy($_FILES['file']['tmp_name'][$key], $add);

}

if($_POST['edit'])

{

$addid=$_POST["id"];

$folder="/uploads/";

$filess=implode(",",$_POST['new']);

$a = explode(",",$filess);

foreach($a as $key=>$value)

{

unlink("/uploads/".$value);

$image_name=move_uploaded_file($_FILES['new']['tmp_name'],$folder.$_FILES['new']['name']);

}

$image_name=$_POST['new'];

$qry="update post_add_picture set ad_picture='$image_name'where id='$addid'";

}

else{

while(list($key,$value) = each($_FILES['file']['name']))

{

if(!empty($value))

{

$folder="/uploads/";

$filename = $value;

$add = $folder.$filename;

echo $add;

copy($_FILES['file']['tmp_name'][$key], $add);

}

$fileName = $_FILES['file']['name'];

$file=implode(",",$fileName);

for($i=0;$i<count($fileName);$i++)

{

$fileName[$i];

$picture = $newfile;

$size = $_POST[pic_size];

mysql_query("INSERT INTO post_add_picture(add_id,ad_picture,pic_size,created_date)VALUES('$addid','$fileName[$i]','$size', CURDATE())");

}

?>

<html><body><table><?php

$qryAnnouncement=mysql_query("select * from post_add_picture ");

while($row=mysql_fetch_array($qryAnnouncement))

{

?><tr><td><? echo $row["ad_picture"];?></td></tr><tr><td>

<?

}

?></table>

</body>

</html>

<?

}

?>

---------------------------

script.js

var glob;

glob = 1;

function insert_row(tablename)

{

var the_table = document.getElementById(tablename);

var new_row_index = the_table.rows.length;

glob = glob + 1;

the_table.insertRow(new_row_index);

the_table.rows[new_row_index].insertCell(0);

the_table.rows[new_row_index].cells[0].innerHTML =(the_table.rows[0].innerHTML);

}

function removeRowFromTable(tblSample)

{

var tbl = document.getElementById(tblSample);

var lastRow = tbl.rows.length;

if (lastRow > 1) tbl.deleteRow(lastRow - 1);

}

john010117 · March 27, 2008

Um... do you have this on a website somewhere?

zenag · March 27, 2008

NO ....only the script to add dynamic files i,ve got from web..other things are my own ideas...now im trying to modify the edit action more efficiently...

xylex · April 19, 2008

You must be an incredibly trusting indvidual, but you should probably go ahead and sanitize your input on your SQL calls and file uploads. Even if this code is going to be in a "secure" part of your website, you shouldn't leave the keys in the ignition, so to speak.

Sign In

update dynamically added files or image script....

Recommended Posts

zenag

Link to comment

Share on other sites

john010117

Link to comment

Share on other sites

zenag

Link to comment

Share on other sites

xylex

Link to comment

Share on other sites

Browse

Activity

Important Information