MySQL: Removing of duplicates

MySQL: Removing of duplicates

1. DELETE t1 FROM `my_table` t1, `my_table` t2
2. WHERE t1.`my_field` = t2.`my_field` AND t1.`id` > t2.`id`

PHP: Simple pagination with a Twitter Bootstrap

PHP: Simple pagination uses a Twitter Bootstrap layout:

1. $targetpage = "search.php";
2. $limit = 50; //Records per page
3. $total_pages = $total_count; //Total number of the records to paginate
4.  
5. $stages = 3;
6. $page = mysql_escape_string($_REQUEST['page']);
7. if ($page) {
8. $start = ($page - 1) * $limit;
9. } else {
10. $start = 0;
11. }
12. if ($page == 0) {
13. $page = 1;
14. }
15. $prev = $page - 1;
16. $next = $page + 1;
17. $lastpage = ceil($total_pages / $limit);
18. $LastPagem1 = $lastpage - 1;
19.  
20. $paginate = '';
21. if ($lastpage > 1) {
22.  
23. $paginate .= "<div class='pagination pagination-centered'><ul>";
24. if ($page > 1) {
25. $paginate.= "<li><a href='#' onclick='showpage($prev);'>«</a></li>";
26. } else {
27. $paginate.= "<li class='disabled'><span>«</span></li>";
28. }
29. if ($lastpage < 7 + ($stages * 2)) {
30. for ($counter = 1; $counter <= $lastpage; $counter++) {
31. if ($counter == $page) {
32. $paginate.= "<li class='active'><span>$counter</span></li>";
33. } else {
34. $paginate.= "<li><a href='#' onclick='showpage($counter);'>$counter</a></li>";
35. }
36. }
37. } elseif ($lastpage > 5 + ($stages * 2)) {
38. if ($page < 1 + ($stages * 2)) {
39. for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) {
40. if ($counter == $page) {
41. $paginate.= "<li class='active'><span>$counter</span></li>";
42. } else {
43. $paginate.= "<li><a href='#' onclick='showpage($counter);'>$counter</a></li>";
44. }
45. }
46.  
47. $paginate.= "<li class='disabled'><span>...</span></li>";
48. $paginate.= "<li><a href='#' onclick='showpage($LastPagem1);'>$LastPagem1</a></li>";
49. $paginate.= "<li><a href='#' onclick='showpage($lastpage);'>$lastpage</a></li>";
50. } elseif ($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) {
51. $paginate.= "<li><a href='#' onclick='showpage(1);'>1</a></li>";
52. $paginate.= "<li><a href='#' onclick='showpage(2);'>2</a></li>";
53. $paginate.= "<li class='disabled'><span>...</span></li>";
54. for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) {
55. if ($counter == $page) {
56. $paginate.= "<li class='active'><span>$counter</span></li>";
57. } else {
58. $paginate.= "<li><a href='#' onclick='showpage($counter);'>$counter</a><li>";
59. }
60. }
61. $paginate.= "<li class='disabled'><span>...</span></li>";
62. $paginate.= "<li><a href='#' onclick='showpage($LastPagem1);'>$LastPagem1</a></li>";
63. $paginate.= "<li><a href='#' onclick='showpage($lastpage);'>$lastpage</a></li>";
64. } else {
65. $paginate.= "<li><a href='#' onclick='showpage(1);'>1</a></li>";
66. $paginate.= "<li><a href='#' onclick='showpage(2);'>2</a></li>";
67. $paginate.= "<li class='disabled'><span>...</span></li>";
68.  
69.  
70.  
71. for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) {
72. if ($counter == $page) {
73. $paginate.= "<li class='active'><span>$counter</span></li>";
74. } else {
75. $paginate.= "<li><a href='#' onclick='showpage($counter);'>$counter</a></li>";
76. }
77. }
78. }
79. }
80.  
81. if ($page < $counter - 1) {
82. $paginate.= "<li><a href='#' onclick='showpage($next);'>»</a></li>";
83. } else {
84. $paginate.= "<li class='disabled'><span>»</span></li>";
85. }
86.  
87. $paginate.= "</ul></div>";
88. }
89. echo $paginate;

PHP: Inverse function for nl2br

PHP: Inverse function for nl2br

1. function br2nl($str) {
2. $str = preg_replace("/(\r\n|\n|\r)/", "", $str);
3. return preg_replace("=<br */?>=i", "\n", $str);
4. }

PHP: Session lifetime

PHP: Session lifetime

ini_set('session.save_path', $_SERVER['DOCUMENT_ROOT'] . '/sessions/'); //Important!

ini_set('session.gc_maxlifetime', 86400);

ini_set('session.cookie_lifetime', 86400);

PHP: Get the user's age function

PHP: Get the user's age function

1. function getAge($birthday) {
2. return floor((time() - strtotime($birthday)) / 31556926);
3. }

PHP: Auto-crop the image with GD

PHP: Auto-crop the image with GD

1. <?php
2. /*!*****************************************************************************************************
3. *
4. * @file autocrop.php
5. * @author Jos Pape
6. * @version 1.0
7. * @brief Contains a class that auto crops images
8. * @example new AutoCrop('scan.jpg'); outputs the image directly
9. * @example new AutoCrop('scan.jpg', 'croped.jpg'); outputs the image to the file
10. ******************************************************************************************************/
11.  
12. /*!**************************************************************************
13. * @class AutoCrop
14. * @author Jos Pape
15. * @version 1.0
16. * @brief Facilitates automaticly cropping a image
17. **************************************************/
18.  
19. class AutoCrop
20. {
21. /*!******************************
22. * @brief holds the original image
23. */
24. var $originalImage = false;
26. /*!******************************
27. * @brief holds the original image location
28. */
29. var $originalSource = false;
31. /*!******************************
32. * @brief holds the destination location
33. */
34. var $destinationSource = false;
36. /*!******************************
37. * @brief holds the destination image
38. */
39. var $destinationImage = false;
41. /*!******************************
42. * @brief holds the edges
43. */
44. var $edge = array();
46. /*!******************************
47. * @brief holds the default margin
48. */
49. var $margin = 30;
51. /*!***********
52. * @brief holds the default correction value
53. */
54. var $correction = 5;
56. /**
57. * @param $source (location to the image)
58. * @param $destination (default false means inline display)
59. * @return boolean
60. */
61. public function __construct($source, $destination=false)
62. {
63. if(is_file($source))
64. {
65. $this->originalSource = $source;
66. if($destination)
67. {
68. $this->destinationSource = $destination;
69. }
71. return $this->cropImage();
72. }
73. else return false;
74. }
76. /**
77. * @return boolean
78. */
79. private function cropImage()
80. {
81. // first we get the filetype
82. $fileType = mime_content_type($this->originalSource);
83. if(substr($fileType, 0, 5) == "image")
84. {
85. switch($fileType)
86. {
87. case "image/jpeg":
88. $this->originalImage = imagecreatefromjpeg($this->originalSource);
89. $this->destinationImage = imagecreatefromjpeg($this->originalSource);
90. break;
92. case "image/gif":
93. $this->originalImage = imagecreatefromgif($this->originalSource);
94. $this->destinationImage = imagecreatefromgif($this->originalSource);
95. break;
97. case "image/png":
98. $this->originalImage = imagecreatefrompng($this->originalSource);
99. $this->destinationImage = imagecreatefrompng($this->originalSource);
100. break;
102. default:
103. return false;
104. break;
105. }
106. if($this->originalImage)
107. {
108. $this->imagecolorswap($this->destinationImage);
109. $this->edge = $this->imageGetEdges($this->destinationImage, 250, 250, 250);
110. imagedestroy($this->destinationImage);
112. $newWidth = $this->edge[0]-$this->edge[2];
113. $newHeight = $this->edge[1]-$this->edge[3];
114. $this->destinationImage = imagecreatetruecolor($newWidth, $newHeight);
115. imagecopyresized(
116. $this->destinationImage,
117. $this->originalImage,
118. 0,
119. 0,
120. $this->edge[2],
121. $this->edge[3],
122. $newWidth,
123. $newHeight,
124. $newWidth,
125. $newHeight
126. );
128. return $this->outputImage();
129. }
130. else return false;
131. }
132. else return false;
133. }
135. /**
136. * @return boolean
137. */
138. private function outputImage()
139. {
140. if(count($this->edge) == 4)
141. {
142. // output the image....as what?
143. if($this->destinationSource)
144. { // save to file
145. // get the destination extention so we know how to save this image
146. $fileType = strtolower(substr($this->destinationSource,strripos($this->destinationSource, ".")));
147. switch($fileType)
148. {
149. case ".jpg":
150. case ".jpeg":
151. imagejpeg($this->destinationImage, $this->destinationSource);
152. break;
154. case ".png":
155. imagepng($this->destinationImage, $this->destinationSource);
156. break;
158. case ".gif":
159. imagegif($this->destinationImage, $this->destinationSource);
160. break;
161. }
162. }
163. else
164. { // inline display
165. $fileType = mime_content_type($this->originalSource);
166. header('Content-type: '.$fileType);
167. switch($fileType)
168. {
169. case "image/jpeg":
170. imagejpeg($this->destinationImage);
171. break;
173. case "image/png":
174. imagepng($this->destinationImage);
175. break;
177. case "image/gif":
178. imagegif($this->destinationImage);
179. break;
180. }
181. }
182. return true;
183. }
184. else return false;
185. }
187. /**
188. * @param $img (image resource)
189. * @param $red (color red)
190. * @param $green (color green)
191. * @param $blue (color blue)
192. * @return array(X1, Y1, X2, Y2) (right, bottom, left, top)
193. * @brief X1,Y1 are the bottom right positions and X2,Y2 are the top left position
194. */
195. private function imageGetEdges(&$img, $red, $green, $blue)
196. {
197. // where the color starts thats te edge
198. $margin = 30;
199. $width = imagesx($img);
200. $height = imagesy($img);
202. $returnX = $this->margin;
203. $returnY = $this->margin;
204. $returnXmin = $width-($this->margin);
205. $returnYmin = $height-($this->margin);
206. $Xvalues = array();
207. $Yvalues = array();
209. $searchColor = imagecolorclosest($img, $red, $green, $blue);
210. for($x = $margin; $x<($width-$this->margin); $x=$x+1)
211. {
212. for($y = $margin; $y<($height-$this->margin); $y=$y+1)
213. {
214. $color = imagecolorat($img, $x, $y);
215. if($color != $searchColor)
216. {
217. $aprocX = floor($x/$this->correction)*$this->correction;
218. $aprocY = floor($y/$this->correction)*$this->correction;
219. if(isset($Xvalues[$aprocX]))
220. $Xvalues[$aprocX] += 1;
221. else
222. $Xvalues[$aprocX] = 0;
224. if(isset($Yvalues[$aprocY]))
225. $Yvalues[$aprocY] += 1;
226. else
227. $Yvalues[$aprocY] = 0;
228. }
229. }
230. }
231. // average X and Y
232. $returnX = $this->margin;
233. $returnY = $this->margin;
234. $returnXmin = $width-($this->margin);
235. $returnYmin = $height-($this->margin);
236. foreach($Xvalues AS $X => $aantal)
237. {
238. if($X > $returnX && $aantal > 8)
239. {
240. $returnX = $X;
241. }
242. if($X < $returnXmin && $aantal > 8)
243. {
244. $returnXmin = $X;
245. }
246. }
247. foreach($Yvalues AS $Y => $aantal)
248. {
249. if($Y > $returnY && $aantal > 8)
250. {
251. $returnY = $Y;
252. $maxAantalY = $aantal;
253. }
254. if($Y < $returnYmin && $aantal > 8)
255. {
256. $returnYmin = $Y;
257. }
258. }
260. $testmargin = $this->margin + $this->correction;
262. if($returnX >= $width-($testmargin))
263. $returnX = $width;
264. else
265. $returnX += $this->correction;
267. if($returnY >= $height-($testmargin))
268. $returnY = $height;
269. else
270. $returnY += $this->correction;
272. if($returnXmin <= $testmargin)
273. $returnXmin = 0;
274. else
275. $returnXmin -= $this->correction;
277. if($returnYmin <= $testmargin)
278. $returnYmin = 0;
279. else
280. $returnYmin -= $this->correction;
282. return array($returnX, $returnY, $returnXmin, $returnYmin);
283. }
285. private function imagecolorswap(&$img)
286. {
287. // First we remove the background
288. imagefilter($img, IMG_FILTER_SMOOTH, 10);
289. imagefilter($img, IMG_FILTER_EDGEDETECT);
290. imagefilter($img, IMG_FILTER_CONTRAST, -90);
291. imagefilter($img, IMG_FILTER_BRIGHTNESS, -20);
292. //imagefilter($img, IMG_FILTER_BRIGHTNESS, -40);
293. imagefilter($img, IMG_FILTER_CONTRAST, 20);
295. // remove color: 120 120 120 TO 180 180 180
296. if (!($t = imagecolorstotal($img)))
297. {
298. $t = 250;
299. imagetruecolortopalette($img, 1, $t);
300. }
301. for ($c = 0; $c < $t; $c++)
302. {
303. $cc = imagecolorclosest($img, 150, 150, 150);
304. imagecolorset($img, $cc, 250, 250, 250);
305. }
306. imagefilter($img, IMG_FILTER_COLORIZE, 0, 0, 0);
307. }
308. }
309. ?>