PHP - Issue With Php File Used To Process A Form...

The error is "Error: Duplicate entry '' for key 'usr'"

I don't have any fields with that name.

here is the process code.


<?php
$con = mysql_connect("localhost","uname","pw") or die('Could not connect: ' . mysql_error());
mysql_select_db("db") or die(mysql_error());

$FirstName=mysql_real_escape_string($_POST['FirstName']); //This value has to be the same as in the HTML form file
$LastName=mysql_real_escape_string($_POST['LastName']); //This value has to be the same as in the HTML form file
$UserName=mysql_real_escape_string($_POST['UserName']); //This value has to be the same as in the HTML form file
$Password= md5($_POST['Password']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$Zip=mysql_real_escape_string($_POST['Zip']); //This value has to be the same as in the HTML form file
$Birthday=mysql_real_escape_string($_POST['Birthday']); //This value has to be the same as in the HTML form file
$Security=mysql_real_escape_string($_POST['Security']); //This value has to be the same as in the HTML form file
/*
 *  Specify the field names that are in the form. This is meant 
 *  for security so that someone can't send whatever they want 
 *  to the form.
 */
$allowedFields = array(
'FirstName',
'LastName',
'UserName',
'Password',
'email',
'Birthday',
'Zip',
'Security',
);

// Specify the field names that you want to require...
$requiredFields = array(
'FirstName',
'LastName',
'UserName',
'Password',
'email',
'Birthday',
'Zip',
'Security',
);

$errors = array();
foreach($_POST AS $key => $value)
{
// first need to make sure this is an allowed field
if(in_array($key, $allowedFields))
{
$$key = $value;

// is this a required field?
if(in_array($key, $requiredFields) && $value == '')
{
$errors[] = "The field $key is required.";
}
}
}

// were there any errors?
if(count($errors) > 0)
{
$errorString = '<p>There was an error processing the form.</p>';
$errorString .= '<ul>';
foreach($errors as $error)
{
$errorString .= "<li>$error</li>";
}
$errorString .= '</ul>';

// display the previous form
include 'index.php';
}
else
{


$sql="INSERT INTO Profile (`FirstName`,`LastName`,`Username`,`Password`,`email`,`Zip`,`Birthday`,`Security`) VALUES ('$FirstName','$LastName','$UserName','$Password','$email','$Zip','$Birthday','$Security')"; 
if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error());
 }
//send email
mail('email@gmail.com','A profile has been submitted!',$FirstName.' has submitted their profile',$body);

// display the thank you page
header("Location: thanks.html");
}

I need some assistance with an error I get when trying to submit a form to my email address.
the error is this:

