PHP - Copy Records Into The Same Db

I am having trouble showing reports for a given date range. Currently if I specify something like 11/03/2010 to 11/05/2010 I get results for all years within that month and day such as I may get results for 11/03/2008 11/03/2009 11/03/2010 11/04/2008 11/04/2009 11/04/2010 11/05/2008 11/05/2009 11/05/2010.
I am using the following code
$result = mysql_query("SELECT * FROM report WHERE date>='$date_begin' and date<='$date_end' ORDER BY 'date'",$db);

I use the following format in my date feild mm/dd/yyyy

My script is finally working as intended, but I want to add some additional data results.

I am trying to resolve how I can display a count of ONLY the records updated by my query:

// START :: Query to replace matches
mysql_query("UPDATE orig_codes_1a AS a
      JOIN old_and_new_codes_1a AS b ON concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)
   SET a.orig_code_1 = b.new_code_1,
                           a.orig_code_2 = b.new_code_2") or die(mysql_error());
// END :: Query to replace matches


In this query I count ALL records selection:


// START :: Create query to be displayed as final results of original codes table.
$result = mysql_query("SELECT * FROM orig_codes_1a") 
or die(mysql_error());  

I want to display a count on this part of the query:

....concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)....

Hello everyone, so I made this script that creates directories via "a hack around" cPanel, on my own server, in order to create directories via my own software, but I also need to copy files from one directory into that newly created directory... Therein lies the problem...

I created a script a few years ago that worked, but for the life of me I can't remember how I enabled myself to be able to use the copy function of php...

Anybody know?

hey people
i cant get copy() to work.
im working on an online server and trying to copy a file into directories i just created.
i read about fopen() having to be enabled if both source and destination files are urls, and fopen is enabled and both files are urls (and on the same server).
the directories get created but the file doesnt get copied. the directories have permission 777.
could it be that when i call the copy function the directories aren't yet available on the server? i am copying the file in the same code block as 'create folders', right after.
any pointers?

So my hosting server does not allow fopen anymore, so I was wondering if anyone had an alternative to copying a file from a remote server via a URL to a local folder?

Any alternatives is apprecited.

hi i made my very first array, and its working great

now i want to have another array wich does the same thing, but on another category,
it shows gold silver and bronze logos, but now i want to give leaders of other categorys also those logos, but different ones

so i thought
i change from

$array[$snipergameid][$x] = $sniperleaders[playerid]; (part of the code in a while loop)

into

$array2[$snipergameid][$x] = $sniperleaders[playerid]; (part of the code in a while loop)

and i do the same for the result checker loops
but that doesnt work

so how do i copy an entire arrray, and give it another name
to match it with the correct while loop checker?

Hello, im new to php and I would appreciate help with this one....

Error code is
Warning: copy() expects parameter 1 to be string, array given in /path/to/file/http.class.php on line 143

Error block

Code: [Select]
if (count($_FILES) > 0) {
foreach ($_FILES as $name => $file) {
if ($file['tmp_name']) {
$newfile=dirname(__FILE__).'/../cache/'.$file['name'];
$newfiles[]=$newfile;
copy ($file['tmp_name'],$newfile);
if ($file['tmp_name']) $this->post[$name]='@'.$newfile;
}
}
}
Line 143

Code: [Select]
copy ($file['tmp_name'],$newfile);

Hello freaks,

I am currently creating a member system that will place a default handle image into a newly registered members file.
I have used the mkdir function create the directory successfully based on the members ID, but I can't get the copy function to work.

Code:
Code: [Select]
mkdir("memberFiles/$memberID", 0755);
$old = 'images/defaultlogo.jpg';
$new = 'memberFiles/$memberID/logo.jpg';
copy($old, $new);

Error Message:
Warning: copy(memberFiles/$memberID/logo.jpg) [function.copy]: failed to open stream: No such file or directory

Lastly, this folder is created to store members files.

hey, can some one provide a code to help me copy a folder called contents with files in it to another folder called items

cheers

I am have a query with a limit of 3 i want it to echo the first two in one li class and the 3 in another li class. This is what i have, but i know the logic is not right, but i cant figure it out

Code: [Select]
            </div>
 <?php 

 echo "<ul class='services-list'>";
 //echo "<li class='bubble'>";
 $i = 1;
 foreach ($rows_class as $record_class ){
 ?>
<li class="bubble"><a href="viewclass.php?class_id=<?php echo base64_encode($record_class[class_id]) ?>" /><h6 class="title"><img src="./images/services/picture-services.png" class="picture" alt="logo" /><? echo $record_class[class_title]; ?></h6></a><p><?php $string = $record_class['description'];  echo substr(strip_tags($string), 0, 200); ?></p>
               
               
               
<?php if( $i % 2 === 0 && $record_class !== end($rows_class) ) {
 echo "</li>\n<li class='bubble last'>\n";?>

 
 <?php
  } elseif ( $record_class === end($rows_class) ) {
      echo "</li>\n ";
   }
   $i++;
}
                    
 
  ?>
      </ul> 

