PHP - Copy Files From One Table To Another

Hi all,

Im trying to move files that im uploading from my main domain to a sub domain. I think I can achieve this using passthru?

Im having issues with this, can any one point me in the right direction please?

Thanks, Phil

hey all,
I've been struggling with this for the last few days and can't figure it out...
I'm trying to build a fairly complex uploading system.

the thing i'm getting stuck with is trying to copy/move the uploaded files from the domain name to a subdomain

Ex:
$path1 = "/var/www/vhosts/domain.com/httpdocs/new/test/test.jpg";
$path2 = "/var/www/vhosts/domain.com/subdomains/img/httpdocs/test/test.jpg";

Dedicated server running RHEL with Plesk

The problem seems to be an open_basedir restriction.

My question is... are there any work-arounds open_basedir and if not what are the implications of disabling it???

Any help is greatly appreciated.
Thank you for your time

c

Hello I have a problem.

I have been trying to copy my music folders structure but not copying the mp3s; instead using the file names as a file name for a .txt file and inserting the URL to the file in the .txt file.

Eg.

E:\My Music
       folder 1
           folder 1.1
               file.mp3
       folder 2
       folder 3

to

G:\My Music
       folder 1
           folder 1.1
               file.txt
       folder 2
       folder 3

and inside "file.txt" would be one line saying "http://www.xxx.com/my_music/file.mp3

Hi All, I want to copy into a table values from another table that partially match a given value, case-insensitively. So far I do as follows but I wonder whether there is a quicker way.

$input_table=array('1'=>'toto','2'=>'tota','3'=>'hello','4'=>'TOTO','5'=>'toto');
$input_table_2 = array_map('strtolower', $input_table);
$value_to_look_for='Tot';
$value_to_look_for_2=strtolower($value_to_look_for);
$output_table=array();
foreach ($input_table_2 as $k=>$v)
  {
  if(false !== strpos($v, $value_to_look_for_2))
    {
    $output_table[]=$input_table[$k];
    }
}

One drawback is that $input_table_2 is 'foreached' whereas there might be no occurrences, which would lead to a loss of time/resources for big arrays.   Thanks.

I have a survey that uses colors. At the moment someone takes the survey I need to capture the values that are in a table called "tbl_colors" and write them to each survey in "tbl_surveys" as a row.

tbl_colors
id, hex_color
1 FFF432
2 CC3399
3 DD3399
and so on to the number 12

tbl_survey
id, timestamp, name, hex01, hex02, hex03, hex04, etc to hex12

I have written code that "works" but I know it is extremely redundant and overloaded and someone could probably do the same thing in less than 10 lines of code. So, I post it here so I can learn from my mistakes.


// Make a MySQL Connection
$query = "SELECT * FROM tbl_colors WHERE id = 1"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color1 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 2"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color2 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 3"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color3 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 4"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color4 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 5"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color5 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 6"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color6 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 7"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color7 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 8"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color8 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 9"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color9 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 10"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color10 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 11"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color11 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 12"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color12 = $row['hex_color'];

//echo $color1.$color2.$color3.$color4.$color5.$color6.$color7.$color8.$color9.$color10.$color11.$color12;


mysql_query("INSERT INTO tbl_surveys (hex01, hex02, hex03, hex04, hex05, hex06, hex07, hex08, hex09, hex10, hex11, hex12)
VALUES ('$color1', '$color2', '$color2', '$color3', '$color4', '$color5', '$color6', '$color7', '$color8', '$color9', '$color10', '$color11', '$color12')");

Hi... I planned to create db table daily. When day begin button clicked (text box has date Value) master dB can be copied,with the name of text box value ($date). If already day begin then it show day begin done. How can I do that. Please guide me

Hi all

I am describing my problem below can any body please look into this

I have two databases
DB1:datain1
DB2:datain2
having the below structure

database,            table,                         fields
    datain1 ,             student   ,                    id,name
    datain2 ,             student   ,                    id,name


the two databases having same structure

My query is

i want copy all data from datain1 to datain2 on daily process through php script(script will be executed manually on daily)

i don't want any duplicate or repeated data in datain2

give me some script to do this

kindly help me to solve this its so urgent

Ok I am designing a php upload that will take a image file from a form and change the name of the file to the productnumber also recieved from the form. I had it working the otherday now it says Warning: copy() [function.copy]: open_basedir restriction in effect File() is not within the allowed path(s): (/home:/tmp:/usr) addpro.php on line 51.

my files are attached.... note that $pnum is the product number gotten from my form and image is the image being uploaded gotten from the form also.  The thing is it worked the other day but now it don't is it a change to the server ( I dont run the server) or did I mess up my code since then?  I really need a code that will do this two time over once for a small image being put into a folder called small and once for a folder called large both images being uploaded and being changed to $pnum.ext so they will both be displayed when being called out by the product number. but I can work on that after I get this one working.


line 51 is $copied = copy($_FILES['image']['tmp_name'], $newname);

Hi guys,

I am wirting a script to upload an image file, but I get the error:

copy() [function.copy]: Filename cannot be empty in

Obviouly it has something to do with the copy() function - (copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))

