Jump to content

alter my code

emediastudios

By emediastudios
in PHP Coding Help

 Share

Recommended Posts

emediastudios Advanced Member

emediastudios

Posted
Posted

I have this code i had built and i want to use it in another site with a couple of alterations.

I just want to take out "history" and "position applying for"

The code works fine, but when i take out the pieces of code i think that should go, i get the returned error "failed to insert user data"

 

This is the complete code

<?php 
include_once('includes/include.php');
$pageTitle = "Join Our Team";
$upload_dir = "upload/";

//Experinced Users only Beyond this point except for formatting which will be commented


$form = '<form enctype="multipart/form-data" action="upload_resume.php?submit=2" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="10240000" />
<input type="hidden" name="email" value="'.$_POST[email].'" />
Files must be of PDF format.<br>Max file size, one meg.<br><br>Attach Resume: <input name="uploadedfile" type="file" /><br />
<input type="submit" value="Upload File" />
</form>';



//FORMAT HERE


//VERY IMPORTANT:  make sure that you use " if the entire string is surrounded by ' and vice versa
//otherwise you'll fuck yourself over


    //the table goes here
    $content3 .= '<table width="650">';
    $content3 .= '<form method="post" action="upload_resume.php?submit=1">';
    $content3 .= '<tr><td width="150">Name: </td><td width="150"><input type="text" style="width:175px" class="fields" name="name" value="'.$_POST[name].'" /></td></tr>';
    $content3 .= '<tr><td width="150">Email Address: </td><td width="150"><input type="text" style="width:175px" class="fields" name="email" value="'.$_POST[email].'" /></td></tr>';
    $content3 .= '<tr><td width="150">Contact Number: </td><td width="150"><input type="text" style="width:175px" class="fields" name="contact"  value="'.$_POST[contact].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Mobile Number: </td><td width="150"><input type="text" style="width:175px" class="fields" name="mobile"  value="'.$_POST[mobile].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Address Line 1: </td><td width="150"><input type="text" style="width:175px" class="fields" name="ad1"  value="'.$_POST[ad1].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Address Line 2: </td><td width="150"><input type="text" style="width:175px" class="fields" name="ad2"  value="'.$_POST[ad2].'"/></td></tr>';
    $content3 .= '<tr><td width="150">City: </td><td width="150"><input type="text" style="width:175px" class="fields" name="city"  value="'.$_POST[city].'"/></td></tr>';
    $content3 .= '<tr><td width="150">State: </td><td width="150" class="fields1">';
    $content3 .= '<select name="state" style="width:179px" class="fields">
  <option value="">Please Select</option>
<option value="NSW"';
       if($_POST[state] == "NSW") $content3 .= " selected='selected'"; 
      $content3 .= '>New South Wales</option>
<option value="NT"';
       if($_POST[state] == "NT") $content3 .= " selected='selected'"; 
      $content3 .= '>Northern Territory</option>
<option value="QLD';
       if($_POST[state] == "QLD") $content3 .= " selected='selected'"; 
      $content3 .= '">Queensland</option>
<option value="SA"';
       if($_POST[state] == "SA") $content3 .= " selected='selected'"; 
      $content3 .= '>South Australia</option>
<option value="TAS"';
       if($_POST[state] == "TAS") $content3 .= " selected='selected'"; 
      $content3 .= '>Tasmania</option>
<option value="VIC"';
       if($_POST[state] == "VIC") $content3 .= " selected='selected'"; 
      $content3 .= '>Victoria</option>
<option value="WA"';
       if($_POST[state] == "WA") $content3 .= " selected='selected'"; 
      $content3 .= '>Western Australia</option>

</select></td></tr>
';
$content3 .= '<tr><td width="150">Zip Code: </td><td width="150"><input type="text" style="width:175px" class="fields" name="post"  value="'.$_POST[post].'" /></td></tr>';
$content3 .='<tr><td width="150">Date Of Birth: </td><td width="150">';
$content3 .='
<select name="dateofbirthday">
<option value="">DD</option>';

for($i = 1; $i <= 31; $i++)
{
  if(strlen($i) < 1) $i = '0' . $i;
  if($_POST[dateofbirthday] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select>
<select name="dateofmonth">
<option value="">MM</option>';

for($i = 1; $i <= 12; $i++)
{
  if(strlen($i) < 1) $i = '0' . $i;
  if($_POST[dateofmonth] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select>
<select name="dateofbirthyear">
<option value="">YYYY</option>';

for($i = date('Y') - 100; $i <= date('Y') - 16; $i++)
{
  if($_POST[dateofbirthyear] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select></td></tr>';
$content3 .= '<tr><td width="150">Position Applying For: </td><td width="150"><input type="text" style="width:175px" class="fields" name="position"  value="'.$_POST[position].'"/></td></tr>';
$content3 .= '<tr><td colspan="2">History: </td></tr><tr><td colspan="2"><textarea name="history" cols=35 rows=8>'.$_POST[history].'</textarea></td></tr>';
$content3 .= '<tr><td colspan="2" align="left"><input type="submit" value="Next"/></td></tr></form></table>';
  if($_GET['submit'] == ""){
   $content .= $content3;
  }
  else if($_GET[submit] == '1'){
   //the mysql goes here
    if(!EmailChk($_POST[email])){$kill=1; $content2 .= "Invalid Email Address<br>";}
    if(!EmailCheck($_POST[email])){$kill=1; $content2 .= "Duplicate Email Address<br>";}
    if($_POST[contact] == ""){$kill=1; $content2 .= "Enter a Phone Number (Normal)<br>";}
    if($_POST[mobile] == ""){$kill=1; $content2 .= "Enter a Phone Number (Mobile)<br>";}
    if($_POST[dateofmonth] == ""){$kill=1; $content2 .= "Enter a Birth Month<br>";}
    if($_POST[dateofbirthday] == ""){$kill=1; $content2 .= "Enter a Birth Day<br>";}
    if($_POST[dateofbirthyear] == ""){$kill=1; $content2 .= "Enter a Birth Year<br>";}
    if($_POST[state] == ""){$kill=1; $content2 .= "Enter a State<br>";}
    if($_POST[name] == ""){$kill=1; $content2 .= "Enter a Name<br>";}
    if($_POST[city] == ""){$kill=1; $content2 .= "Enter a City<br>";}
    if($_POST[ad1] == ""){$kill=1; $content2 .= "Enter an Address<br>";}
    if($_POST[post] == ""){$kill=1; $content2 .= "Enter a Postal Code<br>";}
    if($_POST[history] == ""){$kill=1; $content2 .= "Enter work History<br>";}
    if($kill != 1){
     $_POST[address] = $_POST[ad1] . "\n" . $_POST[ad2];
     $_POST[ad1] = "";
     $_POST[ad2] = "";
     $_POST[dob] = $_POST[dateofmonth] . "/" . $_POST[dateofbirthday] . "/" . $_POST[dateofbirthyear];
     $_POST[dateofmonth] = "";
     $_POST[dateofbirthyear] = "";
     $_POST[dateofbirthday] = "";
     $q = "INSERT INTO resume(name,dob,address,city,state,post,contact,mobile,position,history,email,file) VALUES ('".$_POST[name]."','".$_POST[dob]."','".$_POST[address]."','".$_POST[city]."','".$_POST[state]."','".$_POST[post]."','".$_POST[contact]."','".$_POST[mobile]."','".$_POST[position]."','".$_POST[history]."','".$_POST[email]."','')";
     if(!mysql_query($q)) $content .= "failed to insert user data";
     else{
      $content .= $form;
     }
    }
    else $content.= $content2 . "<br><br><br>" . $content3;


  }
  else if($_GET[submit] == '2'){
     $target_path = $upload_dir;
     while(file_exists($target_path)){
      $random3 = (rand()%999999);
      $target_path = $target_path . $random3 . basename( $_FILES['uploadedfile']['name']);
     }
     if(strtolower($_FILES['uploadedfile']['name']) != str_replace(".pdf", "", strtolower($_FILES['uploadedfile']['name']))){
      if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
        $content .= "The file ".  basename( $_FILES['uploadedfile']['name']).
         " has been uploaded for email address:<br> ". $_POST[email];
         mysql_query("UPDATE resume SET file = '".$target_path."' WHERE email='".$_POST[email]."'");
mail("design@sdemail.com.au","New Employment Application at your website", "Please go to your website to see the application", "From: webmaster@emediastudios.com.au");
         
      } else{
        $content .= 'There was an error uploading the file, please try again!<br>';
        $content .= $form;
      }
     }
     else{
     $content .= 'Must Be A .pdf File<br>';
     $content .= $form;
     }

  }
$pageTitle = "Join Our Team";
include('employment.php');

?>

 

I thought i could take out these sections of code, but errors for me  ???

 

$content3 .='</select></td></tr>';
$content3 .= '<tr><td width="150">Position Applying For: </td><td width="150"><input type="text" style="width:175px" class="fields" name="position"  value="'.$_POST[position].'"/></td></tr>';
$content3 .= '<tr><td colspan="2">History: </td></tr><tr><td colspan="2"><textarea name="history" cols=35 rows=8>'.$_POST[history].'</textarea></td></tr>';

    if($_POST[post] == ""){$kill=1; $content2 .= "Enter a Postal Code<br>";}
    if($_POST[history] == ""){$kill=1; $content2 .= "Enter work History<br>";}



position,history,

'".$_POST[position]."','".$_POST[history]."'

Link to comment
Share on other sites
runnerjp Advanced Member

runnerjp

Posted
Posted

here you go... did this one free!

 

<?php 
include_once('includes/include.php');
$pageTitle = "Join Our Team";
$upload_dir = "upload/";

//Experinced Users only Beyond this point except for formatting which will be commented


$form = '<form enctype="multipart/form-data" action="upload_resume.php?submit=2" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="10240000" />
<input type="hidden" name="email" value="'.$_POST[email].'" />
Files must be of PDF format.<br>Max file size, one meg.<br><br>Attach Resume: <input name="uploadedfile" type="file" /><br />
<input type="submit" value="Upload File" />
</form>';



//FORMAT HERE


//VERY IMPORTANT:  make sure that you use " if the entire string is surrounded by ' and vice versa
//otherwise you'll fuck yourself over


    //the table goes here
    $content3 .= '<table width="650">';
    $content3 .= '<form method="post" action="upload_resume.php?submit=1">';
    $content3 .= '<tr><td width="150">Name: </td><td width="150"><input type="text" style="width:175px" class="fields" name="name" value="'.$_POST[name].'" /></td></tr>';
    $content3 .= '<tr><td width="150">Email Address: </td><td width="150"><input type="text" style="width:175px" class="fields" name="email" value="'.$_POST[email].'" /></td></tr>';
    $content3 .= '<tr><td width="150">Contact Number: </td><td width="150"><input type="text" style="width:175px" class="fields" name="contact"  value="'.$_POST[contact].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Mobile Number: </td><td width="150"><input type="text" style="width:175px" class="fields" name="mobile"  value="'.$_POST[mobile].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Address Line 1: </td><td width="150"><input type="text" style="width:175px" class="fields" name="ad1"  value="'.$_POST[ad1].'"/></td></tr>';
    $content3 .= '<tr><td width="150">Address Line 2: </td><td width="150"><input type="text" style="width:175px" class="fields" name="ad2"  value="'.$_POST[ad2].'"/></td></tr>';
    $content3 .= '<tr><td width="150">City: </td><td width="150"><input type="text" style="width:175px" class="fields" name="city"  value="'.$_POST[city].'"/></td></tr>';
    $content3 .= '<tr><td width="150">State: </td><td width="150" class="fields1">';
    $content3 .= '<select name="state" style="width:179px" class="fields">
  <option value="">Please Select</option>
<option value="NSW"';
       if($_POST[state] == "NSW") $content3 .= " selected='selected'"; 
      $content3 .= '>New South Wales</option>
<option value="NT"';
       if($_POST[state] == "NT") $content3 .= " selected='selected'"; 
      $content3 .= '>Northern Territory</option>
<option value="QLD';
       if($_POST[state] == "QLD") $content3 .= " selected='selected'"; 
      $content3 .= '">Queensland</option>
<option value="SA"';
       if($_POST[state] == "SA") $content3 .= " selected='selected'"; 
      $content3 .= '>South Australia</option>
<option value="TAS"';
       if($_POST[state] == "TAS") $content3 .= " selected='selected'"; 
      $content3 .= '>Tasmania</option>
<option value="VIC"';
       if($_POST[state] == "VIC") $content3 .= " selected='selected'"; 
      $content3 .= '>Victoria</option>
<option value="WA"';
       if($_POST[state] == "WA") $content3 .= " selected='selected'"; 
      $content3 .= '>Western Australia</option>

</select></td></tr>
';
$content3 .= '<tr><td width="150">Zip Code: </td><td width="150"><input type="text" style="width:175px" class="fields" name="post"  value="'.$_POST[post].'" /></td></tr>';
$content3 .='<tr><td width="150">Date Of Birth: </td><td width="150">';
$content3 .='
<select name="dateofbirthday">
<option value="">DD</option>';

for($i = 1; $i <= 31; $i++)
{
  if(strlen($i) < 1) $i = '0' . $i;
  if($_POST[dateofbirthday] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select>
<select name="dateofmonth">
<option value="">MM</option>';

for($i = 1; $i <= 12; $i++)
{
  if(strlen($i) < 1) $i = '0' . $i;
  if($_POST[dateofmonth] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select>
<select name="dateofbirthyear">
<option value="">YYYY</option>';

for($i = date('Y') - 100; $i <= date('Y') - 16; $i++)
{
  if($_POST[dateofbirthyear] == $i) $selection = " selected='selected'"; 
  $content3 .= '<option value="'. $i .'" '.$selection.'>'. $i .'</option>';
}

$content3 .='</select></td></tr>';
$content3 .= '<tr><td colspan="2" align="left"><input type="submit" value="Next"/></td></tr></form></table>';
  if($_GET['submit'] == ""){
   $content .= $content3;
  }
  else if($_GET[submit] == '1'){
   //the mysql goes here
    if(!EmailChk($_POST[email])){$kill=1; $content2 .= "Invalid Email Address<br>";}
    if(!EmailCheck($_POST[email])){$kill=1; $content2 .= "Duplicate Email Address<br>";}
    if($_POST[contact] == ""){$kill=1; $content2 .= "Enter a Phone Number (Normal)<br>";}
    if($_POST[mobile] == ""){$kill=1; $content2 .= "Enter a Phone Number (Mobile)<br>";}
    if($_POST[dateofmonth] == ""){$kill=1; $content2 .= "Enter a Birth Month<br>";}
    if($_POST[dateofbirthday] == ""){$kill=1; $content2 .= "Enter a Birth Day<br>";}
    if($_POST[dateofbirthyear] == ""){$kill=1; $content2 .= "Enter a Birth Year<br>";}
    if($_POST[state] == ""){$kill=1; $content2 .= "Enter a State<br>";}
    if($_POST[name] == ""){$kill=1; $content2 .= "Enter a Name<br>";}
    if($_POST[city] == ""){$kill=1; $content2 .= "Enter a City<br>";}
    if($_POST[ad1] == ""){$kill=1; $content2 .= "Enter an Address<br>";}
    
   
    if($kill != 1){
     $_POST[address] = $_POST[ad1] . "\n" . $_POST[ad2];
     $_POST[ad1] = "";
     $_POST[ad2] = "";
     $_POST[dob] = $_POST[dateofmonth] . "/" . $_POST[dateofbirthday] . "/" . $_POST[dateofbirthyear];
     $_POST[dateofmonth] = "";
     $_POST[dateofbirthyear] = "";
     $_POST[dateofbirthday] = "";
     $q = "INSERT INTO resume(name,dob,address,city,state,post,contact,mobile,email,file) VALUES ('".$_POST[name]."','".$_POST[dob]."','".$_POST[address]."','".$_POST[city]."','".$_POST[state]."','".$_POST[post]."','".$_POST[contact]."','".$_POST[mobile]."','".$_POST[email]."','')";
     if(!mysql_query($q)) $content .= "failed to insert user data";
     else{
      $content .= $form;
     }
    }
    else $content.= $content2 . "<br><br><br>" . $content3;


  }
  else if($_GET[submit] == '2'){
     $target_path = $upload_dir;
     while(file_exists($target_path)){
      $random3 = (rand()%999999);
      $target_path = $target_path . $random3 . basename( $_FILES['uploadedfile']['name']);
     }
     if(strtolower($_FILES['uploadedfile']['name']) != str_replace(".pdf", "", strtolower($_FILES['uploadedfile']['name']))){
      if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
        $content .= "The file ".  basename( $_FILES['uploadedfile']['name']).
         " has been uploaded for email address:<br> ". $_POST[email];
         mysql_query("UPDATE resume SET file = '".$target_path."' WHERE email='".$_POST[email]."'");
mail("design@sdemail.com.au","New Employment Application at your website", "Please go to your website to see the application", "From: webmaster@emediastudios.com.au");
         
      } else{
        $content .= 'There was an error uploading the file, please try again!<br>';
        $content .= $form;
      }
     }
     else{
     $content .= 'Must Be A .pdf File<br>';
     $content .= $form;
     }

  }
$pageTitle = "Join Our Team";
include('employment.php');

?> ... am i doing i right?

Link to comment
Share on other sites
runnerjp Advanced Member

runnerjp

Posted
Posted

it thiat case chnage this  

   
     if(!mysql_query($q)) $content .= "failed to insert user data";

 

to this

 

)$query = "INSERT INTO resume(name,dob,address,city,state,post,contact,mobile,email,file) VALUES ('".$_POST[name]."','".$_POST[dob]."','".$_POST[address]."','".$_POST[city]."','".$_POST[state]."','".$_POST[post]."','".$_POST[contact]."','".$_POST[mobile]."','".$_POST[email]."','')"; mysql_query($query) or die("Query failed: " . mysql_error());

Link to comment
Share on other sites
AndyB Regular Member

AndyB

Posted
Posted 

$q = "INSERT INTO resume(name,dob,address,city,state,post,contact,mobile,email,file) VALUES ('".$_POST[name]."','".$_POST[dob]."','".$_POST[address]."','".$_POST[city]."','".$_POST[state]."','".$_POST[post]."','".$_POST[contact]."','".$_POST[mobile]."','".$_POST[email]."','')";

 

10 fields listed

9 values stated

 

If you had error-trapping, it would have jumped out at you

   

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.