Hi Guys,

Basically, I have a long php script to calculate the nearest branch dependant on there postcode hence why $to = $branchemail at the end. It will send it to HQ if anything goes wrong as a safeguard.

Here is a small piece of my php code:

 if (strlen($branchemail) == 0){
// Default Address if anything goes wrong
 $to = "hq@example.com";
 }
 else
 {
 // The address of the branch to send to
 $to = $branchemail;
 }


What I can't seem to do is also send the customer filling in the php form a copy of the email sent. The variable for the customers email is $email

I have tried this and it doesn't seem to work either...

// The address of the branch to send to
 $to = $branchemail;
$to .= $email;
}

At the bottom of the script, there is this code to physically send the email. This also always sends a copy to hq aswell.


echo "Thank you for contacting us, we have received your message and we aim to respond your very shortly.";

mail($to, $subject, $body, $mailheader);

// THIS LINE TO CC Email
mail("hq@example.com", $subject, $body, $mailheader);

} else {

echo "There has been an error code 1. Please try again."; 



So basically I just can't get it to send a copy to the customer filling it in ($email) Any idea's because my mind has gone blank.

Cheers, S

Hi all

I am trying to write a piece of code that copies files from a multiple selected form. Here's the form:

Code: [Select]
<form action="" method="post" enctype="multipart/form-data">
<input type="file" name="image[]" multiple="multiple" />
<input name="submit" type="submit" value="submit">
</form>

Here's my PHP code:

Code: [Select]
if(isset($_POST['submit'])) {
$count=0;
foreach($_FILES['image'] as $filename){
copy($_FILES['image']['tmp_name'], WEB_UPLOAD."/images/galleries/".$filename) or die("Error uploading image ");
$count++;
}
}

I get the message, Array to string conversion and no such directory found. Am I right in thinking I am sending the files as arrays?

Many thanks for your help.

hey guys its me again. what i want is for me to be able to edit php using variables and post it as a new file. now to attchieve this i am simply copying the current template into the php file and telling it to grap what variables it needs. i have successfully done this with a .css file but when im doing it with a php file its erroring at <?php as the file is already in php. what i need to know is can i have the php file look at the <?php as just text to write to a file? my code is below

Code: [Select]
$dir = "../Header/";
$file = "" . $branchid . ".php";
$dir = "$dir"."$file";
touch($dir);
$Handle = fopen($dir, 'w');
 $Data = "
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php


//We count the number of new messages the user has
$nb_new_pm = mysql_fetch_array(mysql_query('select count(*) as nb_new_pm from pm where ((user1="'.$_SESSION['user_id'].'" and user1read="no") or (user2="'.$_SESSION['user_id'].'" and user2read="no")) and id2="1"'));
//The number of new messages is in the variable $nb_new_pm
$nb_new_pm = $nb_new_pm['nb_new_pm'];
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<style type="text/css">
/* Remove margins from the 'html' and 'body' tags, and ensure the page takes up full screen height */
html, body { margin:0; padding:0;}
/* Set the position and dimensions of the background image. */
#page-background {position:fixed; top:0; left:0; width:100%; height:100%;}
/* Specify the position and layering for the content that needs to appear in front of the background image. Must have a higher z-index value than the background image. Also add some padding to compensate for removing the margin from the 'html' and 'body' tags. */
#content {position:relative; z-index:1; padding:10px;}
</style>
<head>
<title>Apollo - Data Management System</title>

<!--Links-->
<link rel="icon" type="image/ico" href="favicon.ico"></link>
<link rel="stylesheet" media="all" type="text/css" href="/styles.css" />


</head>
<body>


<div id="Headerlogo"> <img src="/images/PaulKemp/PaulBanner.png" width="100%" alt="Smile"></div>



<div class="wrapper1">
<div class="wrapper">
<div class="nav-wrapper">

<div class="nav">
<ul id="navigation">
    <li class="active">
<a href="/Main/myaccount.php">
<span class="menu-left"></span>
<span class="menu-mid">Main Menu</span>
<span class="menu-right"></span>
</a>
</li>
    <li class="">
<a href="/PersonnelMessages/list_pm.php">

<span class="menu-left"></span>
<span class="menu-mid"><b>Messages(<?php echo $nb_new_pm; ?> unread)</b></span>
<span class="menu-right"></span>
</a>
<div class="sub">
    <ul>
    <li>
<a href="/PersonnelMessages/new_pm.php">New Personal Message</a>
</li>
   
</ul>
    <div class="btm-bg"></div>
    </div>
</li>
   

<?php if (checkMasterAdmin()) { ?>
<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Admin</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Admin/UploadServices.php">New KPI</a>
</li>
    <li>
<a href="/Admin/MonthReview.php">New Month Review</a>
</li>
    <li>
<a href="/Admin/CreateUser.php">New User</a>
</li>
    <li>
<a href="/Admin/EditUsers.php">Edit User</a>
</li>

<li>
<a href="/Admin/HolidayRequests.php">Authorise Holidays</a>
</li>

<li>
<a href="/Backup/BackupSite.php">Backup</a>
</li>
<li>
<a href="/PersonnelMessages/CompanyAnnouncement.php">Company Announcements</a>
</li>
<li>
<a href="/PersonnelMessages/DeleteAnnouncements.php">Delete Announcements</a>
</li>
    </ul>
    <div class="btm-bg"></div>
    </div>
</li>
<?php } ?>
                               
<?php if (checkAdmin()) { ?>
<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Admin</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Admin/UploadServices.php">New KPI</a>
</li>
    <li>
<a href="/Admin//MonthReview.php">New Month Review</a>
</li>
    <li>
<a href="/Admin/CreateUser.php">New User</a>
</li>
    <li>
<a href="/Admin/EditUsers.php">Edit User</a>
</li>

<li>
<a href="/Admin/HolidayRequests.php">Authorise Holidays</a>
</li>
<li>
<a href="/Backup/BackupSite.php">Backup</a>
</li>
<li>
<a href="/PersonnelMessages/CompanyAnnouncement.php">Company Announcements</a>
</li>
<li>
<a href="/PersonnelMessages/DeleteAnnouncements.php">Delete Announcements</a>
</li>
    </ul>
    <div class="btm-bg"></div>
    </div>
</li>
<?php } ?>

<?php if (checkBranchOwner()) { ?>
<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Admin</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Admin/UploadServices.php">New KPI</a>
</li>
    <li>
<a href="/Admin//MonthReview.php">New Month Review</a>
</li>
    <li>
<a href="/Admin/CreateUser.php">New User</a>
</li>
    <li>
<a href="/Admin/EditUsers.php">Edit User</a>
</li>

<li>
<a href="/Admin/HolidayRequests.php">Authorise Holidays</a>
</li>
<li>
<a href="/Backup/BackupSite.php">Backup</a>
</li>
<li>
<a href="/PersonnelMessages/CompanyAnnouncement.php">Company Announcements</a>
</li>
<li>
<a href="/PersonnelMessages/DeleteAnnouncements.php">Delete Announcements</a>
</li>
    </ul>
    <div class="btm-bg"></div>
    </div>
</li>
<?php } ?>



<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Staff</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Staff/ChangePassword.php">Change Password</a>
</li>
    <li>
<a href="/Staff/mysettings.php">Change Details</a>
</li>
    <li>
<a href="/Staff/HolidaysLeft.php">Holidays Left</a>
</li>
    <li>
<a href="/Staff/profile.php">My Profile</a>
</li>
<li>
<a href="/Staff/MyServices.php">My Services</a>
</li>
<li>
<a href="/Viewmonthreports.php">Month Review</a>
</li>

</ul>
    <div class="btm-bg"></div>
    </div>
</li>



<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Referrers</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Referrers/Newreferrers.php">New Referrers</a>
</li>
    <li>
<a href="/Referrers/SendReferrers.php">Send Referrers</a>
</li>
   
   
</ul>
    <div class="btm-bg"></div>
    </div>
</li>

<li class="">
<a href="#">
<span class="menu-left"></span>
<span class="menu-mid">Holidays</span>
<span class="menu-right"></span>
</a>
                <div class="sub">
    <ul>
    <li>
<a href="/Holidays/RequestHoliday.php">Book Off Holiday</a>
</li>
    <?php if (checkAdmin()) { ?>
<li>
<a href="/Admin/HolidayAmendments.php">Amend Holidays</a>
</li>
<li>
<a href="/Admin/CancelledHolidays.php">Show Cancelled Holidays</a>
</li>
</li>
    <li>
<a href="/reports/holidayreports.php">holiday report</a>
</li>
<?php } ?>

<?php if (checkMasterAdmin()) { ?>
<li>
<a href="/Admin/HolidayAmendments.php">Amend Holidays</a>
</li>
<li>
<a href="/Admin/CancelledHolidays.php">Show Cancelled Holidays</a>
</li>
    <li>
<a href="/reports/holidayreports.php">holiday report</a>
</li>
<?php } ?>


   
   
</ul>
    <div class="btm-bg"></div>
    </div>
</li>


<li class="">
<a href="/logout.php">
<span class="menu-left"></span>
<span class="menu-mid">Logout</span>
<span class="menu-right"></span>
</a>
</li>


</ul>
</div>

</div>


</div>
</div>

<br />
 
"; 
 fwrite($Handle, $Data);
 $Data = "Bilbo Jones\n";
 fwrite($Handle, $Data);
 print "Data Written";
 fclose($Handle);

How would I copy an array of selected files? I know how to list them using a 'for' loop, and how to separate them using a 'foreach' loop, but I am unable to get a checkbox array to copy to a destination folder. Help is appreciated.

hello PHP geniuses! I am new to this whole thing... so please be patient with me
I have a form that is working great.... there are just a couple of things that I would like it to do that I can't figure out. PHP is still a mystery to me, but I am trying to learn. If I include the code, I am hoping someone can help.
I would like to know if I can
1. cc the sender the form details
2. pull form data to create the subject line

This is a HiQform, with attachments...

My HTML:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Studio Job Ticket</title>
<link rel="stylesheet" type="text/css" href="view.css" media="all">
<script type="text/javascript" src="view.js"></script>
<script type="text/javascript" src="calendar.js"></script>

</head>
<body id="main_body" >

<img id="top" src="top.png" alt="">
<div id="form_container">

  <h1><a>Studio Job Ticket</a></h1>
  <form id="studio job ticket" class="appnitro" enctype="multipart/form-data" method="post" action="HiQFM.php">
<div class="form_description">
        <input type=hidden name="recipient" value="dayle_sheward@rogers.com,dayle.sheward@juniperpark.com">
        <input type="hidden" name="redirect" value="http://dayle.me/form/thankyou.html">
        <input type="hidden" name="form_format" value="html">
        <input type="hidden" name="MAX_FILE_SIZE" value="1000000">
        <input type="hidden" name="path_to_file" value="http://dayle.me/form/TEMP_FILES">
        <input type="hidden" name="subject" value="Studio Job Ticket">
        <input type=hidden name="style_sheet" value="view.css">
       
<br />
          <h2>Studio Job Ticket</h2>
<p>The purpose of this form is to ensure the Juniper Park Studio receives all
  necessary
  files and information needed for dockets to be done in timely and
  accurate fashion.
  Please provide as <br />
  much information
  as possible.</p>
<p>Once this job ticket is received, you will be contacted by phone or email, confirming
    your job is <br />
    in progress, with a rough estimate on when you can expect the first proof. </p>
        </div>
    <ul >
<li class="description" id="li_1" >
    <label class="description" for="account manager">Account Manager</label>
  <span>
  <input id="first name" name= "first name" class="element text" maxlength="255" size="10" value=""/>
  <label>First</label>
      </span> <span>
  <input id="last name" name= "last name" class="element text" maxlength="255" size="14" value=""/>
  <label>Last</label>
   </span> </li>
<li id="li_2" >
    <label class="description" for="email">Email</label>
    <div>
  <input id="email" name="email" class="element text" type="text" maxlength="255" value=""/>
      </div>
  </li>
<li id="li_3" >
<label class="description" for="job">Job</label>
  <span>
  <input id="client" name= "client" class="element text" maxlength="255" size="8" value=""/>
<label>Client</label>
      </span> <span>
    <input id="brand" name= "brand" class="element text" maxlength="255" size="14" value=""/>
    <label>Brand</label>
      </span> </li>
<li id="li_4" >
  <label class="description" for="media type">Media Type</label>
  <div>
    <select class="element select medium" id="media type" name="media type">
      <option value=""selected="selected"></option>
      <option value="Award Work" >Awards Work</option>
      <option value="Collateral" >Collateral</option>
      <option value="OOH" >OOH</option>
              <option value="Print" >Print</option>
      <option value="Retouching" >Retouching</option>
              <option value="Photography" >Photography</option>
        </select>
      </div>
  </li>
<li id="li_5" >
          <label class="description" for="docket">Docket (work cannot start without this)</label>
          <div>
          <input id="docket" name="docket" class="element text" type="text" maxlength="255" value=""/>
          </div>
        </li>
<li id="li_6" >
  <label class="description" for="job">Creative Team</label>
  <span>
    <input id="AD" name= "AD" class="element text" maxlength="255" size="14" value=""/>
    <label>AD</label>
      </span> <span>
      <input id="Writer" name= "Writer" class="element text" maxlength="255" size="14" value=""/>
      <label>Writer</label>
      </span></li>
<li id="li_7" >
<label class="description" for="Supplied">Additional Information to Supply</label>
<span>
<input id="copy deck" name="copy deck" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_1">Copy Deck</label>
<input id="spec sheet" name="spec sheet" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_2">Spec Sheet</label>
<input id="ma" name="ma" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_3">MA</label>
        <input id="creative files" name="creative files" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_3">Creative Files</label>
  Please specify location files:</span></li>
<li >
  <div>
        <input id="creative file location" name="creative file location" class="element text" type="text" maxlength="255" value=""/>
        or<br />
        <input id="emailedYN" name="emailedYN" class="element checkbox" type="checkbox" value="1" />
        <label class="choice" for="emailedYN">Check if to be Emailed</label>
          </div>
          </li> <li id="li_7" >
<label class="description" for="upload">Upload a File </label>
<div>
  <input id="attachment" name="attachment[]" class="element file" type="file"/>
</div>
      </li> <li id="li_3" >
<label class="description" for="due date">Due Date </label>
<span>
<input id="element_3_1" name="MM" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_3_1">MM</label>
</span>
<span>
<input id="element_3_2" name="DD" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_3_2">DD</label>
</span>
<span>
<input id="element_3_3" name="YYYY" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_3_3">YYYY</label>
</span>

<span id="calendar_3">
<img id="cal_img_3" class="datepicker" src="calendar.gif" alt="Pick a date.">
</span>
<script type="text/javascript">
Calendar.setup({
inputField : "element_3_3",
baseField    : "element_3",
displayArea  : "calendar_3",
button : "cal_img_3",
ifFormat : "%B %e, %Y",
onSelect : selectDate
});
</script>
<li id="li_10" >
<label class="description" for="element_10">Production Details</label>

<div class="left">
<input id="trim" name="trim" class="element text" value="" type="text">
<label for="trim">Trim Size (width x height)</label>
</div>

<div class="right">
<input id="live" name="live" class="element text" value="" type="text">
<label for="live">Live (width x height)</label>
</div>

<div class="left">
<input id="bleed" name="bleed" class="element text" value="" type="text">
<label for="bleed">Bleed (width x height)</label>
</div>

<div class="right">
<input id="#mechanicals" name="#mechanicals" class="element text" value="" type="text">
<label for="#mechanicals"># of Mechanicals
    (if multiple, please provide a MA or spreadsheet)</label>
</div>
        <div class="left">
<input id="die line" name="die line" class="element text" value="" type="text">
<label for="die line">Die Line</label>
</div>

<div class="right">
<input id="PU docket" name="PU docket" class="element text" value="" type="text">
<label for="PU docket">Pick-Up docket</label>
</div>
       

<div class="left">
<input id="FilesReq" name="FilesReq" class="element text" maxlength="15" value="" type="text">
<label for="FilesReq">To supply raw collected files or PDFX1a</label>
</div>

<div class="right">
<select class="element select medium" id="delivery" name="delivery" onClick='alert("Please provide all deliverable details, such as FTP/emails etc.; info in the ADDITIONAL INFO area below.")'>
<option value="" selected="selected"></option>
<option value="File Cargo" >File Cargo</option>
<option value="FTP" >FTP</option>
<option value="Email" >Email</option>
<option value="Temp Folder" >Temp Folder</option>
<option value="Disk" >Disk</option>


</select>
<label for="deliverable info">Deliverable Info</label>
</div>
</li>
</li>
<li id="li_13" >
  <label class="description" for="Additional">Additional Info</label>
  <div>
    <textarea id="Additional" name="Additional" class="element textarea medium"></textarea>
      </div>
  </li>
    </ul>
<p>
<label for="userCopyMe">Check the box if you wish to be sent a copy of this message</label>
<br />
<input type="checkbox" name="userCopyMe" id="userCopyMe" value="1" <?php if ($userCopyMe == "1") { echo "checked=\"checked\""; }?> />
</p>
    <li class="buttons" id="saveForm">
              <input type="reset" value="Reset" >
      <input id="saveForm" class="button_text" type="submit" name="submit" value="Submit" onclick="verify();">
    </li>
    </ul>
  </form>
<div id="footer"></div>
</div>
<img id="bottom" src="bottom.png" alt="">
</body>
    <name="form_delivery" value="digest"/>
</form>
</html>
Thanks in advance!

EDIT: pinche code tags.