I think it is not copying from my temp folder or something.

Can anyone help me out?

Code is:

Code: [Select]
//IMAGE FILE
$file_name = $_FILES['product_img']['name'];

echo '<p>File Name:' . $file_name . '</p>';
//IMAGE UPLOAD
// random 4 digit to add to file name
$random_digit=rand(0000,9999);

//combine random digit to file name to create new file name
//use dot (.) to combile these two variables
$new_image_name = $random_digit.$file_name;

echo $new_image_name;


//SET DESINATION FOLDER
$path= "uploads/".$new_image_name;
echo '<p>Path:' . $path . '</p>';
if($product_img !=none)
{
if(copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))
{
echo "Successful<BR/>";
echo "File Name :".$new_file_name."<BR/>";
echo "File Size :".$HTTP_POST_FILES['product_img']['size']."<BR/>";
echo "File Type :".$HTTP_POST_FILES['product_img']['type']."<BR/>";
}
else
{
echo "Image upload Error<BR/>";
}
}
Any help would be greatly appreciated!

Thanks

This was generated through phpFormGenerator, but I'm getting the following warning message when a file is not uploaded. I didn't set it as a required field.

"Warning: copy() [function.copy]: Filename cannot be empty ..."

If it possible to skip this check since it's not supposed to be required to upload a file? I'm simply trying to make a contact form that emails basic information with the added option of attaching a file/picture.

Code: [Select]
<?php
include("global.inc.php");
$errors=0;
$error="The following errors occured while processing your form input.<ul>";
pt_register('POST','FullName');
pt_register('POST','Email');
pt_register('POST','Phone');
pt_register('POST','QuestionsorComments');
$QuestionsorComments=preg_replace("/(\015\012)|(\015)|(\012)/","&nbsp;<br />", $QuestionsorComments);$AttachPictureforQuote=$HTTP_POST_FILES['AttachPictureforQuote'];
pt_register('POST','Howdidyoufindus');
if($FullName=="" || $Email=="" ){
$errors=1;
$error.="<li>You did not enter one or more of the required fields. Please go back and try again.";
}
if($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name']==""){ }
 else if(!is_uploaded_file($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'])){
$error.="<li>The file, ".$HTTP_POST_FILES['AttachPictureforQuote']['name'].", was not uploaded!";
$errors=1;
}
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$Email)){
$error.="<li>Invalid email address entered";
$errors=1;
}
if($errors==1) echo $error;
else{
$image_part = date("h_i_s")."_".$HTTP_POST_FILES['AttachPictureforQuote']['name'];
$image_list[4] = $image_part;
copy($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'], "files/".$image_part);
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Full Name: ".$FullName."
Email: ".$Email."
Phone: ".$Phone."
Questions or Comments: ".$QuestionsorComments."
Attach Picture for Quote: ".$where_form_is."files/".$image_list[4]."
How did you find us: ".$Howdidyoufindus."
";
$message = stripslashes($message);
mail("webmaster@gmail.com","Form Submitted at your website",$message,"From: phpFormGenerator");
?>


<!-- This is the content of the Thank you page, be careful while changing it -->

<h2>Thank you!</h2>

<table width=50%>
<tr><td>Full Name: </td><td> <?php echo $FullName; ?> </td></tr>
<tr><td>Email: </td><td> <?php echo $Email; ?> </td></tr>
<tr><td>Phone: </td><td> <?php echo $Phone; ?> </td></tr>
<tr><td>Questions or Comments: </td><td> <?php echo $QuestionsorComments; ?> </td></tr>
<tr><td>Attach Picture for Quote: </td><td> <?php echo $AttachPictureforQuote; ?> </td></tr>
<tr><td>How did you find us: </td><td> <?php echo $Howdidyoufindus; ?> </td></tr>
</table>
<!-- Do not change anything below this line -->

<?php 
}
?>
Thanks for your time and any help you can provide!

I came across the PHP clone method. Does this clone first level fields and methods or does it also do deep copying e.g. copying references to those fields. For example, a field may be an array. Does it make a copy of the actual array or does it refer to the same array position in memory, so if the original changes, then the copy's changes as well?

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

I need php code that creates pdf file with table inside.