Warning: mail() [function.mail]: SMTP server response: 555 syntax error (#5.5.4) in E:\Contact\process.php on line 74
Sorry, unexpected error. Please try again later

the form code is

Code: [Select]
<form id="form" action="process.php" method="post" name="ContactForm">

    <label for="Name">Name</label>
    <input type="text" name="name" id="name" />
    <label for="email">E-mail</label>
    <input type="text" name="email" id="email" />
     <label for="website">Website</label>
    <input type="text" name="website" id="website" />
      <label for="message">Message</label>
    <textarea class="resizable" name="comment">
</textarea>
    <input type="submit" name="submit" id="submit" value="Submit">
    </form>

and the process code

[php]

<?php

//Retrieve form data. 
//GET - user submitted data using AJAX
//POST - in case user does not support javascript, we'll use POST instead
$name = ($_GET['name']) ? $_GET['name'] : $_POST['name'];
$email = ($_GET['email']) ?$_GET['email'] : $_POST['email'];
$website = ($_GET['website']) ?$_GET['website'] : $_POST['website'];
$comment = ($_GET['comment']) ?$_GET['comment'] : $_POST['comment'];

//flag to indicate which method it uses. If POST set it to 1
if ($_POST) $post=1;

//Simple server side validation for POST data, of course, you should validate the email
if (!$name) $errors[count($errors)] = 'Please enter your name.';
if (!$email) $errors[count($errors)] = 'Please enter your email.'; 
if (!$comment) $errors[count($errors)] = 'Please enter your comment.'; 

//if the errors array is empty, send the mail
if (!$errors) {

//recipient
$to = 'My Name <email@gmail.com>';
//sender
$from = $name . ' <' . $email . '>';

//subject and the html message
$subject = 'Comment from ' . $name;
$message = '
<!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></head>
<body>
<table>
<tr><td>Name</td><td>' . $name . '</td></tr>
<tr><td>Email</td><td>' . $email . '</td></tr>
<tr><td>Website</td><td>' . $website . '</td></tr>
<tr><td>Comment</td><td>' . nl2br($comment) . '</td></tr>
</table>
</body>
</html>';

//send the mail
$result = sendmail($to, $subject, $message, $from);

//if POST was used, display the message straight away
if ($_POST) {
if ($result) echo 'Thank you! I have received your message.';
else echo 'Sorry, unexpected error. Please try again later';

//else if GET was used, return the boolean value so that 
//ajax script can react accordingly
//1 means success, 0 means failed
} else {
echo $result;
}

//if the errors array has values
} else {
//display the errors message
for ($i=0; $i<count($errors); $i++) echo $errors[$i] . '<br/>';
echo '<a href="form.php">Back</a>';
exit;
}


//Simple mail function with HTML header
function sendmail($to, $subject, $message, $from) {
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$headers .= 'From: ' . $from . "\r\n";

$result = mail($to,$subject,$message,$headers);

if ($result) return 1;
else return 0;
}

?>

[/php]

Can someone please help? I am simply trying to email process a form with checkboxes and then redirect to a thank you page.  It works fine as long as at least one checkbox is checked. It breaks if no checkboxes are checked using the implode function to list the "interests". I'm getting this error (and no redirect to my thank you page): Warning: implode() [function.implode]: Invalid arguments passed...

<?php
if (isset($_REQUEST['submit']))
{
   $email = $_REQUEST['email'];
   $firstName = $_REQUEST['firstName'];
   $lastName = $_REQUEST['lastName'];
   $address = $_REQUEST['address'];
   $city = $_REQUEST['city'];
   $state = $_REQUEST['state'];
   $zipcode = $_REQUEST['zipcode'];
   $homePhone = $_REQUEST['homePhone'];
   $cellPhone = $_REQUEST['cellPhone'];
   $interest = $_REQUEST['interest'];
   $imploded_interest = implode(',',$interest);
   $comments = $_REQUEST['comments'];
   $to  = 'myemailhere@yahoo.com';
   $subject = 'Volunteer Signup';
   $message = "
   <html>
   <head>
   <title>Volunteer Signup</title>
   </head>
   <body>
      <p>Hello,<br/>A visitor has submitted the following information from the volunteer page:</p>
      <p><b>$firstName $lastName</b><br/>
      $address<br/>
      $city, $state $zipcode<br/><br/>
      Home Phone: $homePhone<br/>
      Cell Phone: $cellPhone<br/>
      Email: <strong>$email</strong><br/><br/>
      I would like to help in the following ways:<br/>
      $imploded_interest
      </p><br/>
      <p>$firstName would also like share the following comments:<br/>
      <q><i>$comments</i></q>
      </p>
      </body>
      </html>
      ";
   $headers  = 'MIME-Version: 1.0' . "\r\n";
   $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
   $headers .= 'From: Volunteer Signup <myemailhere@yahoo.com>' . "\r\n";
   mail($to, $subject, $message, $headers);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Volunteer</title>
</head>
<body>
            <form id="VolunteerForm" method="post" action="thankyou.php">
                 <table>
                           <tr>
                               <td style="width:150px;">Email Address:</td>
                                <td><input name="email" type="text" id="email" /></td>
                                <td style="width:320px;" class="padtr"><strong>Ways I can help:</strong></td>
                           </tr>
                                 <tr>
                               <td>First Name:</td>
                                <td><input name="firstName" type="text" id="firstName" /></td>
                                <td class="padtr"><input name="interest[]" value="yard-sign" type="checkbox"/>
                        Put a yard sign in my yard</td>
                            </tr>
                            <tr>
                               <td>Last Name:</td>
                                <td><input name="lastName" type="text" id="lastName" /></td>
                                <td class="padtr"><input name="interest[]" value="fundraiser-at-home" type="checkbox" />
                        Host a fundraiser at my home</td>
                            </tr>
                            <tr>
                               <td>Address:</td>
                                <td><input name="address" type="text" id="address" /></td>
                                <td class="padtr"><input name="interest[]" value="phone-calls" type="checkbox" />
                                Make phone calls to friends and family</td>
                            </tr>
                            <tr>
                               <td>City:</td>
                                <td><input name="city" type="text" id="city" /></td>
                                <td class="padtr"><input name="interest[]" value="mailings" type="checkbox" />
                                Help with mailings</td>
                            </tr>
                            <tr>
                               <td>State:</td>
                                <td><input name="state" type="text" id="state" /></td>
                                <td class="padtr"><input name="interest[]" value="doors-literature" type="checkbox" />
                                  Help knock on doors and distribute literature</td>
                            </tr>
                            <tr>
                               <td>Zip Code:</td>
                                <td><input name="zipcode" type="text" id="zipcode" /></td>
                                <td class="padtr"><input name="interest[]" value="donate" type="checkbox" />
                                  Make a donation</td>
                            </tr>
                            <tr>
                               <td>Home Phone:</td>
                                <td><input name="homePhone" type="text" id="homephone" /></td>
                                <td class="padtr"><input name="interest[]" value="endorsement" type="checkbox" />
                                Use my name as an endorsement</td>
                            </tr>
                            <tr>
                               <td>Cell Phone:</td>
                                <td><input name="cellPhone" type="text" id="cellphone" /></td>
                                <td class="padtr"><input name="interest[]" value="newsletter" type="checkbox" />
                                Sign up for our newsletter</td>
                            </tr>
                            <tr>
                              <td>Comments:</td>
                       <td><textarea name="comments" id="comments" rows="5" cols="17"></textarea></td>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                           <td>&nbsp;</td>
                           <td>&nbsp;</td>
                                <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" id="submit" value="Submit Now" />&nbsp; <input type="reset" name="reset" id="reset" value="Clear Form" /></td>
                            </tr>
                        </table>
                        </form>
</body>
</html>

I am not getting the result I am hoping for. The code below is full code after a form has been submitted containing a member name and amount of credits:

Code: [Select]
<?php
if (isset($t)){
$t = $_GET['t'];}
?>
<?php
$amount = $_POST['amount'];
$member = $_POST['member'];

$sql = ("SELECT vtp_members.name, vtp_members.team_id FROM vtp_members WHERE vtp_members.team_id=".$_GET['t']." AND vtp_members.name='$member' AND teams.team_treasure >= '$amount' ");
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if($numrows == '1')
{
  $sql2 = "UPDATE vtp_members, teams SET vtp_members.hits=(vtp_members.hits + '$amount'), teams.team_treasure=(teams.team_treasure - '$amount')
WHERE vtp_members.name='$member' AND teams.team_id=".$_GET['t']." ";
$results2 = mysql_query($sql2);
$row2 = mysql_fetch_row($results2);
$tmap2 = $row2[0];

echo "You sent ". $amount . "credits to " . $member . ". ";
}
else
{
echo "The treasure holdings are too low for this transfer<br>(or an error occured)";}

?>
Problem; it returns the else statement although the "teams.team_treasure" is higher or equal to  "$amount"

my front page of d site is having som links like login ,register...whenever i  click on login it shows me login.php properly in another div ..but whenever i submit username and pasword n click on submit button  d loginprocess.php starts downloading on google chrome...i dnt understand why

Hello,

Can someone help me with these contact-form please,

I just want to include a file (.pdf, .jpg, .png) and send the mail.

 

For the moment, the mail is send but not with the file included.

 

Here is the website

http://www.coeuraprendre.art

 

HTML CODE :

 

<form id="contact-form" class="checkform" action="#" target="contact-send.php" method="post" enctype="multipart/form-data" >
				
						<div class="form-row clearfix">
							<label for="name" class="req">Nom *</label>
							<input type="text" name="name" class="name" id="name" value="" placeholder="Name" />
						</div>
						
						<div class="form-row clearfix">
							<label for="email" class="req">Email *</label>
							<input type="text" name="email" class="email" id="email" value="" placeholder="Email"/>
						</div>
						
						<div class="form-row clearfix textbox">
							<label for="message" class="req">Nom du projet  *</label>
							<textarea name="message" class="message" id="message" rows="15" cols="50" placeholder="Message"></textarea>
						</div>
						
							<div class="form-row clearfix">
							<label for="pdf" class="req">Ajoutez votre dossier d'inscription (Pdf intéractif) *</label>
							<input type="file" id="pdf" class="pdf" name="pdf" placeholder="Pdf" accept="image/pdf">

						</div>
						
						
						
						
						<div id="form-note">
							<div class="alert alert-error">
								<strong>Error</strong>: Please check your entries!
							</div>
						</div>
						
						<div class="form-row form-submit">
							<input type="submit" name="submit_form" class="submit" value="Send" />
						</div>
				
						<input type="hidden" name="subject" value="From Coeur à Prendre" />
						<input type="hidden" name="fields" value="name,email,message," />
						<input type="hidden" name="sendto" value="info@coeuraprendre.art" />  
					</form> 
				</div>
				<!-- Contact form -->

 

 

PHP CODE :

 

<?php

define("WEBMASTER_EMAIL", $_POST['sendto']);
if (WEBMASTER_EMAIL == '' || WEBMASTER_EMAIL == 'Testemail') {
	die('<div class="alert alert-confirm"> <h6><strong>The recipient email is not correct</strong></h6></div>');	
} 

define("EMAIL_SUBJECT", $_POST['subject']);
if (EMAIL_SUBJECT == '' || EMAIL_SUBJECT == 'Subject') {
	define("EMAIL_SUBJECT",'Contact');	
}

$name = stripslashes($_POST['name']);
$email = trim($_POST['email']);
$message = stripslashes($_POST['message']);
$pdf = stripslashes($_POST['pdf']);


$custom = $_POST['fields'];
$custom = substr($custom, 0, -1);
$custom = explode(',', $custom);

$message_addition = '';
foreach ($custom as $c) {
	if ($c !== 'name' && $c !== 'email' && $c !== 'message' && $c !== 'pdf' && $c !== 'subject') {
		$message_addition .= '<b>'.$c.'</b>: '.$_POST[$c].'<br />';
	}
}

if ($message_addition !== '') {
	$message = $message.'<br /><br />'.$message_addition;
}


$message = '<html><body>'.nl2br($message)."</body></html>";
$mail = mail(WEBMASTER_EMAIL, EMAIL_SUBJECT, $message,
     "From: ".$name." <".$email.">\r\n"
    ."Reply-To: ".$email."\r\n"
    ."X-Mailer: PHP/" . phpversion()
	."MIME-Version: 1.0\r\n"
	."Content-Type: text/html; charset=utf-8");


if($mail)
{
echo '
		<div class="alert alert-confirm">
			<strong>Confirm</strong>: Your message has been sent. Thank you!
		</div>
';
}
else
{
echo '
		<div class="alert alert-error">
			<strong>Error</strong>: Your message has not been send!
		</div>
';
}

?>

 

Edited July 22 by cocolembo

Stumped!  I have a client who has a form where they upload files to their server: title, two password fields, and the file They have been unable to upload anything over 10m   Small (under 10mb) files work. Larger doesn’t I’ve tracked it down, I think, that the processing page appears to be dropping the form values when the file takes a bit to upload.   I echo’ed the values that are grabbed from the form, and they return empty strings if it takes a while for the file to upload (a large file) - they pass fine if the file is smaller.   I think I've got the php info set correctly, but cannot for the life of me figure out how to adjust the timing out issue, or even where to troubleshoot.   Here's my phpinfo:   Max Requests Per Child: 750 - Keep Alive: off - Max Per Connection: 100 Timeouts Connection: 120 - Keep-Alive: 5     Directive Local Value Master Value allow_call_time_pass_reference Off Off allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap /etc/browscap.ini /etc/browscap.ini default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions leak,posix_getpwuid,posix_getpwnam,posix_getgrid,posix_getgrnam,posix_getgroups leak,posix_getpwuid,posix_getpwnam,posix_getgrid,posix_getgrnam,posix_getgroups display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off error_append_string no value no value error_log /mnt/Target01/337846/945285/www.dermerrealestate.com/logs/php_errors.log no value error_prepend_string no value no value error_reporting 30711 30711 exit_on_timeout Off Off expose_php Off Off extension_dir /usr/lib64/php/modules /usr/lib64/php/modules file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/php log_errors On On log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.add_x_header On On mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 30 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 128M 128M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 8M 8M precision 14 14 realpath_cache_size 4M 4M realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays On On report_memleaks On On report_zend_debug On On request_order no value no value safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 8M 8M upload_tmp_dir /tmp /tmp user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.enable_gc On On  

Hello all,

I'm designing an upload file section for a home medical company.
So far it has been going great, I am uploading files and they're being successfully inserted into my MYSQL Table.
However, my issue is when I download the files they claim to be corrupted and unusable.
If I save the PDF files to my desktop they won't open at all, they claim to be corrupted. If I download a JPG and then open it in photshop it warns me
the file may be corrupted, knowing it is not I clicked "yes". The jpg actually opens and looks like the image, however about 50 pixels on the bottom get cut off and look like a messy TV screen, if that makes sense.

Wondering if anyone has had this similar issue, the uploading part is not the issue - just downloading the files.

My Upload Form Code:

Code: [Select]
<p><a href="upload.php">Upload a File</a>&nbsp;&nbsp;<a href="../admin/admin.php">Back to Control Panel</a></p>
<form action="add_file.php" method="post" enctype="multipart/form-data">
       <input type="file" name="uploaded_file"><br>
       <input type="submit" value="Upload file">
</form>
       <p>
        <a href="list_files.php">See all files</a>
       </p>
My Add File Code (This is working fine but may cause issues with downloading?)
Code: [Select]
<?php
// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
    // Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) {
        // Connect to the database
       $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
        $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `file` (
                `name`, `mime`, `size`, `data`, `created`
            )
            VALUES (
                '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 


        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your file was successfully added!';
        }
        else {
            echo 'Error! Failed to insert the file'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="upload.php">here</a> to go back</p>';
?>


My List File Code (This is working fine also, but does contain the link that I click when I want to download a file)

Code: [Select]
<?php
         $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
     
    // Query for a list of all existing files
    $sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';
    $result = $dbLink->query($sql);
     
    // Check if it was successfull
    if($result) {
        // Make sure there are some files in there
        if($result->num_rows == 0) {
            echo '<p>There are no files in the database</p>';
        }
        else {
            // Print the top of a table
            echo '<table width="100%">
                    <tr>
                        <td><b>Name</b></td>
                        <td><b>Mime</b></td>
                        <td><b>Size (bytes)</b></td>
                        <td><b>Created</b></td>
                        <td><b>&nbsp;</b></td>
                    </tr>';
     
            // Print each file
            while($row = $result->fetch_assoc()) {
                echo "
                    <tr>
                        <td>{$row['name']}</td>
                        <td>{$row['mime']}</td>
                        <td>{$row['size']}</td>
                        <td>{$row['created']}</td>
                        [u][b]<td><a href='get_file.php?id={$row['id']}'>Download</a></td>[/b][/u]
                    </tr>";
            }
     
            // Close table
            echo '</table>';
        }
     
        // Free the result
        $result->free();
    }
    else
    {
        echo 'Error! SQL query failed:';
        echo "<pre>{$dbLink->error}</pre>";
    }
     
    // Close the mysql connection
    $dbLink->close();
    ?>


And here is my Get File page. This is where my problem lies. (I think)

Code: [Select]
<?php
// Make sure an ID was passed
if(isset($_GET['id'])) {
// Get the ID
    $id = intval($_GET['id']);
 
    // Make sure the ID is in fact a valid ID
    if($id <= 0) {
        die('The ID is invalid!');
    }
    else {
        // Connect to the database
      $dbLink = new mysqli('localhost', 'vzimbel_user', 'webdesign1', 'vzimbel_db');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
     
            // Fetch the file information
            $query = "
                SELECT `mime`, `name`, `size`, `data`
                FROM `file`
                WHERE `id` = {$id}";
            $result = $dbLink->query($query);
     
            if($result) {
                // Make sure the result is valid
                if($result->num_rows == 1) {
                // Get the row
                    $row = mysqli_fetch_assoc($result);
     
                    // Print headers
                    header("Content-Type: ". $row['mime']);
                    header("Content-Length: ". $row['size']);
                    header("Content-Disposition: attachment; filename=". $row['name']);
     
                    // Print data
                    echo $row['data'];
                }
                else {
                    echo 'Error! No image exists with that ID.';
                }
     
                // Free the mysqli resources
                @mysqli_free_result($result);
            }
            else {
                echo "Error! Query failed: <pre>{$dbLink->error}</pre>";
            }
            @mysqli_close($dbLink);
        }
    }
    else {
        echo 'Error! No ID was passed.';
    }
    ?>



Thanks for any help that anyone can provide, this issue is really causing some stress and hurting my sleep at night! Can't figure out why this won't work, it's literally the last step in completing this website.
Please let me know if you need any other information regarding this issue.

Thanks,
- Mike

Ok, I have this code that is supposed to upload a csv file and save the contents into a specific sql table.  I am getting an error when i hit submit that states the file is empty, meaning the csv file.  I am thinking that the file isn't really being targeted i just don't know how to fix it.  To start i have a php page with a the form and then i have another php page that is included in the form php page.  The functions for submitting the csv info in the text file is located in the include file.  here is the code:

Code: [Select]
$csv = new Quick_CSV_import();

$arr_encodings = $csv->get_encodings(); //take possible encodings list
$arr_encodings["default"] = "[default database encoding]"; //set a default (when the default database encoding should be used)

if(!isset($_POST["encoding"]))
  $_POST["encoding"] = "default"; //set default encoding for the first page show (no POST vars)

if(isset($_POST["Go"]) && ""!=$_POST["Go"]) //form was submitted
{
  $csv->file_name = $HTTP_POST_FILES['file_source']['tmp_name'];
 
  //optional parameters
  $csv->use_csv_header = isset($_POST["use_csv_header"]);
  $csv->field_separate_char = $_POST["field_separate_char"][0];
  $csv->field_enclose_char = $_POST["field_enclose_char"][0];
  $csv->field_escape_char = $_POST["field_escape_char"][0];
  $csv->encoding = $_POST["encoding"];
 
  //start import now
  $csv->import();
}
else
  $_POST["use_csv_header"] = 1;
?>

<tr>
      <td>Source CSV file to import:</td>
      <td rowspan="30" width="10px">&nbsp;</td>
      <td><input type="file" name="file_source" id="file_source" class="edt" value="<?=$file_source?>"></td>
      </tr>
and

Code: [Select]
class Quick_CSV_import
{
  var $table_name = "tbl_product"; //where to import to
  var $file_name; //where to import from
  var $use_csv_header; //use first line of file OR generated columns names
  var $field_separate_char; //character to separate fields
  var $field_enclose_char; //character to enclose fields, which contain separator char into content
  var $field_escape_char;  //char to escape special symbols
  var $error; //error message
  var $arr_csv_columns; //array of columns
  var $table_exists; //flag: does table for import exist
  var $encoding; //encoding table, used to parse the incoming file. Added in 1.5 version
 
  function Quick_CSV_import()
  {
    $this->file_name = $file_name;
    $this->arr_csv_columns = array();
    $this->use_csv_header = true;
    $this->field_separate_char = ",";
    $this->field_enclose_char  = "\"";
    $this->field_escape_char   = "\\";
    $this->table_exists = false;
  }
 
  function import()
  {
    if($this->table_name=="")
      $this->table_name = "temp_".date("d_m_Y_H_i_s");
   
    $this->table_exists = false;
    $this->create_import_table();
   
    if(empty($this->arr_csv_columns))
      $this->get_csv_header_fields();
   
    /* change start. Added in 1.5 version */
    if("" != $this->encoding && "default" != $this->encoding)
      $this->set_encoding();
    /* change end */
   
    if($this->table_exists)
    {
      $sql = "LOAD DATA INFILE '".@mysql_escape_string($this->file_source).
             "' INTO TABLE `".$this-> table_name.
             "` FIELDS TERMINATED BY '".@mysql_escape_string($this->field_separate_char).
             "' OPTIONALLY ENCLOSED BY '".@mysql_escape_string($this->field_enclose_char).
             "' ESCAPED BY '".@mysql_escape_string($this->field_escape_char).
             "' ".
             ($this->use_csv_header ? " IGNORE 1 LINES " : "")
             ."(`".implode("`,`", $this->arr_csv_columns)."`)";
      $res = @mysql_query($sql);
      $this->error = mysql_error();
    }
  }
 
  //returns array of CSV file columns
  function get_csv_header_fields()
  {
    $this->arr_csv_columns = array();
    $fpointer = fopen($file_name, "r");
    if ($fpointer)
    {
      $arr = fgetcsv($fpointer, 10*1024, $this->field_separate_char);
      if(is_array($arr) && !empty($arr))
      {
        if($this->use_csv_header)
        {
          foreach($arr as $val)
            if(trim($val)!="")
              $this->arr_csv_columns[] = $val;
        }
        else
        {
          $i = 1;
          foreach($arr as $val)
            if(trim($val)!="")
              $this->arr_csv_columns[] = "column".$i++;
        }
      }
      unset($arr);
      fclose($fpointer);
    }
    else
      $this->error = "file cannot be opened: ".(""==$this->file_name ? "[empty]" : @mysql_escape_string($this->file_name));
    return $this->arr_csv_columns;
  }
i just can't figure it out.  could anyone help me out?  the error i get says this:  Warning: fopen() [function.fopen]: Filename cannot be empty in /Quick_CSV_import.php on line 83

Hello,

I am working on a project that downloads large zip files from server, for small files the script works well and downlaod files successfully, but for larger files like currently we are trying to download a 922MB file it gives us this message (in firefox) and doesn't download any thing.

"
File not found

Firefox can't find the file at http://www.domainname.com/abc.zip

"
Script to download the file is as below:

"
$filename = "xyz.mp3;

header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");

header("Content-Disposition: attachment; filename=".basename($filename).";");

header("Content-Transfer-Encoding: binary");
header("Content-Length: ".filesize($filename));

if( !ini_get('safe_mode') )
set_time_limit(360000000);

readfile("$filename");
"

Please advise what can be issue, if its file size issue then how and where can we increase the limit to solve this issue.

pre-thanks,

I am trying to run the following code to upload a file. (WAMP using Win XP). Once I select the file and click submit I get the error: "Forbidden... You don't have permission to access /< on this server." with URL http://localhost/<?=$PHP_SELF?>
Code is below:

<form action="<?=$PHP_SELF?>" method="post" enctype="multipart/form-data">
<br/><br/>
Choose a file to upload:<br/>
<input type="file" name="upload_file">
<br/>
<input type="submit" name="submit" value="submit">
</form>


TIA

Hi Guys, I'm trying to build a form which includes a file field. The idea is that it will upload the file and then email it as an attachment, I couldnt' figure that out at all so I thought I'd go with uploading the file and including a link to it in the email, however that isn't working either and I don't understand why... i'm not getting any error messages and the upload folder is set to 777.

if (($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      $fileLink = $siteroot. "/upload/" . $_FILES["file"]["name"];
      }
  }
else
  {
  echo "Invalid file";
  }
$to = str_replace('info', 'sales', $sc_email);  
$subject = "Quotation request from website";
$body = "From: ".$_POST['first_name']." ".$_POST['last_name']."\n";
if ($_POST['job_title']) {
$body .= "(".$_POST['job_title']." at ".$_POST['your_company'].")\n";
}
$body .= "E-Mail: ".$_POST['your_email']."\n";
$body .= "Telephone: ".$_POST['your_telephone']."\n";
$body .= "Address:\n ".$_POST['your_address']." ,".$_POST['your_country']."\n\n";
$body .= "Project: ".$_POST['project_details']."\n";
$body .= "Translate to: ".$_POST['lang_target']." from ".$_POST['lang_source']."\n";
$body .= "by: ".$_POST['project_deadline'];
$body .= "The text: ".$_POST['text_to_translate'];
$body .= "Link to attachment: <a href=".$fileLink."> Link </a>";

Just helping me to figure out this would be enough but if anyone has a solution to the emailng as attatchment thing that would be even better. I've looked at a few tutorials but they seem a bit confusing.

Thanks in advance.

Main script gets class information from a database and prints them so long as the class start date or end date is after today (actually includes today). Main script calls "instructors.php".  It queries another database based on the instructor name ($chef) and then prints the bio information for that instructor.   "instructors.php" works fine on it's own, when I add "$chef = "Chef Name" ("Chef Name" is in the Instructors database).  When it's called from the main script, nothing shows up in that area - even though "Chef Name" is in the database.  All of the other data is printed fine, just not anything from instructors.php.  I verified that it's actually including the file, as I can add "echo "test";" to the top of instructors.php and it prints fine in the main script.   Any ideas of what I'm missing?       Main Script 

<?php 

// Get required login info
include "/path/to/login/info/file.php"; // Get required login info - changed for this post.

$db = new mysqli('localhost', $username, $password, $database); // Connect to DB using required login info
if($db->connect_errno > 0){
    die('Unable to connect to database [' . $db->connect_error . ']');
}

unset($username);// put these variables back to null
unset($password);// put these variables back to null
unset($database);// put these variables back to null


//query db
$sql = <<<SQL
    SELECT *
    FROM `ft_form_7`
	WHERE DATE(class_start_date) >= CURDATE()
	OR DATE(class_end_date) >= CURDATE()
	ORDER BY class_start_date ASC
SQL;

if(!$result = $db->query($sql)){ // if there is an error in running the query, show error message.
    die('There was an error running the query [' . $db->error . ']');
}

while($row = $result->fetch_assoc()){
	// Get start date information
	$start_date = $row['class_start_date']; // Get event_start_date for conversion and call it $start_date
	$start_date_formatted = date("l M d, Y", strtotime($start_date)); // Convert start_date 
	$end_date = $row['class_end_date']; // Get event_end_date for conversion and call it $start_date
	$end_date_formatted = date("M d, Y", strtotime($end_date)); // Convert start_date
	
	// Get time information.
	$start_time = $row['class_start_time']; // Get event_start_time for conversion and call it $start_time
	$start_time_formatted = date("h:i A", strtotime($start_time)); // Convert start_time 
	$end_time = $row['class_end_time']; // Get event_end_time for conversion and call it $end_time
	$end_time_formatted = date("h:i A", strtotime($end_time)); // Convert end_time 
	
	// echo information...
	    echo "<h2>" , $row['class_name'],"</h2>" ; // echo event name
	    echo "<p><strong>",$start_date_formatted; // echo the start date
		if (empty($start_time)) { echo ''; } else { echo " (", $start_time; } // echo start time
		if (empty($end_date)) { echo ''; } else { echo " -","<br />", $end_date_formatted; } // echo end date
		if (empty($end_time)) { echo ')'; } else { echo " - ", $end_time, ")"; } // echo end time
	// if there is no start time, echo nothing. (otherwise it seems to echo 4pm). If it does contain a time, echo the time.
	echo "</strong><br />";

	$chef = $row['Instructor'];
	global $chef;
	
	if ($chef != NULL) {
		require ('instructors.php'); }
	echo $row['class_description'], "<br />";
	echo "<strong>" , $row['type'], "&nbsp;-&nbsp;Cost: &#36;",$row['cost'] , " - #" , $row['course_number'] , "</strong><br />" , "</p>"; // echo class type and cost
}

$db->close();
$result->free();

?>

 instructors.php

<?php

include "/path/to/login/info/file.php"; // Get required login info - changed for this post.

$db_instructors = new mysqli('localhost', $username, $password, $database); // Connect to DB using required login info
if($db_instructors->connect_errno > 0){
    die('Unable to connect to database [' . $db_instructors->connect_error . ']');
}

unset($username);// put these variables back to null
unset($password);// put these variables back to null
unset($database);// put these variables back to null

//query db
$sql_instructors = <<<SQL
    SELECT *
    FROM ft_form_8
    WHERE chef_name = '$chef'
SQL;

if(!$result_instructors = $db_instructors->query($sql_instructors)) { // if there is an error in running the query, show error message.
    die('There was an error running the query [' . $db_instructors->error . ']');
}

	while($row_instructors = $result_instructors->fetch_assoc()) {
	$chef_full_name = $row_instructors['chef_name'];
	$chef_id = $row_instructors['submission_id'];
	$full_bio = $row_instructors['full_bio'];
	echo "<a href=\"#\" class=\"clickme\">" , $chef_full_name , "</a>";
	echo "<div class=\"box\">";
	echo $full_bio , "</div>";
}


$db_instructors->close();
$result_instructors->free();

?>

I have this code:
$shell = new COM('WScript.Shell');
$shell->Run("C:\WINDOWS\system32\cmd.exe /K ".$ini['indexer']['command'], 0, false);

When it runs, it opens the command line, but then when it is done, it leaves the process open. How can I close it when the process is complete?

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}