Advertisement
reenadak

php duplicate item

Feb 26th, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.31 KB | None | 0 0
  1.           $sql = "SELECT md_day from ". tblMain ." where md_day BETWEEN ".$val." AND DATE_SUB( ".$val.", INTERVAL 1 MONTH ) ";
  2.           $query = DBC::get()->prepare( $sql );
  3.           $query->execute();
  4.           $results = $query->fetchAll();
  5.           $str_date = "";
  6.  
  7.           foreach( $results as $row )
  8.           {
  9.             $str_date = $str_date ." - ". $row['md_day'];
  10.           }
  11.  
  12.  
  13.   function validate_md_day($col,$val,$row,$instanceName)
  14.   {
  15.     if($row['id']) // check if edit or add.
  16.     {
  17.       $add = false; $edit = true;
  18.        $this->Editor->addTooltipMsg('record is being EDITED ');
  19.  
  20.        $query = "SELECT * from ". tblMain ." where md_day = :md_day";
  21.        $queryParams = array('md_day' => $val);
  22.        $stmt = DBC::get()->prepare($query);
  23.        $stmt->execute($queryParams);
  24.         if($row = $stmt->fetch())
  25.         {
  26.           $this->Editor->showDefaultValidationMsg = false;
  27.           $this->Editor->addTooltipMsg('There is already a row with id = ' . $row['id'] );
  28.           return false;
  29.         }
  30.         else
  31.         {
  32.           $this->Editor->showDefaultValidationMsg = false;
  33.           $this->Editor->addTooltipMsg('Entered date is available ' . $val );
  34.           return false;
  35.         }
  36.     }
  37.     else
  38.     {
  39.       // Record is being added.  
  40.       $query = "SELECT * from ". tblMain ." where md_day = :md_day";
  41.       $queryParams = array('md_day' => $val);
  42.       $stmt = DBC::get()->prepare($query);
  43.       $stmt->execute($queryParams);
  44.  
  45.       if($row = $stmt->fetch())
  46.       {
  47.           $this->Editor->showDefaultValidationMsg = false;
  48.           $this->Editor->addTooltipMsg('Following dates are already taken. = '  );
  49.           return false;
  50.         }
  51.         else
  52.         {
  53.           $this->Editor->showDefaultValidationMsg = false;
  54.           $this->Editor->addTooltipMsg('Entered date is available & ok ' . $val );
  55.           return true;
  56.         }
  57.     }    
  58.   }
  59.  
  60.  
  61.           $sql = "SELECT md_day from ". tblMain ." where md_day BETWEEN ".$val." AND DATE_SUB( ".$val.", INTERVAL 1 MONTH ) ";
  62.           $query = DBC::get()->prepare( $sql );
  63.           $query->execute();
  64.           $results = $query->fetchAll();
  65.           $str_date = "";
  66.  
  67.           foreach( $results as $row )
  68.           {
  69.             $str_date = $str_date ." - ". $row['md_day'];
  70.           }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement