Advertisement
Golden_Rus

Untitled

Jun 28th, 2015
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.92 KB | None | 0 0
  1. <?
  2. if($_POST['email'])
  3. {
  4.     include('connectSQL.php');
  5.     $email=$_POST['email'];
  6.     if($_POST['item'])
  7.     {
  8.         $item = $_POST['item'];
  9.         $query = mysqli_query($sql, "SELECT * From Accounts WHERE Email='" . $email . "'");
  10.         $row = mysqli_fetch_array($query);
  11.  
  12.         $name=$row['Cart_name'];
  13.         $cena=$row['Cart_cena'];
  14.  
  15.         $_cena=explode('|', $cena);
  16.         $_name=explode('|', $name);
  17.            
  18.         $key = array_search($item, $_name);
  19.         unset($_name[$key]);
  20.         unset($_cena[$key]);
  21.         $arr_name=array_values($_name);
  22.         $arr_cena=array_values($_cena);
  23.        
  24.         unset($_name);
  25.         unset($_cena);
  26.        
  27.        
  28.         for($i=1;$i<count($arr_name);$i++)
  29.         {
  30.             $_name=$_name . '|' . $arr_name[$i];
  31.             $_cena=$_cena . '|' . $arr_cena[$i];
  32.         }
  33.        
  34.         mysqli_query($sql,"UPDATE Accounts SET Cart_name = '". $_name ."' , Cart_cena = '".$_cena."' WHERE Email = '".$email."'");
  35.     }
  36.     else
  37.     {
  38.         mysqli_query($sql,"UPDATE Accounts SET Cart_name = '' , Cart_cena = '' WHERE Email = '".$email."'");
  39.     }
  40. }
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement