PHP - Php Sql Profile Updates

Hi all,

I am currently facing a problem, if you look at 'viewprofile.jpg' attachment, you can see that there is an uploaded profile picture.

However when I click to edit the profile, the picture is missing (editprofile.jpg), I am just wondering what went wrong? Can someone guide me in troubleshooting this problem?


Code: [Select]
<?php
if (isset($_POST['submit'])) {
  
    // Validate and move the uploaded picture file, if necessary
if (!empty($new_picture)) {
      if ((($new_picture_type == 'image/gif') || ($new_picture_type == 'image/jpeg') || ($new_picture_type == 'image/pjpeg') ||
        ($new_picture_type == 'image/png')) && ($new_picture_size > 0) && ($new_picture_size <= CT_MAXFILESIZE)) {
        //0 indicates a success, other values indicate failure
if ($_FILES['file']['error'] == 0) {
          // Move the file to the target upload folder
          $target = CT_UPLOADPATH . basename($new_picture);
          if (move_uploaded_file($_FILES['new_picture']['tmp_name'], $target)) {
            // The new picture file move was successful, now make sure any old picture is deleted
            if (!empty($old_picture) && ($old_picture != $new_picture)) {
              @unlink(CT_UPLOADPATH . $old_picture);
            }
          }
          else {
            // The new picture file move failed, so delete the temporary file and set the error flag
            @unlink($_FILES['new_picture']['tmp_name']);
            $error = true;
            echo '<p class="error">Sorry, there was a problem uploading your picture.</p>';
          }
        }
      }
      else {
        // The new picture file is not valid, so delete the temporary file and set the error flag
        @unlink($_FILES['new_picture']['tmp_name']);
        $error = true;
        echo '<p class="error">Your picture must be a GIF, JPEG, or PNG image file no greater than ' . (CT_MAXFILESIZE / 1024). '</p>';
      }
    }


// Grab the profile data from the POST
    $name = mysqli_real_escape_string($dbc, trim($_POST['name']));
    $nric = mysqli_real_escape_string($dbc, trim($_POST['nric']));
    $gender = mysqli_real_escape_string($dbc, trim($_POST['gender']));
    

    $old_picture = mysqli_real_escape_string($dbc, trim($_POST['old_picture']));
    $new_picture = mysqli_real_escape_string($dbc, trim($_FILES['new_picture']['name']));
    $new_picture_type = $_FILES['new_picture']['type'];
    $new_picture_size = $_FILES['new_picture']['size']; 
    list($new_picture_width, $new_picture_height) = getimagesize($_FILES['new_picture']['tmp_name']);


    $error = false;

    

    // Update the profile data in the database
    if (!$error) {
      if (!empty($name) && !empty($nric) && !empty($gender)) {
        
$query = "UPDATE tutor_profile SET name = '$name', nric = '$nric', gender = '$gender' WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

mysqli_query($dbc, $query)
or die(mysqli_error($dbc));

        // Confirm success with the user
        echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile.php?tutor_id=' . $_GET['tutor_id'] . '">view your profile</a>?</p>';

        mysqli_close($dbc);
        exit();
      }
      else {
        echo '<p class="error">You must enter all of the profile data (the picture is optional).</p>';
      }
    }
  } // End of check for form submission
  else {
    // Grab the profile data from the database
    $query = "SELECT name, nric, gender FROM tutor_profile WHERE tutor_id = '" . $_GET['tutor_id'] . "'";
    
$data = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));

// The user row was found so display the user data
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);

    if ($row != NULL) {
      $name = $row['name'];
      $nric = $row['nric'];
      $gender = $row['gender'];
    }
    else {
      echo '<p class="error">There was a problem accessing your profile.</p>';
    }
  }
  }

  mysqli_close($dbc);
?>

  <form enctype="multipart/form-data" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo CT_MAXFILESIZE; ?>" />

<ul id="tabSet_ep">
<li><a href="#panel1">Personal Profile</a></li>
<li><a href="#panel2">Qualifications</a></li>
<li><a href="#panel3">Tutor\'s Comments/Commitment</a></li>
<li><a href="#panel4">Tutoring Levels/Subjects</a></li>
</ul>

<!--Personal Profile-->
<div id="panel1">
      <label for="new_picture">Pictu </label>
      <input type="file" id="new_picture" name="new_picture" />
      <?php if (!empty($old_picture)) {
        echo '<img class="profile" src="' . CT_UPLOADPATH . $old_picture . '" alt="Profile Picture" />';
      } ?><br />
  <label for="firstname">First name:</label>
      <input type="text" id="firstname" name="firstname" value="<?php if (!empty($name)) echo $name; ?>" /><br />
      <label for="lastname">Last name:</label>
      <input type="text" id="lastname" name="lastname" value="<?php if (!empty($nric)) echo $nric; ?>" /><br />
      <label for="gender">Gender:</label>
      <select id="gender" name="gender">
        <option value="M" <?php if (!empty($gender) && $gender == 'M') echo 'selected = "selected"'; ?>>Male</option>
        <option value="F" <?php if (!empty($gender) && $gender == 'F') echo 'selected = "selected"'; ?>>Female</option>
      </select><br />
    </div>

    <input type="submit" value="Save Profile" name="submit" />
  </form>

Hi, I am new to PHP and mySQL. I am working on a golf site where it will need to have the user update info through text boxes. There are two things: 1) It will need to keep an average of the last 6 rounds. The user will need to be able to input the current round score and have it bump the oldest score of the database. 2) Also, i have a database of players that will populate a <select>. Is there a way to have the user be able to add/delete player names from this database? My question is what functions are needed to get this done. And how does one go about implementing them.
Thanks in advance!
Taylor

I have a script that has a foreach loop. The script ususally runs for VERY VERY long time ( i have set_time_limit(0)

Now what I need it to do is to echo some string at the end of each loop. However it doesn't. The script displays everything after its finished.

That's not acceptable for me.

I'm running xampp for windows.

Ok this has been driving me crazy for days now. I need to update my DB with multiple data parsed from an XML feed. I need some help in putting together the query.

Currently I have:
Code: [Select]
$xml= 'test-feed.xml'; // URL for feed.



try{
  $feed = new SimpleXMLElement($xml, null, true);
}catch(Exception $e){
  echo $e->getMessage();
  exit;
}


$sqlxml = "";
$arr = array();

foreach($feed->property as $property) {

 $propertyid = (string)$property->id;
 
 foreach($property->images->image as $image) {
 $i = 0;
  $url = (string)$image->url;
  $arr[] = "UPDATE property SET url = '$url' WHERE prop_id = '$propertyid', ";
 $i++;
 
 
 }

}

foreach($arr as $result) $sql .= $result;


$sql = rtrim($sql, ",");

echo $sql;


if(!mysql_query($sql)){
  echo '<h1 style="color: red;">Error</h1><p>', mysql_error(), '</p>';
}
else
{

  echo '<h1 style="color: red;">Property data successfully added to database!</h1>';
}

This structures the query correctly for a single update but repeats it which then throws a MYSQL Syntax error. I am not sure of the correct syntax to use for multiple inserts??

What I get returned at the moment is:

Code: [Select]
UPDATE property SET url = 'ImageId=X1000245' WHERE prop_id = 'A1234', UPDATE property SET url = 'ImageId=X1000296' WHERE prop_id = 'A1234', UPDATE property SET url = 'ImageId=P3&ImgId=X1000237' WHERE prop_id = 'ABC1234',
Need some intervention guys

Thanks in advance

GT

I have a form which shows products ordered from a catalog, it used to work fine when I had individual change buttons for each item, now I have to have multiple check boxes for removing items and the ability to change the quantities of multiple items with a single button. I know you have to use foreach and arrays for this but I am confusing myself trying to make the changes for it to update the correct items.

Attached is a pic of what the form looks like and is how it is supposed to function

here is the form part
Code: [Select]
<?php 
for ($basket_counter=0;$basket_counter<$_SESSION['ses_basket_items'];$basket_counter++) {
   $price=sprintf("%01.2f",$ses_basket_price[$basket_counter]);
    $quantity=$ses_basket_amount[$basket_counter];
$code=$ses_basket_stockcode[$basket_counter];
$itemID=$ses_basket_id[$basket_counter];
    $name=$ses_basket_name[$basket_counter];
$image=$ses_basket_image[$basket_counter];
if ($country='AU') { $price=sprintf("%01.2f",($price*1.1));
$unit=sprintf("%01.2f",($price/$quantity));
 }
else
{ $unit=sprintf("%01.2f",($price/$quantity)); }
?><form method='post' action='' target="_self">
<tr>
  <td align='center' class='rescon' style="border-bottom:solid #330000 1px;"><input type="checkbox" name="remove[]" value="<?php echo $itemID; ?>" /></td>
  <td align='left' class='rescon' style="border-bottom:solid #330000 1px;"><img src="product_images/<?php echo $image; ?>" width="60" alt="<?php echo $name; ?>" title="<?php echo $name; ?>" /></td>
  <td align='left' class='rescon' style="border-bottom:solid #330000 1px;"><font size="+1"><?php echo $name; ?></font><br/><?php echo $code; ?></td>
            <td align='left' class='rescon' style="border-bottom:solid #330000 1px;">&nbsp;</td>
            <td align='center' class='rescon' style="border-bottom:solid #330000 1px;"><input name="price" type="hidden" value="<?php echo $unit; ?>"><input type="hidden" name="pageLink" value="<?php echo $pageLink; ?>" /><input name="basket[]" type="hidden" value="<?php echo $itemID; ?>"><input name="quantity[]" style="vertical-align:middle;" type="text" value="<?php echo $quantity; ?>" size="2" maxlength="5">&nbsp;</td>
            <td align='center' class='rescon' style="border-bottom:solid #330000 1px;">$<?php echo $unit; ?></td>
            <td class='rescon' align='right' bgcolor="#FFFF00" style="border-bottom:solid #330000 1px;">$<?php echo $price; ?>&nbsp;</td>
            </tr>
<?php }  
if ($country='AU') { $totalprice=sprintf("%01.2f",array_sum($ses_basket_price)); $totalprice=sprintf("%01.2f",($totalprice*1.1)); }
else
{ $totalprice=sprintf("%01.2f",array_sum($ses_basket_price)); }
    $totalitems=array_sum($ses_basket_amount); ?>
    <tr><td align='left' colspan='4' valign="top" class='cartbot'>&nbsp;</td>
            <td align='left' valign="top" class='cartbot'><?php echo $totalitems; ?>&nbsp;Items</td>
                <td align='right' colspan='2' class='cartbot'><?php echo "<b>Subtotal:&nbsp;&nbsp;$".$totalprice."&nbsp;</b>"; ?></b></td>
          </tr>
    <tr>
      <td align='left' colspan='5' valign="top"><input type="submit" id="change" name="change" style="vertical-align:middle;" value="Change"></td>
      <td align='right' colspan='2'>&nbsp;</td>
  </tr></form>
and here is the processing part at the top of the page which I have sorta shagged, could use some help getting it to update the correct items for remove and quantity changes
// cart application
if (isset($_POST['change'])) {
$basket = $_POST['basket'];
// check faor AU to include GST
if ($country='AU') { $itemprice = sprintf("%01.2f",(($_POST['price']/11)*10)); }
else
{ $itemprice = $_POST['price']; }
$itemqty = $_POST['quantity'];
$newprice = ($itemprice*$itemqty);
if (($basket!="") && (isset($_POST['change']))){
    if ($_SESSION['ses_basket_items']){
// basket position
$basket_position_counter=0;
// double entry flag set to NO
$double=0;
// Check for existing basket id
if ($_SESSION['ses_basket_items']>0){
   foreach ($ses_basket_id as $basket_item){
      if ($basket_item==$basket){
         // If exist flag for update
 $double=1;
         $basket_position=$basket_position_counter;
      }
  // Add new basket position
      $basket_position_counter++;
   }
}
// Update basket with new quantity and price
if ($double==1){
   $ses_basket_amount[$basket_position]=$itemqty;
   $ses_basket_price[$basket_position]=$newprice;
}
}
// Delete Item when set to 0
if ($itemqty == "0") {
array_splice ($ses_basket_name, $basket_position, 1);
array_splice ($ses_basket_amount, $basket_position, 1);
array_splice ($ses_basket_price, $basket_position, 1);
array_splice ($ses_basket_stockcode, $basket_position, 1);
array_splice ($ses_basket_image, $basket_position, 1);
array_splice ($ses_basket_id, $basket_position, 1);
$_SESSION['ses_basket_items']--;
}
if (isset($remove) && ($remove!='')) {
$remove = $_POST['remove'];
     if(count($remove) > 0){
        foreach($remove AS $removed){
  array_splice ($ses_basket_name, $basket_position, 1);
array_splice ($ses_basket_amount, $basket_position, 1);
array_splice ($ses_basket_price, $basket_position, 1);
array_splice ($ses_basket_stockcode, $basket_position, 1);
array_splice ($ses_basket_image, $basket_position, 1);
array_splice ($ses_basket_id, $basket_position, 1);
$_SESSION['ses_basket_items']--;
         }
     }
}
}
if ($_SESSION['ses_basket_items']==0){
unset($_SESSION['ses_basket_items']);
unset($_SESSION['ses_basket_name']);
unset($_SESSION['ses_basket_amount']);
unset($_SESSION['ses_basket_price']);
unset($_SESSION['ses_basket_stockcode']);
unset($_SESSION['ses_basket_image']);
unset($_SESSION['ses_basket_id']);
header("Location: $pageLink");
}
}

the array variables I have here are $basket, $remove and $quantity.